ajax: extract json object from array of json

Question

JSON (inside array from api):

[{"id":"001", "name":"john", "age":"40"}, {"id":"002", "name":"jane", "age":"30"}]

Ajax:

  $.ajax({                                      
  url: 'interface_API.php',                                                              
  dataType: 'json',                    
  success: function(data)         
  {
    for(var i in data){
        var row = data[i];

        var id = row[0];            
        var name = row[1];
        var age = row[2];

    $('#output').append("<tr width='50%'><td>"+id+"</td><td>"+name+"</td><td>"+age+"</td></tr>"); 
    }
  } 
});

The API uses this to construct:

if(mysqli_num_rows($output)){
     while($row = mysqli_fetch_assoc($output)){
         $json[] = $row;
     }
}

However my Output is 'undefined' repeated for each .append

How do i extract each json object from the array & append to the page?

Have you tried using console.log to see what data actually contains? — Jonathon
– Jonathon, Commented Jul 21, 2014 at 9:14
You should be using a regular for loop for an array, and to access the objects properties you'd do row.id etc. not row[0]. — adeneo
– adeneo, Commented Jul 21, 2014 at 9:15

Jai · Accepted Answer · 2014-07-21 09:16:31Z

1

change this:

var id = row[0];            
var name = row[1];
var age = row[2];

to this:

var id = row['id'];            
var name = row['name'];
var age = row['age'];

or this:

var id = row.id;
var name = row.name;
var age = row.age;

Because you already looped in here:

for(var i in data){
    var row = data[i]; // <----here

so you just required to reference it with keys in the js object.

answered Jul 21, 2014 at 9:16

Jai

74.8k12 gold badges77 silver badges104 bronze badges

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

1 Comment

Simon. Over a year ago

i will accept this answer after the timeout as you were first to answer. thank you

V31 · Accepted Answer · 2014-07-21 09:17:36Z

0

You can change the for loop like this:

$.ajax({                                      
  url: 'interface_API.php',                                                              
  dataType: 'json',                    
  success: function(data)         
  {
    for(var i in data){
        var row = data[i];

        var id = row.id;            
        var name = row.name;
        var age = row.age;

$('#output').append("<tr width='50%'><td>"+id+"</td><td>"+name+"</td><td>"+age+"</td></tr>"); 
}
} 
});

answered Jul 21, 2014 at 9:17

V31

7,6643 gold badges28 silver badges44 bronze badges

Comments

SitecoreNoob · Accepted Answer · 2014-07-21 09:19:21Z

0

please use the key to identify the json Object while retrieving

var list=[
        {"id":"1","text":"test1"},
        {"id":"2","text":"test2"},
        {"id":"3","text":"test3"},
        {"id":"4","text":"test4"}

         ]


    alert(list[2].id)

answered Jul 21, 2014 at 9:19

SitecoreNoob

3111 gold badge3 silver badges12 bronze badges

Collectives™ on Stack Overflow

ajax: extract json object from array of json

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related