API ReferenceDatabases

Execute SQL against database

Beta

Execute a SQL statement against the database. SELECT queries return columns and rows. Non-SELECT statements (CREATE, INSERT, UPDATE, DELETE, ALTER, DROP, etc.) return execution statuses.

Authentication

X-API-KEYstring
API Key authentication via header
OR
AuthorizationBearer

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

Path parameters

asset_idstringRequired

Request

This endpoint expects an object.
sqlstringRequired
SQL statement to execute

Response

Successful Response
columnslist of strings or null

Column names (populated for SELECT queries)

rowslist of maps from strings to any or null

Row data as objects (populated for SELECT queries)

statuseslist of strings or null

Execution statuses (populated for non-SELECT statements)

Errors

400
Bad Request Error
403
Forbidden Error
404
Not Found Error
422
Unprocessable Entity Error
500
Internal Server Error
501
Not Implemented Error
503
Service Unavailable Error