Thursday, 30 January 2020

Sample SOAP Payload to Run a BI Publisher Report

Created a Report Supplier Listing
Below are the properties of the report in Oracle Cloud

WSDL : https://[YourDomain]/xmlpserver/services/ExternalReportWSSService?WSDL

Sample payload to run the report with one parameter.
xmlns:soap="http://www.w3.org/2003/05/soap-envelope"
xmlns:pub="http://xmlns.oracle.com/oxp/service/PublicReportService">
<soap:Header/>
<soap:Body>
<pub:runReport>
<pub:reportRequest>
<pub:attributeFormat>xml</pub:attributeFormat>
<!-- Flatten XML should always be false when we have XML type of output to display the XML tags as mentioned in BIP Data Model and display XML structure in as expected format -->
<pub:flattenXML>false</pub:flattenXML>
<pub:parameterNameValues>
<!--1st Parameter of BIP Report-->
<pub:item>
<pub:name>Supplier_number</pub:name>
<pub:values>
<pub:item>1252</pub:item>
</pub:values>
</pub:item>
</pub:parameterNameValues>
<pub:reportAbsolutePath>/Custom/Procurement/Purchasing/Supplier listing.xdo</pub:reportAbsolutePath>
<!-- Setting sizeOfDataChunkDownload to -1 will return the output to the calling client -->
<pub:sizeOfDataChunkDownload>-1</pub:sizeOfDataChunkDownload>
</pub:reportRequest>
</pub:runReport>
</soap:Body>
</soap:Envelope>

The output of the payload is in base64 format.

No comments:

Post a Comment