Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Unable to Deploy to BIP using Oracle SOAP Services

Received Response
129
Views
5
Comments
Shrujal Patel
Shrujal Patel Rank 2 - Community Beginner
edited Aug 13, 2024 5:36PM in Oracle Analytics Cloud and Server

Unable to use /analystics-ws SOAP Service to deploy a BIP Report (catalog file).

We use pasteItem2 operation of https://<HOSTNAME>/analytics-ws/saw.dll?SoapImpl=webCatalogService and it does

  1. at times create the report folder using the catalog file but while trying to open it we get access denied
  2. at other times it doesn't even create the folders on BIP for the catalog file being uploaded.

Did anyone had any luck trying to upload a catalog file using SOAP Service?

Answers

  • Hassan El Bouihi-Oracle
    Hassan El Bouihi-Oracle Rank 6 - Analytics Lead

    Hello Shrujal,

    Please share the payload request you are using for review.

    Thank you

    Hassan

  • Madasamy -Oracle
    Madasamy -Oracle Rank 6 - Analytics Lead

    Hi,

    I tested the scenario and I can see that the copyitem() and unarchive() methods work fine on OAC. If you are using latest OA* versions, it should be available to you as well.

    Note: in the below examples, i am using v12 wsdl.

    Input Sample for the copyitem() 

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v12="urn://oracle.bi.webservices/v12">
  <soapenv:Header/>
  <soapenv:Body>
   <v12:copyItem2>
     <!--1 or more repetitions:-->
     <v12:path>/shared/Donations Projects/test report</v12:path>
     <v12:recursive>false</v12:recursive>
     <v12:permissions>false</v12:permissions>
     <v12:timestamps>false</v12:timestamps>
     <v12:useMtom>false</v12:useMtom>
     <!--Zero or more repetitions:-->
     <!--v12:skipPath>?</v12:skipPath Modified-->
     <v12:options>
      <v12:sourceApplication>?</v12:sourceApplication>
     </v12:options>
     <v12:sessionID>sessionID</v12:sessionID>
   </v12:copyItem2>
  </soapenv:Body>
</soapenv:Envelope>


    This gives you an output of the archived value in an encoded format such as below


    <sawsoap:archive xsi:type="xsd:base64Binary">value</sawsoap:archive>

    Use the same to the unarchive() and you can paste it to a different directory such as below.


    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v12="urn://oracle.bi.webservices/v12">
  <soapenv:Header/>
  <soapenv:Body>
   <v12:unarchive>
     <v12:archive></v12:archive>
     <v12:replacePath>path_where_unarchive_should_happen</v12:replacePath>
     <v12:flagACL>false</v12:flagACL>
     <v12:flagOverwrite>false</v12:flagOverwrite>
     <v12:flagReplaceReferences>false</v12:flagReplaceReferences>
     <v12:sessionID></v12:sessionID>
   </v12:unarchive>
  </soapenv:Body>
</soapenv:Envelope>
  • Shrujal Patel
    Shrujal Patel Rank 2 - Community Beginner

    Thanks for your inputs @Madasamy-Oracle

    Can you help elaborate significance of "sourceApplication" attribute in copyItem2 operation, I couldn't find any details about it in documentation.

    If I ignore that attribute in copyItem2, I get same value in copyItem2Result.archive irrespective of path provided in request.

  • Madasamy -Oracle
    Madasamy -Oracle Rank 6 - Analytics Lead

    sourceApplication -> I believe that its just a free text that could be added to distinguish where the SOAP call is originated from

  • Shrujal Patel
    Shrujal Patel Rank 2 - Community Beginner

    I have a report in Catalog in /shared/Custom/ABC Custom/Extensions/EXT_CICD_TEST_FLAT, this folder has DataModel file and a Report file.

    No matter what path I give I get exact same response.

    HostName: {{bip_host}}/analytics-ws/saw.dll?SoapImpl=webCatalogService and I am using urn://oracle.bi.webservices/v12 as well