Integration

Hi,

I am trying to invoke the RMS Rest service  from SOA 12.2.1.3.0 's REST Adapter. But I am getting below error fault in BPEL in invoke activity.

RMS Api :

https://<hostname>/services/rest/connect/v1.3/queryResults/?query=select * from Incidents where Incidents.CustomFields.CO.status_set=1 

I setup above RMS API in rest adapter by first exporting it as WADL using SOAP UI (Note: SOAP UI it is working fine) and then importing wadl in REST adapter in SOA.

Error in SOA :

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">

   <env:Header>

      <tracking:faultId xmlns:tracking="http://oracle.soa.tracking.core.TrackingProperty">270160</tracking:faultId>

   </env:Header>

   <env:Body>

      <env:Fault>

         <faultcode>env:Server</faultcode>

         <faultstring>Bad Request</faultstring>

         <faultactor/>

         <detail>

            <exception>{

    "type": "https:/<hostname>/services/rest/connect/exceptions/OSC-CREST-00019",

    "title": "Invalid query parameter value",

    "status": 400,

    "detail": "This query is not supported: near \"*\": syntax error",

    "instance": "https://<hostname>/services/rest/connect/v1.3/queryResults/?query=select+*+from+Incidents+where+Incidents.CustomFields.CO.status_set%3D1",

    "o:errorCode": "OSC-CREST-00019"

}</exception>

         </detail>

      </env:Fault>

   </env:Body>

</env:Envelope>

When I research on this error I see a resolution and metalink note, but that explains the same about ICS, however I am using SOACS here.

I also try adding custom header in invoke activity as property as below ...but no luck.

Service Cloud Query Parameter ROQL Is Not Working (REST API) (Doc ID 2286969.1)

Composite.xml :

<service name="rmsapipocbpel_client_ep" ui:wsdlLocation="WSDLs/RmsApiPocBpel.wsdl">

    <interface.wsdl interface="http://xmlns.oracle.com/RmsApiPocApp/RmsApiPocProj/RmsApiPocBpel#wsdl.interface(RmsApiPocBpel)"/>

    <binding.ws port="http://xmlns.oracle.com/RmsApiPocApp/RmsApiPocProj/RmsApiPocBpel#wsdl.endpoint(rmsapipocbpel_client_ep/RmsApiPocBpel_pt)">

      <property name="oracle.webservices.http.headers">x_ics_use_x_www_form_urlencoded</property>

    </binding.ws>

  </service>

BPEL:

<invoke name="Invoke1" partnerLink="RmsRestApiPocWadlRef" bpelx:method="QueryResults" outputVariable="jsonoutput"

            inputVariable="emptyreq" bpelx:invokeAsDetail="no">

      <bpelx:toProperties>

        <bpelx:toProperty name="x_ics_use_x_www_form_urlencoded">false()</bpelx:toProperty>

      </bpelx:toProperties>

    </invoke>

Please advise.

thanks & Regards,

Sameer