use json parsing of wunderground

[Hubert Huller]

I want to get a list of cities when I search for a city with wunderground.

Till now I use the following example url: http://autocomplete.wunderground.com/aq?query=boston&format=xml

I parse all cities in this xml file and will save it in a list.

But how can I do this with json. When I use the same code I will get always the error RESULTS not found.

Hope somebody can help me.
kindly regards

Here my code for xml and the error with json.

[Abraham Getzler]

See attached for how to do it in JSON.

ABG

[Hubert Huller]

Hi!
Thanks a lot for your answer and example.
How is it possible to get only the name or zmw or tz from one city (row).
kindly regards

[Abraham Getzler]

See https://docs.google.com/document/d/12t4HLNRepCnbmcfycdF8wSHWht_D1P8hKJpTknVDChY/edit?usp=sharing

for how to slice and dice a table.

ABG

[haiflosse]

Thanks for the answer.
I have created the select function but when I start it I will get only () as result.
Enclosed my code an a picture.
Hope you can stil help me.
kindly regards

[Abraham Getzler]

You get empty results because you were impatient,

looking in the results of something that has not yet happened.

Look in the Web blocks for the block that catches the event

of text coming back from the Web, and move all the processing

of results there.

Once you have issued the web.Get command,

there is nothing left to do in that block.

ABG

[haiflosse]

Thanks for your answer.
Sorry, but my english is not the best so I don't know what you mean.
May you can change my code or can explain it what I must change in the code.

Hope you can still help me.
kindly regards

[Abraham Getzler]

I can't figure out how to teach some one 

speaking a different language.

However, I notice if you search YouTube for MIT App Inventor

or AI2, you will find many introductory videos explaining it

in many different languages, maybe even one in your native language.

There are other people on this

board more skilled in other languages than me.  

If you post your question

in your own language, maybe they will be able to

answer in your language.

ABG

[haiflosse]

Hi!
Kindly regards for your answer.
Bad luck for me that you cannot help me anymore.

I understand that I must move the block label1.text to an other position of the code. I tried also other possibilities but couldn't find a solution.
I tried also to move it at the end of web1.got text but there I will get the error that the second argument (index) is not in the list.

I thought it is only a little error of mine to move the label1.text to the right position of the whole code (but where?).
But maybe I am total wrong and my planing is not correct.

May you can still help me and can give me some more ideas.
kindly regards.

here my second code I have tried with error:

[Abraham Getzler]

Your screen shot does not have all your blocks.

Post a Downloaded Blocks Image.

ABG

[Abraham Getzler]

Also, to debug your blocks,

use the Blocks Editor right click Do It on

all blocks, starting from the top down

until your blocks look like a pin cushion.

ABG

[haiflosse]

Thanks again for your answer.
I add again the whole project as aia file and I post here again all blocks as image.

Hope you can find my error.
kindly regards

[Abraham Getzler]

The select procedure you used is not set up to accept only a single column number.

It only works with a list of multiple column numbers.

Instead of select, use this new procedure column

to extract a single column from a table.

ABG

[Abraham Getzler]

I forgot to mention that for new line, use \n

ABG

[haiflosse]

Thanks again for your answer.

I have add the function column and it works wonderful when I use a separate list (in my example liste).
I have marked it with a red circle.

But when I try it with the global list boston_table I will still get a () as result.
So I think the items from the json file will not add to the list correctly as separated fileds.

So hope you can still help me.
kindly regards

Here my full code:

[Abraham Getzler]

See attached.

Web queries take time.

So do File requests.

It might be too fast for a human to notice,

but your app will find the Boston table empty

immediately after the Get request, because it is very fast

faster than the web site can respond.

That is why AI2 has event blocks 

like Web1.GotText

ABG

[haiflosse]

Thanks again for your answer.

Now it works perfect.
I can check now if xml or json is better.
The code for json is a bit more complex than in xml.

kindly regards for your help

[Abraham Getzler]

I can check now if xml or json is better.

For this web site, json is better.

If you examine the text returned from the website in xml versus json,

you will see [] and {} delimiters that express clearly the

differences between an array and an object.

See http://www.json.org/ for an explanation.

XML does not have a markup to distinguish arrays from objects,

at least on your web site, making it much harder to navigate

the data.

ABG