List Invoice Transactions

get/v1/invoice-transactions

Returns a cursor-paginated list of invoice transactions for the active workspace. Read only, no side effects. Results are scoped by workspace via row-level security; for example the allocation linking the Anthropic invoice to its paying transaction. Attributes mirror the records field set for this root. ## Filtering & sorting Filter via `POST /v1/records/query` (root `invoice_transactions`) or the `filters` model; operators are gated by each field's data type. See [Filtering & sorting](../filtering-and-sorting). **Filterable fields** | Field | Type | Allowed operators | |---|---|---| | `accounting_amount` | number | `eq` `neq` `gt` `gte` `lt` `lte` `is_null` `is_not_null` | | `accounting_currency` | enum | `eq` `neq` `in` `is_null` `is_not_null` | | `allocation_type` | enum | `eq` `neq` `in` `is_null` `is_not_null` | | `amount` | number | `eq` `neq` `gt` `gte` `lt` `lte` `is_null` `is_not_null` | | `composite_fx_rate` | text | `contains` `eq` `neq` `starts_with` `ends_with` `is_null` `is_not_null` | | `composite_invoice_transaction_summary` | text | `contains` `eq` `neq` `starts_with` `ends_with` `is_null` `is_not_null` | | `created_at` | date | `eq` `lt` `gt` `is_null` `is_not_null` | | `currency` | enum | `eq` `neq` `in` `is_null` `is_not_null` | | `deleted_at` | date | `eq` `lt` `gt` `is_null` `is_not_null` | | `invoice_transaction_id` | text | `contains` `eq` `neq` `starts_with` `ends_with` `is_null` `is_not_null` | | `is_partial` | boolean | `eq` | | `pk` | number | `eq` `neq` `gt` `gte` `lt` `lte` `is_null` `is_not_null` | | `updated_at` | date | `eq` `lt` `gt` `is_null` `is_not_null` | **Sortable fields:** `accounting_amount`, `accounting_currency`, `allocation_type`, `amount`, `composite_fx_rate`, `composite_invoice_transaction_summary`, `created_at`, `currency`, `deleted_at`, `invoice_transaction_id`, `pk`, `updated_at` (via `orderBy` / `sort`, `asc`|`desc`).

Requires a bearer token: Authorization: Bearer <token>.

Query parameters

Name	Type	Required	Description
cursor	string	No	Opaque pagination cursor returned as links.next on the previous page. Omit to fetch the first page.e.g. eyJwayI6MTI4N30
limit	integer	No	Maximum number of records to return per page (1 to 200, defaults to 50).e.g. 50
orderBy	string	No	Field to sort by, using the records dot path or column name (e.g. created_at).e.g. created_at
direction	string	No	Sort direction for orderBy. Defaults to desc.e.g. desc
workspaceId	string <uuid>	No	Explicit workspace scope. The authenticated user must hold an active membership in this workspace. Defaults to the session workspace when omitted.e.g. a1b2c3d4-0000-4000-8000-000000000001

Request

cURL

curl -X GET https://api.wellapp.ai/v1/invoice-transactions \
  -H "Authorization: Bearer $WELL_API_TOKEN"

Responses

200 — A page of invoice transactions.

{
  "data": [
    {
      "type": "invoice_transaction",
      "id": "e1f2a3b4-0000-4000-8000-0000000000ab",
      "attributes": {
        "invoice_transaction_id": "e1f2a3b4-0000-4000-8000-0000000000ab",
        "amount": 1200,
        "currency": "USD",
        "accounting_amount": 1200,
        "accounting_currency": "USD",
        "allocation_type": "full",
        "is_partial": false,
        "created_at": "2026-04-28T11:00:00Z",
        "updated_at": "2026-04-28T11:00:00Z",
        "deleted_at": null
      },
      "relationships": {
        "invoice": {
          "data": {
            "type": "invoice",
            "id": "00000000-0000-4000-8000-000000000001"
          }
        },
        "transaction": {
          "data": {
            "type": "transaction",
            "id": "00000000-0000-4000-8000-000000000001"
          }
        },
        "subscription": {
          "data": {
            "type": "subscription",
            "id": "00000000-0000-4000-8000-000000000001"
          }
        },
        "exchange_rate": {
          "data": {
            "type": "exchange_rate",
            "id": "00000000-0000-4000-8000-000000000001"
          }
        }
      }
    }
  ],
  "meta": {
    "total": 1,
    "count": 1
  },
  "links": {
    "next": null
  }
}

400 — Bad request

{
  "code": "BAD_REQUEST",
  "status": 400,
  "title": "Bad Request",
  "message": "See title.",
  "meta": {
    "trace_id": "a1b2c3",
    "log_id": "a1b2c3"
  }
}

401 — Unauthorized

{
  "code": "UNAUTHORIZED",
  "status": 401,
  "title": "Unauthorized",
  "message": "See title.",
  "meta": {
    "trace_id": "a1b2c3",
    "log_id": "a1b2c3"
  }
}

This resource's related objects (the ones you can include) and how to filter or sort on each:

Relationship	Cardinality	Filter on a field	Sort by a field
`workspace`	to-one (workspace)	`{ "workspace": { "name": { "_eq": … } } }`	`"field": "workspace.name"` ✅
`invoice`	to-one (invoice)	`{ "invoice": { "grand_total": { "_eq": … } } }`	`"field": "invoice.grand_total"` ✅
`transaction`	to-one (transaction)	`{ "transaction": { "instructed_amount": { "_eq": … } } }`	`"field": "transaction.instructed_amount"` ✅
`subscription`	to-one (subscription)	`{ "subscription": { "status": { "_eq": … } } }`	`"field": "subscription.status"` ✅
`exchange_rate`	to-one (exchange_rate)	`{ "exchange_rate": { "rate_date": { "_eq": … } } }`	`"field": "exchange_rate.rate_date"` ✅

Replace field_name with any field of the related object. See its object-reference page for the full field list.

Filter by a to-one relation (and sort by it):

{
  "root": "invoice_transactions",
  "whereClause": { "workspace": { "name": { "_ilike": "%acme%" } } },
  "orderBy": { "field": "workspace.name", "direction": "asc" }
}

Query parameters

Request

Responses

Filtering & sorting on related objects