Wednesday, July 10, 2024

ERP BI report service - invoke a BI report from soap ui using report service.

Usecase: 

Generally we call the below service to extract the data from BI report.

https://<your oracle cloud application instance domain>/xmlpserver/services/ExternalReportWSSService?WSDL

HERE, We can also use below report service.

https://<host>:<port>/xmlpserver/services/v2/ReportService?wsdl

Screenshots:

Soap >> put wsdl >> ok >> choose run report 


Provide report absolute path  and other details, parameter name values if any >> basic authenticaltion 


We will get the response in base64 encoded that we need to decode and use it.

Reference:

https://docs.oracle.com/cd/E28280_01/bi.1111/e22259/webservices.htm#BIPDV002


No comments:

Post a Comment

Featured Post

OIC - how can I use XSLT functions to remove leading zeros from numeric and alphanumeric fields?

To remove leading zeros from an numeric field in Oracle Integration Cloud (OIC) using XSLT, you can Use number() Function The number() funct...