Update the JSON object and store the changes

Question

Update the JSON object and store the changes

I have a json array object that requires modification and saving the updated version to a variable.

The original json object is:

var json = [ 
{ 
  "Name": "March-2016", 
  "Elements": [ 
    { 
      "Name": "aa", 
      "Elements": [ 
        { 
         "Name": "ss", 
          "Data": { 
            "Test1": [ 
              22
            ], 
            "Test2": [ 
              33 
            ],
            "Test3": [ 
              44
            ],
            "Test4": [ 
              55
            ]
          } 
        },
        { 
          "Name": "ssee", 
           "Data": { 
             "Test12": [ 
               222
             ], 
             "Test22": [ 
               3322 
             ],
             "Test32": [ 
               445
             ],
             "Test42": [ 
               553
             ]
           } 
         }  
      ] 
    } 
  ] 
}

;

The modified version should be:

 var json = [ 
{ 
  "Name": "March-2016", 
  "Elements": [ 
    { 
      "Name": "aa", 
      "Elements": [ 
        { 
         "category": "ss", 
            "Test1": 22, 
            "Test2": 33 ,
            "Test3":44,
            "Test4": 55 
        },
        { 
          "category": "ssee", 
          "Test12": 222, 
          "Test22": 3322 ,
          "Test32":445,
          "Test42": 553 
         }  
      ] 
    } 
  ] 
}

;

I am trying to achieve this using the saveJson method but encountering issues. Here's the method:

var saveJson = function(arr) {
var nameValuePairs = [];
for (var i = 0, len = arr.length; i < len; i++) {
  var item = arr[i];
  if (item.Data) {
    var newvar = {
       category : item.Name
     }
     newvar[Object.keys(item.Data)] = Object.values(item.Data);
     item = newvar

  }

  if (item.Elements) {
    nameValuePairs = nameValuePairs.concat(saveJson(item.Elements));
  }
}
return arr;
};

I need assistance in making this conversion dynamic as I anticipate working with larger json arrays than the sample provided. Thank you for your help in advance.

javascript arrays json

Answer 1

Answer №1

The initial data structure is quite chaotic, however, by carefully navigating through it and extracting the desired values, you can tidy it up. The following script modifies the json object directly:

json.forEach(entry => {
  entry.Elements.forEach(outerElement => {
      outerElement.Elements = outerElement.Elements.map(subItem =>{
          let tempObj =  {category: subItem.Name}
          Object.keys(subItem.Data).forEach(key => {
              tempObj[key] = subItem.Data[key][0]
          })
          return tempObj
      })
   })
})

The updated json should now resemble this:

[{
    "Name":"March-2016",
    "Elements":[
        {
            "Name":"aa",
            "Elements":[
                {
                    "category":"ss",
                    "Test1":22,
                    "Test2":33,
                    "Test3":44,
                    "Test4":55
                },
                {
                    "category":"ssee",
                    "Test1e":224,
                    "Test2e":334,
                    "Test3e":443,
                    "Test4e":554
                }
            ]
        }
    ]
}]

Answer 2

The initial data structure is quite chaotic, however, by carefully navigating through it and extracting the desired values, you can tidy it up. The following script modifies the json object directly:

json.forEach(entry => {
  entry.Elements.forEach(outerElement => {
      outerElement.Elements = outerElement.Elements.map(subItem =>{
          let tempObj =  {category: subItem.Name}
          Object.keys(subItem.Data).forEach(key => {
              tempObj[key] = subItem.Data[key][0]
          })
          return tempObj
      })
   })
})

The updated json should now resemble this:

[{
    "Name":"March-2016",
    "Elements":[
        {
            "Name":"aa",
            "Elements":[
                {
                    "category":"ss",
                    "Test1":22,
                    "Test2":33,
                    "Test3":44,
                    "Test4":55
                },
                {
                    "category":"ssee",
                    "Test1e":224,
                    "Test2e":334,
                    "Test3e":443,
                    "Test4e":554
                }
            ]
        }
    ]
}]

Answer 3

Answer №2

Employing destructuring assignment allows for extracting specific property values from an object

{
  const {Title:sections, Info:{Description:[Description]}} = jsonResponse[0].Objects[0].Objects[0];
  jsonResponse[0].Objects[0].Objects[0] = {sections, Description};
}

Answer 4

Employing destructuring assignment allows for extracting specific property values from an object

{
  const {Title:sections, Info:{Description:[Description]}} = jsonResponse[0].Objects[0].Objects[0];
  jsonResponse[0].Objects[0].Objects[0] = {sections, Description};
}

Update the JSON object and store the changes

Answer №1

Answer №2

Similar questions

JavaScript appends a backslash character to a CSS class

The client side script "/socket.io/socket.io.js" was not located, therefore the Express-generator project was used instead

Rearrange the position of an element within an array

Creating an ImmutableJS Record with custom types: A step-by-step guide

Fetching post data from an HTML form in Node.js using Express 4: A comprehensive guide

"Troubleshooting: Unable to Trigger jQuery Click Event Using Class Selector

The JSON file overwrites entire objects instead of targeting individual ones

What are the steps for manipulating JSON data in a string retrieved using Axios?

What is the best way to create a regex that can recursively assign string values to an array?

Switch up the animation based on the state in AngularJS

Activate dynamic form fields using Ajax

assigning a value of undefined to the selected option in AngularJS

Constructing Browserify with dependencies containing require statements within a try-catch block

Encountering a 'Exception Unhandled' error in C# when attempting to parse JSON data

The console.log() function does not accurately display the true value

Error: Issue transferring data to controller from Ng-Style

What can be used instead of makeStyles in Material UI version 5?

Activate UpdatePanel upon hovering the mouse cursor over it (displayed as a tooltip)

ESLint is reporting that TopBarClass is missing from the file './TopBar' while trying to import it as a named module

Dynamically loading JSON information into a DIV using AJAX requests