Hi! I'am trying to use ZOHO QUERY API. And have a big issue with single quote in "select query".
When i try to send in body name with apostrophe, i get response with "message": "error occured while parsing the query"
All standart methods to escape quote doesn't work.
request body example:
{ "select_query": "select Owner, Account_Name from Accounts where Account_Name: 'Name with \' ' order by Last_Activity_time desc" }
Is there a way to solve this issue or do not use this field for search by coql?