Transactions: get transactions
transactions_listFetch bank transactions for a customer account by date range or payer/payee. Supports pagination with limit and offset to retrieve specific subsets, ideal for reconciling accounts or auditing activity.
Instructions
🟢 READ-ONLY: Fetches data. Makes no changes to the accounting records.
get transactions
Get transactions for a specified customer account. The response includes the number of returned rows and an array of transaction datas.
Use to search bank transactions by account and date range.
To fetch one known transaction, use transactions_get_by_id.
Supports limit and offset; the response reports the total in rows. Ask for a bounded date range rather than the full history.
Endpoint: POST /transactions/get
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | A limit of returned data. If no limit is given, the default will be 500. Also the maximum limit is 500. If specified, the field will be validated. | |
| offset | No | The offset for paging returned data. If no offset is given, the default will be 0. If specified, the field will be validated. | |
| account | No | The account number of the account the transaction is stored to. If specified, the field will be validated. | |
| date_to | No | The transaction's booking date in format 'YYYY-MM-DD' (e.g. '2017-04-26'). All transaction with booking date including and before given value will be returned. An empty string is not considered a valid date. | |
| to_from | No | The payer/payee of the transaction. If specified, the field will be validated. | |
| date_from | No | The transaction's booking date in format 'YYYY-MM-DD' (e.g. '2017-04-26'). All transactions with booking date including and after given value will be returned. An empty string is not considered a valid date. | |
| id_by_customer_to | No | The id_by_customer as an integer. All transactions to given value will be returned. The transaction with the given value will NOT be returned! NOTE: By specifying this, the sort changes to id_by_customer ASC, even if you use this in combination with date params. If specified, the field will be validated. | |
| id_by_customer_from | No | The id_by_customer as an integer. All transactions after given value will be returned. The transaction with the given value will NOT be returned! NOTE: By specifying this, the sort changes to id_by_customer ASC, even if you use this in combination with date params. If specified, the field will be validated. | |
| date_since_last_modified | No | A date and time in format 'YYYY-MM-DD HH:MM:SS' (e.g. '2017-04-26 13:45:00'). If only 'YYYY-MM-DD' is specified, the time defaults to '23:59:59'. All transactions whose date_updated value is later than the specified value will be returned. If specified, the field will be validated. An empty string is not considered a valid date. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | No | An array of transactions data | |
| rows | No | Number of returned rows | |
| message | No | blank | |
| success | Yes | Success boolean |