0 votes
1 view
in Salesforce by (11.9k points)

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.

1 Answer

0 votes
by (31.8k points)

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

Related questions

+1 vote
1 answer
+1 vote
1 answer
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...