# updaterows: Update rows of a data table

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

Sets the given values on all rows that match the conditions (at least one condition). With dryRun the changed rows are returned without saving. 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/updaterows`
- Authentication: header `X-API-KEY: YOURSECRETAPIKEY`
- Content type: application/json
- Credits: 1 credit per call
- Ready-made in: Make
- Docs: https://1001fx.com/functions/updaterows

## 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.
- `data` (object, required) – Values: Columns to change, e.g. {"paid": true}.
- `dryRun` (boolean, optional, default `false`) – Dry run: Return the rows as they would be, without saving.
- `ignoreUnknownColumns` (boolean, optional, default `false`) – Ignore unknown columns: Skip keys that are not columns of the table instead of an error.

## Example: Update rows of a data table

```bash
curl -X POST 'https://api.1001fx.com/datatables/updaterows' \
  -H 'X-API-KEY: YOURSECRETAPIKEY' \
  -H 'Content-Type: application/json' \
  -d '{"table":"processed_orders","filters":[{"column":"orderId","condition":"eq","value":"A-17"}],"data":{"total":59.9}}'
```