queryTable
Query data from tables with filtering, sorting, and pagination. Supports advanced filter operators for precise record retrieval.
Instructions
Query data from a table with filtering, sorting, and pagination. Use this for most data retrieval needs. filter is passed directly to BaseQL _filter (supports operators like _eq, _in, _and, _or). Exact matches are case-sensitive unless you use advanced operators in _filter.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sort | No | Sort options, e.g., [{"field": "lastName", "direction": "asc"}] | |
| limit | No | Maximum records to return (default: 10, max: 100) | |
| fields | No | Specific fields to return, e.g., ["id", "firstName", "email"]. Omit to get all fields (slower). | |
| filter | No | BaseQL _filter object. Exact matches are case-sensitive, e.g., {"type": {"_eq": "Student"}}. Supports _and/_or and _eq/_ne/_in/_nin/_gt/_gte/_lt/_lte. For linked records, filter by ID: {"purchaser": ["rec123xyz"]}. | |
| offset | No | Records to skip for pagination. Example: offset 20 with limit 10 gets records 21-30. | |
| tableName | Yes | Table name to query (use listTables to see options) |