Usage

Report drift between billed usage and the request log for one day

Compares billed usage for one UTC day with usage re-derived from the Postgres request log. Report only; nothing is repaired (repairable is always false).

Pitfalls:

  • Read interpretation before drift. In the current deployment the Postgres request log is usually empty (request_log_rows: 0), so every billed row shows as absent_from_request_log. That is not evidence of overbilling.
  • Defaults to yesterday (UTC); today is still accumulating.
get/v1/usage/reconciliation

Request

  • Base URL: https://api.spicrawl.com
  • URL: https://api.spicrawl.com/v1/usage/reconciliation
  • Auth: HTTP bearer

Query parameters

daystring date
Example:2026-09-21

UTC day to reconcile, YYYY-MM-DD. Defaults to yesterday.

Response

The drift report.

daystring date required

UTC day reconciled.

request_log_rowsinteger required

Rows the Postgres request log holds for the day. 0 means there was nothing to reconcile against.

interpretationstring required

What the drift can and cannot prove. Read this before acting on drift.

repairablefalse required

Always false; the API never repairs billing data. Contact support to dispute.

warningsstring[]

Extra caveats. Omitted when empty.

Changes

No recorded changes to this operation across all 1 revision of this API.