Download Excel template BIP Report using SOAP Web Services

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