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

1 credit per callHTTP API

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 (no body)

Parameters

This function has no parameters.

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