Json in spinner component use list

[stefano]

hi

I’m going crazy but I can’t find the solution, I have to use two spinners to show the provinces in the first and the municipalities already filtered in the second but I can’t use a json file like this https://comuni-ita.herokuapp.com/api/comuni or a csv file like this.https://firebasestorage.googleapis.com/v0/b/serviziassociati730.appspot.com/o/ElencoComuni.csv?alt=media&token=38dd50ef-2068-40de-a2b1-7acccd27d11d

Keep giving me error I also tried to follow what was done here but without success.
can you help me?

[TimAi2 (metricrat)]

JSON: Why not? Use the dictionary blocks (search forum for guides) to convert the json to lists, or to extract the keys and values you need for your spinner/s

CSV: What is the issue with using the csv file. You will need to show your relevant blocks.

[Rogerio_Rios (Professional Support)]

Friend, get this Json in the Response Content of the Got event of the Component web. Use Json Decode Text block in Response Content. Then use the Lookup pairs Key Block. And take the Key you want: nome , regione , lat…

[stefano]

I try

you are just fantastic

thanks

[Rogerio_Rios (Professional Support)]

Extract data from complex JSON

Hello, I have a need in an application to consult an API where my client will enter the document number and this document may be linked to more than one contract and the API returns me a Json with all the contracts and their respective information, I need to take each contract number and play it in a listview. I managed to do it with clients who have only one contract, but clients who have more than one contract, I still couldn’t understand how to go through the text and get this specific infor…

How can i get data from json to spinner

You can try using the block : ( and so learn …just a suggestion) [keypath] + [makelist] + [stringname] + [foreach] + [lookuppairs2] [sitenames] One question: Will your Json always be like this? date, date2, date3, date4, date5 … daily, daily2, daily3, daily4, daily5…

[stefano]

Hi i try bur also error

what am I doing wrong?

The json is https://firebasestorage.googleapis.com/v0/b/serviziassociati730.appspot.com/o/italia_comuni.json?alt=media&token=eefe0ffc-aa7a-4df1-b77d-2d144a60f6cb

the block is

Help me

i want list of nome of provincie

Steve

[stefano]

sorry if i’m late and i don’t understand but i’ve been going crazy for two days, i can’t even sleep.

I have to acquire a list of provinces from a json file you showed me how to import it the problem is the structure of the json.

I can’t point to the name of the province.

the main object is called regions which is an array which contains a list of objects which is called provinces which is in turn an array which contains the name as well as the code and another array which contains the municipalities.

I should extract the names of the provinces and insert them in a spinner then in another spinner show the municipalities filtered for the chosen province.

I can not make it!

the json file is this

https://firebasestorage.googleapis.com/v0/b/serviziassociati730.appspot.com/o/italia_comuni.json?alt=media&token=eefe0ffc-aa7a-4df1-b77d-2d144a60f6cb

Questi sono alcuni tentativi

Can you help me!

Thanks in advance

Excuse my orrible english

Stefano

[Peter (Moderator)]

Don’t open another topic with the same question. I merged them now.

[stefano]

Excuse me thanks

[dora_paz (Dora)]

Use jsonparseronline to see the stucture of your json. What are you trying to get from that json ? Province’s name like Abruzzo or something else ?

[Rogerio_Rios (Professional Support)]

Please , Read

Guide: How to get JSON data from an Api using dictionaries (and show it on a dynamic cardview)

Recently Kodular has removed the Json component but has added the Dictionaries. The Dictionaries can be used to obtain data from a Json in a simple way. Using the dictionaries you don’t need to use any Json extension. First of all, dictionaries are not a component. That’s why you won’t find it in the Designer. You will find it in the block section: [imagen] In this example we are going to obtain the data from the Api newsapi.org The idea is to get something like this: [Tutorial Json Ap…

[stefano]

Hi
i need get in the first list the names of provinces

in the second list

the name of the comuni filter per provincia

Thanks