Firebase RealtimeDB query1.data is invalid?

I'm trying to get data from my Firebase RealtimeDB into a ReTool table. I've followed all the tutorials and directions I can find. The query returns the data perfectly -- but when I put "query1.data" in the data box for the table, I get an error message suggesting I put in "query1.data" instead. (This error persists if I change the name of the query, fwiw.) Obviously this is kind of confusing. :stuck_out_tongue:

Here's the basic data structure in JSON that created the Realtime DB:
{
"bundles": [
{
"id": "bundle_1",
"nominator_id": "1",
"nominator_name": "Nominated Someone",
"email": "violet@hopeoverpain.org",
"phone": "9512829999",
"relationship": "grandaughter",
"date_contacted": "3/10/2022",
"elder_name": "John Smith",
"hobbies": "Huntin and shootin and cooking and dogs but not necessarily all at the same time",
"address_to": "Nominated",
"street1": "123 Main St",
"street2": "Ste 1",
"city": "Someplace",
"state": "CA",
"zippostal": "92683",
"country": "USA",
"media": [
{
"id": "1",
"type": "main",
"format": "image",
"date_added": "3/10/2022",
"display" : "true"
},
{
"id": "2",
"type": "feedback",
"format": "image",
"date_added": "3/25/2022",
"display" : "true"
},
{
"id": "3",
"type": "feedback",
"format": "video",
"date_added": "3/25/2022",
"display" : "true"
}
],
"featured": "",
"scheduled": "",
"letter_count": ""
}
],
"nominators" : [
{
"nominator_id": "1",
"name": "Nominated Someone",
"email": "violet@hopeoverpain.org",
"phone": "9512821047",
"relationship": "grandaughter",
"date_contacted": "3/10/2022"
}
],
"volunteers": [
{
"volunteer_id": "1",
"name": "Jane Doe",
"email": "jane@doe.org",
"date_added": "3/10/2022",
"bundle_id": "1"
}
],
"media": [
{
"id": "1",
"type": "main",
"format": "image",
"date_added": "3/10/2022",
"display" : "true"
},
{
"id": "2",
"type": "feedback",
"format": "image",
"date_added": "3/25/2022",
"display" : "true"
},
{
"id": "3",
"type": "feedback",
"format": "video",
"date_added": "3/25/2022",
"display" : "true"
}
]
}

At this point I would just like to see some of the data appear in the table. I'm pretty sure I can take it from there.

Give me SQL any day of the week.

Thanks.

@LFOETech

Hey there :wave: I took a look at this data and am unsure how you would like to format it/what you would like to populate the table with -- but it seems to be a formatting/nested data issue:

Here is a helpful resource in our docs on data conversion that would definitely come in handy here :slightly_smiling_face:\