QueryAll More Results
If the number of results returned from a SOQL query exceeds the number of requested records or the limit, the response contains a batch of results, a false value for done, and a query locator. Use the query locator in a QueryAll More Results request to retrieve the next batch of records. If there are still more records to be returned, the response contains a new query locator and done is false. You can continue retrieving results from the initial QueryAll request until done is true, which indicates that all results are returned.
The response contains the total number of records returned by the QueryAll request (totalSize), a boolean indicating whether there are no more results (done), the URI of the next set of records (nextRecordsUrl), and an array of query result records (records).
Syntax
- URI
- /services/data/vXX.X/queryAll/queryLocator
- Formats
- JSON, XML
- HTTP Method
- GET
- Authentication
- Authorization: Bearer token
- Parameters
-
Parameter Description queryLocator A string used to retrieve the next set of query results. If there are more results to be retrieved, the previous set of QueryAll results contains the query locator in the nextRecordsUrl field.
Example
- Example Response Body
-
{ "totalSize": 3222, "done": false, "nextRecordsUrl": "/services/data/v63.0/query/01gRO0000016PIAYA2-500", "records": [ { "attributes": { "type": "Contact", "url": "/services/data/v63.0/sobjects/Contact/003RO0000035WQgYAM" }, "Id": "003RO0000035WQgYAM", "Name": "John Smith" }, ... ] }
Resources for Executing SOQL Queries
- To send a QueryAll request that includes deleted items, see Execute a SOQL Query that Includes Deleted Items.
- To increase the batch size of query results use the Query Options Header.
- For more information about SOQL generally, see the SOQL and SOSL Reference.