POST
/
v1
/
blockchain
/
{chain}
/
{table_name}
/
delete
curl --request POST \
  --url https://api.dune.com/api/v1/blockchain/my_chain/blocks/delete?date=2020-06-22 \
  --header 'X-DUNE-API-KEY: <x-dune-api-key>'
{
  "message": "Successfully deleted from table namespace.logs",
  "num_files_removed": 1,
  "num_rows_deleted": 1925
}

The Delete endpoint clears all the data in a predicate from the designated blockchain table. It leaves the other data intact. This endpoint allows you to correct or delete certain entries without needing to clear the whole table.

For now, only a single date is supported as a filtering condition. See ‘Query Parameters’.

Supported tables

  • blocks
  • transactions
  • logs
  • traces
curl --request POST \
  --url https://api.dune.com/api/v1/blockchain/my_chain/blocks/delete?date=2020-06-22 \
  --header 'X-DUNE-API-KEY: <x-dune-api-key>'

Authorizations

x-dune-api-key
string
headerrequired

The API key of your team or user.

Path Parameters

chain
string
required

The blockchain of the table to clear (e.g. my_chain).

table_name
enum<string>
required

The name of one of the supported tables to clear (e.g. blocks).

Available options:
blocks,
transactions,
logs,
traces

Query Parameters

date
string
required

The date to delete data from in the format YYYY-MM-DD (e.g. 2024-04-28).

Response

200 - application/json
message
string

The confirmation message of the deleted predicate

num_files_removed
number

The number of files removed from the underlying filesystem

num_rows_deleted
number

The number of rows deleted from the specified table