AnsweredAssumed Answered

Using LIKE in API not working

Question asked by gasweet283435 on Oct 12, 2017
Latest reply on Oct 12, 2017 by gasweet283435

I am trying to use LIKE in API and getting an Unknown response.

 

I am doing a SOAP call and returning EDI documents where I have any status with an error in the ackStatus field. Here is the query.

 

<api:QueryFilter>
   <api:expression xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" operator="LIKE" property="ackStatus"       xsi:type="api:SimpleExpression">
      <api:argument>%Error%</api:argument>
   </api:expression>
</api:QueryFilter> 

 

I know if works the rest of the code works as when I use EQUALS and the exact wording the response is correct. I tried to use "*" instead of "%" also and it did not work.

 

This is what I get back:

 

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

      <S:Fault xmlns:ns4="http://www.w3.org/2003/05/soap-envelope">
         <faultcode>S:Client.INPUT_ERROR</faultcode>
         <faultstring>Unknown filter op: LIKE</faultstring>
      </S:Fault>
   </S:Body>
</S:Envelope>

 

It does not like my LIKE. What should the parameters be to get the correct documents returned?

Outcomes