Synthoid/ExportSheetData

Nested Elements return with null values - Help

Closed this issue · 7 comments

akliewer99 commented

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!

  • Arlene
    screenshot-null
Synthoid commented

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?

akliewer99 commented
Synthoid commented

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:

image

akliewer99 commented
Synthoid commented

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.

Synthoid commented

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
akliewer99 commented