API Reference

Transform and Execute SQL Query

post
https://api.controlup.com/historical/v1/dynamic-query/execute

Parse, validate, transform, and execute a SQL query, ensuring the result conforms to the expected structure and can be run safely.

Required permission: Dynamic Query

Available tiers: 5m, 1h, 1d, 1w, 1m, 30d

Maximum range per request: 90 days

Note that page and pageSize must be sent together.

For more information about data retention per tier, see here.

Body Params

SQL SELECT statement with date range and pagination parameters

SQL SELECT statement with date range and pagination parameters

string

SQL SELECT statement

date

Start date of the search period in the format: YYYY-MM-DD

date

End date of the search period in the format: YYYY-MM-DD

int32
1 to 5000

The number of items returned per page. Minimum is 1.

int32
1 to 10000

The page number returned. The first page is 1.

Responses

Updated 4 days ago

Did this page help you?
Language
Credentials
Bearer
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json

Updated 4 days ago

Did this page help you?