/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

Query Parameters
  • cursor
    Type: string

    The pagination cursor value.

  • format
    Type: stringenum
    values
    • csv
    • json
    • xml
  • page_size
    Type: integer

    Number of results to return per page.

Responses
Request Example for get/api/v1/reconciliation/subscriptions/
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"
    }
  ]
}