jQuery parseJSON Multidimensional-array

Question

I have PHP outputting a JSON multidimensional array as follows:

{"rates":[{"meter":"30","rate":"0.15060","ppd":"10.000"}]}

However, I keep getting an error when trying to decode it on the JavaSCript side of things.

Uncaught TypeError: Cannot read property 'length' of null

Here is the code below for the jQuery side of things:

success: function (result) {
    console.log(result);
    $.each($.parseJSON(result), function (item, value) {
        if (item == "rates") {
            $.each($.parseJSON(value), function (i, object) {
                console.log(i + "=" + object);
            });
        }

The 1st console log gives me the output I mentioned at the top, but for some reason i am not able to access the array as I thought I would.

Any help is greatly appreciated :)

I can spot some problems, but they don't explain the error. Is the callback of the first $.each even executed? — Felix Kling
– Felix Kling, Commented Dec 10, 2013 at 2:32
you should get an error saying Uncaught SyntaxError: Unexpected token o in the second parseJSON command.. can't explain the error you are getting — Arun P Johny
– Arun P Johny, Commented Dec 10, 2013 at 2:35

Lenny · Accepted Answer · 2013-12-10 02:41:22Z

12

You don't need to call parseJSON again on value. It's already an object

var result='{"rates":[{"meter":"30","rate":"0.15060","ppd":"10.000"}]}';
console.log(result);
$.each($.parseJSON(result), function (item, value) {
    if (item == "rates") {
        $.each(value, function (i, object) {
            $.each(object, function (subI, subObject) {
                console.log(subI + "=" + subObject);
            });
        });

    }
});

Also, incase you were wondering the error was happening because you were trying to call parseJSON on an object and parseJSON expects a string so it was returning null to the each function which was then trying to do a for loop based on null.length

edited Dec 10, 2013 at 2:41

answered Dec 10, 2013 at 2:33

Lenny

5,9872 gold badges21 silver badges27 bronze badges

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

6 Comments

Felix Kling Over a year ago

That's doesn't explain the error though. edit: Weird that I got a different error than the OP.

Seán McCabe Over a year ago

That fixed the error, but it isnt quite providing what I am after. I am now getting: "0=[object Object]"

Felix Kling Over a year ago

@SeánMcCabe: Well, that's because you are trying to convert an object to a string. This output is expected. The default string representation of an object is [object Object]. You could do console.log(i, object) instead.

Lenny Over a year ago

That is as expected. It's an array of objects. [] is an array containing 1 object {...}

Lenny Over a year ago

I just updated the code to include another each to output the individual values

|

Guffa · Accepted Answer · 2013-12-10 02:36:31Z

5

As you only want the content of one property, you don't need to loop through all the properties, so you don't need the nested loops. Just get the array and loop through it:

$.each($.parseJSON(result).rates, function (i, object) {
  console.log(i + "=" + object);
});

If you are using a method specifically for getting JSON, or if the content type is correctly set on the response, you shouldn't even parse the result, It's already parsed before the callback method is called:

$.each(result.rates, function (i, object) {
  console.log(i + "=" + object);
});

answered Dec 10, 2013 at 2:36

Guffa

703k111 gold badges760 silver badges1k bronze badges

Comments

Radim Köhler · Accepted Answer · 2014-01-30 07:02:19Z

1

The program shows how to read json and store data into textbox

$(document).ready(function(){

$.getJSON("Test.json",function(data){

         $.each(data,function(key,value){
             alert(data[key].attrib1name);
             alert(data[key].attrib2name); 
             $('input').val(data[key].enterpriseName);
             activities=data[key].activities;
             console.log(value);
         });
     });    


});

edited Jan 30, 2014 at 7:02

Radim Köhler

124k48 gold badges243 silver badges343 bronze badges

answered Jan 30, 2014 at 6:42

codefreaK

3,6627 gold badges37 silver badges66 bronze badges

Collectives™ on Stack Overflow

jQuery parseJSON Multidimensional-array

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related