You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to query Supplier Name containing special operators like AND/OR/LIKE using the supplier REST ser

48
Views
0
Comments
edited Dec 24, 2020 10:49AM in Supplier Management

Summary

How to query Supplier Name containing special operators like AND/OR/LIKE using the supplier REST service GET operation

Content

When search for suppliers in a REST call using GET, the query parameter ‘q’ is used widely to search for suppliers. The query parameter operators AND, OR and LIKE may be part of a supplier name too.
When these words exist in the supplier name and you use the supplier name as a query parameter, the framework misinterprets these as its operator and therefore the query/search fails.

This can be resolved by using special character ' (literals) in the query and also using LIKE operator instead of = for such searches.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!