Like condition in Sage CRM 2022 Web API

In REST Web API i.e. how can we have two condition in same get URL, for example I have to pass assigned user id and project name too in same condition.

For example, if there is project entity, I want all the project which is assigned to User id : 1 and also need to find the project that contains name as '%Designer%'. I tried below URL but I am not getting any proper result:

.../sdata/CRMj/sagecrm/-/vProjectSummary?where=proj_userid eq '1' and proj_name LIKE '%Designer%'

Any quick assistance will be highly appreciated.

  • 0

    There may be is a slight issue with the LIKE parameter. As the percentage character (%) is used as a control character in the URI, it is possible this is where the problem lies.

    If entered into the browser address bar - the browse will expand it to %25, it Hex value, and passes it on.

    A simple test would be to use %25 in the query and check the result