• Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:June 12, 2020
  • Reading time:4 mins read
You are currently viewing Scheduling BIP Report using SOAP Services?
Scheduling BIP Report using SOAP Services?

We can run the BI Reports ad-hoc, or schedule them to email/FTP at weekly/daily basis. However we will explore the option of scheduling the BIP Report using SOAP webservices.

SOAP WSDL: https://{hostname}/xmlpserver/services/v2/ScheduleService?wsdl

Sample: https://abcd-test.fa.us6.oraclecloud.com/xmlpserver/services/v2/ScheduleService?wsdl

Once we have the WSDL, we can use the SOAPUI to consume this WSDL and execute the scheduleReport request with the below payload.

<soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:v2=”http://xmlns.oracle.com/oxp/service/v2″>
<soapenv:Header/>
<soapenv:Body>
<v2:scheduleReport>
<v2:scheduleRequest>
<v2:bookBindingOutputOption>false</v2:bookBindingOutputOption>
<v2:mergeOutputOption>false</v2:mergeOutputOption>
<v2:notifyHttpWhenFailed>false</v2:notifyHttpWhenFailed>
<v2:notifyHttpWhenSkipped>false</v2:notifyHttpWhenSkipped>
<v2:notifyHttpWhenSuccess>false</v2:notifyHttpWhenSuccess>
<v2:notifyHttpWhenWarning>false</v2:notifyHttpWhenWarning>
<v2:notifyWhenFailed>false</v2:notifyWhenFailed>
<v2:notifyWhenSkipped>false</v2:notifyWhenSkipped>
<v2:notifyWhenSuccess>false</v2:notifyWhenSuccess>
<v2:notifyWhenWarning>false</v2:notifyWhenWarning>
<v2:repeatCount>1</v2:repeatCount>
<v2:repeatInterval>0</v2:repeatInterval>
<v2:reportRequest>
<v2:attributeFormat>csv</v2:attributeFormat>
<v2:attributeLocale>en_US</v2:attributeLocale>
<v2:attributeTemplate>xt</v2:attributeTemplate>
<v2:byPassCache>true</v2:byPassCache>
<v2:flattenXML>false</v2:flattenXML>
<v2:parameterNameValues>
<v2:listOfParamNameValues>
<v2:item>
<v2:name>CONTENTID</v2:name>
<v2:values>
<v2:item>INPUTCONTENTID</v2:item>
</v2:values>
</v2:item>
</v2:listOfParamNameValues>
</v2:parameterNameValues>
<v2:reportAbsolutePath>/Custom/SM/TEST/REPORT.xdo</v2:reportAbsolutePath>
<v2:sizeOfDataChunkDownload>0</v2:sizeOfDataChunkDownload>
</v2:reportRequest>
<v2:saveDataOption>false</v2:saveDataOption>
<v2:saveOutputOption>true</v2:saveOutputOption>
<v2:scheduleBurstringOption>true</v2:scheduleBurstringOption>
<v2:schedulePublicOption>false</v2:schedulePublicOption>
<v2:startDate/>
<v2:useUTF8Option>false</v2:useUTF8Option>
<v2:userJobDesc>SampleJob</v2:userJobDesc>
<v2:userJobName>SampleJob</v2:userJobName>
</v2:scheduleRequest>
<v2:userID>*******</v2:userID>
<v2:password>*******</v2:password>
</v2:scheduleReport>
</soapenv:Body>
</soapenv:Envelope>

You can modify the Absolute Path of Report, Parameters, UserID, Password and submit the request.

If you have any questions, please feel free to reach out to me by posting in comments section.

If you are interested in learning Fusion Technical tools go through this post

If you liked the article, please share it with your friends/ colleagues/ teammates or anyone who might also benefit from it.