Bulk export a full table with Raw endpoints

Export an entire source table from the Data API into your warehouse or analytics pipeline. Raw endpoints return unfiltered rows from the underlying database with cursor-based pagination and snapshot consistency headers.

Raw endpoints require a key of type raw; reading a table (GET /v1/raw/{table_name}) additionally needs both personal data grants, personal and personal_financial, otherwise it returns 403. A transformed key gets 403 on GET /v1/raw/{table_name} and an empty list from GET /v1/raw/tables — see Key types. Raw tables that are not released for your environment appear neither in /v1/raw/tables nor in /v1/changes, and a direct call returns 404.

List available tables

Call GET /v1/raw/tables to discover which tables are available, their primary keys, row counts, and sync status.

curl -s "https://api.trassets.ai/v1/raw/tables" \
  -H "X-API-Key: $TRASSETS_API_KEY"

Example response:

[
  {
    "table_name": "sollart",
    "primary_key": "HDR_ID",
    "status": "synced",
    "row_count": 47,
    "last_sync_at": "2026-04-10T08:00:00"
  }
]

Start the export

Request the first page of the table you want. Set limit up to the maximum of 10000.

curl -s "https://api.trassets.ai/v1/raw/sollart?limit=10000" \
  -H "X-API-Key: $TRASSETS_API_KEY"

Example response:

{
  "data": [
    { "HDR_ID": 1, "BEZ": "Demo" }
  ],
  "count": 1,
  "next_cursor": "eyJjb2wiOiAiSERSX0lEIiwgInZhbCI6IDF9",
  "table_name": "sollart",
  "total": 47
}

Paginate with the cursor

Pass the next_cursor value into the cursor query parameter for each subsequent request. Repeat until next_cursor is null.

#!/bin/bash
TABLE="sollart"
CURSOR=""

while true; do
  if [ -z "$CURSOR" ]; then
    RESP=$(curl -s "https://api.trassets.ai/v1/raw/${TABLE}?limit=10000" \
      -H "X-API-Key: $TRASSETS_API_KEY")
  else
    RESP=$(curl -s "https://api.trassets.ai/v1/raw/${TABLE}?limit=10000&cursor=${CURSOR}" \
      -H "X-API-Key: $TRASSETS_API_KEY")
  fi

  echo "$RESP" | jq '.data[]'

  CURSOR=$(echo "$RESP" | jq -r '.next_cursor')
  if [ "$CURSOR" = "null" ] || [ -z "$CURSOR" ]; then
    break
  fi
done

Verify snapshot consistency

Check the X-Snapshot-At response header on every page. All rows within a single cursor sequence are consistent as of that timestamp. If the header changes between pages, start the export over to ensure a single snapshot view.

curl -sI "https://api.trassets.ai/v1/raw/sollart?limit=10000" \
  -H "X-API-Key: $TRASSETS_API_KEY" | grep -i x-snapshot-at

Full Python example

A complete script that exports a table page by page, following the cursor until exhausted, and verifies snapshot consistency across pages. Requires the requests package.

bulk_export.py

import os
import requests

API_KEY = os.environ["TRASSETS_API_KEY"]
BASE_URL = "https://api.trassets.ai"
HEADERS = {"X-API-Key": API_KEY}


def export_table(table_name: str, page_size: int = 10000) -> list[dict]:
    """Export every row of a raw table, verifying a single consistent snapshot."""
    rows: list[dict] = []
    cursor = None
    snapshot_at = None

    while True:
        params = {"limit": page_size}
        if cursor:
            params["cursor"] = cursor

        resp = requests.get(
            f"{BASE_URL}/v1/raw/{table_name}", headers=HEADERS, params=params, timeout=60
        )
        resp.raise_for_status()

        page_snapshot = resp.headers.get("X-Snapshot-At")
        if snapshot_at is None:
            snapshot_at = page_snapshot
        elif page_snapshot != snapshot_at:
            raise RuntimeError(
                f"Snapshot changed mid-export ({snapshot_at} -> {page_snapshot}); "
                "restart the export from the beginning."
            )

        body = resp.json()
        rows.extend(body["data"])
        cursor = body["next_cursor"]
        if cursor is None:
            break

    return rows, snapshot_at


if __name__ == "__main__":
    rows, snapshot_at = export_table("sollart")
    print(f"Exported {len(rows)} rows as of snapshot {snapshot_at}")

Cursor sequences remain stable under concurrent writes. Because raw tables can receive updates during a long export, X-Snapshot-At tells you which sync version each page belongs to. For a guaranteed single-snapshot export, retry from the beginning if the snapshot timestamp differs across pages.

Get Started

Core Concepts

Guides

Data Model

Bulk export a full table with Raw endpoints