Salesforce REST API Query More than 2000

Question

I'm trying to execute a SOQL query using Salesforce REST API which will return 2,749 results. However, it seems there is a limit of 2,000 results that can be returned for a given request.

Is there a way to query the remaining 749 results without using the OFFSET keyword? (it's not currently supported in my production environment).

I looked into this and found a queryMore function but I can't find a way to call it through the REST API.

Answer 1

The API returns until the first 2,000 report rows. You can narrow the results using filters. You can add up to 20 custom field filters when you run a report in order to get more results.

Or, you can use nextRecordsUrl for query endpoint.

But, I’d suggest you to add a dynamic filter on a selected dimension

To learn in-depth about Salesforce, sign up for an industry based Salesforce Certification.