constructing a json format in javascript with existing json structure

Question

I have a json structure in a variable say "data" which is like this

{
"SearchWithMasterDataDIdAndScandefinitionDAO": [
    {
        "dateDm_id": 20120602,
        "issueValue": "ELTDIWKZ",
        "scanName": "Company Stored as Person (Given Name)",
        "severityCode": 1,
        "severityName": "High",
        "totalDiscovered": 1
    },
    {
        "dateDm_id": 20120602,
        "issueValue": "LTDFPVOI",
        "scanName": "Company Stored as Person (Given Name)",
        "severityCode": 1,
        "severityName": "High",
        "totalDiscovered": 1
    },
    {
        "dateDm_id": 20121005,
        "issueValue": "LTDILWGY",
        "scanName": "Company Stored as Person (Given Name)",
        "severityCode": 1,
        "severityName": "High",
        "totalDiscovered": 1
    },
    {
        "dateDm_id": 20121005,
        "issueValue": "YMORCLTD",
        "scanName": "Company Stored as Person (Given Name)",
        "severityCode": 1,
        "severityName": "High",
        "totalDiscovered": 1
    }
]
}

Now i want to change this structure to something like this where datedm_id from each object becomes the root of new json structure with array as value New wanted structure :

{
"20120602": [
    {
        "issueValue": "ELTDIWKZ",
        "scanName": "Company Stored as Person (Given Name)",
        "severityCode": 1,
        "severityName": "High",
        "totalDiscovered": 1
    },
    {
        "issueValue": "LTDFPVOI",
        "scanName": "Company Stored as Person (Given Name)",
        "severityCode": 1,
        "severityName": "High",
        "totalDiscovered": 1
    }
],
"20121005": [
    {
        "issueValue": "YMORCLTD",
        "scanName": "Company Stored as Person (Given Name)",
        "severityCode": 1,
        "severityName": "High",
        "totalDiscovered": 1
    },
    {
        "issueValue": "COOPER",
        "scanName": "Company Stored as Person (Given Name)",
        "severityCode": 1,
        "severityName": "High",
        "totalDiscovered": 15
    }
]
}

please help me with this

Please note that this question has nothing whatsoever to do with JSON. Once you parsed the JSON you are working with regular JavaScript objects and arrays. So it looks like you are asking for how to create a new object and how to iterate over objects/arrays. Please see Access / process (nested) objects, arrays or JSON and the MDN JavaScript Guide - Working with Objects. — Felix Kling
– Felix Kling, Commented Jan 28, 2014 at 8:32
I dont have any problem in accessing the json structure, I just want to change the existing json structure to the modified one — Saurabh Sinha
– Saurabh Sinha, Commented Jan 28, 2014 at 8:34

jacquard · Accepted Answer · 2014-01-28 08:33:10Z

1

See the fiddle: http://jsfiddle.net/YVB2Y/

In summary you need to create an object inside the for loop.

var returnVar = {}
b.SearchWithMasterDataDIdAndScandefinitionDAO.forEach(function(item){
    var thisItem;
    if(returnVar[item.dateDm_id] == undefined){
        thisItem = [];
        returnVar[item.dateDm_id]  = thisItem;
    }
    else {
        thisItem = returnVar[item.dateDm_id];
    }

    var obj = {};

    obj.issueValue = item.issueValue;
    //and so on..

    thisItem.push(obj);

});

console.log(returnVar);

answered Jan 28, 2014 at 8:33

jacquard

1,3071 gold badge11 silver badges16 bronze badges

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

Comments

Alon Gubkin · Accepted Answer · 2014-01-28 08:41:42Z

0

underscore.js is perfect for dealing with complex data structures:

var json = { ... };
var result = _.groupBy(json['SearchWithMasterDataDIdAndScandefinitionDAO'], 
    function (iterator) {
        var key = iterator['dateDm_id'];
        delete iterator['dateDm_id'];

        return key;
    });

console.log(result);

edited Jan 28, 2014 at 8:41

answered Jan 28, 2014 at 8:36

Alon Gubkin

57.2k58 gold badges200 silver badges292 bronze badges

Collectives™ on Stack Overflow

constructing a json format in javascript with existing json structure

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related