Get Organization Usage

Org-wide token usage, one row per Claude API call.

Returns every billed TokenUsage event attributable to this org — covers tasks created by any member in any project the org owns. Source-of-truth for org membership is Project.organization_id (TokenUsage.organization_id is now populated on write but historical rows may still be NULL, so we join through Project).

Per-event, not aggregated: each row’s id is the TokenUsage UUID, and once billed_cost_usd is set the row is immutable. Consumers (rt_connector_codecobra) can convert each row to an analytic line exactly once and never have to reconcile sums on re-imports — reporting dashboards live elsewhere.

Skips rows whose billed_cost_usd is still NULL: those represent Claude calls whose Odoo pricing webhook hasn’t replied yet. Returning them with cost=0 would force the customer to reconcile later; better to surface them only once they’re billable. The next poll picks them up because billed_cost_usd’s update bumps updated_at, and updated_at drives the watermark.

Owner/admin only.