Developing a JSON structure from a series of lists

Question

Developing a JSON structure from a series of lists

var data = [
    [
        "default_PROJECT",
        "Allow",
        "Connect",
        "Allow",
        "AddComment",
        "Allow",
        "Write",
        "Allow",
        "ViewComments",
        "Allow",
        "ExportData",
        "Allow",
        "ExportImage",
        "Allow",
        "ViewUnderlyingData",
        "Allow",
        "Read",
        "Allow",
        "ShareView",
        "Allow",
        "Filter"
    ],
    [
        "Allow",
        "ExportImage",
        "Allow",
        "Write",
        "Allow",
        "ViewComments",
        "Allow",
        "ShareView",
        "Allow",
        "Filter",
        "Allow",
        "ExportData",
        "Allow",
        "Connect",
        "Allow",
        "Read",
        "Allow",
        "ViewUnderlyingData",
        "Allow",
        "AddComment",
        "Allow",
        "ViewComments",
        "Deny",
        "ExportData",
        "Allow",
        "AddComment",
        "Deny",
        "Write",
        "Allow",
        "Read",
        "Deny",
        "ExportXml",
        "Deny",
        "ShareView",
        "Allow",
        "Connect",
        "Allow",
        "ChangeHierarchy",
        "Allow",
        "WebAuthoring",
        "Deny",
        "ViewUnderlyingData",
        "Deny",
        "Filter",
        "Deny",
        "ExportImage"
    ]
];


var newObj = {};

for(i=0; i<data.length; i++){
  //newObj['name'] = data[i][0];
  for(j=1; j<data[i].length;j++){
   newObj[data[i][j+1]] = data[i][j];
   document.write(data[i][j] + "----");
  }
}

document.write(JSON.stringify(newObj));

I am attempting to create a collection of objects where each object includes the "Name" as the initial element of the array, along with the associated value which can be either "ALLOW" or "Deny". For example, I aim to achieve:

{name: "default_PROJECT", connect: "Allow", AddComment: "Allow"} ... etc

However, there are instances where duplicate keys exist in the arrays, and if the value is Deny, it will always take precedence over a previous Deny value.

I have started by iterating through each array and attempting to set the subsequent element as the key. Am I on the right path?

javascript arrays json

Answer 1

Answer №1

var data  =[["default_PROJECT","Allow","Connect","Allow","AddComment","Allow","Write",
"Allow","ViewComments","Allow","ExportData","Allow","ExportImage","Allow","ViewUnderlyingData","Allow","Read","Allow","ShareView","Allow","Filter"],
["Allow","ExportImage","Allow","Write","Allow","ViewComments",
"Allow","ShareView","Allow","Filter","Allow","ExportData","Allow","Connect","Allow",
"Read","Allow","ViewUnderlyingData","Allow","AddComment","Allow","ViewComments","Deny","ExportData","Allow",
"AddComment","Deny","Write","Allow","Read","Deny","ExportXml","Deny","ShareView","Allow","Connect","Allow","ChangeHierarchy","Allow",
"WebAuthoring","Deny","ViewUnderlyingData","Deny","Filter","Deny","ExportImage"]];


var result = [];

for(var i = 0, len = data.length; i < len; i++) {
  var list = data[i];
  
  result[i] = { name: list[0] };

  for(var j = list.length - 1; j >= 1; j = j - 2) {
    var key = list[j];
    var value = list[j - 1];
    
    console.log('calc', j, key, value);
    

    result[i][key] = value;

    
  }
}

/** IGNORE THIS, IS JUST FOR DEBBUGGING **/
var resultElement = document.getElementById('result1');
var tpl = '';
for(var t = 0, tLen = result.length; t < tLen; t++) {
  var item = result[t];
  
  tpl+= '<table>' +
    '<thead>' +
      '<tr><td colspan="2">' + item.name + '</td></tr>' +
      '<tr><th>KEY</th><th>VAL</th></tr>' +
      '</thead>' +
    '<tbody>'
  ;
  
  for(var key in item) {
    if(!item.hasOwnProperty(key) || key === 'name') { continue; }
    
    tpl += '<tr><td>'+ key +'</td><td>'+ item[key] +'</td></tr>';   
  }
      
  
  tpl += '</tbody></table>';
}
resultElement.innerHTML = tpl;

