Skip to content
Browse all functions

1001fx account

AI

Arrays

Audio & video

Carbone documents

Charts

Code

Data & JSON

Data tables

Date & time

Files & PDF

Geo

Images

Knowledge bases (RAG)

Playground

Spreadsheet

Stripe

YouTube

Update rows of a data table

datatables/updaterows

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.

1 credit per callHTTP APIMake

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.

Endpoint

POSThttps://api.1001fx.com/datatables/updaterows
Header
X-API-KEY: YOURSECRETAPIKEY How to
Content type
application/json

Parameters

  • tablestringrequired

    ID or name of the data table.

    Example:
    processed_orders
  • filtersarray<object>required

    At least one condition.

    • columnstringrequired

      Column name; id, createdAt and updatedAt work too.

      Example:
      orderId
    • conditionenumrequired

      contains ignores upper/lower case; isEmpty and isNotEmpty need no value.

      Values:
      eq
      neq
      gt
      gte
      lt
      lte
      contains
      isEmpty
      isNotEmpty
      Example:
      eq
    • valueanyoptional

      Compared by the type of the column.

      Example:
      A-17
  • matchenumoptional

    all (default): every condition must match; any: one is enough.

    Values:
    all
    any
    Default:
    all
  • dataobjectrequired

    Columns to change, e.g. {"paid": true}.

  • dryRunbooleanoptional

    Return the rows as they would be, without saving.

    Default:
    false
  • ignoreUnknownColumnsbooleanoptional

    Skip keys that are not columns of the table instead of an error.

    Default:
    false

Examples

Update rows of a data table

Needs an API key of an account (not a test key).

Input

Expects a json body
{
  "table": "processed_orders",
  "filters": [
    {
      "column": "orderId",
      "condition": "eq",
      "value": "A-17"
    }
  ],
  "data": {
    "total": 59.9
  }
}

Output · HTTP 200

Response
{
  "statusCode": 200
}
Show curl command
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}}'

Try updaterows now

Run it in your browser or create a free account and get 100 credits every month.

Try it in the appGet your free API key

More in Data tables

Changelog

  • 1.0.001.11.2026created