Loop through a JSON file with jquery

Question

I'm trying to loop through some JSON that has some nested data. The JSON structure is such:

var data =[
{"otherdata":"tons of other data",
 "studentlist":{
             "user":{
                     "first":"john",
                     "last":"doe",
                     "status":"good", 
                     "id":"100404"
              }, 
            "user":{
                   "first":"jane",
                   "last":"doe",
                   "status":"bad", 
                   "id":"100405"
             }
}];

I'm trying to loop through "data", but more importantly, I need to loop through each user. However using jquery's .each(), but it either fails or shows an error for .length. When I'm tracing out in my console.

var student = data.studentlist;
$.each(student, function(i, item){
   console.log('student: ' + student.user[i].id);
});

you're not looping through json. json is a text-encoding of a javascript data structure. you're looping through a javascript structure, and it's a JS structure like any other. just because it used to be json is irrelevant. consider JS the wrapping paper your christmas present came in. — Marc B
– Marc B, Commented Sep 10, 2015 at 18:14

imtheman · Accepted Answer · 2015-09-10 18:20:41Z

1

You have your data in an array or objects you need to access it like so:

data[0].studentlist

Or just remove [] from around the data then you can access it like this:

data.studentlist

Also there are other problems with your data structure i.e. you cannot have 2 "user" keys you would need to make that an array objects. This is what I believe you want your structure to look like:

var data = {
"otherdata":"tons of other data",
    "studentlist":{
         "user":[
                 {
                    "first":"john",
                    "last":"doe",
                    "status":"good", 
                    "id":"100404"
                 }, 
                 {
                    "first":"jane",
                    "last":"doe",
                    "status":"bad", 
                    "id":"100405"
                 }
                ]
    }
};

edited Sep 10, 2015 at 18:20

answered Sep 10, 2015 at 18:12

imtheman

4,8631 gold badge32 silver badges31 bronze badges

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

Comments

user1012181 · Accepted Answer · 2015-09-10 18:14:13Z

0

Loop through each user:

var length = data[0].studentlist.length;
for(i=0; i<length; i++)
   data[0].studentlist[i];
});

answered Sep 10, 2015 at 18:14

user1012181

8,72611 gold badges74 silver badges110 bronze badges

Comments

alcfeoh · Accepted Answer · 2015-09-10 18:15:27Z

0

Here is how I would do it:

for (var i in data[0].studentlist){
  var user = data[0].studentlist[i];
  console.log('student: ' + user.id);
}

answered Sep 10, 2015 at 18:15

alcfeoh

2,2871 gold badge20 silver badges35 bronze badges

Comments

Qullbrune · Accepted Answer · 2015-09-10 18:34:23Z

0

Using your code, it should work like this:

var student = data[0].studentlist;
$.each(student, function(i, item){
  console.log('student: ' + item);
});

You might recheck the jquery-each documentation.

answered Sep 10, 2015 at 18:34

Qullbrune

1,9452 gold badges20 silver badges20 bronze badges

Collectives™ on Stack Overflow

Loop through a JSON file with jquery

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related