Autodesk - Google Sheets Custom Integration

let API_KEY; 
let APP_ID; 

function onOpen() {
  let ui = SpreadsheetApp.getUi();
  ui.createMenu('Torii')
      .addItem('Sync now','syncNow')
      .addItem('Reconfigure','readConfig')
      .addToUi();
}

function syncNow(){
  let docProperties = PropertiesService.getDocumentProperties();
  API_KEY = docProperties.getProperty('api_key');
  APP_ID = docProperties.getProperty('app_id');


  if (!API_KEY || !APP_ID) {
    readConfig();
    docProperties = PropertiesService.getDocumentProperties();
    API_KEY = docProperties.getProperty('api_key');
    APP_ID = docProperties.getProperty('app_id');
  }

  let file = createJsonFile();
  let fileId = uploadFile(file);  
  syncIntegration(fileId);
}

function readConfig() {
  let ui = SpreadsheetApp.getUi();
  let result = ui.prompt("Please enter Torii API Key");
  API_KEY = result.getResponseText();

  result = ui.prompt("Please enter the APP ID");
  APP_ID = result.getResponseText();

  let docProperties = PropertiesService.getDocumentProperties();
  docProperties.setProperty('api_key', API_KEY);
  docProperties.setProperty('app_id', APP_ID);
}

function createJsonFile() {
	let = sheet = SpreadsheetApp.getActive();
	let data = sheet.getDataRange().getValues();
	Logger.log(SpreadsheetApp.getActiveSheet().getName());
	Logger.log(data);
	data.shift();

	let fullDataSet = [];
	let userDataSet = [];
	let updateDataSets = true;


	let licensesMap = {}

	data.forEach(function(row) {

			let firstName = row[2];
			let lastName = row[3];
			let email = row[4];
			let licenses = row[6];
			let day_used = Utilities.formatDate(new Date(row[9]), "UTC", 'YYYY-MM-dd');


			let obj = fullDataSet.find(x => x.email === email && x.license === licenses);
			if (obj) {
				let index = fullDataSet.indexOf(obj);
				let dateFromDataSet = fullDataSet[index].lastUsedDate;
				if (day_used > dateFromDataSet) {
					fullDataSet[index].lastUsedDate = day_used;
				}
				updateDataSets = false;
			}

			if (updateDataSets === true) {
				fullDataSet.push({
					email: email,
					firstName: firstName,
					lastName: lastName,
					status: "active",
					license: licenses,
					lastUsedDate: day_used
				});
			}

			updateDataSets = true;

		}

	);

	for (var i = 0; i < Object.keys(fullDataSet).length; i++) {
		let users;
		if (licensesMap[fullDataSet[i].license]) {
			users = licensesMap[fullDataSet[i].license]
		} else {
			users = []
		}

		users.push({
			email: fullDataSet[i].email,
			licenseStatus: "active",
			lastUsedDate: fullDataSet[i].lastUsedDate
		})
		licensesMap[fullDataSet[i].license] = users;

		const isUserFound = userDataSet.some(element => {
			if (element.email === fullDataSet[i].email) {
				return true;
			}

			return false;
		});
		if (isUserFound === false) {
			userDataSet.push({
				email: fullDataSet[i].email,
				firstName: fullDataSet[i].firstName,
				lastName: fullDataSet[i].lastName,
				status: "active"
			});

		}


	}

	const licenses = Object.keys(licensesMap).map(licenseName => {
		const users = licensesMap[licenseName]
		return {
			name: licenseName,
			users: users
		}
	})


	let file = {
		users: userDataSet,
		licenses: licenses
	}
	// Logger.log(file);
	console.log(JSON.stringify(file));
	return file;
}


function uploadFile(file) {
  let response = UrlFetchApp.fetch('https://api.toriihq.com/v1.0/files/url?name=my_file.json&type=customIntegrationData',
    {
      headers: { 'Authorization': `Bearer ${API_KEY}` }
    });

  let jsonResponse = JSON.parse(response);
  let s3url = jsonResponse.uploadFileParameters.url;
  let filePath = jsonResponse.uploadFileParameters.filePath;  
  Logger.log(s3url);
  Logger.log(filePath);

  response = UrlFetchApp.fetch(s3url,
    {
      'method' : 'put',
      'contentType': 'customIntegrationData',
      'payload' : JSON.stringify(file)
    }
  );
  
  // Get file id
  response = UrlFetchApp.fetch('https://api.toriihq.com/v1.0/files',
    {
      method: 'post',
      contentType: 'application/json',
      headers: { 'Authorization': `Bearer ${API_KEY}` },
      payload: JSON.stringify({
        path: filePath,
        type: 'customIntegrationData'
      }),
      headers: {
        'Authorization': `Bearer ${API_KEY}`
      }
    });

    jsonResponse = JSON.parse(response);
    let fileId = jsonResponse.id;
    Logger.log(fileId);
    return fileId;
};

function syncIntegration(fileId) {
  response = UrlFetchApp.fetch('https://api.toriihq.com/v1.0/services/sync/custom',
    {
      muteHttpExceptions: false,
      'method' : 'put',
      'contentType': 'application/json',
      'payload' : JSON.stringify({
          idFile: fileId,
          idAppAccount: APP_ID
      }),   
      headers: {
        'Authorization': `Bearer ${API_KEY}`
      }
    }
  );
  Logger.log(response);
}