在 JQuery、javascript 中解析 JSON 响应时出错

Question

我收到以下 JSON 响应，但某些索引包含“员工 ID”等空格。这就是为什么我无法解析它。谁能建议用 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]"
            }
        }
    ]
}

我的代码 -

 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);
        }
    });
}

Answer 1

解析没问题。

问题是访问由非字母数字字符组成的键..如空格、破折号等。

这些属性必须使用 [] 表示法处理，如

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

http://jsfiddle.net/h9sbn/

Answer 2

您不能执行fnalObj.Employee.Ext - 1。正确的方法是 fnalObj.Employee['Ext-1']。这里是 jsFiddle http://jsfiddle.net/naryad/VNXa5/1/

使用时fnalObj.Employee.Ext - 1，它被解析为 undefined - 1 ，进而返回您 NaN

相同适用于fnalObj.Employee.Mobile - 1

Answer 3

$.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.
});