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.

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 months 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 months ago

Did this page help you?