Change JSON string structure

Question

I have a JSON string which looks like this:

[
    {
        "queryResult": {
            "A": "12-04-2014",
            "B": 1
        }
    },
    {
        "queryResult": {
            "A": "13-04-2014",
            "B": 2
        }
    },
    {
        "queryResult": {
            "A": "14-04-2014",
            "B": 3
        }
    }
]

And I need to parse it and change it to this

[
    {
        "A": "12-04-2014",
        "B": 1
    },
    {
        "A": "13-04-2014",
        "B": 2
    },
    {
        "A": "14-04-2014",
        "B": 3
    }
]

I already have a function for making that change, which is:

function justAnExample() {
    var jsonData = exampleJSON(); //Obtains the JSON
    var finalJSON=JSON.stringify(jsonData[0]['queryResult']);
    for (var i = 1; i < jsonData.length; i++) {
        finalJSON = finalJSON+','+JSON.stringify(jsonData[i]['queryResult']);
    }
    return JSON.parse('[' + finalJSON + ']');
}

But, this method uses stringifying and then parsing JSON to recreate the JSON object, which works, but is there a better solution, in which I can work with the object notation itself.

P.S: I know the term "JSON object" is a semi-pseudo thing, and that only the JSON notation/format matters, but, just need to confirm if this is the proper way to do it.

Edit

Please find a JS fiddle for the problem

http://jsfiddle.net/mukilr/uJV54/

Does your "JSON string" look exactly like you have shown?

thefourtheye
– thefourtheye

2014-05-21 06:45:40 +00:00
Commented May 21, 2014 at 6:45 — thefourtheye
– thefourtheye, Commented May 21, 2014 at 6:45
Yes, this is the exact representation.

Mkl Rjv
– Mkl Rjv

2014-05-21 06:46:52 +00:00
Commented May 21, 2014 at 6:46 — Mkl Rjv
– Mkl Rjv, Commented May 21, 2014 at 6:46
Can you please create a jsfiddle with that exact string?

thefourtheye
– thefourtheye

2014-05-21 06:47:39 +00:00
Commented May 21, 2014 at 6:47 — thefourtheye
– thefourtheye, Commented May 21, 2014 at 6:47
jsfiddle.net/mukilr/uJV54

Mkl Rjv
– Mkl Rjv

2014-05-21 06:54:01 +00:00
Commented May 21, 2014 at 6:54 — Mkl Rjv
– Mkl Rjv, Commented May 21, 2014 at 6:54
@thefourtheye The fiddle is done

Mkl Rjv
– Mkl Rjv

2014-05-21 06:54:49 +00:00
Commented May 21, 2014 at 6:54 — Mkl Rjv
– Mkl Rjv, Commented May 21, 2014 at 6:54

Totò · Accepted Answer · 2014-05-21 07:01:48Z

2

You can do:

var json = [
    {
        "queryResult": {
            "A": "12-04-2014",
            "B": 1
        }
    },
    {
        "queryResult": {
            "A": "13-04-2014",
            "B": 2
        }
    },
    {
        "queryResult": {
            "A": "14-04-2014",
            "B": 3
        }
    }
];

var out = [];


for (var i = 0; i < json.length; i++){
out[i] = json[i].queryResult;
}

check this fiddle

EDIT This is your fiddle updated

edited May 21, 2014 at 7:01

answered May 21, 2014 at 6:53

Totò

1,85415 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Change JSON string structure

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related