Skip to main content
POST
Query SQL Server

Authorizations

x-api-key
string
header
required

Optional API key for authentication (enabled via application.yaml)

Body

application/json
pipeline
string
required

Name of a pipeline with a SQL Server destination

sql
string

Read-only T-SQL to execute (SELECT or WITH, no semicolons or comments). Omit to preview the pipeline's destination table.

limit
integer
default:100

Maximum rows to return. 0 means the default; there is no upper bound. Pass -1 for unlimited (also disables the 30-second query timeout).

Response

Query results including the SQL that was executed

pipeline
string
sql
string
results
object[]
count
integer