getJSON where parent field is not a field name
I've got data coming in to Creator from Zoho People in JSON format and want to extract specific values. However each record is identified by the individual's unique ID. For Example:
- {
"response": {
"result": [
{
"7552000001012445": [
{
"EmployeeID": "1111",
"LastName": "Simpson",
"FirstName": "Homer"
}
]
},
{
"7552000001010102": [
{
"EmployeeID": "2222",
"LastName": "Simpson",
"FirstName": "Marge"
}
]
},
{
"7552000000781045": [
{
"EmployeeID": "333",
"LastName": "Simpson",
"FirstName": "Bart"
}
]
},
{
"7552000000684973": [
{
"EmployeeID": "4444",
"LastName": "Simpson",
"FirstName": "Lisa"
}
]
}
],
"message": "Data fetched successfully",
"uri": "/api/forms/employee/getRecords",
"status": 0
}
}
How can I drill down to only get the FirstName value when each record is identified by a number ?
- varRawData contains the full raw JSON
- varData = varRawData.getJSON("response").getJSON("result");
- for each employee in varData
- {
- project_name=employee.getJSON("????????????????")
- }