find_rows
Read-onlyIdempotent
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":{...}}.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"table": "<table>"
},
"name": "find_rows"
}
}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 |