Pagination

# Needs curl and jq. Prints one order per line.
base="${FILMO_BASE_URL:-https://app.filmo.io}"
cursor=""
while :; do
  # Keep limit and sort identical on every page.
  set -- --data-urlencode "limit=100" --data-urlencode "sort=createdAt"
  [ -n "$cursor" ] && set -- "$@" --data-urlencode "cursor=$cursor"

  page="$(curl -sS --fail-with-body -G "$base/api/v1/orders" \
    -H "Authorization: Bearer $FILMO_API_KEY" "$@")" || { echo "$page" >&2; exit 1; }

  echo "$page" | jq -c '.data[]'
  cursor="$(echo "$page" | jq -r 'if .pagination.hasMore then .pagination.nextCursor else "" end')"
  [ -n "$cursor" ] || break
done

const base = process.env.FILMO_BASE_URL ?? "https://app.filmo.io";
const headers = { Authorization: `Bearer ${process.env.FILMO_API_KEY}` };

const orders = [];
let cursor = null;
do {
  const url = new URL("/api/v1/orders", base);
  url.searchParams.set("limit", "100"); // keep limit and sort identical on every page
  url.searchParams.set("sort", "createdAt");
  if (cursor) url.searchParams.set("cursor", cursor);

  const res = await fetch(url, { headers });
  if (!res.ok) throw new Error(res.status + " " + (await res.text()));
  const page = await res.json();

  orders.push(...page.data);
  cursor = page.pagination.hasMore ? page.pagination.nextCursor : null;
} while (cursor);

console.log(orders.length + " orders");

import os
import requests

base = os.environ.get("FILMO_BASE_URL", "https://app.filmo.io")
headers = {"Authorization": f"Bearer {os.environ['FILMO_API_KEY']}"}

orders, cursor = [], None
while True:
    # Keep limit and sort identical on every page.
    params = {"limit": 100, "sort": "createdAt"}
    if cursor:
        params["cursor"] = cursor
    res = requests.get(base + "/api/v1/orders", headers=headers, params=params, timeout=30)
    res.raise_for_status()
    page = res.json()

    orders += page["data"]
    if not page["pagination"]["hasMore"]:
        break
    cursor = page["pagination"]["nextCursor"]

print(len(orders), "orders")