Browse all functions

1001fx account

AI

Arrays

Audio & video

Carbone documents

Charts

Code

executejavascript

Data & JSON

Data tables

Date & time

Geo

Knowledge bases (RAG)

Playground

Spreadsheet

Stripe

downloadstripeinvoices

Update or insert a row in a data table

datatables/upsertrow

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

1 credit per callHTTP APIMake

Updates the rows that match the conditions; if none matches, inserts a new row. For the new row, eq conditions on columns that are not in the values are taken over (e.g. orderId eq A-17). Returns action (updated or inserted) and the rows. 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/upsertrow

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 set.
ignoreUnknownColumnsbooleanoptional
Skip keys that are not columns of the table instead of an error.
Default:
false

Examples