How to call BIP Report from Oracle Integration Cloud (OIC)?

• Create a BIP report. Click here to view the steps
• Open the report and save the report in a sample.csv file

• Open OIC Instance and go to Integrations -> Connections

• Click on Create button on Top Right corner and select SOAP adapter

• Enter the Name, select Role as Invoke and give it a description. Click on Create once done.

• Enter the below details:

        WSDL URL: https://<hostname>.oraclecloud.com/xmlpserver/services/ExternalReportWSSService?WSDL

Security Policy: Basic Authentication and give Username & Password

• Click on Test and then click Validate and Test

• Click on Save button once done. You connection tested successfully and now is ready to be used in integrations.
• Go to integrations and click on Create button to create new integration
• Select the integration type as App Driven Orchestration

• Give the integration name and click Create button

• Add a new REST type trigger as starting point of your integration

• Enter the name of your endpoint and click Next

• Enter the resource relative URI, enable parameters for the endpoints and check the option to enable end point receive the response. Click Next button.

• Add query parameters pVendorNum

• Enter the JSON as inline:

{

  "VendorId" : "",

  "VendorName" : "",

  "VendorNumber" : ""

}

• Click on Done

• Add "EXTERNAL_REPORT_SERVICE_CONN" that we created earlier:

• Enter the endpoint name

• Select the operation "runReport"

• Click Next button

• Click Done button

• Integration will look like below:

• Edit the CallBIPReport Mapper and perform the below mapping:
• SizeOfDataChunkDownload as "-1"

• ReportAbsolutePath as "/Custom/Sample/TestReport.xdo"

• Parameter Name as "p_vendor_number"

• Add mapping for parameter values

• Add mapping for attributeFormat also, which is csv in our case

• View code of mapping:

• Now add assign activity

• Name it DecodeReportBytes

• Use decodeBase64ToReference to decode report bytes to reference type. Click on Validate and then Close button

• Add stage file action

• Give it a name "ReadDecodedBytes"

• Choose File Operation as "Read Entire File" 
• Set Configure File Reference as "Yes"

• Specify file reference as below

• Select structure of file content as Sample delimited document (e.g. CSV)

• Choose the sample file and give Record and RecordSet names:

• Click Done button

• Edit the mapper for GetInput

• Add the tracking variable

• Activate and test the integration now