JSON to array - How to parse for such a structure?

Question

My JSON object has the following structure :

{ key :
[
{keya1:value1,
keya2:value2,
keya3:[value31,value32...]
keya4:value4
},
{keyb1:value1,
keyb2:value2,
keyb3:[value31,value32...]
keyb4:value4
},
...
..
{keys1:value1,
keys2:value2,
keys3:[value31,value32...]
keys4:value4
}
]
}

I tried using a simple json.parse but it doesnt work. With such a structure how should i go about parsing so that i can safely iterate over each instances of key and display all keya-valuea,keyb-valueb.. pairs for values of key? Many thanks!

EDIT : I actually omitted quotes on purpose. The original JSON data HAS quotes around keys and values.Sorry i didnt mention it earlier.

Your actually better off getting this data structure to be properly json formatted. It will make it much easier on your part! Can you explain how the data is being generated? — Undefined
– Undefined, Commented Jan 16, 2013 at 8:32

spathirana · Accepted Answer · 2013-01-16 08:29:15Z

2

Try using getJsonArray

JSONObject json = (JSONObject) JSONSerializer.toJSON(response);

JSONArray array= json.getJSONArray("key");

or getString("key"); where applicable

answered Jan 16, 2013 at 8:29

spathirana

1551 silver badge10 bronze badges

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

3 Comments

Undefined Over a year ago

I'm afraid this wouldn't work because the data is not formatted like JSON. Mainly the issue is that there is no double quotes around any of the strings.

Eric Over a year ago

Pretty sure the OP is using javascript

Undefined Over a year ago

Also the OP asked for JavaScript.

Anton · Accepted Answer · 2013-01-16 08:43:42Z

0

Your JSON is invalid, you need the double quotes and comma after your array, when you have a correct JSON you could use JSON.parse

{ "key" :
        [{
          "keya1":"value1",
          "keya2":"value2",
          "keya3":["value31","value32..."],
          "keya4":"value4"
         },
         {
          "keyb1":"value1",
          "keyb2":"value2",
          "keyb3":["value31","value32..."],
          "keyb4":"value4"
         },
         {
          "keys1":"value1",
          "keys2":"value2",
          "keys3":["value31","value32..."],
          "keys4":"value4"
         }
    ]
}

answered Jan 16, 2013 at 8:43

Anton

32.6k5 gold badges47 silver badges54 bronze badges

Comments

Ruslan Polutsygan · Accepted Answer · 2013-01-16 08:53:42Z

0

try to quote each key and value:

var str = '{ key : \
    [ \
        {\
            keya1:value1, \
            keya2:value2, \
            keya3:[value31,value32], \
            keya4:value4 \
        }, \
        {\
            keyb1:value1, \
            keyb2:value2, \
            keyb3:[value31,value32], \
            keyb4:value4 \
        }, \
        {\
            keys1:value1, \
            keys2:value2, \
            keys3:[value31,value32], \
            keys4:value4 \
        } \
    ] \
}';

var pattern=/(\w+\d*)/ig;
var json=str.replace(pattern, '"$1"');
var parsedJSON=JSON.parse(json)
console.log(parsedJSON);

I hope this helps.

answered Jan 16, 2013 at 8:53

Ruslan Polutsygan

4,4612 gold badges28 silver badges38 bronze badges

Collectives™ on Stack Overflow

JSON to array - How to parse for such a structure?

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related