Python

import csv
import os
import time

import requests

# The sandbox key reads a demo group. Set SCOUTWORKS_API_KEY to use your own.
API_KEY = os.environ.get(
    "SCOUTWORKS_API_KEY",
    "sw_live_473adcc6c7236916021f0f24559db36576a53bab071d0f0c08a025adb510b6ab",
)
session = requests.Session()
session.headers["Authorization"] = f"Bearer {API_KEY}"


def get(url, params):
    """GET one page. Waits and tries again if the rate limit is reached."""
    while True:
        res = session.get(url, params=params, timeout=30)
        if res.status_code == 429:
            time.sleep(res.json().get("retryAfter", 30))
            continue
        if not res.ok:
            error = res.json()["error"]
            raise SystemExit(f"{res.status_code} {error['code']}: {error['message']}")
        return res.json()


def read_all(url):
    """Every item in a list, following nextCursor to the last page."""
    items, params = [], {"limit": 200}
    while True:
        page = get(url, params)
        items += page["data"]
        if page["nextCursor"] is None:
            return items
        params["cursor"] = page["nextCursor"]


def safe(value):
    """Stops a spreadsheet running a cell that starts with = + - or @."""
    text = str(value)
    return "'" + text if text.lstrip().startswith(("=", "+", "-", "@")) else text


members = read_all("https://api-demo.scoutworks.app/api/v1/members")

with open("members.csv", "w", newline="", encoding="utf-8") as f:
    writer = csv.writer(f)
    writer.writerow(["First name", "Last name", "Sections", "Patrol", "Joined"])
    for m in members:
        writer.writerow([
            safe(m["firstName"]),
            safe(m["lastName"]),
            safe(", ".join(s["name"] for s in m["sections"])),
            safe(m["patrol"]["name"] if m["patrol"] else ""),
            m["joinedAt"][:10],
        ])

print(f"Saved {len(members)} members to members.csv")