find_rows
Filter rows in a SeaTable table with a predicate DSL. Use operators like eq, contains, gt, and combine them with and/or/not. Supports pagination, sorting, and client-side filtering to retrieve specific records.
Instructions
Find rows using a predicate DSL. Filtering is performed client-side. where format: {"eq":{"field":"Name","value":"foo"}} or shorthand {"Name":"foo"}. Operators: eq, ne, in, gt, gte, lt, lte, contains, starts_with, ends_with, is_null. Combine with {"and":[...]} or {"or":[...]}. Negate with {"not":{...}}.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Target table name | |
| where | No | Filter predicate (e.g. {"eq":{"field":"Name","value":"foo"}} or shorthand {"Name":"foo"}) | |
| page | No | Page number (1-based) | |
| page_size | No | Rows per page (max 1000) | |
| order_by | No | Column name to sort by | |
| direction | No | Sort direction | asc |