change the json structure after getting data

Question

I am getting a json data having structure

{
    SearchDAO: [
        {
            PERSONADDRESS_H_ADDRESS_LINE_ONE: "599 Waterloo place",
            PERSON_H_BIRTHDATE_VALUE: "1939-01-11 00:00:00",
            PERSON_H_CREATE_TS: "2012-11-22 11:17:13.879",
            PERSON_H_GENDER_CD: "M"
        }
    ]
}

As you can see in the data set two type of keys are there 1. starting with "PERSONADDRESS" 2. starting with "PERSON"

I have to convert this structure to

{
    "PERSON":[
         {
             H_BIRTHDATE_VALUE: "1939-01-11 00:00:00",
             H_CREATE_TS: "2012-11-22 11:17:13.879",
             H_GENDER_CD: "M"
         }
    ],
    "PERSONADDRESS":[
         {
             H_ADDRESS_LINE_ONE: "599 Waterloo place"
         }
    ]

I am struggling to do this. As It need to splice key string and change the structure

Please help

I am trying something like this

 $.each(data.SearchDAO[0], function(k, v) {
                               var streetaddress= k.substr(0, k.indexOf('_'));
                               console.log(streetaddress)
                               if(returnVar[streetaddress] == undefined){
                                   thisItem = [];
                                   returnVar[streetaddress]  = thisItem;
                               }
                               else {
                                   thisItem = returnVar[streetaddress];
                               }
                               var obj = {};
                               obj.issueValue = v;
                               thisItem.push(obj);
                           });
 console.log(thisItem)

why have the objects got a 1 length array with an object as the value? `var birthday = object.person[0]H_BIRTHDATE_VALUE;` why not just `var birthday = person.birthday;` — manta, Feb 13 '14 at 10:44
Note that [JS object literals and JSON](http://benalman.com/news/2010/03/theres-no-such-thing-as-a-json/) aren't quite the same thing. — outis, Feb 13 '14 at 10:44
Have you had a look at this post? http://stackoverflow.com/questions/4538269/adding-removing-items-from-json-data-with-jquery — mparkuk, Feb 13 '14 at 10:57

score 0 · Answer 1 · answered Feb 13 '14 at 11:27

I solved the problem

here is my code

   returnVar={};

$.each(data.SearchDAO[0], function(k, v) {
                               var streetaddress= k.substr(0, k.indexOf('_'));
                               var keyFinal= k.substr(k.indexOf('_')+1,k.length-1);
                               console.log(keyFinal)
                               if(returnVar[streetaddress] == undefined){
                                    thisItem = {};
                                    returnVar[streetaddress]  = thisItem;
                                    thisItem[keyFinal]=v;
                                }
                               else {
                                    thisItem = returnVar[streetaddress];
                                    thisItem[keyFinal]=v;
                                }

                            });
                          console.log(returnVar)

Rob Lokhorst · Answer 2 · 2014-02-13T12:34:01.717

This should do it (for multiple persons as well):

var json = {
    SearchDAO: [
        {
            PERSONADDRESS_H_ADDRESS_LINE_ONE: "599 Waterloo place",
            PERSON_H_BIRTHDATE_VALUE: "1939-01-11 00:00:00",
            PERSON_H_CREATE_TS: "2012-11-22 11:17:13.879",
            PERSON_H_GENDER_CD: "M"
        },
        {
            PERSONADDRESS_H_ADDRESS_LINE_ONE: "123 Place",
            PERSON_H_BIRTHDATE_VALUE: "1901-01-01 00:00:00",
            PERSON_H_CREATE_TS: "2001-01-01 00:00:00.000",
            PERSON_H_GENDER_CD: "F"
        }
    ]
}

var converted = {};
for (var i = 0; i < json.SearchDAO.length; i++)
{
    var row = json.SearchDAO[i];
    var keys = Object.keys(row);
    for (var j = 0; j < keys.length; j++)
    {
        var key = keys[j];
        var key_prefix = key.substr(0, key.indexOf('_'));
        var key_suffix = key.substr(key.indexOf('_') + 1);

        if (!(key_prefix in converted))    converted[key_prefix] = [];
        if (!(i in converted[key_prefix])) converted[key_prefix][i] = {};

        converted[key_prefix][i][key_suffix] = row[key_prefix + "_" + key_suffix];
    }
}

change the json structure after getting data

2 Answers2