v1

latestOpenAPI 3.1.02026-07-26474165.4 KB
Query

Execute Query

The query operation allows you to execute a SQL query against one or more data sources configured in your Connect AI account. SELECT, INSERT, UPDATE, DELETE, and EXEC statements are all supported (though the /exec operation should be preferred for the latter).

post/query

Request body

defaultCatalogstring nullable

The default catalog to use for the query if none is specified in the query itself.

defaultSchemastring nullable
parametersobject nullable
querystring required

The SQL query to execute. Must be a valid SQL query.

schemaOnlyboolean

If true, only the schema of the result set is returned without any data rows. The default value is false.

timeoutinteger

Response

OK