Hi I want to use SMHI as weather provider. They have an API http://opendata-download-metfcst.smhi.se/api/category/pmp2g/version/2/geotype/point/lon/17.12/lat/60.65/data.json that gives this json: {"approvedTime":"2017-02-07T16:24:24Z","referenceTime":"2017-02-07T14:00:00Z","geometry":{"type":"P…

Take a look at JSONPath Transformation add-on

This json includes data for every hour for 10 days in the future. I want to have this for forecast data. Is it possible to use JSONPath Transformation to get the values that have validtime tommorrow 13.00. /Mike

In my example I decided to do all parsing through a rule. If you use the http binding and caching you can use the JSONPATH transformation directly on your items if you only need to get the raw values. In my case I needed some extra processing for some of the data, so I needed a rule for that anyway …

The problem with JSONPath is that i want to get an value from json with tomorrow date and 13.00 time and i do not think you can do that type of calculations in Items. /Mike

I don’t know if this is possible but perhaps you can try to combine 2 transformations with adding a dot in between? The first wood be the JSONPATH and the second a JS?

I need some help with JSONPath syntax. How do i get the “t” parameters value from timeSerie “2017-02-07T17:00:00Z” {"approvedTime":"2017-02-07T16:24:24Z", "referenceTime":"2017-02-07T14:00:00Z", "geometry":{"type":"Point","coordinates":[[17.12,60.65]]}, "timeSeries":[ {"validTime":"2017-02-07T15:0…

I have now solved the parse var String var1= transform("JSONPATH", "$.timeSeries.[?(@.validTime=='2017-02-19T01:00:00Z')].parameters.[?(@.name=='t')].values[0]", smhijson) But not i have problem to get rud ot the last brackets [1.3]. Does someone have any input on this? /mike

I have now solved the brackets This is the current code import java.util.Date import java.text.SimpleDateFormat var SimpleDateFormat df = new SimpleDateFormat( "yyyy-MM-dd'T'HH:00:00'Z'") var String Curvaliddate = df.format(new Date()) var String smhijson = sendHttpGetRequest("http://open…

This is what i have tried but it seems that i can not mix Joda with Java Date var SimpleDateFormat cdf = new SimpleDateFormat( "yyyy-MM-dd'T'HH:00:00'Z'") var String Curvaliddate = cdf.format(new Date()) var SimpleDateFormat fdf = new SimpleDateFormat( "yyyy-MM-dd'T'13:00:00'Z'") var Strin…

openHAB Community

[Solved] SMHI Weather

Setup, Configuration and Use Scripts & Rules

kubawolanin (Kuba Wolanin) February 7, 2017, 6:21pm 4

Then I believe you need to configure HTTP binding properly.
See Robert’s example - he’s utilizing HTTP and JSONPath to achieve something similar.