# Trassets Data API ## Documentation ### Get Started - [Authenticate requests to the Trassets Data API](https://docs.trassets.ai/authentication.md): Learn how to obtain and use API keys for the Trassets Data API, and understand the authentication errors you may encounter. - [Trassets Data API: Real-Estate Data for Developers](https://docs.trassets.ai/index.md): The Trassets Data API provides property, contract, accounting, and operations data for developers building property management integrations and analytics. - [Get started with the Trassets Data API](https://docs.trassets.ai/quickstart.md): Learn how to request an API key and make your first call to the Trassets Data API in three steps. ### Core Concepts - [Category and Raw Endpoints Explained](https://docs.trassets.ai/concepts/endpoint-types.md): Trassets Data API offers two endpoint types: normalized category endpoints for dashboards and raw endpoints for bulk warehouse syncs. Choose the right one for your use case. - [Error Responses in the Trassets Data API](https://docs.trassets.ai/concepts/errors.md): Trassets Data API returns RFC 7807 problem+json errors. Learn the format, status codes, and how to handle each one when integrating the API. - [Pagination in the Trassets Data API](https://docs.trassets.ai/concepts/pagination.md): Trassets Data API uses offset pagination for category endpoints and cursor pagination for raw endpoints. Learn how to paginate through large datasets reliably. - [Rate Limits for the Trassets Data API](https://docs.trassets.ai/concepts/rate-limits.md): Trassets Data API allows 500 requests per hour per API key. Learn how to handle 429 responses and minimize unnecessary requests with delta sync. - [Sync Cycle: How Data Gets Into the API](https://docs.trassets.ai/concepts/sync-cycle.md): Understand the Databricks-to-RDS sync pipeline behind the Trassets Data API: TRUNCATE+Reload semantics, last_sync_at, and what GET /changes actually detects. - [API Versioning Policy for the Trassets Data API](https://docs.trassets.ai/concepts/versioning.md): Trassets Data API currently uses a base URL without a version prefix. URL versioning under /v1/ is planned, but breaking changes may occur until then. ### Guides - [Bulk export a full table with Raw endpoints](https://docs.trassets.ai/guides/bulk-export.md): Use /raw/{table_name} to export all rows from a source table for warehousing or analytics using cursor-based pagination and consistent snapshots. - [Use delta sync to detect changed tables efficiently](https://docs.trassets.ai/guides/delta-sync.md): Poll /changes with the since parameter and ETags to avoid unnecessary fetches and discover which tables have new data since your last sync. - [Incrementally sync real-estate data with Trassets](https://docs.trassets.ai/guides/incremental-sync.md): Fetch only changed data using offset pagination and category endpoints to keep a local copy of Trassets data up to date without re-fetching everything. ### Data Model - [Accounting Data Model: Ledger and Budget Entities](https://docs.trassets.ai/data-model/accounting.md): Explore the five accounting tables in the Trassets Data API covering accounts, booking headers, booking positions, budgets, and account-range mappings, with real field names. - [Contracts Data Model: Leases, Debits, and Services](https://docs.trassets.ai/data-model/contracts.md): Explore the Contracts domain in the Trassets Data API, covering rental debits, debit diffs, service contracts, and contract ends with real field names and join keys. - [Depreciation Data Model: Assets and Depreciation Postings](https://docs.trassets.ai/data-model/depreciation.md): Understand the Depreciation domain in the Trassets Data API: fixed assets and their depreciation postings. - [Field Glossary for the Trassets Data API](https://docs.trassets.ai/data-model/field-glossary.md): Reference guide to common field names across the Trassets Data API, including entrance, address, floor_area_id, property_id, and pagination cursors. - [Operations Data Model: Notifications, Offers, Orders, and Projects](https://docs.trassets.ai/data-model/operations.md): Understand the Operations domain in the Trassets Data API: maintenance notifications, offers, work orders, and capital projects. - [Trassets Data Model: Entities and Relationships](https://docs.trassets.ai/data-model/overview.md): Explore the six data domains of the Trassets Data API and how entities relate through property_id, floor_area_id, and other join keys. - [Property Data Model: Objects, Structure, and Technical Assets](https://docs.trassets.ai/data-model/property.md): Understand the Property domain in the Trassets Data API: property objects, the property structure tree, property-creditor services, and technical objects. - [Stakeholder Data Model: Creditors, Employees, Owners, and Tenants](https://docs.trassets.ai/data-model/stakeholder.md): Understand the Stakeholder domain in the Trassets Data API: creditors, employees, property owners, and tenants. ## API Reference ### Overview - [Trassets Data API Reference: Endpoints Overview](https://docs.trassets.ai/api-reference/introduction.md): Overview of the Trassets Data API: base URL, authentication, endpoint types, pagination, errors, and versioning. ### Endpoints #### Raw Data - [List available RAW tables for the authenticated customer](https://docs.trassets.ai/api-reference/raw-data/list-available-raw-tables-for-the-authenticated-customer.md): 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 cu… - [Export a RAW table with cursor-based pagination](https://docs.trassets.ai/api-reference/raw-data/export-a-raw-table-with-cursor-based-pagination.md): Returns a paginated page of rows from the specified RAW table. Use `cursor` (from `next_cursor` in the previous response) to fetch the next page. Maximum page size is controlled by `MAX_RAW_PAGE_SIZE` (default: 10000). When `next_cursor` is `null`, all rows have been exported. Tables without a prima… #### Delta Sync - [List tables changed since a given timestamp](https://docs.trassets.ai/api-reference/delta-sync/list-tables-changed-since-a-given-timestamp.md): Returns metadata for all tables whose last successful sync occurred after `since`. Only tables with `status = 'synced'` and a non-null `last_sync_at` are returned. Each entry includes an `endpoint_url` pointing to the corresponding category endpoint (e.g. `/realestates/objects`) or `/raw/{table_name… #### Accounting - [accounts](https://docs.trassets.ai/api-reference/accounting/accounts.md): Financial accounts from the chart of accounts, classified by account type (G/L, personal, creditor, asset) and balance sheet side. - [booking_header](https://docs.trassets.ai/api-reference/accounting/booking_header.md): Booking headers from the general ledger, enriched with cost centre, person and creditor references and the associated floor area in m². - [booking_positions](https://docs.trassets.ai/api-reference/accounting/booking_positions.md): Individual booking line items with net, tax and gross amounts as well as per-m² figures. - [budgets](https://docs.trassets.ai/api-reference/accounting/budgets.md): Budget amounts per account and property, normalised from 12 monthly columns into individual monthly rows. - [kontenmapping_ranges](https://docs.trassets.ai/api-reference/accounting/kontenmapping_ranges.md): Resolved account group assignments: maps account number ranges to a group (position) and an optional property range. #### Contracts - [contract_debits](https://docs.trassets.ai/api-reference/contracts/contract_debits.md): Rental debit positions as a continuous time series with validity intervals, debit type, amount and floor area reference. - [contract_debit_diffs](https://docs.trassets.ai/api-reference/contracts/contract_debit_diffs.md): Monthly deviations between the rental debit target and actual account movements (open items), split into net, tax and gross. - [service_contracts](https://docs.trassets.ai/api-reference/contracts/service_contracts.md): Maintenance and service contracts, expanded to monthly rows, with contract type, creditor, duration and contract value. - [contract_ends](https://docs.trassets.ai/api-reference/contracts/contract_ends.md): Lease end dates and extension options per rental contract, normalised to validity intervals with deadlines and exercise status. #### Depreciation - [assets](https://docs.trassets.ai/api-reference/depreciation/assets.md): Fixed asset master data with depreciation configuration (method, useful life, account) and property assignment. - [depreciation](https://docs.trassets.ai/api-reference/depreciation/depreciation.md): Depreciation transactions from the general ledger, linked to the asset, depreciation method and associated property. #### Operations - [notifications](https://docs.trassets.ai/api-reference/operations/notifications.md): Defect reports and damage notifications with report type, priority, status, reporter, processor and reference to a technical object or cost centre. - [offers](https://docs.trassets.ai/api-reference/operations/offers.md): Offers from the maintenance process: links requests to creditor quotes with amount, status and property reference. - [orders](https://docs.trassets.ai/api-reference/operations/orders.md): Work orders and purchase orders from the maintenance process with positions, amounts, VAT, creditor, invoice status and links to notifications and technical objects. - [projects](https://docs.trassets.ai/api-reference/operations/projects.md): Projects with hierarchical account structure (up to 20 levels), budget and performance overview, and links to offers and orders. #### Property - [properties](https://docs.trassets.ai/api-reference/property/properties.md): Property master data with address, property type, use type, construction year, geographic coordinates and management mandate. - [property_creditor_services](https://docs.trassets.ai/api-reference/property/property_creditor_services.md): Assignment of service providers (creditors) to properties by trade category and exclusivity status. - [property_structure](https://docs.trassets.ai/api-reference/property/property_structure.md): All components of a property as a flat table: one row per component — the property itself, each building, building part/entrance, floor/level and floor area (rental unit). The account_type column identifies the component type. - [technical_objects](https://docs.trassets.ai/api-reference/property/technical_objects.md): Technical installations and devices with type, location (building, floor, unit), warranty and inspection data, and linked service contract. #### Stakeholder - [creditor](https://docs.trassets.ai/api-reference/stakeholder/creditor.md): Creditor master data with name, address, bank details, contact information, trade category and tax exemption certificate. - [employees](https://docs.trassets.ai/api-reference/stakeholder/employees.md): Employees and their team assignments per property, including contact details and activity status. - [owner](https://docs.trassets.ai/api-reference/stakeholder/owner.md): Owner master data with ownership share per property, contact information and bank details. - [tenants](https://docs.trassets.ai/api-reference/stakeholder/tenants.md): Tenant master data per rental unit, deduplicated to the current lease, with contact details, IBAN and contract duration. #### Tables - [List all tables in authenticated customer's schema grouped by category](https://docs.trassets.ai/api-reference/tables/list-all-tables-in-authenticated-customers-schema-grouped-by-category.md): Returns all data categories and their available tables for the authenticated API key. #### Meta - [Get configured lookup values for a column](https://docs.trassets.ai/api-reference/meta/get-configured-lookup-values-for-a-column.md): Returns a list of `{value, label}` pairs for the specified column and table as configured in `api_model.value_lookups`. Returns 404 when no lookup values are configured for this combination. ## OpenAPI Specs - [openapi](https://api.trassets.ai/openapi.json) > The links below point to documentation indexes. Follow each `/_llms/` index recursively until you reach documentation pages. ## Indexes - [German (21 pages)](https://docs.trassets.ai/_llms/de.md): Documentation for German.