Search code examples
oracle-databasesoaprightnow-crmoracle-service-cloud

Oracle Service Cloud SOAP API RunAnalyticsReport Filter Issue

This is about the Oracle Service Cloud SOAP.

My roadblock: I want to be able to filter using a keyword (answers.search_fnl).

Below i have a SOAP markup which accesses a report using the report Id.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
   <soapenv:Header>
      <ns7:ClientInfoHeader soapenv:mustUnderstand="0" xmlns:ns7="urn:messages.ws.rightnow.com/v1_2">
         <ns7:AppID>getFAQbyKeyword</ns7:AppID>
      </ns7:ClientInfoHeader>
      <wsse:Security mustUnderstand="1" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">
         <wsse:UsernameToken>
            <wsse:Username>username</wsse:Username>
            <wsse:Password>password</wsse:Password>
         </wsse:UsernameToken>
      </wsse:Security>
   </soapenv:Header>
   <soapenv:Body>
      <ns7:RunAnalyticsReport xmlns:ns7="urn:messages.ws.rightnow.com/v1_2">
         <ns7:AnalyticsReport xsi:type="ns7:AnalyticsReport" xmlns:ns7="urn:objects.ws.rightnow.com/v1_2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
            <ID id="#" xmlns="urn:base.ws.rightnow.com/v1_2"/>
         </ns7:AnalyticsReport>
      </ns7:RunAnalyticsReport>
   </soapenv:Body>
</soapenv:Envelope>

I now want to include this part within it:

        <ns7:Filters xsi:type="ns7:AnalyticsReportFilter">
           <ns7:Name>answers.search_fnl</ns7:Name>
           <ns7:Values>test</ns7:Values>
        </ns7:Filters>

My attempt is:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
   <soapenv:Header>
      <ns7:ClientInfoHeader soapenv:mustUnderstand="0" xmlns:ns7="urn:messages.ws.rightnow.com/v1_2">
         <ns7:AppID>getFAQbyKeyword</ns7:AppID>
      </ns7:ClientInfoHeader>
      <wsse:Security mustUnderstand="1" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">
         <wsse:UsernameToken>
            <wsse:Username>username</wsse:Username>
            <wsse:Password>password</wsse:Password>
         </wsse:UsernameToken>
      </wsse:Security>
   </soapenv:Header>
   <soapenv:Body>
      <ns7:RunAnalyticsReport xmlns:ns7="urn:messages.ws.rightnow.com/v1_2">
         <ns7:AnalyticsReport xsi:type="ns7:AnalyticsReport" xmlns:ns7="urn:objects.ws.rightnow.com/v1_2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
            <ID id="#" xmlns="urn:base.ws.rightnow.com/v1_2"/>
            <ns7:Filters xsi:type="ns7:AnalyticsReportFilter">
               <ns7:Name>answers.search_fnl</ns7:Name>
               <ns7:Values>test</ns7:Values>
            </ns7:Filters>
         </ns7:AnalyticsReport>
      </ns7:RunAnalyticsReport>
   </soapenv:Body>
</soapenv:Envelope>

My error is:

RightNowSyncService|urn:wsdl.ws.rightnow.com/v1_2 failed

Found out-of-order or unrecognized node

Filters|urn:messages.ws.rightnow.com/v1_2 while parsing node of type AnalyticsReport|urn:objects.ws.rightnow.com/v1_2

Failure in setting value for object RunAnalyticsReportMsg element AnalyticsReport of type objects_ws_rightnow_com_v1_2::AnalyticsReport

Failure in setting value for object RunAnalyticsReport element RunAnalyticsReport of type messages_ws_rightnow_com_v1_2::RunAnalyticsReportMsg

NULL returned from the RunAnalyticsReport deserializer due to missing or invalid XML

Can the solution please be the SOAP structure including the necessary edits.

Thank you in advance!

Solution

  • ANSWER: 

    <ID id="#" xmlns="urn:base.ws.rightnow.com/v1_2"/> <Filters xmlns="urn:objects.ws.rightnow.com/v1_2"> <Name>answers.search_fnl</Name> <Values>string</Values> </Filters>