POST
/
v1
/
table
/
{namespace}
/
{table_name}
/
insert
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

{
  "rows_written": 9000
}
This endpoint is currently in beta, and may change without warning.
To be able to insert into a table, it must have been created with the /create endpoint.
  • 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.

​
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. 
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

Authorizations

​
x-dune-api-key
string
header
required

The API key of your team or user.

Path Parameters

​
namespace
string
required

The namespace of the table to insert into (e.g. my_user).

​
table_name
string
required

The name of the table to insert into (e.g. interest_rates).

Body

The file to insert into the table.

The body is of type file.

Response

200
application/json

Successful operation

The response is of type object.