What is the maximum number of results that can be obtained with Find Records(s) by Query in Salesforce?
It seems that sometimes you can get 500 items and sometimes you can get 1000 items.
I would like to know what restrictions there are.
Answer
What is the maximum number of results from Find Records by Query in Salesforce?
- Beginner
Best answer by Troy Tessalone
Appears Salesforce has a limit of 2,000 records returned.
Using the standard query pagination, you can get the error, "The maximum offset is 2,000 rows. Requesting an offset greater than 2,000 will result in a NUMBER_OUTSIDE_VALID_RANGE error." While we can't increase the limit since it's hard coded, here are some suggested workarounds.
https://help.salesforce.com/s/articleView?id=000387840&type=1
https://help.salesforce.com/s/articleView?id=000386264&type=1
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
How are you trying to use the returned records after the Salesforce step?
e.g. If you are trying to iterate thru each, the Looping by Zapier Zap app has a 500 iteration limit.
Other apps have limits per page (pagination) or limits on handling arrays of line items.
The size of the returned data can also cause issues in Zap steps.
+14- Zapier Orchestrator & Solution Partner
- Answer
Appears Salesforce has a limit of 2,000 records returned.
Using the standard query pagination, you can get the error, "The maximum offset is 2,000 rows. Requesting an offset greater than 2,000 will result in a NUMBER_OUTSIDE_VALID_RANGE error." While we can't increase the limit since it's hard coded, here are some suggested workarounds.
https://help.salesforce.com/s/articleView?id=000387840&type=1
https://help.salesforce.com/s/articleView?id=000386264&type=1
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.