v1

latestOpenAPI 3.0.12026-07-22367385.5 KB

Execute, or run a query for the specified query ID

post/v1/query/{query_id}/execute

Path parameters

query_idinteger required

Unique identifier of the query

Query parameters

api_keystring

Alternative to using the X-Dune-Api-Key header

performance'small' | 'medium' | 'large'

The performance engine tier the execution will be run on. Can be small, medium, or large. Omit to use the default tier for the query engine. Credits are consumed based on actual compute resources used.

query_parametersstring

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.

Headers

X-Dune-Api-Keystring required

API Key for the service

Response

execution_idstring

statestring

Example response

{
  "execution_id": "01HKZJ2683PHF9Q9PHHQ8FW4Q1",
  "state": "QUERY_STATE_PENDING"
}