Quickest way to change key name in nested json?

Question

I have json that looks like this

const myJson = [
  {

  "title":"1. Lockdown Population by Loan (186006)",
  children:[
     {
        title:"1.1 Previous (191225)",
        "firstLevelSubNodes:[
              { 
                title:"1.1.1 Roll forward (178260)" ,
                "firstLevelSubNodes":[{ 
                  title:"1.1.1.1 Roll forward (178260)"
                  }]
              }
        ],
        "secondLevelSubNodes":[
             title:"1.2.1 Bounce forward (178260)" ,
                "firstLevelSubNodes":[{ 
                  title:"1.2.1.1 Dash forward (178260)",
                    "firstLevelSubNodes":[{ 
                     title:"1.2.1.1.1 Skip forward (178260)",
                  }]
                  }]
        ],
        "thirdLevelSubNodes":[
        ],
        "fourthLevelSubNodes":[

        ]
     }         
  ],
  }
]

Everywhere you see the word xxxLevelSubNodes it needs to say the word "children" like below.

 const myJson = [
     {

  "title":"1. Lockdown Population by Loan (186006)",
  children:[
     {
        title:"1.1 Previous (191225)",
        "children:[
              { 
                title:"1.1.1 Roll forward (178260)" ,
                "children":[{ 
                  title:"1.1.1.1 Roll forward (178260)"
                  }]
              }
        ],
        "children":[
             title:"1.2.1 Bounce forward (178260)" ,
                "children":[{ 
                  title:"1.2.1.1 Dash forward (178260)",
                    "children":[{ 
                     title:"1.2.1.1.1 Skip forward (178260)",
                  }]
                  }]
        ],
        "children":[
        ],
        "children":[
        ]
     }         
  ],
  }
]

I have tried to loop through but it renames the word with children however it overwrites the last key. Also it doesn't loop through the nested portion of the JSON. I need it to remain in the exact same structure as above

const res = { firstLevelSubNodes: 'children', secondLevelSubNodes: 'children',

  thirdLevelSubNodes: 'children', fourthLevelSubNodes: 'children' }; 

 const object = JSON.parse(myJson);
    for (const k in res) {

      const newValue = res[k];

      object[newValue] = object[k];

      object[newValue].name = newValue;

      delete object[k];

    }

Maybe you can create one key children list and add all the xxxLevelSubNodes to it — Thiyagu
– Thiyagu, Commented Feb 21, 2018 at 18:21
I agree with @user7 but if you really wanted to, I would use JSON.stringify() and then use some regex with string.replace() You would get the result you're describing. — Mark Carpenter Jr
– Mark Carpenter Jr, Commented Feb 21, 2018 at 18:23
Do you want to merge the children arrays for everything that matches? — Scott Sauyet
– Scott Sauyet, Commented Feb 21, 2018 at 18:24
No merging. This represents a tree view in our app. The custom angular directive we use finds the word "children" and identifies it automatically as a child node — CodeMan03
– CodeMan03, Commented Feb 21, 2018 at 18:37

Yftach · Accepted Answer · 2018-02-21 19:14:54Z

3

Like the people who commented said, what you are asking for is not possible just because of the way JSON works.

you need to rethink what you are trying to do... "This represents a tree view in our app. The custom angular directive we use finds the word "children" and identifies it automatically as a child node "

By that logic, there should be only 1 children property at each level that means that your json should look like:

let myJson = [
    {

        "title":"1. Lockdown Population by Loan (186006)",
        children:[
            {
                title:"1.1 Previous (191225)",
                "children":[
                   {
                        title:"1.1.1 Roll forward (178260)" ,
                        "children":[{
                            title:"1.1.1.1 Roll forward (178260)"
                        }]
                    },
                    {
                        title: "1.2.1 Bounce forward (178260)",
                        "children": [{
                            title: "1.2.1.1 Dash forward (178260)",
                            "children": [{
                                title: "1.2.1.1.1 Skip forward (178260)",
                            }]
                        }]
                    },
                ],
            }
        ],
    }
];

If this is structure is true, what you really want to do is merge all the properties with a key that contains you format into the same array.

Of course you would want to do this recursively.

So its something like

function refactorJson(array) {
    for (var i =0; i< array.length; i++) {
        var obj = array[i];
        var newObj = {};
        newObj.title = obj.title;
        newObj.children = [];

        for (var property in obj) {
        console.log(property)
            if (property.contains('LevelSubNodes') || property === 'children') {
                var subObj = obj[property];
                var child = refactorJson(subObj);
                if (child) {
                    newObj.children.push(child);
                }
            }

        }
    }
    return newObj;
}





var json =  [{
    "title": "1. Lockdown Population by Loan (186006)",
    "children": [{
        "title": "1.1 Previous (191225)",
        "firstLevelSubNodes": [{
            "title": "1.1.1 Roll forward (178260)",
            "firstLevelSubNodes": [{
                "title": "1.1.1.1 Roll forward (178260)"
            }]
        }],
        "secondLevelSubNodes": [{
            "title": "1.2.1 Bounce forward (178260)",
            "firstLevelSubNodes": [{
                "title": "1.2.1.1 Dash forward (178260)",
                "firstLevelSubNodes": [{
                    "title": "1.2.1.1.1 Skip forward (178260)"
                }]
            }]
        }],
        "thirdLevelSubNodes": [],
        "fourthLevelSubNodes": [

        ]
    }]
}];

var newJson = formatJson(json)

edited Feb 21, 2018 at 19:14

answered Feb 21, 2018 at 19:06

Yftach

7525 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Yftach Over a year ago

btw, your json had some other validity issues with it, so i added a test one that works

CodeMan03 Over a year ago

Also I noticed the return newObj variable exists outside of the loop it was created in

CodeMan03 Over a year ago

your code works but it is putting an extra [] bracket right after the children node. Do you know why it's doing that? The JSON isn't formatted correctly. It looks like "children": [ [ { } ] ] when it should be "children": [ { } ]

Yftach Over a year ago

im not sure to what you are refereing to {"title":"1. Lockdown Population by Loan (186006)","children":[{"title":"1.1 Previous (191225)","children":[{"title":"1.1.1 Roll forward (178260)","children":[{"title":"1.1.1.1 Roll forward (178260)","children":[]}]},{"title":"1.2.1 Bounce forward (178260)","children":[{"title":"1.2.1.1 Dash forward (178260)","children":[{"title":"1.2.1.1.1 Skip forward (178260)","children":[]}]}]}]}]} this is what im getting, and the children is an array of objects not arrays as you are describing... can you give me an example?

Collectives™ on Stack Overflow

Quickest way to change key name in nested json?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related