table { text-align: left; width: 100%; margin-bottom: 50px; border-collapse: collapse;}
td, th { width: 50%; border: 1px solid black; line-height: 1; padding:2px 10px;}
[colspan="2"] { color: blue; font-weight: bolder;text-transform: uppercase; text-align: center;}

<div id="result1"></div>

Answer 2

var data  =[["default_PROJECT","Allow","Connect","Allow","AddComment","Allow","Write",
"Allow","ViewComments","Allow","ExportData","Allow","ExportImage","Allow","ViewUnderlyingData","Allow","Read","Allow","ShareView","Allow","Filter"],
["Allow","ExportImage","Allow","Write","Allow","ViewComments",
"Allow","ShareView","Allow","Filter","Allow","ExportData","Allow","Connect","Allow",
"Read","Allow","ViewUnderlyingData","Allow","AddComment","Allow","ViewComments","Deny","ExportData","Allow",
"AddComment","Deny","Write","Allow","Read","Deny","ExportXml","Deny","ShareView","Allow","Connect","Allow","ChangeHierarchy","Allow",
"WebAuthoring","Deny","ViewUnderlyingData","Deny","Filter","Deny","ExportImage"]];


var result = [];

for(var i = 0, len = data.length; i < len; i++) {
  var list = data[i];
  
  result[i] = { name: list[0] };

  for(var j = list.length - 1; j >= 1; j = j - 2) {
    var key = list[j];
    var value = list[j - 1];
    
    console.log('calc', j, key, value);
    

    result[i][key] = value;

    
  }
}

/** IGNORE THIS, IS JUST FOR DEBBUGGING **/
var resultElement = document.getElementById('result1');
var tpl = '';
for(var t = 0, tLen = result.length; t < tLen; t++) {
  var item = result[t];
  
  tpl+= '<table>' +
    '<thead>' +
      '<tr><td colspan="2">' + item.name + '</td></tr>' +
      '<tr><th>KEY</th><th>VAL</th></tr>' +
      '</thead>' +
    '<tbody>'
  ;
  
  for(var key in item) {
    if(!item.hasOwnProperty(key) || key === 'name') { continue; }
    
    tpl += '<tr><td>'+ key +'</td><td>'+ item[key] +'</td></tr>';   
  }
      
  
  tpl += '</tbody></table>';
}
resultElement.innerHTML = tpl;

table { text-align: left; width: 100%; margin-bottom: 50px; border-collapse: collapse;}
td, th { width: 50%; border: 1px solid black; line-height: 1; padding:2px 10px;}
[colspan="2"] { color: blue; font-weight: bolder;text-transform: uppercase; text-align: center;}

<div id="result1"></div>

Developing a JSON structure from a series of lists

Answer №1

Similar questions

There seems to be an issue with npm displaying an inaccurate version number for my

Dividing a fixed string state according to an increment state and showcasing the state in a React component

The absence of the 'profileStore' property is noticed in the '{}' type, which is necessary in the 'Readonly<AppProps>' type according to TypeScript error code ts(2741)

Bypassing the "Your connection is not private" error in NodeJS + Express with fetch() using Javascript

What is the significance of providing a sole argument to the Object () function?

Pressing the submit button will trigger the execution of a .php script, which will then generate a popup on the screen and refresh a specific part of

retrieving a key from a JSON object

Discovering the highest value in the final row of a two-dimensional array

Ensure that PHP form validations are checked when submitting the form using jQuery

Is the unavailability of nodejs's require function in this closure when using the debugger console due to a potential v8 optimization?

Generating a two-dimensional array and setting its values in JavaScript

An unusual problem stemming from jQuery/AJAX arises when variables within a function fail to update while a click

Effortlessly submit form data in Codeigniter without the need for page refreshing using jQuery ajax

What is the correct method for exporting an ES6 module function as a library to be utilized in a Node.js application?

Dynamically loading Ember templates with asynchronous requests

ReactJS: Difficulty with SVG foreignObject not capturing onClick event

Issue: parsing error, only 0 bytes out of 4344 have been successfully parsed on Node.js platform

Ensure that the three.js script remains in a fixed position on a page that can be

Is it truly necessary to remove packages from devDependencies to improve performance?

Emails not being sent by Nodemailer