Get query

Get query including paginated results if the query execution is complete

query_idstringRequiredformat: "uuid4"

The unique identifier for the query

offsetintegerOptional>=0<=9223372036854776000Defaults to 0

Starting index to return in the results

limitintegerOptional>=1<=9223372036854776000Defaults to 100

Max number of items to return in the results

exclude_resultsbooleanOptionalDefaults to false

Optionally exclude results from the 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

1	import requests
2
3	url = "https://app.coactive.ai/api/v1/queries/57552f03-87af-4847-a83e-e46a320af0c2"
4
5	querystring = {"offset":"0","limit":"100","exclude_results":"false"}
6
7	headers = {"Authorization": "Bearer <token>"}
8
9	response = requests.get(url, headers=headers, params=querystring)
10
11	print(response.json())

1	{
2	"createdUserId": "user_example",
3	"createdDt": "2018-09-11T15:11:45.456Z",
4	"updatedUserId": "user_example",
5	"updatedDt": "2018-09-11T15:11:45.456Z",
6	"queryId": "57552f03-87af-4847-a83e-e46a320af0c2",
7	"query": "select * from coactive_images_table",
8	"datasetId": "c40276f0-024b-4a3f-b3e6-dcf0d304843e",
9	"status": "Running",
10	"result": {
11	"error": "Error raised while executing query",
12	"meta": {
13	"page": {
14	"currentPage": 1,
15	"limit": 10,
16	"offset": 0,
17	"total": 100
18	},
19	"links": {
20	"next": "/api/list?limit=10&offset=10",
21	"first": "/api/list?limit=10&offset=0",
22	"last": "/api/list?limit=10&offset=90"
23	},
24	"sort": [
25	{
26	"direction": "asc",
27	"field": "name"
28	}
29	]
30	},
31	"data": []
32	}
33	}