list_bills
Read-onlyIdempotent
Retrieve bills from Bexio with filters for status, vendor, date, amount, and more. Find specific bills by search term or field values to manage accounting efficiently.
Instructions
Get Bills
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page | No | current page | |
| sort | No | field to sort by | |
| limit | No | Limit the number of results (max is 500) | |
| order | No | sorting order | |
| title | No | filter for Bill 'title', text containing in field | |
| status | No | filter for Bill 'status' (DRAFTS: [DRAFT], TODO: [BOOKED, PARTIALLY_CREATED, CREATED, PARTIALLY_SENT, SENT, PARTIALLY_DOWNLOADED, DOWNLOADED, PARTIALLY_PAID, PARTIALLY_FAILED, FAILED], PAID: [PAID], OVERDUE: [BOOKED, PARTIALLY_CREATED, CREATED, PARTIALLY_SENT, SENT, PARTIALLY_DOWNLOADED, DOWNLOADED, | |
| vendor | No | filter for Bill 'vendor', text containing in fields lastname_company and firstname_suffix | |
| net_max | No | filter for Bill 'net', the greatest accepted value | |
| net_min | No | filter for Bill 'net', the lowest accepted value | |
| fields[] | No | fields for which search will be run (if no 'fields[]' is specified than searching will be done for all allowed fields) | |
| gross_max | No | filter for Bill 'gross', the greatest accepted value | |
| gross_min | No | filter for Bill 'gross', the lowest accepted value | |
| vendor_ref | No | filter for Bill 'vendor_ref', text containing in field | |
| document_no | No | filter for Bill 'document_no', text containing in field | |
| search_term | No | term for which application will look for (minimum 3 signs, maximum 255 signs) | |
| supplier_id | No | filter for Bill 'supplier_id' | |
| due_date_end | No | filter for Bill 'due_date', the latest accepted date | |
| bill_date_end | No | filter for Bill 'bill_date', the latest accepted date | |
| currency_code | No | filter for Bill 'currency_code', text containing in field | |
| due_date_start | No | filter for Bill 'due_date', the earliest accepted date | |
| bill_date_start | No | filter for Bill 'bill_date', the earliest accepted date | |
| pending_amount_max | No | filter for Bill 'pending_amount', the greatest accepted value | |
| pending_amount_min | No | filter for Bill 'pending_amount', the lowest accepted value | |
| average_exchange_rate_enabled | No | indicates whether 'average_exchange_rate_enabled' is enabled, or not |