Zoho crm api v2 - getting records with Query Map
Hi.
When I want to get a record (Let's simplify it and say that for now I am only interested in Leads), I am getting this error response:
{
"errorMessage": "Only 'AND' operator is supported. Found a(n) 'OR' operator in the search expression",
"providerMessage": null,
"status": "BAD_REQUEST"
}
While my query looks like this:
{
"debug": "true",
"isVdrTrace": "true",
"page": "1",
"pageSize": "5",
"timestamp": "1629746501389",
"where": "Email='christopher-maclead@gmail.com' OR Phone='555-555-5555'"
}
As you can see it says that only the AND operation is supported and, overall, I can only use equals and 'AND'.
But I need to filter my Leads with 'OR', basically my queries will be like:
Email='christopher-maclead@gmail.com' OR Email='anothermail@gmail.com' OR Email='andanothermail@gmail.com' OR Phone='555-555-5555' OR Phone='111-111-1111'
What can I do to enable the OR operation (or, at the very least, not operation - De Morgan should do the trick)?
Maybe there is another endpoint that I could use for this?