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

Check if rows exist in a data table

datatables/rowexists

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

1 credit per callHTTP APIMake

Returns whether rows match the conditions and how many – e.g. as a filter in Make to skip records that were already processed (deduplication).

Endpoint

POSThttps://api.1001fx.com/datatables/rowexists
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>optional

    Optional. Without conditions all rows match.

    • 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

Examples

Check if rows exist in 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"
    }
  ]
}

Output · HTTP 200

Response
{
  "statusCode": 200
}
Show curl command
curl -X POST 'https://api.1001fx.com/datatables/rowexists' \
  -H 'X-API-KEY: YOURSECRETAPIKEY' \
  -H 'Content-Type: application/json' \
  -d '{"table":"processed_orders","filters":[{"column":"orderId","condition":"eq","value":"A-17"}]}'

Try rowexists 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