Download Excel template BIP Report using SOAP Web Services — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Download Excel template BIP Report using SOAP Web Services

in Reporting and Analytics for ERP 6 comments

Summary:

We are currently using the following two web services to schedule and download BIP reports:

  • soapWsdlUrlSchedule: https://{instance-name}.oraclecloud.com/xmlpserver/services/v2/ScheduleService?wsdl
  • soapWsdlUrlReport: https://{instance-name}.us6.oraclecloud.com/xmlpserver/services/v2/ReportService?wsdl

After running the downloadReportDataChunk operation, we receive a base64 string in the XML response under the <reportDataChunk> tag. If the report is designed using an eText template, we can decode the base64 string received in the XML response, save it as a .txt or .csv file, and open it successfully.

However, when we try to do the same operation on a BIP report developed in an excel template, decoding the base64 string and saving the file as 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!