Your members in Google Sheets

// Scoutworks → Google Sheets. https://developers.scoutworks.app/recipes/google-sheets

function importMembers() {
  const apiKey = PropertiesService.getScriptProperties().getProperty('SCOUTWORKS_API_KEY');
  if (!apiKey) throw new Error('Add SCOUTWORKS_API_KEY in Project Settings → Script Properties.');

  const rows = [['First name', 'Last name', 'Sections', 'Patrol', 'Joined']];
  let cursor = null;

  do {
    let url = 'https://api-demo.scoutworks.app/api/v1/members?limit=200';
    if (cursor) url += '&cursor=' + encodeURIComponent(cursor);
    const body = fetchScoutworks(url, apiKey);

    body.data.forEach(function (m) {
      rows.push([
        safe(m.firstName),
        safe(m.lastName),
        safe(m.sections.map(function (s) { return s.name; }).join(', ')),
        safe(m.patrol ? m.patrol.name : ''),
        m.joinedAt.slice(0, 10),
      ]);
    });
    cursor = body.nextCursor;
  } while (cursor);

  const book = SpreadsheetApp.getActive();
  const sheet = book.getSheetByName('Members') || book.insertSheet('Members');
  sheet.clearContents();
  sheet.getRange(1, 1, rows.length, rows[0].length).setValues(rows);
}

// Calls the API. Waits and tries again if the rate limit is reached.
function fetchScoutworks(url, apiKey) {
  for (let attempt = 0; attempt < 3; attempt++) {
    const res = UrlFetchApp.fetch(url, {
      headers: { Authorization: 'Bearer ' + apiKey },
      muteHttpExceptions: true,
    });
    const body = JSON.parse(res.getContentText());
    if (res.getResponseCode() === 200) return body;
    if (res.getResponseCode() === 429) {
      Utilities.sleep((body.retryAfter || 30) * 1000);
      continue;
    }
    throw new Error(body.error.code + ': ' + body.error.message);
  }
  throw new Error('Scoutworks is still busy. Try again in a minute.');
}

// Stops a name that starts with = + - or @ from running as a formula.
function safe(value) {
  const text = String(value);
  return /^\s*[=+\-@]/.test(text) ? "'" + text : text;
}

function syncMembers() {
  const props = PropertiesService.getScriptProperties();
  const apiKey = props.getProperty('SCOUTWORKS_API_KEY');
  // Once a week, and on the first run, read every member from 2000 and
  // rebuild the sheet: that is how a member who left disappears from it.
  const lastFull = props.getProperty('SCOUTWORKS_MEMBERS_FULL_AT');
  const full = !lastFull || Date.now() - Date.parse(lastFull) > 7 * 24 * 60 * 60 * 1000;
  const since = full ? '2000-01-01T00:00:00Z' : props.getProperty('SCOUTWORKS_MEMBERS_SINCE');

  const book = SpreadsheetApp.getActive();
  const sheet = book.getSheetByName('Members (sync)') || book.insertSheet('Members (sync)');
  const byId = new Map();
  if (!full) {
    sheet.getDataRange().getValues().slice(1).forEach(function (row) {
      if (row[0]) byId.set(row[0], row);
    });
  }

  let cursor = null;
  let mark = null;
  do {
    let url = 'https://api-demo.scoutworks.app/api/v1/members?limit=200';
    url += '&updatedSince=' + encodeURIComponent(since);
    if (cursor) url += '&cursor=' + encodeURIComponent(cursor);
    const body = fetchScoutworks(url, apiKey);
    body.data.forEach(function (m) {
      byId.set(m.id, [
        m.id,
        safe(m.firstName),
        safe(m.lastName),
        safe(m.sections.map(function (s) { return s.name; }).join(', ')),
      ]);
    });
    mark = body.nextUpdatedSince || mark;
    cursor = body.nextCursor;
  } while (cursor);

  const rows = [['id', 'First name', 'Last name', 'Sections']].concat(Array.from(byId.values()));
  sheet.clearContents();
  sheet.getRange(1, 1, rows.length, rows[0].length).setValues(rows);
  props.setProperty('SCOUTWORKS_MEMBERS_SINCE', mark);
  if (full) props.setProperty('SCOUTWORKS_MEMBERS_FULL_AT', new Date().toISOString());
}