Nested Elements return with null values - Help
Closed this issue · 7 comments
I finally got the "Nested Elements" to be exactly where I need them. However, there is no data. (see screenshot) Everything is null. Did I miss something?
(FYI: Used "mouse" instead of "records", just in case "records" was a reserved word.)
I work with a non-profit on a fundraising event. This is urgent. Thanks in advance for your time!
Can you link to an example sheet or give an example of desired data? That will help me figure the issue out faster.
Also, what settings are you using?
Does this seem like the data format you were expecting?
{
"Sheet2": {
"records": [
{
"id": 10880791,
"collection": "Participants2020_test",
"action": "patch",
"data": [
{
"lookupID": 10880791,
"registrantID": "01DVABPTWG12WN6JF5T",
"racerLName": "Data",
"racerFName": "Commander",
"gender": "male",
"isScholar": "N",
"racer_dob": "8-6-1970",
"age": 50,
"race_name": "1 Mile",
"reg_choice_name": "1 Mile Adult",
"bibNumber": 1502,
"raceShirt1": "NAVY Adult-Medium",
"designatedCampus": "EDH",
"scholarLName": "Oxford",
"scholarFName": "Ashely",
"grade": "3rdGrade",
"gradeNumber": 3,
"couponCode": "VTEER100",
"zipCode": 95762,
"status": "CONF",
"raceWaiver": true,
"teacher": "langtonKaralee"
}
]
},
{
"id": 10880792,
"collection": "Participants2020_test",
"action": "patch",
"data": [
{
"lookupID": 10880792,
"registrantID": "01DVABPTWJ2MF7Y10VX",
"racerLName": "Troi",
"racerFName": "Deanna",
"gender": "female",
"isScholar": "N",
"racer_dob": "4-9-2011",
"age": 9,
"race_name": "10K",
"reg_choice_name": "10K Youth (18-under)",
"bibNumber": 103,
"raceShirt1": "NAVY Youth-Small",
"designatedCampus": "ROS",
"scholarLName": "Walker",
"scholarFName": "Tammy",
"grade": "6thGrade",
"gradeNumber": 6,
"couponCode": "VTEER100",
"zipCode": 95678,
"status": "CONF",
"raceWaiver": true,
"teacher": "rummelsburgSteven"
}
]
},
{
"id": 11621807,
"collection": "Participants2020_test",
"action": "patch",
"data": [
{
"lookupID": 11621807,
"registrantID": "01E0251NHMP6MY7AHRR",
"racerLName": "Picard",
"racerFName": "Jean-Luc",
"gender": "male",
"isScholar": "N",
"racer_dob": "6-30-2009",
"age": 11,
"race_name": "1 Mile",
"reg_choice_name": "1 Mile Youth (18-under)",
"bibNumber": 1602,
"raceShirt1": "NAVY Youth-Small",
"designatedCampus": "ROS",
"scholarLName": "Kliewer",
"scholarFName": "Paul",
"grade": "10thGrade",
"gradeNumber": 10,
"couponCode": "VTEER100",
"zipCode": 95678,
"status": "CONF",
"raceWaiver": true,
"teacher": "courage"
}
]
}
]
}
}
If so, this was the formatting I used for the keys:
If you want each value in the data array to be its own object (similar to what you had originally) all you would need to do is change the index values to what you had originally. So instead of all your data keys starting with [records]{#id}[data]{#1}
, you would number them sequentially with [records]{#id}[data]{#2}
, [records]{#id}[data]{#3}
, etc.
Keep in mind that this would make accessing the data look more like data[0].lookupID
, data[1].registrantID
, data[2].racerLName
, and so on.
Upon closer reading of your comment, it sounds like you want you data elements to look something like this:
{
"key" : "lookupID",
"value" : 10880791
}
If so, you should be able to format your keys like this:
[records]{#id}[data]{#1}key |
[records]{#id}[data]{#1}value |
[records]{#id}[data]{#2}key |
[records]{#id}[data]{#2}value |
---|---|---|---|
lookupID | 10880791 | registrantID | 01DVABPTWG12WN6JF5T |