'{"error":{"code":400,"details":[{"@type":"type.googleapis.com/google.rpc.ErrorInfo","metadata":{"cause":"Validation failed : DISCRETE_PAGINATION_LIMIT_EXCEEDED => You can only get the first 2000 records without using page_token param [ 2000 ] ","conditions":"","connection_type":"Zohocrm","entity_type":"Accounts"}}],"message":"Unable to list entities.","status":"FAILED_PRECONDITION"}}'
Solved
Getting an error while trying to access data from Cdata for zohocrm entities
Best answer by Ethem Q
Hi
Based on the description it looks like you are using the ZohoCRM connector in Google Cloud Apigee so this has been incorrectly tagged for Connect Cloud.
The "DISCRETE_PAGINATION_LIMIT_EXCEEDED => You can only get the first 2000 records without using page_token param" error message is tied to a limitation of the ZohoCRM API that requires the usage of a cursor based pagination when dealing with a resultset of 2000+ records. We have seen this error message before with our ZohoCRM connector when using UseCOQL=False however unless you are using an older version of the ZohoCRM connector this should be already fixed. With that being said, can you confirm the following?
- the version of the ZohoCRM connector
- the version defined for the Schema connection property
- is UseCOQL connection property set to False
The above information or a screenshot of the connection settings would be very helpful so we can further troubleshoot the problem.
On a side note if you are using an outdated version of the ZohoCRM connector, can try setting Schema=v2.1 as a workaround and see if that resolves the issue?
If you have any other questions feel free to reach out to the support team at [email protected].
This topic has been closed for replies.
Hi
Based on the description it looks like you are using the ZohoCRM connector in Google Cloud Apigee so this has been incorrectly tagged for Connect Cloud.
The "DISCRETE_PAGINATION_LIMIT_EXCEEDED => You can only get the first 2000 records without using page_token param" error message is tied to a limitation of the ZohoCRM API that requires the usage of a cursor based pagination when dealing with a resultset of 2000+ records. We have seen this error message before with our ZohoCRM connector when using UseCOQL=False however unless you are using an older version of the ZohoCRM connector this should be already fixed. With that being said, can you confirm the following?
- the version of the ZohoCRM connector
- the version defined for the Schema connection property
- is UseCOQL connection property set to False
The above information or a screenshot of the connection settings would be very helpful so we can further troubleshoot the problem.
On a side note if you are using an outdated version of the ZohoCRM connector, can try setting Schema=v2.1 as a workaround and see if that resolves the issue?
If you have any other questions feel free to reach out to the support team at [email protected].
Hi,
Here is the information you requested for the Zoho CRM connection:
-
Zoho CRM Driver Version: 23
-
Schema Version: V4
-
UseCOQL: False
Please let me know the next steps.
Thanks,
Hi
Thanks for providing the details. The issue is present in v23 builds but it has been resolved in v24 so this means you would need to use an updated v24 version of the ZohoCRM connector. You would need to reach out to GCP team for further steps.
In the meantime, let me know if setting Schema=v2.1 as a workaround gets you past the issue?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
