v1

latestOpenAPI 3.0.12026-07-22367385.5 KB

Given a query ID, returns the latest executed result of a query on Dune as CSV

Given a query ID, returns the latest executed result of a query on Dune as CSV

get/v1/query/{query_id}/results/csv

Path parameters

query_idstring required

Query ID

Query parameters

api_keystring

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

allow_partial_resultsboolean

This enables returning a query result that was too large and only a partial result is available. By default, allow_partial_results is set to false and a failed state is returned.

columnsstring

Specifies a comma-separated list of column names to return. If omitted, all columns are included. Tip: use this to limit the result to specific columns, reducing datapoints cost of the call.

filtersstring

Expression to filter out rows from the results to return. This expression is similar to a SQL WHERE clause. More details about it in the Filtering section of the doc. This parameter is incompatible with sample_count.

ignore_max_credits_per_requestboolean

To bypass the default max credits per request limit, set ignore_max_credits_per_request=true

limitinteger

Limit number of rows to return. This together with 'offset' allows easy pagination through results in an incremental and efficient way. This parameter is incompatible with sampling (sample_count).

offsetinteger

Offset row number to start (inclusive, first row means offset=0) returning results from. This together with 'limit' allows easy pagination through results in an incremental and efficient way. This parameter is incompatible with sampling (sample_count).

queryIDinteger required
sample_countinteger

Number of rows to return from the result by sampling the data. This is useful when you want to get a uniform sample instead of the entire result. If the result has less than the sample count, the entire result is returned. Note that this will return a randomized sample, so not every call will return the same result. This parameter is incompatible with offset, limit, and filters parameters.

sort_bystring

Expression to define the order in which the results should be returned. This expression is similar to a SQL ORDER BY clause. More details about it in the Sorting section of the doc.

Headers

X-Dune-Api-Keystring required

API Key for the service

Response

OK