Given a query ID, returns the latest executed result of a query on Dune in JSON format
You must pass parameter query_id.
Returns the latest execution id and results (in JSON) of that latest run, regardless of the job id/run or if it is run in the app or the api.
The query specified must either be public or a query you have ownership of (you or a team you belong to have ownership).
allow_partial_results
set to true will trigger an error message: “error”: “Partial Result, please request with ‘allows_partial_results=true’”. If you wish to retrieve partial results, you can pass the parameter allow_partial_results=true
. But please make sure you indeed want to fetch the truncated result.Execute query and get result in one call
Use run_query
to get result in JSON,
run_query_csv
to get result in CSV format,
and run_query_dataframe
to get result in Pandas dataframe
API Key for the service
Query ID
Alternative to using the X-Dune-Api-Key header
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.
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.
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.
There is a default 250,000 datapoints limit to make sure you don't accidentally spend all your credits in one call. To ignore the max limit, you can add ignore_max_datapoints_per_request=true
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).
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).
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.
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.
OK
The response is of type object
.
Given a query ID, returns the latest executed result of a query on Dune in JSON format
You must pass parameter query_id.
Returns the latest execution id and results (in JSON) of that latest run, regardless of the job id/run or if it is run in the app or the api.
The query specified must either be public or a query you have ownership of (you or a team you belong to have ownership).
allow_partial_results
set to true will trigger an error message: “error”: “Partial Result, please request with ‘allows_partial_results=true’”. If you wish to retrieve partial results, you can pass the parameter allow_partial_results=true
. But please make sure you indeed want to fetch the truncated result.Execute query and get result in one call
Use run_query
to get result in JSON,
run_query_csv
to get result in CSV format,
and run_query_dataframe
to get result in Pandas dataframe
API Key for the service
Query ID
Alternative to using the X-Dune-Api-Key header
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.
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.
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.
There is a default 250,000 datapoints limit to make sure you don't accidentally spend all your credits in one call. To ignore the max limit, you can add ignore_max_datapoints_per_request=true
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).
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).
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.
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.
OK
The response is of type object
.