Read trial-balance source data
get_tb_rowsRead the SOURCE DATA behind a statement: the trial-balance rows (account name, debit, credit) as landed for a period, BEFORE grouping — the pre-statement numbers, not statement figures. PREFER FILTERS over fetching everything: name_patterns (e.g. ['cash','bank','od']), side ('debit'/'credit' by net balance), and min_abs_balance return a small exact subset with its own debit/credit totals — e.g. wrong-side cash accounts = name_patterns ['cash','bank'] + side 'credit'. Paginated (page 1-based; page_size default 50, max 500). These are the CURRENT live rows: statement figures are frozen at a generated version, so if the trial balance was re-uploaded after a version was generated, these rows may not tie to that version (the response note says so). Amounts are decimal strings in rupees. Figures are Datavrn's deterministic engine output; interpretation is your assistant's.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page | No | 1-based page number (default 1). | |
| side | No | Keep only accounts whose net balance falls on this side (debit = debits exceed credits). Accounts netting to zero match neither. | |
| client_id | Yes | The entity (client) id — from list_clients. | |
| page_size | No | Rows per page (default 50, max 500 — prefer filters over big pages). | |
| period_id | Yes | The reporting period id — from list_periods. | |
| name_patterns | No | Up to 10 case-insensitive substrings; an account matches if its name contains ANY of them (e.g. ['gst','tds']). | |
| min_abs_balance | No | Keep only accounts whose balance (the larger of its debit/credit) is at least this many rupees — a decimal string like '100000'. |