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
– Pavan, Commented May 14, 2016 at 3:09

sampathsris · Accepted Answer · 2014-10-27 08:36:02Z

68

Be careful, d is the list.

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

edited Oct 27, 2014 at 8:36

sampathsris

22.4k12 gold badges74 silver badges102 bronze badges

answered Apr 29, 2009 at 2:06

Burcu Dogan

9,2234 gold badges36 silver badges34 bronze badges

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

2 Comments

Nick Over a year ago

Thanks.. but that doesn't return anything either.

Chad Grant Over a year ago

It should. That is correct. JavaScript is case sensitive. EmployeeName

veN · Accepted Answer · 2009-05-08 17:40:25Z

57

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

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

answered May 8, 2009 at 17:40

veN

4 Comments

Nick Over a year ago

Thank you. This is the conclusion I came to as well. Here is a great post that has the solution detailed. elegantcode.com/2009/05/04/jquery-ajax-with-class-arrays Hope this helps others.

seinecle Over a year ago

the link in the comment above is dead

kojow7 Over a year ago

the link in the comment above is undead

sodimel Over a year ago

the link in the comment above seems to redirect to linkedin

Cᴏʀʏ · Accepted Answer · 2009-04-29 12:07:02Z

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, 2009 at 12:07

answered Apr 29, 2009 at 2:07

Cᴏʀʏ

108k20 gold badges169 silver badges201 bronze badges

1 Comment

Nick Over a year ago

This gets me closer.. It still just alerts with [object Object],[object Object]....

bluish · Accepted Answer · 2012-02-20 12:46:07Z

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, 2012 at 12:46

bluish

27.5k28 gold badges126 silver badges185 bronze badges

answered Nov 18, 2010 at 9:56

redcrowe

1911 silver badge4 bronze badges

Comments

KyleFarris · Accepted Answer · 2009-04-30 14:00:24Z

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, 2009 at 14:00

answered Apr 29, 2009 at 14:53

KyleFarris

17.6k5 gold badges43 silver badges41 bronze badges

2 Comments

Nick Over a year ago

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 Over a year ago

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?

Anne · Accepted Answer · 2012-09-20 08:10:32Z

7

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

edited Sep 20, 2012 at 8:10

Anne

27.2k9 gold badges66 silver badges71 bronze badges

answered Sep 20, 2012 at 7:07

Denzil Sequeira

1293 silver badges7 bronze badges

1 Comment

Denzil Sequeira Over a year ago

here check the following link hope it helps encosia.com/never-worry-about-asp-net-ajaxs-d-again

Mogsdad · Accepted Answer · 2016-05-14 03:43:35Z

4

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.

edited May 14, 2016 at 3:43

Mogsdad

46k21 gold badges166 silver badges289 bronze badges

answered May 13, 2016 at 22:16

Sterling Diaz

3,8832 gold badges34 silver badges35 bronze badges

3 Comments

Sterling Diaz Over a year ago

How about that? I think now it's better explained.

Mogsdad Over a year ago

Better - without the yelling, as well. Good luck!

Will Sams Over a year ago

By the way, Sterling, your "someclass" is missing the close quote.

bluish · Accepted Answer · 2012-02-20 12:43:12Z

2

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"}}

edited Feb 20, 2012 at 12:43

bluish

27.5k28 gold badges126 silver badges185 bronze badges

answered Nov 23, 2010 at 10:21

ramonhimera

5065 silver badges4 bronze badges

Collectives™ on Stack Overflow

Loop through JSON object List

8 Answers 8

2 Comments

4 Comments

1 Comment

Comments

2 Comments

1 Comment

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

2 Comments

4 Comments

1 Comment

Comments

2 Comments

1 Comment

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related