PowerShell

# Scoutworks → CSV. https://developers.scoutworks.app/recipes/powershell

$Base = 'https://api-demo.scoutworks.app/api/v1'
# The sandbox key reads a demo group. Set $env:SCOUTWORKS_API_KEY to use your own.
$ApiKey = if ($env:SCOUTWORKS_API_KEY) { $env:SCOUTWORKS_API_KEY } else {
    'sw_live_473adcc6c7236916021f0f24559db36576a53bab071d0f0c08a025adb510b6ab'
}
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12

# Every item in a list, following nextCursor to the last page.
function Read-All([string]$Path) {
    $items = @()
    $cursor = $null
    while ($true) {
        $url = "$Base$Path" + $(if ($Path.Contains('?')) { '&' } else { '?' }) + 'limit=200'
        if ($cursor) { $url += '&cursor=' + [uri]::EscapeDataString($cursor) }
        try {
            $page = Invoke-RestMethod -Uri $url -Headers @{ Authorization = "Bearer $ApiKey" }
        } catch {
            if ([int]$_.Exception.Response.StatusCode -eq 429) {
                Start-Sleep -Seconds 30   # The rate limit. Wait, then try the same page again.
                continue
            }
            throw
        }
        $items += $page.data
        $cursor = $page.nextCursor
        if (-not $cursor) { return $items }
    }
}

# 2026-09-24T18:30:00.000Z → 2026-09-24. PowerShell 7 reads it as a date first.
function Day($Value) {
    if ($Value -is [datetime]) { $Value.ToUniversalTime().ToString('yyyy-MM-dd') }
    else { ([string]$Value).Substring(0, 10) }
}

# Stops Excel running a cell that starts with = + - or @.
function Safe($Value) {
    $text = [string]$Value
    if ($text -match '^\s*[=+\-@]') { "'$text" } else { $text }
}

$members = Read-All '/members'

$rows = $members | ForEach-Object {
    [pscustomobject]@{
        'First name' = Safe $_.firstName
        'Last name'  = Safe $_.lastName
        'Sections'   = Safe (($_.sections | ForEach-Object { $_.name }) -join ', ')
        'Patrol'     = Safe $(if ($_.patrol) { $_.patrol.name } else { '' })
        'Joined'     = Day $_.joinedAt
    }
}
if ($rows) {
    $rows | Export-Csv -Path members.csv -NoTypeInformation -Encoding UTF8
} else {
    # No members: still write the headings, so the file has its columns.
    Set-Content -Path members.csv -Value '"First name","Last name","Sections","Patrol","Joined"' -Encoding UTF8
}

Write-Host "Saved $($members.Count) members to members.csv"