# deleterows: Delete rows from a data table

> deleterows (Delete rows from a data table) is a 1001fx API function in the group Data tables: POST https://api.1001fx.com/datatables/deleterows, 1 credit per call. It works as a ready-made module in Make or as a plain HTTP call.

Deletes all rows that match the conditions (at least one condition) and returns them. With dryRun the rows are only returned. Parallel calls on the same table can overwrite each other (last write wins): in Make, process bundles one after another for writing functions.

- Group: Data tables
- Endpoint: `POST https://api.1001fx.com/datatables/deleterows`
- Authentication: header `X-API-KEY: YOURSECRETAPIKEY`
- Content type: application/json
- Credits: 1 credit per call
- Ready-made in: Make
- Docs: https://1001fx.com/functions/deleterows

## Parameters

- `table` (string, required) – Table: ID or name of the data table.
- `filters` (array<object>, required) – Conditions: At least one condition.
  - `column` (string, required) – Column: Column name; id, createdAt and updatedAt work too.
  - `condition` (enum, required, one of `eq`, `neq`, `gt`, `gte`, `lt`, `lte`, `contains`, `isEmpty`, `isNotEmpty`) – Condition: contains ignores upper/lower case; isEmpty and isNotEmpty need no value.
  - `value` (any, optional) – Value: Compared by the type of the column.
- `match` (enum, optional, one of `all`, `any`, default `all`) – Match: all (default): every condition must match; any: one is enough.
- `dryRun` (boolean, optional, default `false`) – Dry run: Return the rows that would be deleted, without deleting.

## Example: Delete rows from a data table

```bash
curl -X POST 'https://api.1001fx.com/datatables/deleterows' \
  -H 'X-API-KEY: YOURSECRETAPIKEY' \
  -H 'Content-Type: application/json' \
  -d '{"table":"processed_orders","filters":[{"column":"createdAt","condition":"lt","value":"2026-01-01"}]}'
```