API ReferenceQuery

Get query

Get query including paginated results if the query execution is complete.

Note: You can only paginate up until 10,000 rows. Please use our Export to S3 option for the full result set.

Authentication

AuthorizationBearer

Bearer authentication of the form Bearer <token>, where token is your auth token.

Path parameters

query_idstringRequiredformat: "uuid4"
The unique identifier for the query

Query parameters

offsetintegerOptional0-9223372036854776000Defaults to 0
Starting index to return in the results
limitintegerOptional1-9223372036854776000Defaults to 100
Max number of items to return in the results
exclude_resultsbooleanOptionalDefaults to false
Optionally exclude results from the response

Response

Query data including paginated results if available
createdUserIdstring
The user that created the resource
createdDtstringformat: "date-time"
The created datetime of the resource
updatedUserIdstring
The user that last updated the resource
updatedDtstringformat: "date-time"
The datetime the resource was last updated
queryIdstringformat: "uuid4"
The query id
querystring
The SQL query
datasetIdstringformat: "uuid4"
The dataset id
statusenum
The current status of the query
startDtstring or nullformat: "date-time"
The time the query started executing
endDtstring or nullformat: "date-time"
The time the query finished executing
isActiveboolean or nullDefaults to false
Defines if the query is in an active state or not
resultobject or null
The result of the query

Errors