Example of operation "uploadReportDataChunk" for SOAP service ReportService

Andrea Gallo

Hello

we are trying to call "uploadReportDataChunk" operation in order to load an XML to OTBI server, then call operation "runReport" with paramerter fileDataSource/dynamicDataSourcePath populated with the reference to the file. I cannot understand the correct value to use:

1. Upload Data Chunk payload request

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v2="http://xmlns.oracle.com/oxp/service/v2">
<soapenv:Header/
<soapenv:Body>
<v2:uploadReportDataChunk>
<v2:reportDataChunk>PD9...uPg</v2:reportDataChunk> —→ it is BASE64 codification of the XML payload
<v2:userIDXXXXXXXX</v2:userID>
<v2:passwordYYYYYYYYY</v2:password>
</v2:uploadReportDataChunk>
</soapenv:Body>
</soapenv:Envelope>

2. Upload Data Chunk payload Response

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Body>
<uploadReportDataChunkResponse xmlns="http://xmlns.oracle.com/oxp/service/v2">
<uploadReportDataChunkReturn>data/xmlpwsxdrZHqV2ZX18209570837089342914.tmp</uploadReportDataChunkReturn>
</uploadReportDataChunkResponse>
</soapenv:Body>
</soapenv:Envelope>

3. operation Run Report with reference to the file

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v2="http://xmlns.oracle.com/oxp/service/v2">
<soapenv:Header/>
<soapenv:Body>
<v2:runReport>
<v2:reportRequest>
<v2:attributeFormat>pdf</v2:attributeFormat>
<v2:attributeLocale>US</v2:attributeLocale>
<v2:dynamicDataSource
<v2:fileDataSource
<v2:dynamicDataSourcePath>data/xmlpwsxdrZHqV2ZX18209570837089342914.tmp</v2:dynamicDataSourcePath>
<v2:temporaryDataSource>yes</v2:temporaryDataSource>
</v2:fileDataSource>
</v2:dynamicDataSource>
v2:reportAbsolutePath>/Custom/OTN_OTP_SIGN/POD_OTN.xdo</v2:reportAbsolutePath>
</v2:reportRequest>
<v2:userID>XXXXXXXX</v2:userID>
<v2:password>YYYYYYYYY</v2:password>
</v2:runReport>
</soapenv:Body>
</soapenv:Envelope>

4. Run Report response

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<soapenv:Fault>
<faultcode>soapenv:Server</faultcode>
<faultstring>PublicReportService::generateReport for reportAbsolutePath [/Custom/OTN_OTP_SIGN/POD_OTN.xdo] failed: due to java.io.FileNotFoundException: data/xmlpwsxdrZHqV2ZX18209570837089342914.tmp (No such file or directory)</faultstring>
</soapenv:Fault>
</soapenv:Body>
</soapenv:Envelope>

How to correctly pass the reference of the file?

Regards

Andrea