list_expenses
Read-onlyIdempotent
Retrieve expense records from Bexio with filters for date ranges, amounts, vendor, title, and more. Find specific expenses quickly by applying multiple search criteria.
Instructions
Get Expenses
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page | No | current page | |
| sort | No | field to sort by | |
| limit | No | results per page | |
| order | No | sorting order | |
| title | No | filter for Expense 'title', text containing in field | |
| vendor | No | filter for Expense 'vendor', text containing in fields lastname_company and firstname_suffix | |
| net_max | No | filter for Expense 'net', the greatest accepted value | |
| net_min | No | filter for Expense 'net', the lowest accepted value | |
| gross_max | No | filter for Expense 'gross', the greatest accepted value | |
| gross_min | No | filter for Expense 'gross', the lowest accepted value | |
| project_id | No | filter for Expense 'project_id' | |
| document_no | No | filter for Expense 'document_no', text containing in field | |
| paid_on_end | No | filter for Expense 'paid_on', the latest accepted date | |
| supplier_id | No | filter for Expense 'supplier_id' | |
| currency_code | No | filter for Expense 'currency_code', text containing in field | |
| paid_on_start | No | filter for Expense 'paid_on', the earliest accepted date | |
| created_at_end | No | filter for Expense 'created_at', the latest accepted date | |
| created_at_start | No | filter for Expense 'created_at', the earliest accepted date |