Unable to fetch large query

Unable to fetch large query

Hi

I'm unable to retrieve more than 2000 records using the CRM API v6. Looking at the docs it is clear that the upper limit should be around 10.000, not 2000.

  1. Query error # {'code': 'LIMIT_EXCEEDED', 'details': {'by': 'limit', 'limit': 2000}, 'message': 'limit exceeded', 'status': 'error'} ## select id from Purchase_Orders where (Status in (Confirmed) and Delivery_Date between '2023-01-01' and '2024-01-01') and Vendor_Name.id in (4992289000000390001) limit 0,9999

The docs state:

"You can fetch a maximum of 10,000 records using this API."

https://www.zoho.com/crm/developer/docs/api/v7/COQL-Limitations.html