Tech Trainings

SOAP Payload to invoke BIP Report

May 8, 2023 by admin

Request

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:pub="http://xmlns.oracle.com/oxp/service/PublicReportService">
   <soapenv:Header/>
   <soapenv:Body>
      <pub:runReport>
         <pub:reportRequest>
            <pub:parameterNameValues>
               <!--1st Parameter of BIP Report-->
               <pub:item>
                  <pub:name>p_ledger_name</pub:name>
                  <pub:values>
                     <pub:item>'UK Primary Ledger'</pub:item>
                  </pub:values>
               </pub:item>
            </pub:parameterNameValues>
            <pub:attributeFormat>csv</pub:attributeFormat>
            <pub:flattenXML>false</pub:flattenXML>
            <pub:reportAbsolutePath>/Custom/Sreeram/GLLedgerRepo.xdo</pub:reportAbsolutePath>
            <pub:sizeOfDataChunkDownload>-1</pub:sizeOfDataChunkDownload>
         </pub:reportRequest>
         <pub:userID>fas17.student</pub:userID>
         <pub:password>tSR4B%4?</pub:password>
      </pub:runReport>
   </soapenv:Body>
</soapenv:Envelope>

Response

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <soapenv:Body>
      <runReportResponse xmlns="http://xmlns.oracle.com/oxp/service/PublicReportService">
         <runReportReturn>
            <reportBytes>77u/UF9MRURHRVJfTkFNRQoiJ1VLIFByaW1hcnkgTGVkZ2VyJyIK</reportBytes>
            <reportContentType>text/plain;charset=UTF-8</reportContentType>
         </runReportReturn>
      </runReportResponse>
   </soapenv:Body>
</soapenv:Envelope>

Comments |0|