Ex Fetch Rows With Filters

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

{
    "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

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"