I am using PHP CURL to request data using MethodAPISelect_XMLV2. I am making successful requests until I try using LIKE in the where clause. For example, if I use
strWhereClause=RefNumber = '123'
data is retrieved.
If, however, I use
strWhereClause=RefNumber like '%123%'
no data is retrieved (and no errors either).
Is it possible to make MethodAPISelect_XMLV2 calls using LIKE in the where clause? If so, why is the syntax I am using not working?