> ## Documentation Index
> Fetch the complete documentation index at: https://docs.wellapp.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# List Transactions

> Workspace-scoped, cursor-paginated list of `transaction` records. Served by the generic read-only resource handler over the data-views pipeline (Hasura row-level security).

## Filtering & sorting on related objects

Filter and sort on a **related (included) object** by nesting into the relationship — the same relationships you pass to `include`.

* **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.

Workspace row-level security applies at every hop, so a related-object filter never widens your tenant scope. Full operator set, deep-nesting rules, and pagination notes: [Filtering & sorting](/api-reference/filtering-and-sorting).

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": { "field_name": { "_eq": … } } }`                                   | `"field": "workspace.field_name"` ✅                |
| `debtor_payment_means`           | to-one (PaymentMeans)                   | `{ "debtor_payment_means": { "field_name": { "_eq": … } } }`                        | `"field": "debtor_payment_means.field_name"` ✅     |
| `creditor_payment_means`         | to-one (PaymentMeans)                   | `{ "creditor_payment_means": { "field_name": { "_eq": … } } }`                      | `"field": "creditor_payment_means.field_name"` ✅   |
| `account_balance`                | to-one (AccountBalance)                 | `{ "account_balance": { "field_name": { "_eq": … } } }`                             | `"field": "account_balance.field_name"` ✅          |
| `sourceWorkspaceConnector`       | to-one (WorkspaceConnector)             | `{ "sourceWorkspaceConnector": { "field_name": { "_eq": … } } }`                    | `"field": "sourceWorkspaceConnector.field_name"` ✅ |
| `ledger_account`                 | to-one (LedgerAccount)                  | `{ "ledger_account": { "field_name": { "_eq": … } } }`                              | `"field": "ledger_account.field_name"` ✅           |
| `transaction_documents`          | to-many (TransactionDocument)           | `{ "transaction_documents": { "_some": { "field_name": { "_eq": … } } } }`          | aggregate proxy only ⚠️                            |
| `transactionWorkspaceConnectors` | to-many (TransactionWorkspaceConnector) | `{ "transactionWorkspaceConnectors": { "_some": { "field_name": { "_eq": … } } } }` | aggregate proxy only ⚠️                            |

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):

```json theme={null}
{
  "root": "transactions",
  "whereClause": { "workspace": { "field_name": { "_ilike": "%acme%" } } },
  "orderBy": { "field": "workspace.field_name", "direction": "asc" }
}
```

**Filter by a to-many relation** (quantified — bare nesting is invalid):

```json theme={null}
{
  "root": "transactions",
  "whereClause": { "transaction_documents": { "_some": { "field_name": { "_gt": 0 } } } }
}
```


## OpenAPI

````yaml GET /v1/transactions
openapi: 3.1.0
info:
  title: Well Document API
  version: 1.0.0
  description: API for uploading and managing financial documents in the Well platform
servers:
  - url: https://api.wellapp.ai
security: []
paths:
  /v1/transactions:
    get:
      tags:
        - Records read endpoints
      summary: List Transactions
      description: >-
        Workspace-scoped, cursor-paginated list of `transaction` records. Served
        by the generic read-only resource handler over the data-views pipeline
        (Hasura row-level security).
      operationId: listTransactions
      parameters:
        - name: limit
          in: query
          schema:
            type: integer
            default: 50
            maximum: 200
          description: Page size (max 200).
        - name: cursor
          in: query
          schema:
            type: string
          description: Opaque keyset cursor; omit for the first page.
        - name: orderBy
          in: query
          schema:
            type: string
          description: Field to order by.
        - name: direction
          in: query
          schema:
            type: string
            enum:
              - asc
              - desc
        - name: workspaceId
          in: query
          schema:
            type: string
            format: uuid
          description: Optional explicit workspace scope (Firebase-authenticated callers).
      responses:
        '200':
          description: A page of transaction records.
          content:
            application/json:
              example:
                data:
                  - type: transaction
                    id: uuid
                    attributes: {}
                meta:
                  total: 0
                  count: 0
                links:
                  next: null
        '401':
          description: Unauthenticated.
        '403':
          description: Workspace scope not permitted.

````