Retrieve content from JSON nested array

Question

I have a JSON response that looks like this

[
    {
        "alias": "Server1", 
        "hostgroup_worst_service_state": "0", 
        "status_history": {
            "status": [
                "0", 
                "2", 
                "0", 
                "0"
            ]
        }
    }, 
    {
        "alias": "Server2", 
        "hostgroup_worst_service_state": "0", 
        "status_history": {
            "status": [
                "0", 
                "0", 
                "0", 
                "0"
            ]
        }
    }, 
    {
        "alias": "Server3", 
        "hostgroup_worst_service_state": "0", 
        "status_history": {
            "status": [
                "1", 
                "1", 
                "1", 
                "0"
            ]
        }
    }
]

I can easily access the alias and hostgroup_worst_state using the .each iterator function:

 $.each(data, function(i, item) {
   console.log(item.alias)
   console.log(item.hostgroup_worst_service_state)
}

However I struggle to have access to the status data. I would need to display them this way:

["0","2","0","0"]
["0","0","0","0"]
["1","1","1","1"]

These value will next be used to display graphs using jQuery Sparklines.

Thanks for your help,

Hum. Did you look at the many related questions ? If so, what's the problem ? — Denys Séguret
– Denys Séguret, Commented Sep 11, 2012 at 14:11

João Silva · Accepted Answer · 2012-09-11 14:29:39Z

3

You have an array of objects, where each object has a property called status_history, which points to another object that has a property called status, which contains your required array. Thus, to access this array, use the following:

$.each(data, function () { 
  console.log(this.status_history.status); 
});

Note that this inside .each() refers to each object/value you iterate. It's the equivalent of using the following:

$.each(data, function (i, item) { 
  console.log(item.status_history.status); 
});

Also, if you want an array of arrays with the given status data, you could use $.map():

var arr = $.map(data, function (el) { 
  return [ el.status_history.status ];
});

edited Sep 11, 2012 at 14:29

answered Sep 11, 2012 at 14:12

João Silva

91.8k29 gold badges156 silver badges158 bronze badges

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

1 Comment

Moustache Over a year ago

Hi guys, Thanks. I was on the right way but my error was somewhere else. However thumbs up for the explanation. It cleared my doubts and solve my problem to some extend.

avladov · Accepted Answer · 2012-09-11 14:15:21Z

1

Result will contain the required arrays.

var result = [];

for(var i = 0; i < data.length; i++) {
    result.push(data[i].status_history.status);
}

answered Sep 11, 2012 at 14:15

avladov

8514 silver badges12 bronze badges

Comments

Patriks · Accepted Answer · 2012-09-11 14:16:12Z

0

take your data to an element , say data then

for(i=0;i<data.length;i++)
{
 console.log(data.status_history.status);
}

answered Sep 11, 2012 at 14:16

Patriks

1,0101 gold badge9 silver badges29 bronze badges

Collectives™ on Stack Overflow

Retrieve content from JSON nested array

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