Get Latest Query Result in CSV

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

You must pass parameter query_id.

Returns the latest execution id and results (in CSV) 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).

This endpoint does NOT trigger an execution but does consume credits through datapoints.

• Dune internally has a maximum query result size limit (which currently is 8GB, but subject to increase in the future). If your query yields more than 8GB of data, the result will be truncated in storage. In such cases, pulling the result data (using pagination) but without specifying 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.
• We recommend reading about Pagination to get the most out of the API and handle large results.

Execute query and get result in one call

If you are using the Python SDK, you can directly executes and fetches result in one function call, like below:

Python SDK

import dotenv, os, json
from dune_client.types import QueryParameter
from dune_client.client import DuneClient
from dune_client.query import QueryBase

# change the current working directory where .env file lives
os.chdir("/Users/abc/local-Workspace/python-notebook-examples")
# load .env file
dotenv.load_dotenv(".env")
# setup Dune Python client
dune = DuneClient.from_env()

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

result = dune.run_query(
    query=query # pass in query to run 
    , performance = 'large' # optionally define which tier to run the execution on (default is "medium")
    )

cURL

curl --request GET \
  --url https://api.dune.com/api/v1/query/{query_id}/results/csv

'''
Download Dune Python SDK by running `pip install dune-client`
For more info, visit the GitHub repository: https://github.com/duneanalytics/dune-client/tree/d2195b2a9577e2dcae5d2600cb3eddce20987f38
'''

import dotenv, os, json
from dune_client.types import QueryParameter
from dune_client.client import DuneClient
from dune_client.query import QueryBase

# change the current working directory where .env file lives
os.chdir("/Users/abc/local-Workspace/python-notebook-examples")
# load .env file
dotenv.load_dotenv(".env")
# setup Dune Python client
dune = DuneClient.from_env()

# pass in the query_id
result = dune.download_csv('2363421') 

# can also call `get_latest_result_dataframe` method to get latest result in Python Pandas dataframe format

import requests

url = "https://api.dune.com/api/v1/query/{query_id}/results/csv"

headers = {"X-DUNE-API-KEY": "<x-dune-api-key>"}

response = requests.request("GET", url, headers=headers)

print(response.text)

const options = {method: 'GET', headers: {'X-DUNE-API-KEY': '<x-dune-api-key>'}};

fetch('https://api.dune.com/api/v1/query/{query_id}/results/csv', options)
  .then(response => response.json())
  .then(response => console.log(response))
  .catch(err => console.error(err));

package main

import (
	"fmt"
	"net/http"
	"io/ioutil"
)

func main() {

	url := "https://api.dune.com/api/v1/query/{query_id}/results/csv"

	req, _ := http.NewRequest("GET", url, nil)

	req.Header.Add("X-DUNE-API-KEY", "<x-dune-api-key>")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := ioutil.ReadAll(res.Body)

	fmt.Println(res)
	fmt.Println(string(body))

}

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://api.dune.com/api/v1/query/{query_id}/results/csv",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => [
    "X-DUNE-API-KEY: <x-dune-api-key>"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

HttpResponse<String> response = Unirest.get("https://api.dune.com/api/v1/query/{query_id}/results/csv")
  .header("X-DUNE-API-KEY", "<x-dune-api-key>")
  .asString();