XML/JSON/HTML API to database

Many weather sources allow api access to the weather that doesn't include all the cookies, html, javascript, and junk that isn't weather.  I suggest finding one with the weather you need, contact them for access to that data, and then set up the proper URL/call.

Data will likely be returned as CSV, XML, or JSON.  This link http://www.yr.no/place/Netherlands/North_Holland/Amsterdam/data.html shows 3 ways to download just the data.  For you, xml may be the best option.

After that, you can do a lot of PEEK's to peek through the receive buffer and parse it out.  It will be dreadfully slow if I guess correctly, so perhaps just run one xml chunk per scan since they usually do not allow you to update more than say once an hour for free.

Do you best to find the best download option for your needs first.  Downloading from a web page will probably be your worst option.  Web page s***ing is so inefficient and a waste of resources.  It may even be a violation of the terms of use for that web site (many say you cannot do it).

NiekT

Hi MicTsc,

thanks for your response, that IS exactly what i want :-)

I do want to call *some* data from the weather report that i get as an response. I need 3 or 4 Parameters from the weather report to display in HMI and i need 2 parameters for controlling the application. So i think indeed the easy way is to read them on the webserver, and store them in a DB.

But since im not a webdesigner, i do not even have a clue..... 

Thanks

The ip address is 192.241.169.168, your subnet mask is probably 255.255.255.0 and your router will forward your internet GET request to that ip address. 

If you are Siemens SCL savvy, you can use the OSCAT open source network SCL library to handle all the hard work.

The hard part for you will be to convert the non-Siemens SCL to Siemens compatible SCL, and drop in a few blocks in your project, and away you go.

It is probably the fastest way if you know anything at all about SCL, and exporting/importing SCL blocks using the external source portion of the project tree.

NiekT

Hi huggy,

How do i call it like that in S7, i realle have never done that before. 

I have API Access to a Wheaterservice, and XML is really "clean":

<current>

<cityid="2783307"name="Zeebrugge">

<coordlon="3.18"lat="51.33"/>

<country>BE</country>

<sunrise="2017-09-13T05:20:29"set="2017-09-13T18:04:14"/>

</city>

<temperature value="13"min="13"max="13"unit="metric"/>

<humidity value="87"unit="%"/>

<pressure value="1001"unit="hPa"/>

<wind>

<speed value="8.7"name="Fresh Breeze"/>

<gusts value="13.9"/>

<direction value="240"code="WSW"name="West-southwest"/>

</wind>

<clouds value="40"name="scattered clouds"/>

<visibility value="10000"/>

<precipitation mode="no"/>

<weather number="521"value="shower rain"icon="09n"/>

<lastupdate value="2017-09-13T18:20:00"/>

</current>

 the only thing i have is a link with an API key

http://api.openweathermap.org/data/2.5/weather?q=Zeebrugge%2CBE&mode=xml&units=metric&appid=xxxxxxx

(not going to give the complete link, because im restricted to 1 read per 10 min, and 500/month :-) )

Ho do i call this in S7?