Hello,
I am struggling to search records in Zoho CRM, which contain special characters in the fields I am comparing to.
I am using the REST API of CRM so search Accounts based on the Account_Name.
The doc explains parentheses or comma need to be escaped and encoded. This is not true. When following the instructions and search something like (Last_Name:equals:Burns%5C%2CB) instead of (Last_Name:equals:Burns,B), the API searches for "Burns%5C%2CB". While searching with (Last_Name:equals:Burns,B) works perfectly fine.
However this is not my main problem. The character & can be used in the URL to represent a logical AND. But a lot of our companies use this character in their name.
When searching for (Account_Name:equals:test & company) I get this:
{"code":"INVALID_QUERY","details":{},"message":"invalid query formed","status":"error"}
I tried escaping and encoding: (Account_Name:equals:test %5C%26 company) or (Account_Name:equals:test+%5C%26+company) ... and many more configurations
But then the API searches for the provides strings: "test %5C%26 company" or "test+%5C%26+company"
How can I search by comparing strings containing "&"?