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.
To view more rows, export the report to Excel or use the printable view for tabular and summary reports. For joined reports, printable view displays a maximum of 20,000 rows. Printable view is only available in Salesforce Classic.
To better monitor your org's API usage and limits, you can use these resources: The API Usage section of the System Overview page in Setup. The API Requests, Last 24 Hours item in the Organization Detail section of the System Overview page in Setup.
A batch can contain a maximum of 10,000,000 characters for all the data in a batch. A field can contain a maximum of 32,000 characters.
part of the result is a nextRecordsUrl property which when you do a GET on it, will return you the next chunk of the results. See the section on query in the rest api docs.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With