Use the GET /api/v3/query/{queryId}/chunks/{chunkId} endpoint of the Data 360 Query API to retrieve a specific result chunk from a completed query. Use the chunkCount field from the query status response to determine the available chunk IDs. Results are streamed and available in JSON or Apache Arrow format.
/api/v3/query/{queryId}/chunks/{chunkId}| Parameter | Type | Description |
|---|---|---|
queryId | string | Required. The unique identifier of the query returned from POST /api/v3/query. Example: MTAuMjcuMTgxLjE0OTo3NDg0_1cfc8d35. |
chunkId | integer | Required. The chunk index to retrieve. The index starts at 0. Use chunkCount from the query status response to determine the total number of available chunks. |
| Parameter | Required | Type | Description |
|---|---|---|---|
omitSchema | No | boolean | true to omit schema metadata from the response. Default false. |
| Header | Value |
|---|---|
Authorization | Bearer {accessToken} |
Accept | application/json or application/vnd.apache.arrow.stream |
Results are streamed using Transfer-Encoding: chunked.
| Field | Description |
|---|---|
metadata | Object containing column schema. Not included when omitSchema=true. |
data | Array of result rows, where each row is an array of values ordered by the metadata.columns schema. |
returnedRows | Number of rows returned in this chunk. Arrow responses omit this field. |
Set Accept: application/vnd.apache.arrow.stream to receive the chunk as a binary Arrow IPC stream instead of JSON. Arrow is recommended for large chunks.
This example shows a chunk retrieval request and response.
1GET https://{dne_cdpInstanceUrl}/api/v3/query/MTAuMzAuNTkuMTA4Ojc0ODQ_c3161a23-1803-c0a0-ce4a-9d5bc19deddc/chunks/1
2Authorization: Bearer {accessToken}1{
2 "metadata": {
3 "columns": [
4 { "name": "id__c", "type": "varchar", "nullable": false },
5 { "name": "name__c", "type": "varchar", "nullable": true }
6 ]
7 },
8 "data": [["c1ce2a48-9d03-4eed-938d-f354db79c425", "Gowtham"]],
9 "returnedRows": 1
10}
j