/dune/queries

POST /api/dune/queries

Price: 1 credit

Get a Dune query by id: SQL text, metadata, author, parameters and visualizations

How to use it

Get a Dune Analytics query by its numeric id (the number in a dune.com/queries/{id} URL). Returns the full SQL text, name, AI-generated description, tags, star count, created/updated timestamps, the author (analyst or team), declared query parameters, and the visualizations defined on the query. Use the 'queries/results' endpoint to fetch the actual cached on-chain result rows for a query.

Parameters

• access-token string required

Request body

• timeout integer — Max scrapping execution timeout (in seconds) (default: 300; min: 20; max: 1500)
• query integer required — Query id (numeric), e.g. 5868495 or a dune.com/queries/{id} URL (examples: 5868495)

Response

• @type string (default: "DuneQuery")
• id integer required
• name string nullable
• description string nullable
• ai_description string nullable
• sql string nullable
• version integer nullable
• dataset_id integer nullable
• tags array (default: [])
• is_private boolean (default: false)
• is_archived boolean (default: false)
• star_count integer nullable
• fork_count integer nullable
• is_favorite boolean (default: false)
• created_at string nullable
• updated_at string nullable
• author object nullable
  • @type string (default: "DuneAuthor")
  • id integer nullable
  • name string nullable
  • alias string nullable
  • image string nullable
  • is_team boolean (default: false)
• parameters array (default: [])
  • @type string (default: "DuneQueryParameter")
  • key string required
  • type string nullable
  • value string nullable
• visualizations array (default: [])
  • @type string (default: "DuneVisualization")
  • id integer required
  • type string nullable
  • name string nullable
  • description string nullable

Errors

• 422 — The request body did not validate Check the fields against this schema. A URN with the wrong prefix is the most common cause.
• 408 — The request ran past its time limit Raise `timeout` in the request body, up to the maximum this endpoint documents. Lowering `count` or turning off the `with_*` flags also helps, because less work finishes sooner.
• 412 — Query not found Retrying will not help: either the entity does not exist, or the input points at a different one.
• 429 — Too many requests: a rate limit or a usage window is exhausted When the response carries an X-Retry-After header, wait that many seconds and retry: the same number is in the body as `detail.retry_after`, and the limit clears once that window passes. The message in the body names the limit that was hit.
• 500 — Something broke on our side Retrying will not help. If it keeps happening, send us the X-Request-ID from the response headers.
• 529 — Rate limit reached, or the endpoint is overloaded Wait at least 30 seconds, then retry.

Response headers

• X-Error — Error message text (present only on error)
• X-Request-ID — Unique request identifier
• X-Execution-Time — Execution time in seconds
• X-Result-Count — How many records the body carries. 0 means an empty result, which is a normal answer and not by itself an error. A non-zero count can come back together with X-Error when the failure happened partway through — read this header and X-Error independently.
• X-Total-Available-Results — How many records exist for this query, when the endpoint can say. On a `dry_run` request this is the answer and the body is empty. It saturates: the endpoint's documented maximum means 'at least that many', any smaller number is exact.
• X-Warning — Present when the request body carried keys this endpoint does not document. They were ignored, so any filter you meant to apply through them did not apply. Check the spelling against this schema and retry.
• X-Retry-After — Seconds to wait before retrying. Present only on 429.