How to get values of attributes from JSON using jQuery

Question

I am generating json from an xml file using the Newtonsoft dll. From the below how would I get the address details into a list(if there were more in the example) and write them to a dropdown list I have the following valid json (checked onjsonlint):

{
    "?xml": {
        "@version": "1.0",
        "@encoding": "utf-8"
    },
    "Root": {
        "Information": {
            "Error": {
                "ErrorNo": "0",
                "ErrorMsg": null
            },
            "Address": {
                "Address": [
                    {
                        "@AddressID": "14961943",
                        "@Sequence": "1",
                        "@Description": "Some Company Name, Some Building, 10 Some Street, Some County, Some City"
                    }            
                ]
            }
        }
    }
}

Rory McCrossan · Accepted Answer · 2012-05-03 13:30:57Z

1

Try this:

var json = // that object above
var addresses = json.Root.Information.Address.Address;

for (var i = 0; i < addresses.length; i++) {
    var $option = $("<option></option>").val(addresses[i]["@AddressID"]).text(addresses[i]["@Description"]);
    $("#mySelect").append($option);
}

Example fiddle

edited May 3, 2012 at 13:30

answered May 3, 2012 at 13:18

Rory McCrossan

338k41 gold badges322 silver badges353 bronze badges

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

2 Comments

user835440 Over a year ago

it is coming back undefined, I have set var json = data;

user835440 Over a year ago

additionally there are 9 things in the list being returned i just can not get at them.

Daniel Baulig · Accepted Answer · 2012-05-03 13:20:38Z

0

Solution without use of jQuery:

var select = document.getElementById('selectID');
var addresses = json.Root.Information.Address.Address;

for(var i = 0, l = addresses.length; i < l; i++) {
  var o = document.createElement('option');
  o.value = addresses[i]['@AddressID'];
  o.innerHTML = addresses[i]['@Description'];
  select.appendChild(o);
}

answered May 3, 2012 at 13:20

Daniel Baulig

11.1k7 gold badges47 silver badges45 bronze badges

Collectives™ on Stack Overflow

How to get values of attributes from JSON using jQuery

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related