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("????????????????")
- }