query_export
Filter NetSuite export rows using predicates like equality, comparison, contains, regex, or date range, optionally project columns, and control row limit.
Instructions
Filter rows from a NetSuite export by a list of predicates (AND-combined; empty list returns everything). Predicate ops: eq/ne, gt/gte/lt/lte, contains/not_contains (case-insensitive by default), regex, date_range (ISO 8601 start/end, inclusive by default). Optionally project to a subset of columns via the columns argument. Implicit limit=1000; pass limit=0 to get total_matched without fetching any rows. Returns rows, total_matched, and a truncated flag.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | ||
| filters | No | ||
| columns | No | ||
| limit | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | ||
| total_matched | Yes | ||
| truncated | Yes |