> ## Documentation Index
> Fetch the complete documentation index at: https://dune-tables-docs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Execute Query

> Execute, or run a query for the specified query ID

<Accordion title="Execute query and get result in one call">
  <Tip> If you are using the [Python SDK](https://github.com/duneanalytics/dune-client/tree/d2195b2a9577e2dcae5d2600cb3eddce20987f38), you can directly executes and fetches result in one function call, like below: </Tip>

  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

  ```python 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()

  query = QueryBase(
      name="Sample Query",
      query_id=1215383,
  )

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

  # go over the results returned
  for row in result.result.rows: 
      print (row) # as an example we print the rows
  ```
</Accordion>

If the query has parameters and you don't add them in your API call, it will just run with the default params. You may add query parameters as part of the POST params data.

You can choose to include a `performance` parameter, by default it will use the "medium" performance tier which consumes 10 credits. "large" will use 20 credits and are faster.

Returns an execution\_id associated with the triggered query execution and the state of the execution.

<RequestExample>
  ```bash cURL
  curl -X POST "https://api.dune.com/api/v1/query/{{query_id}}/execute"   \
    -H "X-Dune-API-Key: {{api_key}}                                       \
    -H "Content-Type: application/json"                                   \
    -d '{"query_parameters": {"param1":24}, "performance": "large"}'
  ```

  ```python Python SDK

  '''
  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()

  # define the query to run
  query = QueryBase(
      name="Sample Query",
      query_id=1215383,
      params=[
          QueryParameter.text_type(name="TextField", value="Word"),
          QueryParameter.number_type(name="NumberField", value=3.1415926535),
          QueryParameter.date_type(name="DateField", value="2022-05-04 00:00:00"),
          QueryParameter.enum_type(name="ListField", value="Option 1"),
      ],
  )

  result = dune.execute_query(query = query # pass in the query we just defined
            , performance = "large" # define engine query is run on, default is "medium"
  )

  ```

  ```python Python
  import requests

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

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

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

  print(response.text)

  ```

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

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

  ```

  ```go Go
  package main

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

  func main() {

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

      req, _ := http.NewRequest("POST", 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 PHP
  <?php

  $curl = curl_init();

  curl_setopt_array($curl, [
  CURLOPT_URL => "https://api.dune.com/api/v1/query/{query_id}/execute",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "POST",
  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;
  }

  ```

  ```java Java
  HttpResponse<String> response = Unirest.post("https://api.dune.com/api/v1/query/{query_id}/execute")
  .header("X-DUNE-API-KEY", "<x-dune-api-key>")
  .asString();
  ```
</RequestExample>