Import a json file into a listview or spinner

MIT App Inventor Help
1

Hi!
I have here an json file wich I want to import in a listview or spinner.
The json file is located in the web:http://schulehaho.bplaced.net/sender.html
I want to insert from this file the text: http://onair.krone.at/kronehit.mp3 and http://mp3stream1.apasf.apa.at:8000/

I have tried the following code:

grafik
grafik707×575 36.3 KB

But my listview is alway empty.

Hope somebody can help.
kindly regards

2

Start with using responseContent instead of responseCode.

Here is the JSON you get:

{"sender":["http://onair.krone.at/kronehit.mp3","http://mp3stream1.apasf.apa.at:8000/"]}

Do you want your ListView to contain the two Elements

Set ListView1.Elements to
lookup in pairs(key('sender'),pairs(Web1.JSONDecode(responseContent)),notfound(create empty list))

in your Web1.GotText even

3

Thanks for your reply.
I have change now the following:

grafik
grafik660×586 70.9 KB

But when I press the button I will get the following error message:
The second argument to foreach is not a list. The second argument is "<script>"

It seems the webfile is not correct. when I open the source of the url I will get:

Hope someone have an idea how I can get a real json file which I can use with appinventor.
kindly regards

4


Please export your project and post it here.

5

Try this

blocks
blocks875×302 21.8 KB
halflosse.aia (2.1 KB)

6

Strangely, the Web component returns a script in html...
Capture

blocks
blocks872×363 23.6 KB

That is not JSON.

7

In a computer web browser the url returns a JSON:

{"sender":["http://onair.krone.at/kronehit.mp3","http://mp3stream1.apasf.apa.at:8000/"]}

Explain what you want to do with the two elements?

8

Thanks for your answer.
I want to add these two elements in a spinner for selecting for an audiostream.
kindly reagards

9

@ABG is right, the web url being called is malformed and not returning a JSON, it is setup to write text to an html page. However, with replacement blocks it is possible to get at the content

Example blocks

blocks (4)
blocks (4)1232×840 103 KB

Example screen

image
image544×617 32 KB

10

thanks for the answer.
I have done an update of my json file.
I use now:
{sender:[{text:krone,url:'http://onair.krone.at/kronehit.mp3'},{text:hit, url:'http://mp3stream1.apasf.apa.at:8000/'}]}
I want not two list. In one list I want to insert all text elements and in the other list all url elements.
In my example:
list1: krone, hit
list2: http://onair.krone.at/kronehit.mp3, http://mp3stream1.apasf.apa.at:8000/
Hope someone can still help me here again.
kindly regards

11

What is the url now, and have you revised the output of the file to return just JSON and not javascript?

12

the new url is now:
http://schulehaho.bplaced.net/stationen2.txt
kindly regards

13

Your JSON should look like this:

{"sender":[{"text1":"krone","url1":"http://onair.krone.at/kronehit.mp3"},{"text2":"hit", "url2":"http://mp3stream1.apasf.apa.at:8000/"}]}
14

Thanks.
I have changed now the url.
kindly regards

15

If your JSON is formed as above:

image
image1102×648 84.2 KB

image

16

You didn't add the double quotes....

17

Thanks a lot for your answer.
It seems I don't need the double quotes - or?
Also I tried it with only text and url.
In my code it works.
Thanks for your help.
kindly regards

18

Hi!
I see. When I do a validation of the file I must use the double quotes. Thanks for the information.
I have changed now again the url.
kindly regards

19

For a correctly formatted JSON, the keys must be in double quotes

{"key":value}

If the value is a number it does not need quotes, but it makes sense to put a string in quotes as well.

20

Thanks for the information.
kindly regards