Deploy BIP Reports using Web-service -ERP Cloud

In this Quick Post , I will outline the steps to perform the BIP reports deployment using web service . This will be extremely helpful , if you want to automate the deployments using CI/CD pipelines.

WSDL:

https://POD/xmlpserver/services/v2/CatalogService?wsdl

Request Payload : for downloading the BIP report from source instance

<x:Envelope
    xmlns:x="http://schemas.xmlsoap.org/soap/envelope/"
    xmlns:v="http://xmlns.oracle.com/oxp/service/v2">
    <x:Header/>
    <x:Body>
        <v:downloadObject>
            <v:reportAbsolutePath>Provide your report path </v:reportAbsolutePath>
            <v:userID>username</v:userID>
            <v:password>password</v:password>
        </v:downloadObject>
    </x:Body>
</x:Envelope>

Response Payload:

This will contain the Encoded base64 data .

Request Payload for Upload Object :

The above returned encoded data need to be passed as input to the below along with report absolute path

<x:Envelope
    xmlns:x="http://schemas.xmlsoap.org/soap/envelope/"
    xmlns:v="http://xmlns.oracle.com/oxp/service/v2">
    <x:Header/>
    <x:Body>
        <v:uploadObject>
            <v:reportObjectAbsolutePathURL>?</v:reportObjectAbsolutePathURL>
            <v:objectType>xdoz</v:objectType>
            <v:objectZippedData>[base64Binary?]</v:objectZippedData>
            <v:userID>?</v:userID>
            <v:password>?</v:password>
        </v:uploadObject>
    </x:Body>
</x:Envelope>

Hope this Helps ! Happy Learning.