export_table
Export rows from an IRIS table as JSON, CSV, or pipe-separated TXT. Narrow results using columns, where clause, and limit to manage response size.
Instructions
Export rows from an existing IRIS table as JSON, CSV, or TXT (pipe-separated).
The result is returned as a single string the caller can preview, copy to a file,
or stream to a downstream client. For large tables narrow the result with
columns, where, and/or limit to keep responses manageable.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table_name | Yes | Bare table name (letters, digits, underscore; no schema, no dot). | |
| table_schema | No | Schema of the table (default 'SQLUser'). | SQLUser |
| format | No | Output format — 'json' (list of objects), 'csv' (RFC 4180, comma delimiter, CRLF line terminator), or 'txt' (pipe-separated columns + ruler, same look as other tools' output). Case-insensitive. | json |
| columns | No | Optional list of column names to export. None or empty = all columns. | |
| where | No | Optional SQL fragment placed after WHERE (do **not** include the 'WHERE' keyword). Example: "Age > 30 AND City = 'Rome'". Caller is responsible for escaping; consider parameterized fetch_data for untrusted input. | |
| limit | No | Maximum number of rows to return. Pass 0 or a negative value to disable the cap (use only for known-small tables). |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |