Loop through JSON object List

Question

I am returning a List<> from a webservice as a List of JSON objects. I am trying to use a for loop to iterate through the list and grab the values out of the properties. This is a sample of the returning JSON:

{"d":[{"__type":"FluentWeb.DTO.EmployeeOrder",
 "EmployeeName":"Janet Leverling",
 "EmployeeTitle":"Sales Representative",
 "RequiredDate":"\/Date(839224800000)\/",
 "OrderedProducts":null}]}

So I am trying to extract the contents using something like this:

function PrintResults(result) {

for (var i = 0; i < result.length; i++) { 
    alert(result.employeename);
}

How should this be done?

IN Java, you need to map the Json into POJO. Once this done you can retrive any value. If its List then iterate(loop) it and get the json value through object — Pavan, May 14 '16 at 03:09

score 68 · Answer 1 · edited Oct 27 '14 at 08:36

68

Be careful, d is the list.

for (var i = 0; i < result.d.length; i++) { 
    alert(result.d[i].employeename);
}

edited Oct 27 '14 at 08:36

sampathsris

21,564
12
71
98

answered Apr 29 '09 at 02:06

Burcu Dogan

9,153
4
34
34

Thanks.. but that doesn't return anything either. – Nick Apr 29 '09 at 02:09
1

It should. That is correct. JavaScript is case sensitive. EmployeeName – Chad Grant Apr 29 '09 at 02:30

score 57 · Accepted Answer · answered May 08 '09 at 17:40

57

had same problem today, Your topic helped me so here goes solution ;)

 alert(result.d[0].EmployeeTitle);

answered May 08 '09 at 17:40

5

Thank you. This is the conclusion I came to as well. Here is a great post that has the solution detailed. http://elegantcode.com/2009/05/04/jquery-ajax-with-class-arrays/ Hope this helps others. – Nick May 10 '09 at 23:23
the link in the comment above is dead – seinecle Sep 09 '12 at 17:55
2

the link in the comment above is undead – kojow7 Apr 25 '16 at 22:05
the link in the comment above seems to redirect to linkedin – sodimel Dec 19 '19 at 19:17

Cᴏʀʏ · Answer 3 · 2009-04-29T12:07:02.863

22

It's close! Try this:

for (var prop in result) {
    if (result.hasOwnProperty(prop)) {
        alert(result[prop]);
    }
}

Update:

If your result is truly is an array of one object, then you might have to do this:

for (var prop in result[0]) {
    if (result[0].hasOwnProperty(prop)) {
        alert(result[0][prop]);
    }
}

Or if you want to loop through each result in the array if there are more, try:

for (var i = 0; i < results.length; i++) {
    for (var prop in result[i]) {
        if (result[i].hasOwnProperty(prop)) {
            alert(result[i][prop]);
        }
    }
}

edited Apr 29 '09 at 12:07

answered Apr 29 '09 at 02:07

Cᴏʀʏ

105,112
20
162
194

1

This gets me closer.. It still just alerts with [object Object],[object Object].... – Nick Apr 29 '09 at 02:12

score 17 · Answer 4 · edited Feb 20 '12 at 12:46

17

Here it is:

success: 
    function(data) {
        $.each(data, function(i, item){
            alert("Mine is " + i + "|" + item.title + "|" + item.key);
        });
    }

Sample JSON text:

{"title": "camp crowhouse", 
"key": "agtnZW90YWdkZXYyMXIKCxIEUG9zdBgUDA"}

edited Feb 20 '12 at 12:46

bluish

26,356
27
122
180

answered Nov 18 '10 at 09:56

redcrowe

191
1
4

KyleFarris · Answer 5 · 2009-04-30T14:00:24.110

9

Since you are using jQuery, you might as well use the each method... Also, it seems like everything is a value of the property 'd' in this JS Object [Notation].

$.each(result.d,function(i) {
    // In case there are several values in the array 'd'
    $.each(this,function(j) {
        // Apparently doesn't work...
        alert(this.EmployeeName);
        // What about this?
        alert(result.d[i][j]['EmployeeName']);
        // Or this?
        alert(result.d[i][j].EmployeeName);
    });
});

That should work. if not, then maybe you can give us a longer example of the JSON.

Edit: If none of this stuff works then I'm starting to think there might be something wrong with the syntax of your JSON.

edited Apr 30 '09 at 14:00

answered Apr 29 '09 at 14:53

KyleFarris

17,274
5
40
40

I found the solution the hard way (not JQuery). I will try this out asap. I'd rather do it your way. I'll make sure to post the solution. – Nick Apr 29 '09 at 22:56
So this very, very close. Now i am looping through the array of objects. In FireBug I can see the values in the properties but the alert just returns "Undefined". How can I get the string, dates, etc out of the properties? – Nick Apr 30 '09 at 01:16

score 7 · Answer 6 · edited Sep 20 '12 at 08:10

7

var d = $.parseJSON(result.d);
for(var i =0;i<d.length;i++){
    alert(d[i].EmployeeName);
}

edited Sep 20 '12 at 08:10

Anne

26,765
9
65
71

answered Sep 20 '12 at 07:07

Denzil Sequeira

129
3
7

here check the following link hope it helps http://encosia.com/never-worry-about-asp-net-ajaxs-d-again/ – Denzil Sequeira Sep 24 '12 at 18:26

score 4 · Answer 7 · edited May 14 '16 at 03:43

This will work!

$(document).ready(function ()
    {
        $.ajax(
            {
            type: 'POST',
            url: "/Home/MethodName",
            success: function (data) {
                //data is the string that the method returns in a json format, but in string
                var jsonData = JSON.parse(data); //This converts the string to json

                for (var i = 0; i < jsonData.length; i++) //The json object has lenght
                {
                    var object = jsonData[i]; //You are in the current object
                    $('#olListId').append('<li class="someclass>' + object.Atributte  + '</li>'); //now you access the property.

                }

                /* JSON EXAMPLE
                [{ "Atributte": "value" }, 
                { "Atributte": "value" }, 
                { "Atributte": "value" }]
                */
            }
        });
    });

The main thing about this is using the property exactly the same as the attribute of the JSON key-value pair.

By the way, Sterling, your "someclass" is missing the close quote. — Will Sams, Nov 08 '19 at 20:37

score 2 · Answer 8 · edited Feb 20 '12 at 12:43

I have the following call:

$('#select_box_id').change(function() {
        var action = $('#my_form').attr('action');
    $.get(action,{},function(response){
        $.each(response.result,function(i) {

            alert("key is: " + i + ", val is: " + response.result[i]);

        });
    }, 'json');
    });

The structure coming back from the server look like:

{"result":{"1":"waterskiing","2":"canoeing","18":"windsurfing"}}

Loop through JSON object List

8 Answers8

Linked