JSON as list

[Newman]

How would I get "description" into a listview from the JSON at WeatherBug - WeatherBug REST JSON API
I'm trying to retrieve it from Alerts, call by zipcode.

I have only had success in getting the entire message.

 

[Erel]

Have you parsed the message with the JSON library?

 

[Newman]

I was able to get what I wanted using xml. However, any insight into JSON would help as this is my first attempt at programming.

I think I had the message parsed with the JSON library. In the log it would read something like {message=Warning in effect for....etc. I don't remember exactly. However, in the example on the Weatherbug website it showed the JSON return as having this:

{"alertCount":1,"alertList":[{"alertId":"nws97561010","dateTimeBegins":null,
"dateTimeBeginsUtc":null,"dateTimeEnds":1282125600000,"dateTimeEndsUtc":1282150800000,
"dateTimeExpires":1282125600000,"dateTimeExpiresUtc":1282150800000,"dateTimePosted":
1282113960000,"dateTimePostedUtc":1282139160000,"description":"Fire Weather Warning",
"id":97561010,"message":" Urgent - Fire Weather MessageNational Weather Service
Pendleton OR646 AM PDT Wed Aug 18 2010\u000d\u000a\u000d\u000a East Slopes Of North
Oregon Cascades-Columbia Basin Of Oregon-\u000d\u000a\u000d\u000a...Red Flag Warning
Remains In Effect Until 10 AM PDT ThisMorning For Thunderstorms Producing Abundant
Lightning...\u000d\u000a\u000d\u000a* Affected Area: In Oregon...Fire Zone 609 East
Slopes Of North Oregon Cascades...Fire Zone 631 Columbia Basin Of Oregon.
\u000d\u000a\u000d\u000a* Timing: Thunderstorms Will Continue This Morning But Decrease
As The Low Pressure System Moves East Today.\u000d\u000a\u000d\u000a* Lightning
Activity: Primarily Lal 3 Activity With An Occasional Lal 4 Activity Storm.
\u000d\u000a\u000d\u000a* Impacts: Some Storms Will Produce Little Or No Rain At The
Surface. Gusty Northwest Winds May Develop Again This Morning.
\u000d\u000a\u000d\u000aPrecautionary\/Preparedness Actions...\u000d\u000a\u000d\u000aA
Red Flag Warning Means That Critical Fire Weather Conditions Are Either Occurring Now...
Or Will Shortly. These Conditions WillCreate The Potential For Explosive Fire Growth.
For Additional Weather Information...Visit Our Web Site At
Www.Weather.Gov\/Pendleton.\u000d\u000a\u000d\u000a&&","typeId":105}],
"supportsAlerts":true}

I just wanted "description" to put into a listview, and then a link that the user would be directed to when clicking on it. Any help would be much appreciated. I went through the the tutorial and read over all the forum posts I could find and just couldn't get anything to work for it. Although not necessary at this point, I would like to get a firm grasp on how it works.

 

[Erel]

It seems like this text is not a valid JSON. I tried several online JSON tools and they weren't able to parse it.

 

[Newman]

OK. Thanks for your help.

 

[margret]

Pull Data from JSON

I am using a JSON string returned that looks very much like your. You should be able to use the string functions here:

http://www.b4x.com/forum/basic4android-getting-started-tutorials/10365-string-functions.html

And the code below. It may need tweeked as I did not test it.

yourvar = s.Mid(json, s.At(json, "description"), 50)
yourvar = s.Right(yourvar, s.Len(yourvar)-15)
yourvar = s.Left(yourvar, s.At(yourvar, ",QUOTE")-1)

Thanks,

Margret

 

[Newman]

Great! Thanks margret and Erel, I believe I've got it figured out.