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": "8b0c4a15-e792-4360-95d8-1f47c0b3e926",
      "subscription_id": "5b7e2d40-1a86-4c39-97f2-e83d0b16c5a4",
      "method_id": "8b0c4a15-e792-4360-95d8-1f47c0b3e926",
      "currency_id": "8f27a0d4-63be-4915-8c07-1a5d9e34b628",
      "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": "7f3d1c92-8b45-4e6a-9d21-5c8e0a4b6f13",
    "total": 50,
    "limit": 50
  }
}

Example prompts

"Show me the last 50 payments on project 7f3d1c92-8b45-4e6a-9d21-5c8e0a4b6f13."

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

Failure modes

TOKEN_MISSING_ABILITY — token lacks project-subscription:view-any.
RESOURCE_NOT_FOUND — project_id names a project the token cannot see: unknown, another team's, or outside the token's scope:project: allow-list.
VALIDATION_FAILED — status is not one of the payment statuses; the error context lists the supported values.

list_transactions — keyset-paginated with richer filters.
get_earnings_report
list_subscribers