Extract data from array of objects (Slightly complicated issue)

Question

I have an array of objects as follows.

Array[0-2]
   0: Object
           Name: 'Rick'
           City: 'Sunnyvale'
           FactorJSONMap: "{"Id":"234","Country":"USA"}"
   1: Object
           Name: 'Diana'
           City: 'Santa Clara'
           FactorJSONMap: "{"Id":"124","Country":"USA"}"
   2: Object
           Name: 'Thiago'
           City: 'New Jeresy'
           FactorJSONMap: "{"Id":"673","Country":"USA"}"

I am able to loop through the elements 'Name' and 'City' properly. However there is an element 'FactorJSONMap'. this is coming from database. I am not able to loop through this generally.

Can anyone please let me know if there is a way to convert above format of data into the below format.

Please note. The FactorJSONMap is dynamic and there can be different elements. here it has 'Id' and 'City' currently. It can have 'Id', 'City' and 'Sex'.

Is there a way i can pull above data and convert into this simple array of objects form.

Array[0-2]
   0: Object
           Name: 'Rick'
           City: 'Sunnyvale'
           Id: '234'
           Country:'USA'
   1: Object
           Name: 'Diana'
           City: 'Santa Clara'
           Id: '124'
           Country:'USA'
   2: Object
           Name: 'Thiago'
           City: 'New Jeresy'
           Id: '673'
           Country:'USA'

@AndrewLi- how do i parse when its already inside the array of objects ? — Rihana
– Rihana, Commented Jul 14, 2017 at 20:51
JSON.parse(array[0].FactorJSONMap) or when you're iterating over it, for example array.forEach(obj => { const map = JSON.parse(obj.FactorJSONMap) })? — Andrew Li
– Andrew Li, Commented Jul 14, 2017 at 20:52
but this will only be for FactorJSONMap.? how can i add this to the array of objects and then iterate all togetheR ? — Rihana
– Rihana, Commented Jul 14, 2017 at 20:58
I would think you need to flatten the object. Check this out for reference stackoverflow.com/questions/8750362/… — johnny_mac
– johnny_mac, Commented Jul 14, 2017 at 21:03

zfrisch · Accepted Answer · 2017-07-14 21:12:33Z

1

You can simply use the parse method of the JSON object to get the data within the FactorJSONMap into object format, then assign it to the parent object within the array. Once you've iterated through all Objects in the array, the returned Object Array will have all the nested properties listed within the first level.

https://jsfiddle.net/4h72h6b8/3/

function traverseData(data) {
  for(let data_obj of data) {
  Object.assign(data_obj, JSON.parse(data_obj.FactorJSONMap));
  delete data_obj.FactorJSONMap;
  }
  return data;
};

In the example you will see the result in the console log.

answered Jul 14, 2017 at 21:12

zfrisch

8,6901 gold badge26 silver badges39 bronze badges

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

2 Comments

Rihana Over a year ago

Can you also share knowledge about asign and delete function. i have never come across this in javascript. But this works well. thanks.

zfrisch Over a year ago

When you use Object.assign(target, object) - Properties in the target object will be overwritten by properties in the sources if they have the same key. Later sources' properties will similarly overwrite earlier ones. delete is simply a keyword that removes a property from an Object.

Collectives™ on Stack Overflow

Extract data from array of objects (Slightly complicated issue)

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related