How can I dynamically remove a parent in JSON with JS?

Question

With some JavaScript, how can I transform a JSON from:

{
  "d": {
    "__count": "13",
    "results": [
      {
        "__metadata": {
          "id": "123"
        },
        "COAST": "East",
        "STATUS": "done",
        "COLOR": "blue",
      }
]
}
}

TO

{
    "__count": "13",
    "data": [
      {
        "__metadata": {
          "id": "123"
        },
        "COAST": "East",
        "STATUS": "done",
        "COLOR": "blue",
      }
]
}

Basically removing the extra "d" parent and renaming results to data? I am using this in the context of vue-table in VueJS.

danin · Accepted Answer · 2020-05-15T21:58:50.243

2

Assumed that you have the json saved in a variable 'data':

data = data.d
data.data = data.results
delete data.results

edited May 15 '20 at 21:58

answered May 15 '20 at 21:46

danin

106
4

score 0 · Answer 2 · answered May 15 '20 at 21:46

0

This function will do it.

function transform(json) {
  var obj = JSON.parse(json);
  obj.d.data = obj.d.result;
  delete obj.d.result;
  return JSON.stringify(obj.d);
}

answered May 15 '20 at 21:46

Rediska

1,392
10
14

1

The parsing and re-stringifying seems unnecessary? (Especially since it's an object, not JSON.) – Dave Newton May 15 '20 at 21:48
json is text, not a javascript object – Rediska May 15 '20 at 21:49

score 0 · Answer 3 · answered May 15 '20 at 21:47

0

One solution is to unserialize your JSON to have an object (JSON.parse()). Then to serialize only what you need (JSON.stringify()).

answered May 15 '20 at 21:47

Rémi Fongaufier

51
1
7

score -1 · Answer 4 · answered May 15 '20 at 21:48

-1

You can use a loop.

var res = [];
for(var k in jsonData){
    res.push(jsonData[k]);
}

var jsonData = {
  "d": {
    "__count": "13",
    "results": [
      {
        "__metadata": {
          "id": "123"
        },
        "COAST": "East",
        "STATUS": "done",
        "COLOR": "blue",
      }
]
}
};

console.log(jsonData);

var res = [];
for(var k in jsonData){
    res.push(jsonData[k]);
}
console.log("result:");
console.log(res);

answered May 15 '20 at 21:48

Onurgule

707
8
21

Why? You're creating an array (not asked for) and not creating a `data` key. – Dave Newton May 15 '20 at 21:52
@DaveNewton I assumed that's not a single node. – Onurgule May 15 '20 at 21:56
Why? Either way, still missing 1/2 of the question :) – Dave Newton May 15 '20 at 21:57

How can I dynamically remove a parent in JSON with JS?

4 Answers4