List Invoice Items
Invoice Items
List Invoice Items
Workspace-scoped, cursor-paginated list of invoice_item records. Served by the generic read-only resource handler over the data-views pipeline (Hasura row-level security).
GET
List Invoice Items
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 |
|---|---|---|---|
invoice | to-one (invoice) | { "invoice": { "grand_total": { "_eq": … } } } | "field": "invoice.grand_total" ✅ |
ledger_account | to-one (ledger_account) | { "ledger_account": { "name": { "_eq": … } } } | "field": "ledger_account.name" ✅ |
applied_tax_rate | to-one (tax_rate) | { "applied_tax_rate": { "field_name": { "_eq": … } } } | "field": "applied_tax_rate.field_name" ✅ |
media | to-one (media) | { "media": { "file_name": { "_eq": … } } } | "field": "media.file_name" ✅ |
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_item records.