How to get the report output using SOAP Services?

Run and get the report output using the SOAP Service

To test the SOAP services we need the SOAP UI. To download the SOAP UI : https://www.soapui.org/downloads/soapui/

Soap Service to access the reports : /services/ExternalReportWSSService?wsdl (or) /services/PublicReportService?wsdl

Example: 

https://abcd-test.fa.em4.oraclecloud.com/xmlpserver/services/ExternalReportWSSService?wsdl

In SOAP UI create a project with Project Name and use the above WSDL URL.

 

Authentication:

Expand the runReport and double click on Request, then the XML file will open.

Prepare the load in XML file and run the service.

Sample load with one parameter to run the report:

<soap:Envelope 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:parameterNameValues>

               <pub:item>

                  <pub:name>candnumber</pub:name>

                  <pub:values>

                     <pub:item>57636</pub:item>

                  </pub:values>

               </pub:item>

            </pub:parameterNameValues>

            <pub:reportAbsolutePath>/Custom/Human Capital Management/Extra_Info_Data.xdo</pub:reportAbsolutePath>

            <pub:sizeOfDataChunkDownload>-1</pub:sizeOfDataChunkDownload>

         </pub:reportRequest>

      </pub:runReport>

   </soap:Body>

</soap:Envelope>

Parameter and report path are highlighted in XML file.

After we run the report ,output of the report is in base64 format, we need to decode the output.

It may helpful for you. please visit blog for more information and share your ideas.Thanks,Sainath