Trouble Searching for Hyphenated Phone Numbers in ZOHO CRM Using COQL Query and Curl Command

Trouble Searching for Hyphenated Phone Numbers in ZOHO CRM Using COQL Query and Curl Command

Hi.

I’m using the ZOHO CRM API and the curl command and trying to search for contacts using the COQL Query but it is not working.

Below are the problems that are happening now. I created a curl command to search for hyphenated phone numbers registered in ZOHO CRM as shown in the attached image.

  1. curl "https://www.zohoapis.com/crm/v4/coql" \
  2. -H "Authorization: Zoho-oauthtoken <access_token>" \
  3. -d '{ "select_query": "SELECT id, Phone, Mobile FROM Contacts WHERE ((Phone = '07077938815896689') OR (Mobile = '07077938815896689'))" }' \
  4. -X POST

Perhaps you are aware that there are no hyphenated phone numbers in my command .What I would like to know this time is, could you please tell me if it is possible to search for hyphenated phone numbers by entering non-hyphenated numbers in the search criteria of the command?

Best regards,