> ## Documentation Index > Fetch the complete documentation index at: https://docs.casa-layer.com/llms.txt > Use this file to discover all available pages before exploring further. # Search transactions > Searches revenue transactions for the credential's scope, ordered by consumption date (newest first). All filters are optional and combine with AND. Paginated via `limit`/`cursor`; follow `next_cursor` until it is null. Requires scope `read:transactions`. ## OpenAPI ````yaml /api-reference/openapi.yaml get /v1/transactions openapi: 3.1.0 info: title: Casa API version: 1.0.0 description: > Headless, read-only access to the guest context layer — the entire canonical data model over HTTP. Every endpoint is **scoped by the credential**: the default scope is the caller's property group, returning data across all of its properties. Auth sources resolve to the same credential: a user-generated **API key** (`casa_…`, created in Account settings — the recommended method for machines), a WorkOS AuthKit session JWT (the web app; org and role come from verified token claims), or a static token. (The MCP server also accepts read-only OAuth connector tokens, but those are rejected on these REST routes.) Send `X-Property-Id` to drill down into a single property; API keys can also be pinned to one property at creation. Tenant isolation holds by construction. Integration-management endpoints write connection *metadata* only and are session-only; canonical guest data enters exclusively through the connector workers and the ingest pipeline. The Model Context Protocol (MCP) server is exposed separately at `/mcp` and is documented under **MCP Server** in the guides — it is not a REST endpoint and is intentionally omitted from this reference. It accepts the same API keys. servers: - url: https://api.casa-layer.com description: Production Cloudflare Worker security: - bearerAuth: [] tags: - name: System description: Liveness, health, and the public welcome page. - name: Guests description: Canonical guest profiles as ingested from each source system. - name: Master Profiles description: >- Identity-resolved golden records — one entity per real guest, merged across sources and properties. - name: Reservations description: >- Reservation records linked to guest profiles, searchable by status, stay window, and channel. - name: Transactions description: >- Revenue lines (Pace Transactions V2–shaped) linked to guests and optionally reservations. - name: Consents description: > Contact-grain consent observations (contact method + value × purpose). Rows store decisive signals only (granted/withdrawn/denied); absence of a row means unknown / not eligible. Effective eligibility within a property group is the most restrictive status among stored observations for the same contact×purpose (withdrawn/denied beat granted). - name: Tables description: > Attio-style ops tables — curated or filter-defined containers for day-to-day work inside Casa. Tables are not consent eligibility records and not marketing segments; campaign audiences stay in downstream ESP tools (Klaviyo, Mailchimp, and peers). - name: Actions description: Guest actions (purchases, visits, and other tracked events). - name: Events description: >- The append-only guest event log — full change history or latest delta slice per entity. - name: Reviews description: Guest reviews with free-text search and an aggregate summary. - name: Loyalty description: Loyalty programs and member search (tier, points, guest). - name: Dimensions description: Reference dimensions — booking channels and bookable spaces. - name: Properties description: >- Properties within a group, plus self-serve onboarding (org-anchored tenant bootstrap). - name: SQL description: >- Read-only SQL over the public data model, isolated per tenant by row-level security. - name: API Keys description: Manage the organization's API keys (session-only). - name: Integrations description: >- Connection metadata for source systems (Mews, Square, …). Metadata only — never canonical guest data. Session-only. paths: /v1/transactions: get: tags: - Transactions summary: Search transactions description: > Searches revenue transactions for the credential's scope, ordered by consumption date (newest first). All filters are optional and combine with AND. Paginated via `limit`/`cursor`; follow `next_cursor` until it is null. Requires scope `read:transactions`. parameters: - name: guest_profile_id in: query schema: type: string format: uuid - name: reservation_id in: query schema: type: string format: uuid - name: type in: query description: Canonical transaction type (e.g. `space`, `product`). schema: type: string - name: consumption_date_from in: query description: Include transactions consumed on/after this ISO date. schema: type: string format: date - name: consumption_date_to in: query description: Include transactions consumed on/before this ISO date. schema: type: string format: date - $ref: '#/components/parameters/PropertyHeader' - $ref: '#/components/parameters/Limit' - $ref: '#/components/parameters/Cursor' responses: '200': description: Matching transactions. content: application/json: schema: allOf: - $ref: '#/components/schemas/Pagination' - type: object required: - data properties: data: type: array items: $ref: '#/components/schemas/Transaction' '400': $ref: '#/components/responses/BadRequest' '401': $ref: '#/components/responses/Unauthorized' '403': $ref: '#/components/responses/Forbidden' components: parameters: PropertyHeader: name: X-Property-Id in: header required: false description: > Optional single-property drill-down. When set, narrows the request to this property; it must belong to the caller's group, else `403`. A property-pinned API key is already narrowed and ignores this header. schema: type: string format: uuid Limit: name: limit in: query required: false description: > Page size — rows returned per call (1–500). This is NOT a cap on the total dataset: follow `next_cursor` to retrieve every matching row. schema: type: integer minimum: 1 maximum: 500 default: 100 Cursor: name: cursor in: query required: false description: > Opaque pagination token from a previous response's `next_cursor`. Omit for the first page. A malformed token returns `400 invalid_cursor`. schema: type: string schemas: Pagination: type: object description: > Keyset-pagination fields present on every list/search response. When `has_more` is true, re-request with `cursor` set to `next_cursor`; repeat until `next_cursor` is null to retrieve the full result set. required: - next_cursor - has_more properties: next_cursor: type: - string - 'null' description: Opaque cursor for the next page, or null on the last page. has_more: type: boolean description: Whether another page exists. Transaction: type: object description: A revenue line linked to a guest profile and optionally a reservation. required: - id - property_id - integration_id - guest_profile_id - source_id - source_version - type - net_revenue - gross_revenue - quantity - source_payload - created_at - updated_at properties: id: type: string format: uuid property_id: type: string format: uuid integration_id: type: string format: uuid guest_profile_id: type: string format: uuid reservation_id: type: - string - 'null' format: uuid source_id: type: string description: Stable id from the source system (e.g. Mews order item id). source_version: type: string description: Monotonic source version (bigint serialized as a string). type: type: string description: Canonical transaction type (e.g. `space`, `product`, `city_tax`). status: type: - string - 'null' enum: - open - closed - inactive - canceled - null net_revenue: type: string description: Decimal serialized as a string. gross_revenue: type: string description: Decimal serialized as a string. currency: type: - string - 'null' description: ISO 4217. consumption_date: type: - string - 'null' format: date description: Date the revenue was consumed. quantity: type: integer description: type: - string - 'null' accounting_category_source_id: type: - string - 'null' closed_at: type: - string - 'null' format: date-time source_payload: type: object additionalProperties: true created_at: type: string format: date-time updated_at: type: string format: date-time Error: type: object required: - error properties: error: type: string description: Machine-readable error code. scope: type: string description: The scope that was required when the error is a scope failure.: null detail: type: string description: Optional human-readable detail. responses: BadRequest: description: >- Malformed request — e.g. a `cursor` that is not a valid pagination token. content: application/json: schema: $ref: '#/components/schemas/Error' example: error: invalid_cursor Unauthorized: description: Missing, unknown, or revoked bearer credential. content: application/json: schema: $ref: '#/components/schemas/Error' example: error: unauthorized Forbidden: description: > The credential lacks the scope required for this endpoint, or the auth surface is wrong. Machine-readable codes include `forbidden` (scope or role), `tenant_not_provisioned` (org claim present but no property group), and `mcp_oauth_required` (SPA session token used on `/mcp`). content: application/json: schema: $ref: '#/components/schemas/Error' example: error: forbidden scope: read:guests securitySchemes: bearerAuth: type: http scheme: bearer description: > `Authorization: Bearer `. Token types resolve to the same scoped credential: a user-generated **API key** (`casa_…`, from Account settings — recommended for machines and MCP clients), a WorkOS AuthKit session JWT (the web app; org and role come from verified token claims), or a static token. API keys are group-scoped, optionally pinned to one property at creation. MCP OAuth connector tokens authenticate the MCP server only and are rejected on these REST routes. ````