How to update an existing OTBI report using SOAP Web Service calls?

MD-JMS

Using the updateObject SOAP call doesn't include all report changes (i.e. security, metadata) - is there a web service that can be used to update existing OTBI reports that includes all aspects of the report?

Dimple-Nagesh-Support-Oracle

Hi ,

You can use https://podname.oraclecloud.com/analytics-ws/saw.dll/wsdl/v7 for OTBI and for BIP : https://docs.oracle.com/cd/E28280_01/bi.1111/e22259/webservices.htm#BIPDV002

These consist of the ScheduleService, CatalogService, SecurityService, and ReportService.

Each provides access to specific functionality as defined by its name and details of its implementation can be found via the appropriate .wsdl :

http://<host>:<port>/xmlpserver/services/v2/<webservicename>?wsdl

Specific to Fusion Application integration, Oracle have developed following webservices: PublicReportWSSService, ScheduleReportWSSService, ExternalReportWSSService.

They can be accessed using similar URL as bellow:

http://<host>:<port>/xmlpserver/services/<webservicename>?wsdl

• PublicReportWSSService?wsdl This WSDL contains the reporting operations such as generating reports online, getting the report definition, and uploading template.

         The WSDL uses the global web service policy defined in WebLogic.

• ScheduleReportWSSService?wsdl This WSDL contains the scheduling operations such as running a report job, getting the job metadata, and downloading the XML or document data.

         The WSDL uses the global web service policy defined in WebLogic.

• ExternalReportWSSService?wsdl The operations defined here are a subset of PublicReportWSSService?wsdl. This WSDL uses the local web service security policy. External clients use this WSDL.

NOTE: REST webservices of BI Publisher are currently not available for consumption in Fusion Application. There are no plans to include REST APIs in Fusion Applications.

Hope this helps

Thanks,

Dimple N