query_table
Filter, select, sort, and limit worksheet or table data by column values, comparisons, string matches, and blank checks to retrieve exactly the rows you need.
Instructions
Filter, project, sort, and limit worksheet or table data. Filters support eq/neq/ne, comparisons, string matching, blank checks, and in/not_in with value or values.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| select | No | ||
| filters | No | ||
| sort_by | No | ||
| filepath | Yes | ||
| row_mode | No | arrays | |
| sort_desc | No | ||
| header_row | No | ||
| sheet_name | No | ||
| table_name | No | ||
| infer_schema | No |