Execute, or run a query for the specified query ID
Execute query and get result in one call
Use run_query
to get result in JSON,
run_query_csv
to get result in CSV format,
and run_query_dataframe
to get result in Pandas dataframe
If the query has parameters and you don’t add them in your API call, it will just run with the default params. You may add query parameters as part of the POST params data.
You can choose to include a performance
parameter, by default it will use the “medium” performance tier which consumes 10 credits. “large” will use 20 credits and are faster.
Returns an execution_id associated with the triggered query execution and the state of the execution.
API Key for the service
Unique identifier of the query
Alternative to using the X-Dune-Api-Key header
The performance engine tier the execution will be run on. Can be either medium
or large
. Medium consumes 10 credits, and large consumes 20 credits, per run. Default is medium
.
medium
, large
SQL Query parameters in json key-value pairs. Each parameter is to be provided in key-value pairs. This enables you to execute a parameterized query with the provided values for your parameter keys. Partial submission of parameters is allowed. For example, if the query expects three parameters and you only pass in two, the third one will automatically use its default value as defined in the Query Parameter Editor page.
OK
The response is of type object
.
Execute, or run a query for the specified query ID
Execute query and get result in one call
Use run_query
to get result in JSON,
run_query_csv
to get result in CSV format,
and run_query_dataframe
to get result in Pandas dataframe
If the query has parameters and you don’t add them in your API call, it will just run with the default params. You may add query parameters as part of the POST params data.
You can choose to include a performance
parameter, by default it will use the “medium” performance tier which consumes 10 credits. “large” will use 20 credits and are faster.
Returns an execution_id associated with the triggered query execution and the state of the execution.
API Key for the service
Unique identifier of the query
Alternative to using the X-Dune-Api-Key header
The performance engine tier the execution will be run on. Can be either medium
or large
. Medium consumes 10 credits, and large consumes 20 credits, per run. Default is medium
.
medium
, large
SQL Query parameters in json key-value pairs. Each parameter is to be provided in key-value pairs. This enables you to execute a parameterized query with the provided values for your parameter keys. Partial submission of parameters is allowed. For example, if the query expects three parameters and you only pass in two, the third one will automatically use its default value as defined in the Query Parameter Editor page.
OK
The response is of type object
.