Make object key a value in the equivalent sub-object

Question

I have a complex object where the key of each object property should actually be a value. So, I am trying to convert this:

{
  "2019-04-24T00:00:00Z": {
    "one": 185,
  },
  "2019-04-25T00:00:00Z": {
    "one": 207,
  }
}

to this:

{
  {
    "date": "2019-04-24T00:00:00Z",
    "one": 185,
  },
  {
    "date": "2019-04-25T00:00:00Z",
    "one": 207,
  }
}

I have pasted a snippet with an attempt.

var obj2 = {"all":[{"branches":[{"branchname":"NAN","mains":[{"mainName":"FirstOne","plName":[{"metrics":{"2019-04-24T00:00:00Z":{"one":185,"two":143697,"three":126161,"four":3909,"five":0,"six":0.2304,"seven":30.72,"eight":13.333,"nine":1.165},"2019-04-25T00:00:00Z":{"one":207,"two":50819,"three":16428,"four":2820,"five":0,"six":0.329,"seven":57.166,"eight":15.442,"nine":1.422}}}]}]}]}]};

var json2 = jsonPath(obj2, "$.all..branches..mains..[*].plName[*].metrics.");

var found = Object.keys(json2).find(function(layerKey) {
  console.log(json2[layerKey]);
});

for (var i = 0; i<= Object.keys(json2).length; i++) {
  for (var prop in json2[i]) {
    console.log("Key:" + prop);
    //Add date as a value in the JSON
    //json2[i].map(i=>i.Date=prop);
    json2[i]["Date"] = prop;
  }
}

//json2.map(i=>i.Date=prop);
console.log(json2);

<script src="https://www.w3resource.com/JSON/jsonpath.js"></script>

"*I have a complex JSON string*" what you're showing is an object literal, not a string. — VLAZ, Jun 26 '19 at 14:32
that not a valid javascript output. do you want an array instead? — Daniel A. White, Jun 26 '19 at 14:36
@DanielA.White Yes. An array will be the output saved in a JSON file. — Datacrawler, Jun 26 '19 at 14:58
Question statement is misleading: I'm trying to convert this ... to this... may be perceived as expected result, while accepted answer context is slightly different. If long-term value of this question matters, I'd rephrase that — Yevhen Horbunkov, Jun 27 '19 at 11:27

score 2 · Accepted Answer · answered Jun 26 '19 at 14:51

You can try using nested map

var obj2 = {"all":[{"branches":[{"branchname":"NAN","mains":[{"mainName":"FirstOne","plName":[{"metrics":{"2019-04-24T00:00:00Z":{"one":185,"two":143697,"three":126161,"four":3909,"five":0,"six":0.2304,"seven":30.72,"eight":13.333,"nine":1.165},"2019-04-25T00:00:00Z":{"one":207,"two":50819,"three":16428,"four":2820,"five":0,"six":0.329,"seven":57.166,"eight":15.442,"nine":1.422}}}]}]}]}]};

var json2 = jsonPath(obj2, "$.all..branches..mains..[*].plName[*].metrics");

var result = json2.map(e =>
  Object.keys(e).map(m => Object.assign(e[m], {
    data: m
  }))
)

console.log(result)

<script src="https://www.w3resource.com/JSON/jsonpath.js"></script>

score 2 · Answer 2 · answered Jun 26 '19 at 14:54

You may want an array as output, because the output you provide is not a valid js object literal.

const obj = {"2019-04-24T00:00:00Z": {"one": 185,},"2019-04-25T00:00:00Z": {"one": 207,}};

const newArr = Object.keys(obj).map(item=>({...obj[item],date:item}));


console.log(newArr);

score 1 · Answer 3 · answered Jun 26 '19 at 14:41

1

Try this:

const a = {
  "2019-04-24T00:00:00Z": {
    "one": 185,
  },
  "2019-04-25T00:00:00Z": {
    "one": 207,
  }
}

const result = Object.keys(a).reduce((acc, ele)=> acc =  [...acc,{date: ele, one: a[ele].one}] ,[]);

console.log(result);

answered Jun 26 '19 at 14:41

Ghoul Ahmed

4,446
1
14
23

score 1 · Answer 4 · answered Jun 26 '19 at 14:50

There you go:

var example = {"2019-04-24T00:00:00Z": {"one": 185}, "2019-04-25T00:00:00Z": {"one": 207}}

var result = []
for (var key in example) {
    var objectCopy = JSON.parse(JSON.stringify(example[key]));
    objectCopy['date'] = key;
    result.push(objectCopy); 
}
console.log(result)

<script src="https://www.w3resource.com/JSON/jsonpath.js"></script>

Yevhen Horbunkov · Answer 5 · 2019-07-23T15:26:08.873

To me, Object.entries() is the most natural way to achieve your goal:

var obj2 = {"all":[{"branches":[{"branchname":"NAN","mains":[{"mainName":"FirstOne","plName":[{"metrics":{"2019-04-24T00:00:00Z":{"one":185,"two":143697,"three":126161,"four":3909,"five":0,"six":0.2304,"seven":30.72,"eight":13.333,"nine":1.165},"2019-04-25T00:00:00Z":{"one":207,"two":50819,"three":16428,"four":2820,"five":0,"six":0.329,"seven":57.166,"eight":15.442,"nine":1.422}}}]}]}]}]};

var json2 = jsonPath(obj2, "$.all..branches..mains..[*].plName[*].metrics.");

const res = json2.map(item => Object.entries(item).map(([date, obj]) => ({...obj,date})));

console.log(res);

.as-console-wrapper {min-height: 100%}

<script src="https://www.w3resource.com/JSON/jsonpath.js"></script>

Make object key a value in the equivalent sub-object

5 Answers5

Linked