[Capture%202019-07-11_3] I have this Firebase database structure that I am trying to import into my app. How do I get the first element “van1” without explicitly calling van1 but usin in list get #1? I have googled for several hours now and I’m still at a lost. I trying to get the Brand name of van1. Can anyone point me in the right direction on how to access this JSON object. It’s not a array of objects. I think that’s where I have the problem. I need the JSON to be [{},{}] and not {{},{}}

Did that solve your issue? If so, please click on the three dots on the reply that was the answer and click solved.

Thanks for the fast reply. However lets say that I will not have an idea about the “van1” key. I know VEHICLES exists but inside VEHICLES are items which have unique ids… How can I get the first item in the list of items in VEHICLES?

So one way would be to call vehicles and get the list and then use the get#1fromlist block in the list drawer. you would have to parse the list but thats not super hard.

I tired this but it does not work [Capture%202019-07-11_4] Perhaps I dont have a correct understanding of how Firebase DB structures should be created.

No, you have to clean the data up that is going into the list. When you get the data back from firebase, it will have ALL the data from vehicles. You have to remove the pieces of data you dont want. I’ll see if I can make an example for you.

OK, here ya go. Try this out and it should give you a list of the FIRST items and then you can call each item as you wish. Also you are replacing the characters with blank boxes, so basically deleting them so it is easier to work with the data. [help3]

wow thanks a lot! will try it out ASAP!

I use a label and a list viewer so I can see the json I am working with. It helps me figure out where I need to split my data. I am sure there is a better way to do this but thats how I found works for me.

[image] heart Saying Thanks in the Community! Learn About the Thunkable Community So, you’ve taken the time to carefully craft a new topic title and filled it with details about the current question that’s on your mind. Suddenly, out of seven billion people on the planet, one of them has taken a few moments out of their day to respond to you. How should you react? heart Like, totally! The easiest way to show your appreciation is by simply clicking the “like” button to show you like what you’re hearing. Perhaps someone has pointed you to another topic, a video or a doc t…

How do get the first element of this JSON

Questions about Thunkable X

kartik_old July 12, 2019, 12:48am 11

Topic		Replies	Views
How to get JSON ID from an JSON Object Questions about Thunkable X	12	3907	July 26, 2023
Retrieve firebase data in list viewer Questions about Thunkable X firebase , solved , beginner , help	6	1931	December 4, 2020
Read data from Firebase Thunkable x Questions about Thunkable X firebase , beginner	3	1480	April 28, 2019
Import a list from firebase Questions about Thunkable X firebase , beginner	16	689	April 8, 2022
How to get a value from this json Questions about Thunkable X	10	1389	July 22, 2019

How do get the first element of this JSON

Related topics