How to display JSON list data from Xano?

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!

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

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

Screenshot 2023-03-27 at 10.35.41 AM

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

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

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.