XML data

[tomnord]

Hello, I`m looking to import weaterdata from a website.
The site exports data as xml.

Is there a guide to doing so in LM?

Example xml:
https://www.yr.no/sted/Norge/Vestfold_og...varsel.xml


Sent fra min SM-G950F via Tapatalk

[Daniel]

Code:

12345678910111213141516171819202122232425262728293031323334353637383940414243

require('socket.http') forecast = {} function parsetag(parser, tag, attributes)   if tag == 'time' then     table.insert(forecast, {})   elseif tag == 'symbol' then     forecast[ #forecast ].symbol = attributes.name   elseif tag == 'precipitation' then     forecast[ #forecast ].precipitation = attributes.value   elseif tag == 'windDirection' then     forecast[ #forecast ].wind_direction = attributes.code   elseif tag == 'windSpeed' then     forecast[ #forecast ].wind_speed = attributes.mps   elseif tag == 'temperature' then     forecast[ #forecast ].temperature = attributes.value   elseif tag == 'pressure' then     forecast[ #forecast ].pressure = attributes.value   end end url = 'http://www.yr.no/place/United_Kingdom/England/Farnborough/varsel.xml' data, err = socket.http.request(url) if data then   require('lxp').new({     StartElement = parsetag   }):parse(data)   grp.update('Weather precipitation', tonumber(forecast[1].precipitation))   grp.update('Weather symbol', forecast[1].symbol)   grp.update('Weather windDirection', forecast[1].wind_direction)   grp.update('Weather windSpeed', tonumber(forecast[1].wind_speed))   grp.update('Weather temperature', tonumber(forecast[1].temperature))   grp.update('Weather pressure', tonumber(forecast[1].pressure))   --log(forecast)   else   alert('Fetch failed: ' .. tostring(err)) end

[Tokatubs]

Daniel, is this still working. ?

I think yr.no changed to another api.

https://api.met.no/

[admin]

Their new beta API provides JSON which is much easier to parse:
https://api.met.no/weatherapi/locationfo...0&lon=9.58

[Daniel]

My script still works.

[Tokatubs]

require('ssl.https')
require('json')

data = ssl.https.request('http://weerlive.nl/api/json-10min.php?locatie=' ..plaatsnaam)
datatable = json.pdecode(data)
datatable = datatable['liveweer'][1]

log(datatable)

If you use something like this, how do you deploy it and how do you extract this to groupo adresses?

[tomnord]

Their new beta API provides JSON which is much easier to parse:
https://api.met.no/weatherapi/locationfo...0&lon=9.58

Where do we privide location on this one?

never mind, I see the long lat now

---

decoding json gives me "nesting to deep" in most of the tables..
What could be the reason for this?

[Daniel]

I tried like that you have to put coordinate of location as longitude and latitude.

Code:

123456

require('ssl.https') require('json') data = ssl.https.request('https://api.met.no/weatherapi/locationforecast/2.0/.json?lat=51.28&lon=-0.75') datatable = json.pdecode(data) log(datatable.properties.timeseries[1].data.instant.details.air_temperature)

[tomnord]

I tried like that you have to put coordinate of location as longitude and latitude.

Code:

123456

require('ssl.https') require('json') data = ssl.https.request('https://api.met.no/weatherapi/locationforecast/2.0/.json?lat=51.28&lon=-0.75') datatable = json.pdecode(data) log(datatable.properties.timeseries[1].data.instant.details.air_temperature)

yeah, I got some data, but I also got "nesting to deep" in the log. could try to extract spesiffic data, maybe that would do the trick.

---

seems to work, but the amount of data in the table is quite big, and difficult to navigate.
Any good tips to view the table in a structured way?

[admin]

Firefox can display JSON data in a structured way. Or just copy JSON from the URL and use any online JSON viewer.