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

Get rows from a data table

datatables/getrows

getrows (Get rows from a data table) is a 1001fx API function in the group Data tables: POST https://api.1001fx.com/datatables/getrows, 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 the rows of a data table that match the conditions, sorted and paged. Conditions: eq, neq, gt, gte, lt, lte, contains, isEmpty, isNotEmpty, compared by the column type. Default limit 100, at most 1,000.

Endpoint

POSThttps://api.1001fx.com/datatables/getrows
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
  • limitnumberoptional

    Maximum number of rows (default 100, at most 1000).

    Min:
    1
    Max:
    1000
    Example:
    100
  • offsetnumberoptional

    Rows to skip (paging).

    Example:
    0
  • orderBystringoptional

    Column to sort by (default id).

    Example:
    createdAt
  • directionenumoptional
    Values:
    asc
    desc
    Default:
    asc

Examples

Get rows from a data table

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

Input

Expects a json body
{
  "table": "processed_orders",
  "filters": [
    {
      "column": "total",
      "condition": "gt",
      "value": 20
    }
  ],
  "orderBy": "total",
  "direction": "desc"
}

Output · HTTP 200

Response
{
  "statusCode": 200
}
Show curl command
curl -X POST 'https://api.1001fx.com/datatables/getrows' \
  -H 'X-API-KEY: YOURSECRETAPIKEY' \
  -H 'Content-Type: application/json' \
  -d '{"table":"processed_orders","filters":[{"column":"total","condition":"gt","value":20}],"orderBy":"total","direction":"desc"}'

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