Update Query

This API allows for anyone to update the sql text, parameters, name, tags, and state of a query. Only the API key generated under the context of the owner of that query will work.

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

Headers

X-DUNE-API-KEY

string

required

API Key for the service

Path Parameters

queryId

integer

required

unique identifier of the query

Body

application/json

query_id

integer

Unique identifier of the query.

name

string

Name of the query.

description

string

Description of the query.

tags

string[]

Tags associated with the query.

parameters

object[]

Show child attributes

parameters.key

string

required

The key name of the parameter.

parameters.description

string

A brief description of the parameter.

parameters.value

string

The default value used by this parameter during execution, format depends on the type.

parameters.values

string[]

An array of string values, used when multiple selections are allowed.

parameters.type

enum<string>

The type of the parameter, determines the format of 'value(s)'. 'number': Numeric parameters, the value must be a number (e.g., '20'). 'text': String parameters, value can be any text including hex 0x-prefixed values (e.g., '0xae2fc...'), an empty value defaults to an empty string. 'datetime': Date and time parameters, value must be in 'YYYY-MM-DD hh:mm:ss' format (e.g., '2021-12-31 23:59:59'). 'enum': Parameters with a specific list of values, 'EnumValues' field is mandatory, providing a JSON list of strings representing valid options, the 'value' must be one of these options (e.g., 'Option1').

Available options:

number,

text,

datetime,

enum

parameters.EnumValues

string[]

List of valid options for 'enum' type parameters.

parameters.isMultiselect

boolean

Indicates if multiple selections are allowed for this parameter.

parameters.isFreeformAllowed

boolean

Indicates if freeform input is allowed for this parameter.

parameters.enumFromResults

object

Show child attributes

parameters.enumFromResults.queryId

integer

The ID of the query to fetch results from.

parameters.enumFromResults.columnName

string

The column name to use from the query results.

query_sql

string

The SQL query text.

is_private

boolean

Indicates if the query is private.

is_archived

boolean

Indicates if the query is archived.

Response

200

application/json

OK

query_id

integer