> ## 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 Ledger Accounts

> Workspace-scoped, cursor-paginated list of `ledger_account` 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": { "name": { "_eq": … } } }`                   | `"field": "workspace.name"` ✅                  |
| `parent_account`             | to-one (ledger\_account)      | `{ "parent_account": { "name": { "_eq": … } } }`              | `"field": "parent_account.name"` ✅             |
| `child_accounts`             | to-many (ledger\_account)     | `{ "child_accounts": { "_some": { "name": { "_eq": … } } } }` | aggregate proxy only ⚠️                        |
| `source_workspace_connector` | to-one (workspace\_connector) | `{ "source_workspace_connector": { "name": { "_eq": … } } }`  | `"field": "source_workspace_connector.name"` ✅ |

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": "ledger_accounts",
  "whereClause": { "workspace": { "name": { "_ilike": "%acme%" } } },
  "orderBy": { "field": "workspace.name", "direction": "asc" }
}
```

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

```json theme={null}
{
  "root": "ledger_accounts",
  "whereClause": { "child_accounts": { "_some": { "name": { "_gt": 0 } } } }
}
```


## OpenAPI

````yaml GET /v1/ledger-accounts
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/ledger-accounts:
    get:
      tags:
        - Records read endpoints
      summary: List Ledger Accounts
      description: >-
        Workspace-scoped, cursor-paginated list of `ledger_account` records.
        Served by the generic read-only resource handler over the data-views
        pipeline (Hasura row-level security).
      operationId: listLedgerAccounts
      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 ledger_account records.
          content:
            application/json:
              example:
                data:
                  - type: ledger_account
                    id: uuid
                    attributes: {}
                meta:
                  total: 0
                  count: 0
                links:
                  next: null
        '401':
          description: Unauthenticated.
        '403':
          description: Workspace scope not permitted.

````