List Exchange Rates
/v1/exchange-ratesReturns a cursor-paginated list of exchange rates for the active workspace. Read only, no side effects. Results are scoped by workspace via row-level security; for example a USD to EUR rate used on a Vercel invoice. Attributes mirror the records field set for this root. ## Filtering & sorting Filter via `POST /v1/records/query` (root `exchange_rates`) 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 | |---|---|---| | `composite_exchange_rate_summary` | text | `contains` `eq` `neq` `starts_with` `ends_with` `is_null` `is_not_null` | | `composite_invoice_transactions_list` | text | `contains` `eq` `neq` `starts_with` `ends_with` `is_null` `is_not_null` | | `composite_invoices_list` | text | `contains` `eq` `neq` `starts_with` `ends_with` `is_null` `is_not_null` | | `created_at` | date | `eq` `lt` `gt` `is_null` `is_not_null` | | `deleted_at` | date | `eq` `lt` `gt` `is_null` `is_not_null` | | `exchange_rate_id` | text | `contains` `eq` `neq` `starts_with` `ends_with` `is_null` `is_not_null` | | `pk` | number | `eq` `neq` `gt` `gte` `lt` `lte` `is_null` `is_not_null` | | `rate` | number | `eq` `neq` `gt` `gte` `lt` `lte` `is_null` `is_not_null` | | `rate_date` | date | `eq` `lt` `gt` `is_null` `is_not_null` | | `source` | text | `contains` `eq` `neq` `starts_with` `ends_with` `is_null` `is_not_null` | | `source_currency` | enum | `eq` `neq` `in` `is_null` `is_not_null` | | `target_currency` | enum | `eq` `neq` `in` `is_null` `is_not_null` | | `updated_at` | date | `eq` `lt` `gt` `is_null` `is_not_null` | **Sortable fields:** `composite_exchange_rate_summary`, `composite_invoice_transactions_list`, `composite_invoices_list`, `created_at`, `deleted_at`, `exchange_rate_id`, `pk`, `rate`, `rate_date`, `source`, `source_currency`, `target_currency`, `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 -X GET https://api.wellapp.ai/v1/exchange-rates \
-H "Authorization: Bearer $WELL_API_TOKEN"Responses
200 — A page of exchange rates.
{
"data": [
{
"type": "exchange_rate",
"id": "d0e1f2a3-0000-4000-8000-0000000000aa",
"attributes": {
"exchange_rate_id": "d0e1f2a3-0000-4000-8000-0000000000aa",
"source_currency": "USD",
"target_currency": "EUR",
"rate": 0.918,
"rate_date": "2026-04-27",
"source": "ecb",
"created_at": "2026-04-27T06:00:00Z",
"updated_at": "2026-04-27T06:00:00Z",
"deleted_at": null
}
}
],
"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"
}
}Filtering & sorting on related objects
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" ✅ |
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": "exchange_rates",
"whereClause": { "workspace": { "name": { "_ilike": "%acme%" } } },
"orderBy": { "field": "workspace.name", "direction": "asc" }
}