Create Query

This API allows for anyone to create a query. The owner of the query will be under the context of the API key.

To access Query endpoints, a Plus plan or higher is required.

Headers

X-Dune-Api-Key

string

required

API Key for the service

Query Parameters

api_key

string

API Key, alternative to using the HTTP header X-Dune-Api-Key

Body

*/*

name

string

required

The name of the createc query.

query_sql

string

required

The SQL of the query.

description

string

The description of the created query.

is_private

boolean

Indicates if the query is private, meaning that only the team or, in case of personal queries, the user that created it can see it.

parameters

object[]

The parameters that the SQL query accepts.

Show child attributes

parameters.description

string

parameters.enumFromResults

object

Show child attributes

parameters.enumFromResults.columnName

string

parameters.enumFromResults.queryId

integer

parameters.enumOptions

string[]

parameters.isFreeformAllowed

boolean

parameters.isMultiselect

boolean

parameters.key

string

parameters.type

string

parameters.value

string

parameters.values

string[]

tags

string[]

The tags of the query.

Response

200 - application/json

query_id

integer

The Unique ID of the created query