Webservice or REST API to fetch Data from OTBI Report

Neha Bhatt

We are trying to get data from seeded OTBI Report through webservice: https://instanceURL/analytics-ws/saw.dll? but getting the following error:

<sawsoape:Error xmlns:sawsoape="com.siebel.analytics.web/soap/error/v1">

<sawsoape:Code>GCARFLCS</sawsoape:Code>

<sawsoape:CatalogCode>16</sawsoape:CatalogCode>

<sawsoape:Message>Object expected: /shared/Financials/Payables/Payables to Ledger Reconciliation</sawsoape:Message>

</sawsoape:Error>

Can anyone please help to resolve this error or get a REST API to fetch data from OTBI Report?

Gianni Ceresa

If you look at the posted example, the filterExpressions is a piece of XML that use the same XML syntax as filters in an analysis.

If you don't want to write it by hand from scratch, build the filter in an analysis and then look at the XML and adapt it as needed. (Using the webservice is a kind of advanced task and that's why it requires to be familiar with the Oracle Analytics XML format.)

Gianni Ceresa

How are you calling the webservice? Did it ever work? What does your call exactly look like?

EzequielC-Oracle

Hello,

Please, look at the following video for the steps to use the REST API connector:

https://www.youtube.com/watch?v=mrbK_AyFp_A

Regards,

Ezequiel.

Neha Bhatt

https://community.oracle.com/products/oracleanalytics/discussion/comment/48701#Comment_48701

Request which I'm sending:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v6="urn://oracle.bi.webservices/v6">

  <soapenv:Header/>

  <soapenv:Body>

   <v6:executeXMLQuery>

     <v6:report>

      <v6:reportPath>/shared/Financials/Payables/Payables to Ledger Reconciliation</v6:reportPath>

     </v6:report>

     <v6:outputFormat></v6:outputFormat>

     <v6:executionOptions>

      <v6:async></v6:async>

      <v6:maxRowsPerPage></v6:maxRowsPerPage>

      <v6:refresh></v6:refresh>

      <v6:presentationInfo></v6:presentationInfo>

      <v6:type></v6:type>

     </v6:executionOptions>

     <v6:reportParams>

      <!--Zero or more repetitions:-->

      <v6:filterExpressions></v6:filterExpressions>

      <!--Zero or more repetitions:-->

      <v6:variables>

        <v6:name>Ledger</v6:name>

        <v6:value>Ledger Name</v6:value>

      </v6:variables>

      <v6:variables>

        <v6:name>Request Name</v6:name>

        <v6:value>June 10 close 5:05 AM</v6:value>

      </v6:variables>

      <!--Zero or more repetitions:-->

      <v6:nameValues>

        <v6:name></v6:name>

        <v6:value></v6:value>

      </v6:nameValues>

      <!--Zero or more repetitions:-->

      <v6:templateInfos>

        <v6:templateForEach></v6:templateForEach>

        <v6:templateIterator></v6:templateIterator>

        <!--Zero or more repetitions:-->

        <v6:instance>

         <v6:instanceName></v6:instanceName>

         <!--Zero or more repetitions:-->

         <v6:nameValues>

           <v6:name></v6:name>

           <v6:value></v6:value>

         </v6:nameValues>

        </v6:instance>

      </v6:templateInfos>

      <!--Optional:-->

      <v6:viewName></v6:viewName>

     </v6:reportParams>

     <v6:sessionID>m555evn555dgbbnfjvrgi555jhhfo0hc5jeofkgiq555vhu55knitpj55</v6:sessionID>

   </v6:executeXMLQuery>

  </soapenv:Body>

</soapenv:Envelope>

Madasamy -Oracle

i tested with OAC and you need to put the filters under the filterExpession and in an xml format( You may have to use v6 versions instead of v12 versions in the sample below

You may have to extend it to the variables based on your requirement.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v12="urn://oracle.bi.webservices/v12">
  <soapenv:Header/>
  <soapenv:Body>
   <v12:executeXMLQuery>
     <v12:report>
      <v12:reportPath>/shared/Folder Test/sampletest</v12:reportPath>
     </v12:report>
     <v12:outputFormat>SAWRowsetSchemaAndData</v12:outputFormat>
     <v12:executionOptions>
      <v12:async>2</v12:async>
      <v12:maxRowsPerPage>10</v12:maxRowsPerPage>
      <v12:refresh>true</v12:refresh>
      <v12:presentationInfo>false</v12:presentationInfo>
      <v12:type>1</v12:type>
     </v12:executionOptions>
     <v12:reportParams>
      <!--Zero or more repetitions:-->
      <v12:filterExpressions><![CDATA[<sawx:expr xsi:type="sawx:string" op="equal"
            xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xmlns:saw="com.siebel.analytics.web/report/v1.1"
      xmlns:sawx="com.siebel.analytics.web/expression/v1.1" subjectArea="SA Name"><sawx:expr xsi:type="sawx:sqlExpression">"SampleApp"."Time"."Year"</sawx:expr><sawx:expr xsi:type="sawx:string">2013</sawx:expr></sawx:expr>]]></v12:filterExpressions>
     </v12:reportParams>
     <v12:sessionID>sessionID</v12:sessionID>
   </v12:executeXMLQuery>
  </soapenv:Body>
</soapenv:Envelope>

Neha Bhatt

https://community.oracle.com/products/oracleanalytics/discussion/comment/48776#Comment_48776

Hey,

Could you please let me know more on the filterExpression, like what values we need to pass in it?

Thanks