Convert json data to javascript array - in multi-dimensional sense

Question

I have a json array say

{
   "People": {
       "Person": [
          {"FirstName": "John", "LastName": "Smith"}
          {"FirstName": "Joe", "LastName": "Bloggs"}
          {"FirstName": "Wendy", "LastName": "Deng"}
        ]
    }
}

And I want to convert this into a javascript array (something like this)

var persons = [ ["FirstName", "John", "LastName", "Smith"], ["FirstName", "Joe", "LastName", "Bloggs"], ["FirstName", "Wendy", "LastName": "Deng"] ];

How do I accomplish this? Hope my question makes sense and I realise the javascript array initialization may not be the correct way to put it.

Thanks.

Why would you want to do this? Why not just use the JSON as a JavaScript object? — Aesthete
– Aesthete, Commented Nov 28, 2012 at 11:05
Two reasons: 1. It's out of my curiosity if there's any good array-like data structures that I can use to perform data manipulation inside the json such as binary search, binary sort etc versus javascript object. 2. I'm still a JSON newbie. — awongCM
– awongCM, Commented Nov 28, 2012 at 11:18
First of all, JSON is a data interchange format, represented as a string. JSON format can be mapped directly to JavaScript types, including Object and Array. You question doesn't go into why you want to do this, and maybe that would help you to understand the uses of JSON and JavaScript objects. — Aesthete
– Aesthete, Commented Nov 28, 2012 at 11:24

Umesh Patil · Accepted Answer · 2012-11-28 11:07:52Z

1

jsfiddle demo: here

var src={
   "People": {
       "Person": [
          {"FirstName": "John", "LastName": "Smith"},
          {"FirstName": "Joe", "LastName": "Bloggs"},
          {"FirstName": "Wendy", "LastName": "Deng"}
        ]
    }
};

var persons=[];
var obj=src["People"]["Person"];
for(i in obj){
  var temp=[];
  temp.push("FirstName");
  temp.push(obj[i].FirstName);
  temp.push("LastName");
  temp.push(obj[i].LastName);
  persons.push(temp);
  }

// persons contain your requried array

edited Nov 28, 2012 at 11:07

answered Nov 28, 2012 at 11:01

Umesh Patil

10.7k16 gold badges56 silver badges81 bronze badges

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

2 Comments

awongCM Over a year ago

Thanks for that. I'll give it go and try it on my experimentation. Cheers!

Umesh Patil Over a year ago

@AW-GWTF899, Well ! json is such data structure that you can play around however you wish :)

Aesthete · Accepted Answer · 2012-11-28 11:49:32Z

1

What you're trying to do doesn't make alot of sense. Converting an existing valid JSON Object into the array format you specified is rather pointless, and will make accessing elements difficult.

Sounds like what you really want to do is this:

var data = JSON.parse(jsonString); // Your JSON, parsed into a JS object.
var persons = []
data.people.person.foEach( function(el) {
  person.push(el.FirstName + " " + el.LastName);
}

Now persons look like this:

["John Smith", "Joe Bloggs", "Wendy Deng"]

Are you sure you know how JSON and JavaScript objects work?

var myJSON = '{ "foo": { "bar": { "baz" : [1,2,3] } } }' // JSON, String type.
var myObj = JSON.parse(myJSON); // Now a JS Object type.
var innerArray = myObj.foo.bar.baz;

Now the value of variable innerArray is [1,2,3], an Array type.

console.log(innerArray[0]); // Log the first element.

> 1 // First element is 1

edited Nov 28, 2012 at 11:49

answered Nov 28, 2012 at 11:11

Aesthete

18.9k6 gold badges38 silver badges46 bronze badges

8 Comments

awongCM Over a year ago

Well, actually the example I provided above is a rough sketch which I just made up on the spot. The actual example I wanted is lot of more (and complex)data of json and I want to extract certain elements in json that I'm more interested in to put in another array.

Aesthete Over a year ago

@AW-GWTF899 - And is it your intention to store the keys as strings in the nested array as in your example? Because they will be the same for each object in the array, which seems a bit useless to me.

awongCM Over a year ago

{"responseData": "translatedText":"\u6211"},"responseDetails":"","responseStatus":200,"matches":[{"id":"175389268","segment":"I","translation":"\u6211","quality":"74","reference":"","usage-count":2,"subject":"Social_Science","created-by":"UN","last-updated-by":null,"create-date":"0000-00-00 00:00:00","last-update-date":"2010-11-13 15:05:19","match":1},{"id":"430922621","segment":"I.","translation":"I.","quality":"74","reference":"","usage-count":26,"subject":"All","created-by":"","last-updated-by":null,"create-date":"2012-08-17 13:09:06","last-update-date":"2012-08-17 13:09:06","match":1}}

awongCM Over a year ago

Here's my example json data. Basically what I want from this data is to pick the "matches"'s array elements store in another array as keys and i want to ignore the rest of the elements in the json data. Just the matches key part, if that makes sense..

Aesthete Over a year ago

@AW-GWTF899 - It isn't even valid JSON.

|

Collectives™ on Stack Overflow

Convert json data to javascript array - in multi-dimensional sense

2 Answers 2

2 Comments

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related