Get Results Sql Query

GET/api/v2/sqlQueries/{sqlQueryId}/getResults

Warning

This endpoint is in preview and may be modified or removed at any time. To use this endpoint, add preview=true to the request query parameters.

Gets the results of a query. This endpoint implements long polling and requests will time out after one minute. They can be safely retried while the query is still running.

Third-party applications using this endpoint via OAuth2 must request the following operation scope: api:sql-queries-read.

Path parameters

sqlQueryId

string

The id of a query.

Query parameters

preview

boolean

optional

Enables the use of preview functionality.

Response body

body

string

Examples

Request

Copied!

curl \
	-H "Authorization: Bearer $TOKEN" \
	"https://$HOSTNAME/api/v2/sqlQueries/OikKBfqBaWRjOGQ3YTJkNzMtYjhiZi00ZDMzLTlkOWMtOGQzOW/getResults?preview=true"

Error responses

Error Name
`QueryCanceled`	Error Code	`INVALID_ARGUMENT`
	Status Code	400
	Description	The query was canceled.
	Parameters	`queryId`
`QueryFailed`	Error Code	`INTERNAL`
	Status Code	500
	Description	The query failed.
	Parameters	`queryId, errorMessage`
`QueryParseError`	Error Code	`INVALID_ARGUMENT`
	Status Code	400
	Description	The query cannot be parsed.
	Parameters	`errorMessage`
`QueryRunning`	Error Code	`INVALID_ARGUMENT`
	Status Code	400
	Description	The query is running.
	Parameters	`queryId`
`ReadQueryInputsPermissionDenied`	Error Code	`PERMISSION_DENIED`
	Status Code	403
	Description	The provided token does not have permission to access the inputs to the query.
	Parameters	`rids`
`QueryPermissionDenied`	Error Code	`PERMISSION_DENIED`
	Status Code	403
	Description	The provided token does not have permission to access the given query.
	Parameters	`queryId`
`GetResultsSqlQueryPermissionDenied`	Error Code	`PERMISSION_DENIED`
	Status Code	403
	Description	Could not getResults the SqlQuery.
	Parameters	`sqlQueryId`

See Errors for a general overview of errors in the platform.