Get a guaranteed table format

curl -X POST "$RETRIEVER_API_URL/v1/runs" \
  -H "Authorization: Bearer $RETRIEVER_API_KEY" \
  -H "Content-Type: application/json" \
  -H "Idempotency-Key: agencies-paris-2026-09-15" \
  -d '{
    "prompt": "Find 20 B2B design agencies in Paris with the CEO name and email.",
    "output": {
      "type": "tables",
      "tables": [{
        "key": "agencies",
        "row_schema": {
          "type": "object",
          "required": ["company_name", "website", "ceo_name", "ceo_email"],
          "properties": {
            "company_name": { "type": "string" },
            "website": { "type": "string" },
            "ceo_name": { "type": ["string", "null"] },
            "ceo_email": { "type": ["string", "null"] }
          }
        }
      }]
    }
  }'

import os, requests

API = os.environ["RETRIEVER_API_URL"]
HEADERS = {"Authorization": f"Bearer {os.environ['RETRIEVER_API_KEY']}"}

def get(path, **params):
    res = requests.get(f"{API}{path}", headers=HEADERS, params=params, timeout=30)
    res.raise_for_status()
    return res.json()

output = get(f"/v1/runs/{run_id}/output")
agencies = next(t for t in output["tables"] if t["key"] == "agencies")

cursor = None
while True:
    page = get(agencies["links"]["rows"], limit=1000, **({"cursor": cursor} if cursor else {}))
    for row in page["items"]:
        print(row["values"]["company_name"], row["values"]["ceo_email"])
    cursor = page["next_cursor"]
    if not cursor:
        break