Converting CSV to JSON payload

[dhruvsachdeva13]

var csvData = `"Worker ID","Security ID","Buyer Reference","First Name","Last Name","Worker Status","Cost Center","Business Unit"

"W00039149","7352tyhg5463","120440","test","user","Closed","ADC ","Operations "`;

// Function to convert CSV to JSON

function csvToJson(csv) {

    var lines = csv.trim().split('\n');

    var headers = lines[0].replace(/"/g, '').split(',');

    var jsonResult = lines.slice(1).map(line => {

        var values = line.replace(/"/g, '').split(',');

        var obj = {};

        headers.forEach((header, index) => {

            obj[header.trim()] = values[index].trim();

        });

        return obj;

    });

    return JSON.stringify(jsonResult, null, 4); // Pretty print with 4 spaces

}

// Convert and log the result

var jsonOutput = csvToJson(csvData);

gs.print(jsonOutput);

Output :

*** Script: [
    {
        "Worker ID": "W00039149",
        "Security ID": "7352tyhg5463",
        "Buyer Reference": "120440",
        "First Name": "test",
        "Last Name": "user",
        "Worker Status": "Closed",
        "Cost Center": "ADC",
        "Business Unit": "Operations"
    }
]