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

# List available RAW tables for the authenticated customer

> Returns all RAW tables that have been successfully replicated to Postgres for the authenticated customer catalog. Includes table name, primary key, sync status, last sync timestamp, and row count. The response header `X-Sync-Status` is `synced` when at least one table has been replicated for this customer, or `pending` when no synced tables exist yet.



## OpenAPI

````yaml https://api.trassets.ai/openapi.json get /raw/tables
openapi: 3.1.0
info:
  title: Trassets Data API
  description: >

    The **Trassets Data API** exposes customer real-estate and market data as a
    REST API —

    objects, units, contracts, meters and bookings, machine-readable and stably
    versioned under `/v1/`.


    ## Quickstart


    ```bash

    export TRASSETS_API_KEY="sk_live_…"

    curl "https://api.trassets.ai/v1/realestates/objects?limit=1" \
      -H "X-API-Key: $TRASSETS_API_KEY"
    ```


    ## Authentication


    Send your API key on every request as the `X-API-Key` header.

    The key determines the customer scope and access tiers.

    Trassets stores only an HMAC-SHA-256 hash — the plaintext key is never shown
    again after creation.


    ## Endpoint Types


    ### Category Endpoints — `/{category}/{api_table}`


    Normalized master data and business queries. Use these for day-to-day
    integrations.


    - **Pagination:** Offset-based (`limit` / `offset` query parameters)

    - **Data character:** Normalized, business-ready data

    - **Use case:** Business queries, dashboards, incremental data fetches


    ### Raw Endpoints — `/raw/{table_name}`


    Full table access for bulk sync and export.


    - **Pagination:** Cursor-based (`cursor` query parameter from `next_cursor`
    in response)

    - **Data character:** Raw source data, unfiltered

    - **Use case:** Bulk sync, full exports, data warehousing


    ## Pagination


    - **Category endpoints**: `X-Total-Count`, `X-Has-More`, `X-Next-Offset`
    response headers.

    - **Raw endpoints**: `next_cursor` in response body. Stable under concurrent
    writes.


    ## Error format


    Errors follow [RFC 7807](https://datatracker.ietf.org/doc/html/rfc7807)
    (`application/problem+json`):

    `type`, `title`, `status`, `detail`, `instance`.


    | Status | Meaning |

    |--------|---------|

    | 400 | Missing required filter |

    | 401 | Invalid API key |

    | 403 | Missing access tier |

    | 404 | Unknown endpoint |

    | 429 | Rate limit (500 req/h per API key; see `Retry-After` header) |

    | 500 | Internal error |


    ## Versioning Policy


    This API will adopt URL versioning (`/v1/`) in an upcoming release. Breaking
    changes will then be

    introduced under a new version prefix. Until versioning is in place, the API
    may receive breaking changes.


    ## Field Glossary


    The following fields appear across multiple endpoints:


    | Field | Description |

    |---|---|

    | `entrance` | Street name and house number, e.g. Musterstrasse 12 |

    | `address` | Comma-separated postal code and city, e.g. 10115, Berlin |

    | `name` | Full name as single field. No separate first/last name available.
    |

    | `floor_area_id` | References floor_area_id in the property_structure table
    |


    ## Request an API key


    API keys are issued via the [Trassets
    Portal](https://portal.api.trassets.ai).
  version: 1.0.0
servers: []
security: []
paths:
  /raw/tables:
    get:
      tags:
        - Raw Data
      summary: List available RAW tables for the authenticated customer
      description: >-
        Returns all RAW tables that have been successfully replicated to
        Postgres for the authenticated customer catalog. Includes table name,
        primary key, sync status, last sync timestamp, and row count. The
        response header `X-Sync-Status` is `synced` when at least one table has
        been replicated for this customer, or `pending` when no synced tables
        exist yet.
      operationId: get_raw_tables_raw_tables_get
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                items:
                  $ref: '#/components/schemas/RawTableInfo'
                type: array
                title: Response Get Raw Tables Raw Tables Get
              examples:
                success:
                  summary: Available RAW tables
                  value:
                    - table_name: ixhaus_contracts
                      primary_key: contract_id
                      last_sync_at: '2026-04-10T08:00:00'
                      status: synced
                      row_count: 12500
        '401':
          description: Unauthorized
          content:
            application/problem+json:
              example:
                type: about:blank
                title: Unauthorized
                status: 401
                detail: API key required
                instance: /raw/tables
        '403':
          description: Forbidden
          content:
            application/problem+json:
              example:
                type: about:blank
                title: Forbidden
                status: 403
                detail: Invalid or disabled API key
                instance: /raw/tables
        '429':
          description: Too Many Requests
          content:
            application/problem+json:
              example:
                type: about:blank
                title: Too Many Requests
                status: 429
                detail: 'Rate limit exceeded: 500 per 1 hour'
                instance: /raw/tables
      security:
        - APIKeyHeader: []
components:
  schemas:
    RawTableInfo:
      properties:
        table_name:
          type: string
          title: Table Name
        primary_key:
          anyOf:
            - type: string
            - type: 'null'
          title: Primary Key
        last_sync_at:
          anyOf:
            - type: string
              format: date-time
            - type: 'null'
          title: Last Sync At
        status:
          type: string
          title: Status
        row_count:
          anyOf:
            - type: integer
            - type: 'null'
          title: Row Count
      type: object
      required:
        - table_name
        - primary_key
        - last_sync_at
        - status
        - row_count
      title: RawTableInfo
  securitySchemes:
    APIKeyHeader:
      type: apiKey
      in: header
      name: X-API-Key

````