import_incidents_from_CSV_template.js - CSV Template (https://docs.google.com/spreadsheets/d/1lC7dOhtyWMaLGXmm1pQsdfwhEBu7NulIov5K_pvv7BE/edit#gid=0)

import_incidents_from_CSV_template.js

const fetch = require('node-fetch');
const fs = require('fs');
const csv = require('csv-parser');

const csvFilePath = 'CSV TEMPLATE';
const apiEndpoint = 'CUSTOMER SPECIFIC INCIDENTS SYNC ENDPOINT';
const apiKey = 'API KEY';


fs.createReadStream(csvFilePath)
  .pipe(csv())
  .on('data', (row) => {

    const incidentData = {
      reference_id: row.reference_id,
      name: row.name,
      started_at: row.started_at,
      resolved_at: row.resolved_at,
      source_url: row.source_url || '',
      services: row.services ? row.services.split(',') : []  
    };
    console.log('Request Body:', JSON.stringify(incidentData, null, 2)); // Print formatted JSON

    fetch(apiEndpoint, {
      method: 'POST',
      headers: {
        'Content-Type': 'application/json',
        'Authorization': `Bearer ${apiKey}`
      },
      body: JSON.stringify(incidentData)
    })
    .then(response => response.json())
    .then(data => console.log('Success:', data))
    .catch(error => console.error('Error:', error));
  })
  .on('end', () => {
    console.log('CSV file successfully processed');
  });