How to call a BI publisher report from SOAP UI

Question

I am trying to view the data of a BI publisher report from SOAP UI. I have used SAWSessionService to establish the connection and as a response I have got a sessionID .

I have again used XMLViewService -> executeXMLQuery to view the report . I have used the sessionID that I got earlier , to create the envelope as follows:

 <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"       xmlns:v7="urn://oracle.bi.webservices/v7">
   <soapenv:Header/>
   <soapenv:Body>
      <v7:executeXMLQuery>
        <v7:report>
         <v7:reportPath>absolute_report_path
         </v7:reportPath>
         <v7:reportXml></v7:reportXml>
         </v7:report>
         <v7:outputFormat></v7:outputFormat>
         <v7:executionOptions>
            <v7:async></v7:async>
            <v7:maxRowsPerPage></v7:maxRowsPerPage>
            <v7:refresh></v7:refresh>
            <v7:presentationInfo></v7:presentationInfo>
            <v7:type></v7:type>
         </v7:executionOptions>
         <v7:reportParams>
            <!--Zero or more repetitions:-->
            <v7:filterExpressions></v7:filterExpressions>
            <!--Zero or more repetitions:-->
            <v7:variables>
               <v7:name></v7:name>
               <v7:value></v7:value>
            </v7:variables>
            <!--Zero or more repetitions:-->
            <v7:nameValues>
               <v7:name></v7:name>
               <v7:value></v7:value>
            </v7:nameValues>
            <!--Zero or more repetitions:-->
            <v7:templateInfos>
               <v7:templateForEach></v7:templateForEach>
               <v7:templateIterator></v7:templateIterator>
               <!--Zero or more repetitions:-->
               <v7:instance>
                  <v7:instanceName></v7:instanceName>
                  <!--Zero or more repetitions:-->
                  <v7:nameValues>
                     <v7:name></v7:name>
                     <v7:value></v7:value>
                  </v7:nameValues>
               </v7:instance>
            </v7:templateInfos>
            <!--Optional:-->
            <v7:viewName></v7:viewName>
         </v7:reportParams>
         <v7:sessionID>session_id_Earlier_Generated</v7:sessionID>
      </v7:executeXMLQuery>
   </soapenv:Body>
</soapenv:Envelope>

But I am getting the response as Path not found . I have given public permissions to the report .

Can someone please help ?

I feel I am doing something wrong .

Answer 1

Your absolute path needs to be based on the directory structure below your Shared Folders. For spaces in names, a + symbol has always worked for us. An easy way to find your absolute report path is to find the URL that you'd go to if you just clicked on the report to run it from the interactive menu, and then take the stuff after the xmlpserver:

For example:

http://yourdomainhere:9704/xmlpserver/FolderRepresentingCompanyNameUnderSharedFolders/ManufacturingFolder/Production+Stats.xdo

In this case, your absolute path is: /FolderRepresentingCompanyNameUnderSharedFolders/ManufacturingFolder/Production+Stats.xdo