Get Json values from string

Question

I have a json string like the below format. I would like to get the Table1.ActualDate value. How can i get this using jquery.

{
    "Table": [
        {
            "DisplayVoucherNumber": "A101239Z",
            "ActualDate": "08/07/2013",
            "AccountName": "shyamal",
            "Pcs": "50",
            "Weight": "500.000"
        }
    ],
    "Table1": [
        {
            "DisplayVoucherNumber": "R101249B",
            "ActualDate": "11/07/2013",
            "AccountName": "vipul",
            "NetWeight": "90.000",
            "Weight": "80.000",
            "Difference": "10.000"
        },
        {
            "DisplayVoucherNumber": "R101249B",
            "ActualDate": "11/07/2013",
            "AccountName": "vipul",
            "NetWeight": "500.000",
            "Weight": "100.000",
            "Difference": "400.000"
        }
    ]
}

if data refers to this object then data.Table1[0].ActualDate.. — Arun P Johny
– Arun P Johny, Commented Mar 6, 2014 at 6:14
var jObj = JSON.parse(jsonString);for(i=0;i<jObj.Table1.length;i++) { console.log(jObj.Table1[i].ActualDate); } — Purushotham
– Purushotham, Commented Mar 6, 2014 at 6:18

Rajaprabhu Aravindasamy · Accepted Answer · 2014-03-06 06:14:59Z

1

You have to parse that string to get a valid JSON object.

Try,

var xObj = JSON.parse(xString);
console.log(xObj.Table1[0].ActualDate);

where xString is the string variable contains your JSON string.

answered Mar 6, 2014 at 6:14

Rajaprabhu Aravindasamy

67.2k17 gold badges107 silver badges133 bronze badges

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

Comments

Anoop Joshi P · Accepted Answer · 2014-03-06 06:15:17Z

0

If it is a string, you should make it as a json object using

var data= jQuery.parseJSON(data);

After that can use it like.

 alert(data.Table1[0].ActualDate);

If it is an abject already, you dont have to use the jQuery.parseJSON() method

answered Mar 6, 2014 at 6:15

Anoop Joshi P

25.6k9 gold badges35 silver badges54 bronze badges

Comments

Praveen · Accepted Answer · 2014-03-06 06:20:32Z

0

Since your Table1 array may grow, I would suggest you to go for iteration like

var tab = JSON.parse("you object");
for (i = 0; i < tab["Table1"].length; i++) {
    console.log(tab["Table1"][i].AccountName);
}

answered Mar 6, 2014 at 6:20

Praveen

56.7k35 gold badges137 silver badges169 bronze badges

Comments

Purushotham · Accepted Answer · 2014-03-06 06:22:34Z

0

var jObj = JSON.parse(jsonString); // Converts the string to JSON object

if(jObj !== undefined && jObj.Table1 !== undefined) {
    for (i = 0; i < jObj.Table1.length; i++) {
        console.log(jObj.Table1[i].ActualDate); 
    }
}

answered Mar 6, 2014 at 6:22

Purushotham

3,80631 silver badges42 bronze badges

Comments

Felix · Accepted Answer · 2014-03-06 06:29:45Z

0

You can use:

$.each(json.Table1, function(x, contents) {
    alert(contents.ActualDate);
});

Fiddle Demo

answered Mar 6, 2014 at 6:29

Felix

38.2k8 gold badges46 silver badges56 bronze badges

Comments

code99 · Accepted Answer · 2014-03-06 06:39:40Z

        var json = {
            "Table": [
                {
                    "DisplayVoucherNumber": "A101239Z",
                    "ActualDate": "08/07/2013",
                    "AccountName": "shyamal",
                    "Pcs": "50",
                    "Weight": "500.000"
                }
            ],
            "Table1": [
                {
                    "DisplayVoucherNumber": "R101249B",
                    "ActualDate": "11/07/2013",
                    "AccountName": "vipul",
                    "NetWeight": "90.000",
                    "Weight": "80.000",
                    "Difference": "10.000"
                },
                {
                    "DisplayVoucherNumber": "R101249B",
                    "ActualDate": "13/08/2012",
                    "AccountName": "vipul",
                    "NetWeight": "500.000",
                    "Weight": "100.000",
                    "Difference": "400.000"
                }
            ]
        };


        for(var i=0; i<json.Table1.length; ++i) {
            alert(json.Table1[i].ActualDate)
        }

Collectives™ on Stack Overflow

Get Json values from string

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related