Insert Data (beta)

Insert the data in a file into a table.

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

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

rows_written

number

The number of rows that were written to the table.

Example:

9000