Sdy603

Sdy603 / fetch_jira_incidents_and_POST_incidents_API.js

Last active September 25, 2024 19:54 — forked from ivansnag/fetch_jira_incidents_and_POST_incidents_API.js

Fetches JIRA incidents from DB and POSTs to the Incidents API

	const { Client } = require('pg');
	const axios = require('axios');

	// Set debug mode
	const debug = true; // Set to false to make actual API calls

	// Database connection string
	const connectionString = [CONNECTION STRING FROM DX]

	// Create a new PostgreSQL client

Sdy603 / import_incidents_from_CSV_template.js

Created August 16, 2024 21:59 — forked from ivansnag/import_incidents_from_CSV_template.js

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

	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)