List Invoice Transactions
Invoice Transactions
List Invoice Transactions
Workspace-scoped, cursor-paginated list of invoice_transaction records. Served by the generic read-only resource handler over the data-views pipeline (Hasura row-level security).
GET
List Invoice Transactions
Filtering & sorting on related objects
Filter and sort on a related (included) object by nesting into the relationship — the same relationships you pass toinclude.
- To-one relations nest directly:
{ "issuer": { "name": { "_eq": "Acme" } } }, and sort by a dot-path:"orderBy": { "field": "issuer.name", "direction": "asc" }. - To-many relations must be quantified with
_some,_every, or_none:{ "items": { "_some": { "quantity": { "_gt": 1 } } } }. They are not directly sortable (a to-many sort needs an aggregate proxy). - Composite
composite_*columns are virtual — filter and sort on their underlying source fields, not on the composite.
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" ✅ |
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):
Query Parameters
Page size (max 200).
Required range:
x <= 200Opaque keyset cursor; omit for the first page.
Field to order by.
Available options:
asc, desc Optional explicit workspace scope (Firebase-authenticated callers).
Response
A page of invoice_transaction records.