Note: This release is in preview. Features described here don’t become generally available until the latest general availability date that Salesforce announces for this release. Before then, and where features are noted as beta, pilot, or developer preview, we can’t guarantee general availability within any particular time frame or at all. Make your purchase decisions only on the basis of generally available products and features.

QueryAll More Results

Returns the next batch of results from a QueryAll request using a query locator. This API resource executes the specified QueryAll request. This resource is available in REST API version 29.0 and later.

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 URI specified in the nextRecordsUrl field of a QueryAll response body contains query instead of queryAll. To retrieve the next set of results, you can use either the Query More Results or the QueryAll More Results resources with the same query locator. The remaining results include deleted records that match the initial query.

For example, if the response body of a QueryAll request contains "nextRecordsUrl": "/services/data/v67.0/query/01g5e00001AH2dOAAT-4000", you can retrieve the next set of QueryAll results with either URI.

/services/data/v67.0/query/01g5e00001AH2dOAAT-4000
/services/data/v67.0/queryAll/01g5e00001AH2dOAAT-4000

Note

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

1{
2  "totalSize": 3222,
3  "done": false,
4  "nextRecordsUrl": "/services/data/v67.0/query/01gRO0000016PIAYA2-500",
5  "records": [
6    {
7      "attributes": {
8        "type": "Contact",
9        "url": "/services/data/v67.0/sobjects/Contact/003RO0000035WQgYAM"
10      },
11      "Id": "003RO0000035WQgYAM",
12      "Name": "John Smith"
13    },
14    ...
15  ]
16}

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.

REST API Developer Guide

QueryAll More Results

Syntax

Example

Resources for Executing SOQL Queries