Function uploadToSlack

scripts/sendWeeklyExcelSheet.mjs:35–84

(buffer, filename, message)

}

async function uploadToSlack(buffer, filename, message) {
  // Step 1: get upload URL
  let urlRes = await fetch('https://slack.com/api/files.getUploadURLExternal', {
    method: 'POST',
    headers: {
      Authorization: `Bearer ${SLACK_TESTING_BOT_TOKEN}`,
      'Content-Type': 'application/x-www-form-urlencoded'
    },
    body: new URLSearchParams({filename, length: buffer.byteLength}),
    signal: AbortSignal.timeout(30000)
  });
  let urlData = await urlRes.json();
  if (!urlData.ok) {
    throw new Error(`Failed to initialize Slack file upload: ${urlData.error}`);
  }

  let parsedUploadUrl = new URL(urlData.upload_url);
  if (parsedUploadUrl.protocol !== 'https:' || parsedUploadUrl.hostname !== 'files.slack.com') {
    throw new Error('Unexpected upload URL');
  }
  // Step 2: upload file bytes
  let uploadRes = await fetch(urlData.upload_url, {
    method: 'POST',
    headers: {'Content-Type': 'application/octet-stream'},
    body: buffer,
    signal: AbortSignal.timeout(30000)
  });
  if (!uploadRes.ok) {
    throw new Error(`File upload failed: ${uploadRes.status} ${uploadRes.statusText}`);
  }

  // Step 3: complete upload and share to channel
  let completeRes = await fetch('https://slack.com/api/files.completeUploadExternal', {
    method: 'POST',
    headers: {
      Authorization: `Bearer ${SLACK_TESTING_BOT_TOKEN}`,
      'Content-Type': 'application/json'
    },
    body: JSON.stringify({
      files: [{id: urlData.file_id}],
      channel_id: SLACK_CHANNEL_ID,
      initial_comment: message
    }),
    signal: AbortSignal.timeout(30000)
  });
  let completeData = await completeRes.json();
  if (!completeData.ok) {
    throw new Error(`Failed to complete Slack file upload: ${completeData.error}`);
  }
}

async function main() {
  let args = parseArgs({allowPositionals: true});