CSV output

# -D saves the headers, where the next page's cursor is.
curl "https://api.citino.ai/v1/projects/$PROJECT_ID/reports/brands?from=$FROM&to=$TO&dimensions=date&format=csv" -H "Authorization: Bearer $CITINO_API_KEY" -D headers.txt -o page.csv
grep -i '^citino-next-cursor' headers.txt

import os
import requests

BASE = "https://api.citino.ai/v1"
key = os.environ["CITINO_API_KEY"]
project_id = os.environ["PROJECT_ID"]
session = requests.Session()
session.headers["Authorization"] = f"Bearer {key}"

params = {"from": os.environ["FROM"], "to": os.environ["TO"], "dimensions": "date", "format": "csv"}
with open("brands.csv", "w", encoding="utf-8", newline="") as out:
    wrote_header = False
    while True:
        response = session.get(f"{BASE}/projects/{project_id}/reports/brands", params=params)
        response.raise_for_status()
        lines = response.text.splitlines(keepends=True)
        if lines:
            out.writelines(lines if not wrote_header else lines[1:])
            wrote_header = True
        cursor = response.headers.get("Citino-Next-Cursor")
        if not cursor:
            break
        params["cursor"] = cursor

import { writeFile } from "node:fs/promises";

const BASE = "https://api.citino.ai/v1";
const headers = { Authorization: `Bearer ${process.env.CITINO_API_KEY}` };
const params = { from: process.env.FROM, to: process.env.TO, dimensions: "date", format: "csv" };

let csv = "";
for (;;) {
  const query = new URLSearchParams(params);
  const response = await fetch(
    `${BASE}/projects/${process.env.PROJECT_ID}/reports/brands?${query}`,
    { headers },
  );
  if (!response.ok) throw new Error(`Citino answered ${response.status}`);
  const text = await response.text();
  if (text) csv += csv ? text.slice(text.indexOf("\r\n") + 2) : text;
  const cursor = response.headers.get("Citino-Next-Cursor");
  if (!cursor) break;
  params.cursor = cursor;
}
await writeFile("brands.csv", csv);