Database
Run Query
POST
/
v1
/
database
/
query
/
Authorizations
Authorization
string
headerrequiredBearer authentication header of the form Bearer <token>
, where <token>
is your auth token.
Body
query
string
requiredQueries to run. Multiple queries can be separated by semicolons.
Response
200 - application/json
query_id
string
requiredThe query UUID.
query
string
requiredThe query that was run.
summary
object
requiredThe summary of the query results.
row_count
integer
requiredThe number of rows returned by the query.
column_names
string[]
requiredA list of strings representing the column names
column_types
string[]
requiredA list of strings representing the column types
result_rows
array
requiredA matrix of the data returned in the form of a Sequence of rows, with each row element being a sequence of column values.
start_timestamp
number
requiredThe timestamp when the query started running.
end_timestamp
number
requiredThe timestamp when the query finished running.