Retrieve array from multidimension arrays in JSON

Question

Following is my JSON output :

{
    "BILLINGINFO": [
        {
            "CUST_REQ_BILL_DATE": "15",
            "BILL_MONTH": "03",
            "CONSOLIDATION_CRITERIA": "016",
            "CONSOLIDATION_OPTION": "A",
            "SPLIT_LINES": "",
            "BILL_IN_ARREARS": "X",
            "BILL_CREATE_DATE": "02"
        }
    ],
    "DROPDOWNS": [
        {
            "FIELD": "CUST_REQ_BILL_DATE",
            "VALUE": "01",
            "TEXT": "1st of month"
        },
        {
            "FIELD": "CUST_REQ_BILL_DATE",
            "VALUE": "02",
            "TEXT": "2nd of month"
        }
   ]
}

I am still learming jquery and not sure how to retrive values of BILLINGINFO and DROPDOWN arrays.

Community · Accepted Answer · 2017-05-23 12:18:55Z

3

Say this JSON is stored in a variable called obj. Then you'd use:

obj.BILLINGINFO
// and
obj.DROPDOWNS

or:

obj["BILLINGINFO"]
obj["DROPDOWNS"]

Reference: JavaScript property access: dot notation vs. brackets?

To loop through them, you can use something like the following (need to apply to each):

for (var i = 0; i < obj.BILLINGINFO.length; i++) {
    var current = obj.BILLINGINFO[i];
    // Work with `current` and you can use
    // current.CUST_REQ_BILL_DATE, current.BILL_MONTH, etc.
}

So there's no need to use jQuery for any of this. But an option for looping is using each: http://api.jquery.com/jQuery.each/

edited May 23, 2017 at 12:18

CommunityBot

11 silver badge

answered Apr 22, 2013 at 17:58

Ian

51k13 gold badges104 silver badges111 bronze badges

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

6 Comments

mellamokb Over a year ago

+1 Also, you can use obj['BILLINGINFO'] and obj['DROPDOWN'].

Ian Over a year ago

@mellamokb True, but stackoverflow.com/questions/4968406/… . I'll still add it in

user1596433 Over a year ago

Actually, the dropdown array is meant for combobox values and I need to loop thru it. I am using this but it gives "cannot read property 'length' of undefined" error : $.each(data.dropdowns, function(index) { $('#conscrit').append('<option>' + data.dropdowns[index].TEXT + '</option>'); });

Ian Over a year ago

@user1596433 Why are you using data.dropdowns? It should be data.DROPDOWNS

user1596433 Over a year ago

Thank You Ian, that was the issue. I was so dumb to not to notice that.

|

chandresh_cool · Accepted Answer · 2013-04-22 17:57:49Z

1

You can use

$.parseJson

function to parse it

answered Apr 22, 2013 at 17:57

chandresh_cool

11.9k3 gold badges32 silver badges46 bronze badges

2 Comments

user400654 Over a year ago

@hop We have no way of knowing whether or not that is parsed yet due to lack of information.

hop Over a year ago

@KevinB Fine.But, does this answer the question

Collectives™ on Stack Overflow

Retrieve array from multidimension arrays in JSON

2 Answers 2

6 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related