Skip to main content

Get Daily Financial Summary Column Totals

GET 

/api/v2/financials/daily-summary/aggregates

Column-summary totals for the report's "Calculate" footer — computes Sum, Average, Min, Max, Range, or a Count variant per column over the FULL filtered set (not just the current page), in one query.

Required scope: reports:read

Grant this scope to your token under Settings → Developer → Personal Access Tokens.

Aggregatable columns: quantity, quantity_returned, num_orders, revenue, revenue_allocated, revenue_credits, total_revenue, cost, cost_allocated, cost_invoices, cost_returned, total_cost, profit. Supported calcs: sum, avg, min, max, range, count_all, count_values, count_unique, count_empty, count_not_empty. Pass them as aggregates[<column>]=<calc>. Totals cover the quantity, order-count and revenue/cost/profit columns.

Apply the same filters and search as the list endpoint to scope the totals. An unknown calc returns 422. Authentication: Requires Bearer token.

Request​

Responses​

OK

Response Headers
    Content-Type