List Expenses
list_expensesRead-onlyIdempotent
Retrieve expenses sorted by date with optional filters for vendor, category, date range, and pagination. Control result fields, limit, offset, or cursor.
Instructions
List all expenses with optional pagination and date range filters. Returns expenses sorted by date (newest first). Example: from='2026-01-01', to='2026-03-31', limit=50 / Lista todos los gastos con paginacion y filtros de fecha opcionales.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| vendorId | No | Filter by vendor ID / Filtrar por ID de proveedor | |
| category | No | Filter by expense category (e.g. 'office', 'travel') / Filtrar por categoria | |
| from | No | Start date filter (YYYY-MM-DD) / Fecha inicio | |
| to | No | End date filter (YYYY-MM-DD) / Fecha fin | |
| fields | No | Comma-separated field names to return (e.g. 'id,description,amount') / Campos a devolver | |
| limit | No | Max results (1-100) / Resultados maximos | |
| offset | No | Offset / Desplazamiento | |
| after | No | Cursor for cursor-based pagination (document ID) / Cursor para paginacion basada en cursor |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | Yes | ||
| total | Yes | ||
| limit | Yes | ||
| offset | Yes | ||
| nextCursor | No |