How to display JSON list data from Xano?

[jarryd]

Hey Adalo Community,
Is it possible to display JSON data stored in Xano as a list in Adalo? Here’s the JSON data I have:

[
{ “location_name”:“Brass Bear Brewing & Bistro”,
“location_happy_hours”: {
“Fri”: {“hours”:“5:00 PM - 6:00 PM”},
“Mon”:{“hours”:“5:00 PM - 6:00 PM”},
“Sat”:{“hours”:“5:00 PM - 6:00 PM”},
“Sun”:{“hours”:“5:00 PM - 6:00 PM”},
“Thu”:{“hours”:“5:00 PM - 6:00 PM”},
“Tue”:{“hours”:“5:00 PM - 6:00 PM”},
“Wed”:{“hours”:“5:00 PM - 6:00 PM”}}},

{“location_name”:“Rodeo Room”,“location_happy_hours”:{“Fri”:{“hours”:“-----”},“Mon”:{“hours”:“-----”},“Sat”:{“hours”:“5:00 PM - 6:00 PM”},“Sun”:{“hours”:“5:00 PM - 6:00 PM”},“Thu”:{“hours”:“5:00 PM - 6:00 PM”},“Tue”:{“hours”:“-----”},“Wed”:{“hours”:“5:00 PM - 6:00 PM”}}}

]

Thank you in advance for your help!

[theadaloguy]

Yes it’s possible, what’s the issue you’re facing? Do you have a bit more info?

[jarryd]

Thanks for the reply! Here’s what I see when adding the location hours as magic text:

[jarryd]

@theadaloguy, does this info help or is more needed? Thank you again for taking a look at this!

[theadaloguy]

Ideally you want that data flattened before being returned from the api. Adalo sometimes can’t read the data when it is nested.