Error in parsing the JSON response in JQuery, javascript

Question

I am getting following as the JSON response but some indexes are having spaces like 'Employee Id'. That's why I am unable to parse it. Can anyone suggest the way to parse it in JavaScript?

{
    "Employees": [
        {
            "Employee": {
                "Employee ID": "777",
                "Short Name": "abc",
                "First name": null,
                "Middle name": null,
                "Last name": null,
                "Designation": "Senior Engineer",
                "Ext-1": null,
                "Ext-2": null,
                "Mobile-1": null,
                "Mobile-2": null,
                "Email": "[email protected]"
            }
        },
        {
            "Employee": {
                "Employee ID": "888",
                "Short Name": "xyz",
                "First name": null,
                "Middle name": null,
                "Last name": null,
                "Designation": "Test Lead",
                "Ext-1": null,
                "Ext-2": null,
                "Mobile-1": null,
                "Mobile-2": null,
                "Email": "[email protected]"
            }
        }
    ]
}

My code -

 function GetContacts() {
    $.ajax({
        type: "GET",
        contentType: 'application/json; charset=utf-8',
        url: "http://. . . . . .",

        dataType: "json",
        success: function(data) {

            //alert(data.getString("Employee ID"));
            $.each(data, function(i, contactList) {

                alert('First Loop' + i);
                alert('First Loop' + contactList[0]);

                $.each(contactList, function(j, Contact) {
                    //alert('Second Loop'+Contact);
                    var fnalObj = Contact;
                    //alert(fnalObj);
                    //alert(fnalObj.["Employee"]["Employee ID"]);
                    //alert(Employees[j]["Employee"]["Email"]);
                    //alert(Employees[0]["Employee"]["Employee ID"]);
                    alert(fnalObj.Employee.Email);
                    alert(fnalObj.Employee.Designation);
                    alert(fnalObj.Employee.Ext - 1);
                    alert(fnalObj.Employee.Mobile - 1);
                });
            });
        },
        error: function(XMLHttpRequest, textStatus, errorThrown) {
            alert(errorThrown);
            alert(textStatus);
        }
    });
}

Keys with spaces are no problem for the parser. JSON.parse and jQuery's parser will just work fine. See jsfiddle.net/4jqQw ... so the question is what is your actual problem? — Felix Kling
– Felix Kling, Commented Oct 19, 2011 at 10:40
I think you can use Employees[0]["Employee"]["Employee ID"] instead of Employees[0].Employee.Employee ID(which is not correct) , but I'm not 100% sure — e-MEE
– e-MEE, Commented Oct 19, 2011 at 10:44
I put your JSON into jsonlint.com and it comes up as valid JSON, so a parser shouldn't be breaking on this. What parser are you using? Would you please paste code from your parsing attempt as well as the error you are getting? — Liam
– Liam, Commented Oct 19, 2011 at 10:46

Gabriele Petrioli · Accepted Answer · 2011-10-19 11:11:43Z

3

Parsing is fine.

The problem is accessing the keys which are made of non-alhpanumeric characters.. like spaces, dashes etc..

These properties must be handled with the [] notation like this

alert(fnalObj.Employee['Employee ID']);
alert(fnalObj.Employee['Ext-1']);

Demo at http://jsfiddle.net/h9sbn/

answered Oct 19, 2011 at 11:11

Gabriele Petrioli

197k35 gold badges275 silver badges331 bronze badges

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

Comments

Narendra Yadala · Accepted Answer · 2011-10-19 11:07:39Z

2

You cannot do fnalObj.Employee.Ext - 1. The correct way to do it would be fnalObj.Employee['Ext-1']. Here is the jsFiddle http://jsfiddle.net/naryad/VNXa5/1/

When using fnalObj.Employee.Ext - 1, it gets resolved to undefined - 1 which in turn returns you NaN

Same applies to fnalObj.Employee.Mobile - 1

answered Oct 19, 2011 at 11:07

Narendra Yadala

9,6641 gold badge31 silver badges44 bronze badges

Comments

Mike Thomsen · Accepted Answer · 2011-10-19 11:15:05Z

0

$.each(contactList, function(j, Contact) {
    //alert('Second Loop'+Contact);
    var fnalObj = Contact;
    $.each(finalObj, function (key, value) {
        var newKey = key.replace(/[\s]\-/g, '_');
        delete finalObj[key];
        finalObj[newKey] = value;
    });
    //revised alerts here.
});

answered Oct 19, 2011 at 11:15

Mike Thomsen

37.7k11 gold badges63 silver badges86 bronze badges

Collectives™ on Stack Overflow

Error in parsing the JSON response in JQuery, javascript

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related