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.
Page 1 / 1
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.
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.