---
title: "Ex Fetch Rows With Filters"
method: POST
path: "/v2/module/table/{id}/row/fetch"
tags: ["Table Module"]
---

# Ex Fetch Rows With Filters

`POST /v2/module/table/{id}/row/fetch`

# Filter Rows in Table

## Request Parameters

### Pagination Options

- `page`: Page number (starting from 0)
- `page_size`: Number of items per page

### Filtering Options

- `filters`: Array of Filter Objects

## Request Body

```json
{
    "start_date": [
        {
            "operator": "asc"
        }
    ],
    "ms_table_lookup": [
        {
            "operator": "in",
            "query": [
                "op2"
            ]
        }
    ],
    "child_table_column_slug": {
        "child_table_column": [
            {
                "operator": "regex",
                "query": "32"
            }
        ]
    }
}
```

## Response

*Array of Table Rows*

---

## Notes

1. The exact nature of input and output may vary based on specific system requirements and configurations.
2. When filtering over nested (child) tables, the filter key used is the column slug of the child table in the parent table. The inner slug belongs to the column to be filtered in the child table.

---

# Documentation for Table Column Filters

## Filter Operators

| Operator | Description |
|----------|-------------|
| `regex`  | Performs a regular expression search |
| `gt`     | Filters greater than |
| `lt`     | Filters less than |
| `gte`    | Filters greater than or equal to |
| `lte`    | Filters less than or equal to |
| `eq`     | Filters equal |
| `ne`     | Filters not equal |
| `in`     | Filters for values in input *array* |
| `nin`    | Filters for values not in input *array* |

## Column Types and Supported Filters

### 1. Text
- **Supported Operators**: regex
- **Query Example**: `"expe"`

### 2. Date
- **Supported Operators**: gte, lte, eq, gt, lt
- **Query Example**: `"2023-01-01"`

### 3. SingleSelect
- **Supported Operators**: gte, lte, eq, gt, lt
- **Query Example**: `"slack"`

### 4. Binary
- **Supported Operators**: in, nin
- **Query Example**: `"[true, false]"`

### 5. MultiSelect
- **Supported Operators**: in, nin
- **Query Example**: `"[slack, gmail]"`

### 6. Phone
- **Supported Operators**: regex
- **Query Example**: `"+123"`

### 7. Email
- **Supported Operators**: regex
- **Query Example**: `"john@vert"`

### 8. User
- **Supported Operators**: in, nin
- **Query Example**: `"[42, 6]"`

### 9. Team
- **Supported Operators**: in, nin
- **Query Example**: `"[9]"`

### 10. Number
- **Supported Operators**: gt, gte, lt, lte, eq, ne
- **Query Example**: `"111"`

### 11. File
- **Supported Operators**: regex
- **Query Example**: `"april renewals"`

### 12. Url
- **Supported Operators**: regex
- **Query Example**: `"google.co"`

### 13. Currency
- **Supported Operators**: gte, lte
- **Query Example**: `"500"`

## Path parameters

- `id` string, required

## Query parameters

- `page` integer — Page number
- `page_size` integer — Number of items per page

## Headers

- `authorization` string, required — The authorization token can be retrieved by calling the OAuth authentication API. The value for this header parameter follows the format "Bearer &nbsp;&nbsp; `access_token`" (excluding the quotes). For example: <br /> `Bearer MZA1YJMYZDKTZTFMMI0ZYZG1LTLMMDGTYTG4NJG2YZC3NJGY`

## Request body

- object

## Response `200`

Successful Response

- FetchRowResponse
  - `page` integer, required
  - `page_size` integer, required
  - `total` integer, required
  - `data` unknown[], required
    - unknown
  - `columns` string[]

## Other responses

- `401` — Unauthorized
- `422` — Validation Error

---

[API](https://skmtc.dev/expent/apis/expent-apis.md) · [All operations](https://skmtc.dev/expent/apis/expent-apis/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/expent/expent-apis/revisions/ce1d50af5e2c/schema)