Get SQL Query Rows
Use the GET /api/v3/query/{queryId}/rows endpoint of the Data 360 Query API to retrieve results from a completed query using offset-based pagination. Use this endpoint to page through large result sets by specifying an offset and optional limit or byteLimit. Responses are available in JSON or Apache Arrow format.
- HTTP Method: GET
- Format: REST
- URI:
/api/v3/query/{queryId}/rows
| Parameter | Type | Description |
|---|---|---|
queryId | string | Required. The unique identifier of the query returned from POST /api/v3/query. Example: MTAuMjcuMTgxLjE0OTo3NDg0_1cfc8d35. |
| Parameter | Required | Type | Description |
|---|---|---|---|
offset | Yes | integer | Row offset to start from. |
limit | No | integer | Maximum number of rows to return. |
byteLimit | No | integer | Maximum bytes to return. Default and maximum is 20 MB (20000000). |
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 |
| 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 response. Arrow responses omit this field. |
This example shows a row retrieval request and response.
Set Accept: application/vnd.apache.arrow.stream to receive results as a binary Arrow IPC stream instead of JSON. Arrow is recommended for large result sets — it reduces payload size and deserialization overhead compared to JSON. The omitSchema query parameter has no effect on Arrow responses; the schema is always embedded in the Arrow stream.
For large result sets, Get SQL Query Chunks is the preferred retrieval method.