Delete all rows from a table

DELETE

https://api.clay.com/v3/tables/{TABLE_ID}/records

Deletes all rows from a specific view in the table. This endpoint removes all records that are visible in the specified view, based on the view's filters.

Input: Provide the viewId to delete all rows from that view. You can optionally specify omitDeletingRecordIds to exclude certain records from deletion.

Note: This action is permanent and cannot be undone. All rows matching the view's filters will be deleted. Use with caution.

Request

Path Params

Header Params

Body Params application/x-www-form-urlencodedRequired

Responses

🟢200Success

application/json

Bodyapplication/json

Request Example

Shell

JavaScript

Java

Swift

curl --location --request DELETE 'https://api.clay.com/v3/tables/<TABLE_ID>/records' \
--header 'Cookie: {YOUR_CLAY_COOKIES}' \
--data-urlencode '%7B%22deleteAll%22%3Atrue%2C%22viewId%22%3A%22%7BVIEW_ID%7D%22%2C%22omitDeletingRecordIds%22%3A%5B%5D%2C%22recordIds%22%3A%5B%5D%2C%22viewFiltersHash%22%3A%22%7BFILTERS_HASH%7D%22%7D='

Response Example

{}

Modified at 2026-01-16 07:50:01

Delete a row from the table

Run an enrichment column