Read table
banana_tableExtract table data from Banana Accounting documents, choosing specific views, columns, and output as JSON or HTML.
Instructions
Return the content of a table in a document. Defaults to JSON. Supports selecting a view, a subset of columns, and html/json output.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| doc | No | Accounting document name as opened in Banana (e.g. "accounting.ac2"). Append "_p1", "_p2" for previous years. Defaults to BANANA_DEFAULT_DOC if set. | |
| view | No | XML name of the view to return. | |
| table | Yes | Table name, e.g. "Accounts", "Transactions", "Budget", "FileInfo". | |
| format | No | Response format. Defaults to "json" for machine-readable output. | |
| columns | No | Comma-separated XML names of columns to return, e.g. "Account,Description,Balance". | |
| navigation | No | When true, include the HTML page navigation (only relevant for html format). |