// Format CSV data to Entry JSON to update entries
const csvTable = input.csvTable; 
let csvColumn=csvTable['tableState']['data'][0];
let fieldUids = Object.values(input.csvTable['tableState']['data'][0]);//Field UIDs
let csvData=csvTable['tableState']['data']
csvData.shift();
let entries=csvData.map(a => a.column4);
const FinalObj=[];
for(let i=0;i<csvData.length;i++){
    let formattedArr=[]
    let formattedObj={}
    for(let k=0;k<fieldUids.length;k++){
        let keyID=k+1
        formattedObj[fieldUids[k]]=csvData[i]['column'+keyID]
    }
    FinalObj.push(formattedObj)
}//Formatted Entry JSON from CSV
let createEntries = FinalObj.filter(function (el) {
  return el.uid == undefined 
}); // Create Entries Objects Array where no UIDs provieded 
let localiseEntries = FinalObj.filter(function (el) {
  return  !(el.uid == undefined)
}); // Update/Localise Entries Objects Array where UIDs provieded 
console.log(createEntries,localiseEntries)
return {'createEntries':createEntries,'localiseEntries':localiseEntries};

External CSS

This Pen doesn't use any external CSS resources.

External JavaScript

This Pen doesn't use any external JavaScript resources.