Json parsing with jquery

Question

I have a json file that looks like this:

{
    "status": 200,
    "data": {
        "employeeId": "515552",
        "firstName": "Name",
        "lastName": "LastName",
        "locationName": "Location Name",
        "businessUnitName": "Unit",
        "workPhone": "212/465-5555",
        "cellPhone": "646/261-5555",
        "faxNumber": "",
        "assistant": "",
        "email": "[email protected]",
        "reportsTo": [
            {
                "employeeId": "533953",
                "firstName": "Howard",
                "lastName": "Jacobs",
                "jobTitle": "EVP Marketing & Sales Teams"
            }
        ],
        "departnemtId": "649654910",
        "departnemtName": "Action Sports Administration",
        "jobTitle": "VP Action Sports/Transform Dev"
    }
}

I am using an Ajax call to push the data into an array, but I can't seem to figure out the proper way to get to the reportsTo data. It's the last one and I'm getting Undefined:

// Load the Employee Details on the index.page  
$.ajax({
            url: "user-details-515552.json",
            cache: true,
            dataType : 'json',

            success : function(results) {
                var employeeData = [];
                    employeeData.push({
                        assistant: results.data.assistant,
                        departmentID: results.data.departnemtId,
                        departmentName: results.data.departnemtName,
                        locationName: results.data.locationName,
                        reportsToName: results.data.reportsTo.employeeId
                    });

                $('#employee-details').tmpl(employeeData).appendTo('#results-container');

            } 

        });

reportsTo is an array, will there be cases of having more than one person? — charlietfl
– charlietfl, Commented Feb 28, 2012 at 17:40

Jordan Running · Accepted Answer · 2012-02-28 17:41:43Z

1

In this case reportsTo is an array (see the [ and ]?):

{ // ...
  "data" : {
    // ...
    "reportsTo": [
      { "employeeId": "533953",
        // ...
      }
    ],
    // ...
}

...so you need to supply an array index, e.g.:

results.data.reportsTo[ 0 ].employeeId

answered Feb 28, 2012 at 17:41

Jordan Running

107k18 gold badges193 silver badges189 bronze badges

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

Comments

lamplightdev · Accepted Answer · 2012-02-28 17:39:43Z

0

reportsTo is an array ([]) containing one object ({}) so you will need to access the first element of the array ([0]) first:

results.data.reportsTo[0].employeeId

answered Feb 28, 2012 at 17:39

lamplightdev

2,1011 gold badge20 silver badges24 bronze badges

Comments

Rafay · Accepted Answer · 2012-02-28 17:41:42Z

0

$.each(json.data.reportsTo,function(k,v){
console.log(v.firstName);
});

http://jsfiddle.net/pCAQp/5/

to get a single value from the array

console.log(json.data.reportsTo[0].firstName);

http://jsfiddle.net/pCAQp/9/

answered Feb 28, 2012 at 17:41

Rafay

31.1k5 gold badges71 silver badges106 bronze badges

Comments

elrado · Accepted Answer · 2012-02-28 17:42:37Z

0

for (var reportsTo in results.data.reportsTo){
   //use reportsTo
}

answered Feb 28, 2012 at 17:42

elrado

5,3321 gold badge19 silver badges15 bronze badges

Comments

Brian Mains · Accepted Answer · 2012-02-29 03:35:07Z

0

I think your problem is this: here you try to get it by the property name of the object:

reportsToName: results.data.reportsTo.employeeId

Yet you pushed this earlier on in an array:

"reportsTo": [
            {
                "employeeId": "533953",
                "firstName": "Howard",
                "lastName": "Jacobs",
                "jobTitle": "EVP Marketing & Sales Teams"
            }
        ],

I'm not sure.. but I think the solution is to set

results.data.reportsTo.employeeId

to

results.data.reportsTo[0].employeeId

(not sure though..) It might be easier to just remove the []..

edited Feb 29, 2012 at 3:35

Brian Mains

50.8k35 gold badges155 silver badges260 bronze badges

answered Feb 28, 2012 at 17:40

tycho martins

71 bronze badge

Collectives™ on Stack Overflow

Json parsing with jquery

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related