get_table
Read table data by name (case-insensitive) and retrieve columns, row records, or cached/formula values, with filtering and paging options. Read-only operation preserving source data.
Instructions
Read a table's data by its name (case-insensitive). columns projects a subset; values is cached | formula | both (the honest calc story); records true returns row objects keyed by column name. Returns the table ref, the column names, and the data rows without the header or totals row; filter or page big tables with query_range and a {table} location. Advanced table ops (columns, totals, resize, banding): manage_table (design pack). Read-only; nothing is written.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | ||
| path | Yes | ||
| values | No | cached | |
| columns | No | ||
| records | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||