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

# Insert Data (beta)

> Insert the data in a file into a table.

<Warning>
  This endpoint is currently in beta, and may change without warning.
</Warning>

To be able to insert into a table, it must have been created with the [/create endpoint](./create).

<Note>
  * The data in the files must conform to the schema, and must use the same column names as the schema.
  * One successful `/insert` request consumes 10 credits.
</Note>

## Supported filetypes

### CSV files (`Content-Type: text/csv`)

CSV files must use a comma as delimiter, and the column names in the header must match the column names of the table.

### JSON files (`Content-Type: application/x-ndjson`)

These are files where each line is a complete JSON object which creates one table row.
Each line must have keys that match the column names of the table.

<RequestExample>
  ```bash curl
  curl --request POST \
    --url https://api.dune.com/api/v1/table/my_user/interest_rates/insert \
    --header 'X-DUNE-API-KEY: <x-dune-api-key>' \
    --header 'Content-Type: text/csv' \
    --upload-file interest_rates.csv
  ```

  ```python Python SDK
  import dotenv, os
  from dune_client.client import DuneClient
   
  dotenv_path = os.path.join(os.path.dirname(__file__), '.', '.env')
  dotenv.load_dotenv(".env")
  dune = DuneClient.from_env()

  with open("./interest_rates.csv", "rb") as data:
      response = dune.insert_table(
              namespace="my_user",
              table_name="interest_rates",
              data=data,
              content_type="text/csv"
          )
  ```

  ```python Python
  import requests

  url = "https://api.dune.com/api/v1/table/my_user/interest_rates/insert"

  headers = {
      "X-DUNE-API-KEY": "<x-dune-api-key>",
      "Content-Type": "text/csv"
  }

  with open("./interest_rates.csv", "rb") as data:
    response = requests.request("POST", url, data=data, headers=headers)
  ```

  ```javascript Javascript
  const url = "https://api.dune.com/api/v1/table/my_user/interest_rates/insert";

  const headers = {
      "X-DUNE-API-KEY": "<x-dune-api-key>",
      "Content-Type": "text/csv"
  };

  fs.readFile('./interest_rates.csv', (err, data) => {
    if (err) {
        console.error(err);
        return;
    }

    fetch(url, {
          method: 'POST',
          headers: headers,
          body: data
      })  
      .then(response => response.json())
      .then(response => console.log(response))
      .catch(err => console.error(err));
  });
  ```
</RequestExample>