/api/v1/reconciliation/subscriptions/
List subscriptions for reconciliation with multi-format support.
Supports JSON (default), XML (?format=xml), and CSV (?format=csv) output. Requires a valid rk_ API key via Bearer authentication. Queries are scoped to the authenticated tenant's schema.
Query parameters: start_date (required): YYYY-MM-DD (filters on created_at) end_date (optional): YYYY-MM-DD (max 90-day range) status (optional): comma-separated subscription statuses (UPPERCASE) payment_gateway_id (optional): UUID next_billing_date_from (optional): YYYY-MM-DD next_billing_date_to (optional): YYYY-MM-DD format (optional): json | xml | csv page_size (optional): 1-1000 (default 100) cursor (optional): pagination cursor
- Type: stringcursor
The pagination cursor value.
- Type: stringenumformatvalues
- csv
- json
- xml
- Type: integerpage
_size Number of results to return per page.
curl '/api/v1/reconciliation/subscriptions/?cursor=&format=csv&page_size=1' \
--header 'Authorization: Bearer YOUR_SECRET_TOKEN'
{
"next": "http://api.example.org/accounts/?cursor=cD00ODY%3D\"",
"previous": "http://api.example.org/accounts/?cursor=cj0xJnA9NDg3",
"results": [
{
"id": "123e4567-e89b-12d3-a456-426614174000",
"status": "PENDING_ACTIVATION",
"billing_amount": "string",
"currency": "string",
"billing_frequency": null,
"start_date": "2026-04-16T09:16:14.005Z",
"next_billing_date": null,
"last_billing_date": null,
"cancelled_at": null,
"trial_end_date": null,
"billing_anchor_date": null,
"successful_billing_count": 1,
"failed_billing_count": 1,
"total_revenue": "string",
"order_id": "123e4567-e89b-12d3-a456-426614174000",
"lead_id": "123e4567-e89b-12d3-a456-426614174000",
"offer_id": "123e4567-e89b-12d3-a456-426614174000",
"payment_gateway_id": "123e4567-e89b-12d3-a456-426614174000",
"created_at": "2026-04-16T09:16:14.005Z",
"updated_at": "2026-04-16T09:16:14.005Z"
}
]
}