Zoho CRM - COQL query failing with no reason

Zoho CRM - COQL query failing with no reason

Hi

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:
  1. {
    "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_
  2. Number_Short,Invoice_Date,Shipping_City,Shipping_Code,Shipping_Name,Shipping_State,Shipping_Street,Status,Sub_Total,Subject,Created_Time,Modified_Time,Terms_and_
  3. Conditions,Preorder_Number,Purchase_Order,Payment_Date,Account_Name.id,Account_Name.Company_Name,Account_Name.Email,Account_Name.First_Name,Account_Name.
  4. 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_
  5. Order.Status from Invoices where (Invoices.Invoice_Number_Short = 'F000038') and (Invoices.Delivery_Method = 'DC') and (Invoices.Shipping_Street = 'A_Street') and
  6. (Invoices.Shipping_State = 'New York') order by Invoices.id desc limit 0,5"
    }
Response code: 400 Bad Request

Response body:

  1. {
    "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