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

Delete rows from a data table

datatables/deleterows

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.

1 credit per callHTTP APIMake

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.

Endpoint

POSThttps://api.1001fx.com/datatables/deleterows

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
dryRunbooleanoptional
Return the rows that would be deleted, without deleting.
Default:
false

Examples