list_recent_payments

List the most recent subscription payments for one project with optional status filter. Reverse-chronological, no raw webhook payloads.

Purpose

Return the most recent subscription payment rows for a project, reverse-chronological by occurred_at. Rows carry provider references (external_payment_id, external_event_id) but omit raw webhook payloads. Useful for quick revenue inspection and failure triage.

Required ability

project-subscription:view-any

Input schema

{
  "type": "object",
  "required": ["project_id"],
  "properties": {
    "project_id": {
      "type": "string",
      "description": "UUID of the project whose payments to list."
    },
    "status": {
      "type": "string",
      "description": "Payment status filter. One of: successful, pending, failed, refunded."
    },
    "limit": {
      "type": "integer",
      "minimum": 1,
      "maximum": 200,
      "description": "Maximum payments to return (1..200, default 50)."
    }
  }
}

Output shape

{
  "data": [
    {
      "id": "pay_01HX...",
      "subscription_id": "sub_01HX...",
      "method_id": "pmt_01HX...",
      "currency_id": "cur_01HX...",
      "status": "successful",
      "amount": "29.00",
      "transaction_fee": 87,
      "calculated_fee": "0.87",
      "external_payment_id": "pi_...",
      "external_event_id": "evt_...",
      "billing_reason": "subscription_cycle",
      "occurred_at": "2026-05-18T10:05:00Z"
    }
  ],
  "meta": {
    "project_id": "prj_01HX...",
    "total": 50,
    "limit": 50
  }
}

Example prompts

"Show me the last 50 payments on project prj_01HX...."

"Which payments failed in the last 24 hours on my Research Premium project?"

Failure modes

TOKEN_MISSING_ABILITY — token lacks project-subscription:view-any.

list_transactions — keyset-paginated with richer filters.
get_earnings_report
list_subscribers