Get a child element from a JSON list

Hi Friends! Here I am again!

I have a Firebase database and I generated a JSON file to display as a list. When I display the list without sorting/filtering, it works. But I need to filter data from there, and when I filter, the structure of the JSON changes.

  1. Display the list as it is:


    (https://myvocab-30705.firebaseio.com/myvocab.json)

  2. Display the list sorted and filtered by adding ?orderBy=“Box”&equalTo=0 to the website address:

Some nodes appear in this second version and I tried everything that came to my mind to extract the information “Portugues” and “Alemao” from this JSON.

It might be silly, but I cannot see where my mistake is…

Hi,

an example of working with JSON on the scrJSON screen

https://x.thunkable.com/projects/5c8e64dfe1aad2f778a4c5ad/project/properties/designer/