A weekly numbers email

// Scoutworks → weekly numbers email. https://developers.scoutworks.app/recipes/weekly-numbers

const BASE = 'https://api-demo.scoutworks.app/api/v1';
const WAITING = ['received', 'contacted', 'offered', 'accepted'];
const DAY = 24 * 60 * 60 * 1000;

function sendWeeklyNumbers() {
  const to = PropertiesService.getScriptProperties().getProperty('SEND_TO') ||
    Session.getEffectiveUser().getEmail();
  const group = fetchScoutworks(BASE + '/me').data.group.name;
  const members = readAll('/members');
  const waiting = readAll('/waiting-list').filter(function (w) {
    return WAITING.indexOf(w.status) !== -1;
  });
  const weekAgo = Date.now() - 7 * DAY;

  // Members and waiting list, side by side, for each section.
  const sections = {};
  function row(name) {
    return (sections[name] = sections[name] || { members: 0, waiting: 0 });
  }
  members.forEach(function (m) { if (m.sections[0]) row(m.sections[0].name).members++; });
  waiting.forEach(function (w) { row(w.targetSection ? w.targetSection.name : 'No section').waiting++; });

  const table = Object.keys(sections).sort().map(function (name) {
    return '<tr><td>' + html(name) + '</td><td align="right">' + sections[name].members +
      '</td><td align="right">' + sections[name].waiting + '</td></tr>';
  }).join('');

  const newThisWeek = waiting.filter(function (w) { return new Date(w.appliedAt).getTime() >= weekAgo; });
  const noReply = waiting.filter(function (w) {
    return w.status === 'received' && new Date(w.appliedAt).getTime() < weekAgo;
  });

  const body =
    '<h2>' + html(group) + ': this week</h2>' +
    '<table cellpadding="4"><tr><th align="left">Section</th><th>Members</th><th>Waiting</th></tr>' +
    table + '</table>' +
    '<h3>New on the waiting list (' + newThisWeek.length + ')</h3>' + list(newThisWeek) +
    '<h3>Waiting more than a week for a first reply (' + noReply.length + ')</h3>' + list(noReply);

  MailApp.sendEmail({
    to: to,
    subject: group + ': ' + members.length + ' members, ' + waiting.length + ' waiting',
    htmlBody: body,
  });
}

// A bullet list of applications, or a short note if there are none.
function list(entries) {
  if (entries.length === 0) return '<p>None.</p>';
  return '<ul>' + entries.map(function (w) {
    return '<li>' + html(w.firstName + ' ' + w.lastName) + ' for ' +
      html(w.targetSection ? w.targetSection.name : 'no section') +
      ', applied ' + w.appliedAt.slice(0, 10) + '</li>';
  }).join('') + '</ul>';
}

// Names on the waiting list come from a public form. Escape them before they go into HTML.
function html(value) {
  return String(value).replace(/&/g, '&amp;').replace(/</g, '&lt;').replace(/>/g, '&gt;').replace(/"/g, '&quot;');
}

// Every item in a list, following nextCursor to the last page.
function readAll(path) {
  const items = [];
  let cursor = null;
  do {
    let url = BASE + path + (path.indexOf('?') === -1 ? '?' : '&') + 'limit=200';
    if (cursor) url += '&cursor=' + encodeURIComponent(cursor);
    const body = fetchScoutworks(url);
    items.push.apply(items, body.data);
    cursor = body.nextCursor;
  } while (cursor);
  return items;
}

// Calls the API. Waits and tries again if the rate limit is reached.
function fetchScoutworks(url) {
  const apiKey = PropertiesService.getScriptProperties().getProperty('SCOUTWORKS_API_KEY');
  if (!apiKey) throw new Error('Add SCOUTWORKS_API_KEY in Project Settings → Script Properties.');
  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.');
}