Zoho CRM - COQL query failing with no reason

I'm trying to execute a COQL query but it's returning an error. Unfortunately I cannot understand where I'm wrong

The query is the following;:

URL: POST https://www.zohoapis.com/crm/v2.1/coql

Body:

{
"select_query": "select id,Adjustment,Billing_City,Billing_Code,Billing_State,Billing_Street,Buyer_PO_Number,Delivery_Date,Delivery_Method,Due_Date,Grand_Total,Invoice_
Number_Short,Invoice_Date,Shipping_City,Shipping_Code,Shipping_Name,Shipping_State,Shipping_Street,Status,Sub_Total,Subject,Created_Time,Modified_Time,Terms_and_
Conditions,Preorder_Number,Purchase_Order,Payment_Date,Account_Name.id,Account_Name.Company_Name,Account_Name.Email,Account_Name.First_Name,Account_Name.
Last_Name,Account_Name.Delivery_Method,Account_Name.Store_Number,Account_Name.Account_Name,Sales_Order.id,Sales_Order.Number_Short,Sales_Order.Grand_Total,Sales_
Order.Status from Invoices where (Invoices.Invoice_Number_Short = 'F000038') and (Invoices.Delivery_Method = 'DC') and (Invoices.Shipping_Street = 'A_Street') and
(Invoices.Shipping_State = 'New York') order by Invoices.id desc limit 0,5"
}

Response code: 400 Bad Request

Response body:

{
"code": "SYNTAX_ERROR",
"details": {
"near": "where"
},
"message": "error occured while parsing the query",
"status": "error"
}

Important note: if I only leave two where criterias it works ok! Only after inserting more than 2 where criterias in the where clause it fails. Maybe I'm constructing incorrectly the query?

Can you please specify where I'm wrong in this query?

I'm also well below the limitations:

Thanks

Tout forum

France ZUGs

Zoho SalesIQ Resources

Topic Participants
dante
Abishek Mazumdar

Sticky Posts
The CX Workshops are back in 2023!
Hello, can you see my screen? Can you hear me? This is a phrase we've all been saying more often than "good morning" over the last couple of years. Well, now it's time to re-connect in person. We're excited to invite you all to the CX Workshops we've
Refer Zoho CRM Plus to your friends and earn rewards!
Hey everyone, We'd like to thank you from the bottom of our hearts for continuing to be our esteemed customers. Now you have the opportunity to refer Zoho CRM Plus to your friends or family members who are looking for a suitable solution to enhance
Social in CRM Plus now supports TikTok, Instagram Stories and Reels, and YouTube Shorts
Hey everyone, We are excited to inform you that Social in CRM Plus now allows you to publish on TikTok! We've also updated it to let you create Instagram Stories and Reels, as well as YouTube Shorts. Here's a brief about the updates. Publishing on
Unified telephony in Zoho CRM Plus
In any business, managing calls with the prospects or customers is an integral part of a salesperson or a support agent's daily life. They have access to information about the customers within Zoho CRM, and they also use a suitable PBX service to communicate
The New Zoho CRM Plus is here to stay from May 15th, 2018.
Last year, on November 1, 2017 - we released the New Zoho CRM Plus with an improved interface which offered a consistent user experience across all ten products. Since then, we have been testing and improving the New Zoho CRM Plus rigorously. The tons of feedback we've received from our customers have been immensely helpful to improve our product. We’re happy to say that finally - we are ready to jump into the deeper end of the pool. We are making The New Zoho CRM Plus as the default choice for