jQuery parsing of server JSON (String)

Question

I've been at this for a while and can't seem to nail it down, your help is much appreciated.

Challenge: Unable to identify how to properly use JQUERY to parse the following JSON (String?) response from the server:

{"d":"{\"NewDataSet\":{\"Table\":{\"EMPLOYEE_NO\":\"3605\",\"NAME\":\"Last, First\",\"STAFF\":\"CSR\",\"USERNAME\":\"lis\",\"PIN\":\"somepassword\"}}}"}

Tried: Many things, such as...

var dtObj = jQuery.parseJSON(data);
$.each(dtObj, function (i, val) {
.. do some stuff
});

Requirement: Need to get the EMPLOYEE_NO, NAME, STAFF, USERNAME, AND PING values.

Thanks!

Musa · Accepted Answer · 2012-10-17 00:21:24Z

1

Your JSON id nested, so you'll have to parse twice and the object that holds the data you want is some levels deep.

var Obj1 = jQuery.parseJSON(data);
var Obj2 = jQuery.parseJSON(Obj1.d);
var dtObj = Obj2.NewDataSet.Table;
// now you can use dtObj to access EMPLOYEE_NO, NAME, STAFF, USERNAME, AND PING properties.

jsFiddle

edited Oct 17, 2012 at 0:21

answered Oct 16, 2012 at 23:57

Musa

97.9k17 gold badges123 silver badges144 bronze badges

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

Comments

Tariqulazam · Accepted Answer · 2012-10-16 23:57:37Z

0

First make sure, your json is valid. Use this tool http://jsonlint.com/

var data={
    "d": {
        "NewDataSet": {
            "Table": {
                "EMPLOYEE_NO": "3605",
                "NAME": "Last,First",
                "STAFF": "CSR",
                "USERNAME": "lis",
                "PIN": "somepassword"
            }
        }
    }
};
alert(data.d.NewDataSet.Table.NAME);

http://jsfiddle.net/tariqulazam/rBfLw/

answered Oct 16, 2012 at 23:57

Tariqulazam

4,5831 gold badge38 silver badges44 bronze badges

Collectives™ on Stack Overflow

jQuery parsing of server JSON (String)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related