Execute saved invoice report and return DataTable-compatible response.
:param request: HTTP request with query params :param pk: Custom report ID :return: Paginated, sparse-formatted response
Documentation Index
Fetch the complete documentation index at: https://docs.campfire.ai/llms.txt
Use this file to discover all available pages before exploring further.
Token-based authentication with required prefix "Token"
Aggregates: sum:amount, sum:amount_paid, sum:amount_due, etc.
Filter by client ID(s)
Filter by contract ID(s)
Filter by currency code
Filter by department ID(s)
End date (YYYY-MM-DD)
Entity ID(s), comma-separated
Row dimensions: client_id, invoice_id, invoice_date_month, product_id, etc.
Drilldown parent keys
Include grand totals row
Page size (max 10000)
paginated | full | csv
Pagination offset
Filter by status: draft,open,sent,partial,paid,uncollectible
Column dimensions: product_id, client_id, etc.
Filter by product ID(s)
Enable pivot columns
Start date (YYYY-MM-DD)
Output schema for invoice report responses.
Total rows before pagination
Next page URL (null for datatable pagination)
Previous page URL
Paginated result rows
Execution engine: 'postgres'
postgres - postgrespostgres Sorted list of pivot column names
Grand totals across all rows
Mapping of pivot field -> {display_name: id} for drilldown