レポートAPI - Google Sheetsインテグレーション用のWebhookの例

const {google} = require('googleapis');
const axios = require('axios');

// mabl API info
const MABL_API_KEY = '<API-KEY>';
const MABL_ENDPOINT_URL = 'https://api.mabl.com/results/planRun';

// Spreadsheet that has been shared with Google Service Account email address.
// Spreadsheet ID can be found in the URL for the spreadsheet like https://docs.google.com/spreadsheets/d/SPREADSHEET-ID-IS-HERE
const SPREADSHEET_ID = '<SPREADSHEET-ID>';
const SPREADSHEET_PAGE = 'Sheet1';

// Google scopes needed to append to spreadsheet
const SCOPES = ['https://www.googleapis.com/auth/spreadsheets'];

// File containing Google Service Account key created and downloaded in Setup step (4)
const GOOGLE_SA_CREDENTIALS_FILE = 'path/to/google-service-account-key.json';

// Ordered fields on individual test runs
const TEST_RUN_FIELDS = [
  "initial_url",
  "browser",
  "browser_version",
  "execution_runner_type",
  "scenario_name",
  "test_id",
  "test_version",
  "test_name",
  "test_type",
  "branch",
  "test_run_id",
  "test_run_app_url",
  "is_ad_hoc_run",
  "start_time",
  "end_time",
  "run_time",
  "status",
  "success",
  "failure_category",
  "emulation_mode"
];

// Ordered fields on plan runs, to be appended after the test run fields.
const PLAN_RUN_FIELDS = [
  "workspace_name",
  "plan_id",
  "plan_run_id",
  "plan_name",
  "trigger_type",
  "triggering_deployment_event_id",
  "application_name",
  "environment_name",
  "status",
  "success"
];

async function getPlanRunResults(id) {
  const response = await axios.get(`${MABL_ENDPOINT_URL}/${id}`, {
    auth: {
      username: 'key',
      password: MABL_API_KEY,
    }
  });
  return response.data.test_results.map(result => {
    const testRunFields = TEST_RUN_FIELDS.map(field => result[field]);
    const planRunFields = PLAN_RUN_FIELDS.map(field => response.data[field]);
    return [...testRunFields, ...planRunFields];
  });
}

async function loadGoogleCredentials(filename) {
  return new google.auth.GoogleAuth({
    keyFile: filename,
    scopes: SCOPES,
  });
}

async function appendToSheet(googleAuth, data) {
  const sheets = google.sheets({version: 'v4', auth: googleAuth});
  return await sheets.spreadsheets.values.append({
    spreadsheetId: SPREADSHEET_ID,
    range: SPREADSHEET_PAGE,
    valueInputOption: 'RAW',
    insertDataOption: 'INSERT_ROWS',
    resource: {
      values: data
    }
  });
}

async function handlePlanRunWebhook(webhookPayload) {
  const planRunId = webhookPayload.plan_execution.id;
  const planRunResult = await getPlanRunResults(planRunId);
  const googleAuth = await loadGoogleCredentials(GOOGLE_SA_CREDENTIALS_FILE);
  await appendToSheet(googleAuth, planRunResult);
  console.log(`Successfully processed plan run ID [${planRunId}]`);
}