# getrows: Get rows from a data table

> 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.

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.

- Group: Data tables
- Endpoint: `POST https://api.1001fx.com/datatables/getrows`
- Authentication: header `X-API-KEY: YOURSECRETAPIKEY`
- Content type: application/json
- Credits: 1 credit per call
- Ready-made in: Make
- Docs: https://1001fx.com/functions/getrows

## Parameters

- `table` (string, required) – Table: ID or name of the data table.
- `filters` (array<object>, optional) – Conditions: Optional. Without conditions all rows match.
  - `column` (string, required) – Column: Column name; id, createdAt and updatedAt work too.
  - `condition` (enum, required, one of `eq`, `neq`, `gt`, `gte`, `lt`, `lte`, `contains`, `isEmpty`, `isNotEmpty`) – Condition: contains ignores upper/lower case; isEmpty and isNotEmpty need no value.
  - `value` (any, optional) – Value: Compared by the type of the column.
- `match` (enum, optional, one of `all`, `any`, default `all`) – Match: all (default): every condition must match; any: one is enough.
- `limit` (number, optional, min 1, max 1000) – Limit: Maximum number of rows (default 100, at most 1000).
- `offset` (number, optional) – Offset: Rows to skip (paging).
- `orderBy` (string, optional) – Order by: Column to sort by (default id).
- `direction` (enum, optional, one of `asc`, `desc`, default `asc`) – Direction

## Example: Get rows from a data table

```bash
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"}'
```