Hallo Leute!
Ich versuche gerade eine Wetterabfrage über openweatherwap.org am Homeserver einzurichten. openweatherwap.org liefert ein JSON mit 40 Datensätzen mit je ca. 20 Einzeldaten. Die 40 Datensätze sind fix, bei den Einzeldaten können unzutreffende Daten auch fehlen.
Die Idee ist, über eine Webabfrage mit komplexer Auswertung zunächst einmal die Antwort auf 40 Datensätze aufzuteilen und in 40 KO's abzulegen.
Das empfangene JSON von openweatherwap.org sieht so aus:
Die einzelnen Datensätze lassen sich mit folgender Regular Expression extrahieren (getestet mit https://regex101.com):
"dt" ist dabei das 1. Element, "dt_txt" ist las letzte Element eines Datensatzes. Im Experten habe ich dazu bei der Webafrage 40 KO's eingetragen. Funktioniert aber nicht: Auf der Debug-Seite schaut der Anfang der Anwort richtig aus, aber die KO's werden nicht befüllt, und bei der Abfrage wird der eingetragene Befehl für nicht erfolgreiche Ausführung ausgeführt.
Um mich heranzutasten, habe ich mal versucht, eine ganz einfache Regular Expression einzugeben:
Dazu nur ein KO in der Webabfrage. Der String "mess" kommt in der Antwort nur 1x vor, also hätte ich erwartet, dass das KO mit "mess" befüllt wird. Aber auch schon dieses einfache Beispiel funktioniert nicht. Auch hier wird der Befehl für fehlerhafte Ausführung ausgeführt und auf der Debug-Seite endet die Abfrage mit
also fehlerhaft. Was ist hier falsch?
Gruß
GKap
Ich versuche gerade eine Wetterabfrage über openweatherwap.org am Homeserver einzurichten. openweatherwap.org liefert ein JSON mit 40 Datensätzen mit je ca. 20 Einzeldaten. Die 40 Datensätze sind fix, bei den Einzeldaten können unzutreffende Daten auch fehlen.
Die Idee ist, über eine Webabfrage mit komplexer Auswertung zunächst einmal die Antwort auf 40 Datensätze aufzuteilen und in 40 KO's abzulegen.
Das empfangene JSON von openweatherwap.org sieht so aus:
Code:
{"cod":"200","message":0.0061,"cnt":40,"list":[{"dt":1545998400,"main":{"temp":8.18,"temp_min":6.26,"temp_max":8.18,"pressure":991.71,"sea_level":1038.01,"grnd_level":991.71,"humidity":79,"temp_kf":1.92},"weather":[{"id":802,"main":"Clouds","description":"Überwiegend bewölkt","icon":"03d"}],"clouds":{"all":48},"wind":{"speed":4.12,"deg":293.501},"sys":{"pod":"d"},"dt_txt":"2018-12-28 12:00:00"},{"dt":1546009200,"main":{"temp":5.98,"temp_min":4.54,"temp_max":5.98,"pressure":992.56,"sea_level":1038.82,"grnd_level":992.56,"humidity":75,"temp_kf":1.44},"weather":[{"id":800,"main":"Clear","description":"Klarer Himmel","icon":"01d"}],"clouds":{"all":0},"wind":{"speed":4.25,"deg":303.503},"sys":{"pod":"d"},"dt_txt":"2018-12-28 15:00:00"},{"dt":1546020000,"main":{"temp":3.32,"temp_min":2.36,"temp_max":3.32,"pressure":993.97,"sea_level":1040.57,"grnd_level":993.97,"humidity":77,"temp_kf":0.96},"weather":[{"id":800,"main":"Clear","description":"Klarer Himmel","icon":"01n"}],"clouds":{"all":0},"wind":{"speed":3.41,"deg":311.501},"sys":{"pod":"n"},"dt_txt":"2018-12-28 18:00:00"},{"dt":1546030800,"main":{"temp":1.79,"temp_min":1.31,"temp_max":1.79,"pressure":995.28,"sea_level":1042.05,"grnd_level":995.28,"humidity":83,"temp_kf":0.48},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10n"}],"clouds":{"all":48},"wind":{"speed":3.17,"deg":322.001},"rain":{"3h":0.005},"sys":{"pod":"n"},"dt_txt":"2018-12-28 21:00:00"},{"dt":1546041600,"main":{"temp":0.73,"temp_min":0.73,"temp_max":0.73,"pressure":996.09,"sea_level":1043.03,"grnd_level":996.09,"humidity":86,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10n"}],"clouds":{"all":64},"wind":{"speed":3.01,"deg":322.501},"rain":{"3h":0.015},"sys":{"pod":"n"},"dt_txt":"2018-12-29 00:00:00"},{"dt":1546052400,"main":{"temp":0.73,"temp_min":0.73,"temp_max":0.73,"pressure":996.49,"sea_level":1043.53,"grnd_level":996.49,"humidity":89,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10n"}],"clouds":{"all":68},"wind":{"speed":2.97,"deg":321.506},"rain":{"3h":0.03},"snow":{"3h":0.005},"sys":{"pod":"n"},"dt_txt":"2018-12-29 03:00:00"},{"dt":1546063200,"main":{"temp":0.37,"temp_min":0.37,"temp_max":0.37,"pressure":997.03,"sea_level":1044.15,"grnd_level":997.03,"humidity":89,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10n"}],"clouds":{"all":68},"wind":{"speed":3.11,"deg":319.01},"rain":{"3h":0.015},"snow":{"3h":0.0475},"sys":{"pod":"n"},"dt_txt":"2018-12-29 06:00:00"},{"dt":1546074000,"main":{"temp":1.1,"temp_min":1.1,"temp_max":1.1,"pressure":997.47,"sea_level":1044.44,"grnd_level":997.47,"humidity":89,"temp_kf":0},"weather":[{"id":800,"main":"Clear","description":"Klarer Himmel","icon":"01d"}],"clouds":{"all":12},"wind":{"speed":2.97,"deg":314.501},"rain":{},"snow":{"3h":0.005},"sys":{"pod":"d"},"dt_txt":"2018-12-29 09:00:00"},{"dt":1546084800,"main":{"temp":2.95,"temp_min":2.95,"temp_max":2.95,"pressure":996.44,"sea_level":1043.1,"grnd_level":996.44,"humidity":84,"temp_kf":0},"weather":[{"id":803,"main":"Clouds","description":"Überwiegend bewölkt","icon":"04d"}],"clouds":{"all":56},"wind":{"speed":3.63,"deg":305.001},"rain":{},"snow":{},"sys":{"pod":"d"},"dt_txt":"2018-12-29 12:00:00"},{"dt":1546095600,"main":{"temp":1.88,"temp_min":1.88,"temp_max":1.88,"pressure":996.3,"sea_level":1043.11,"grnd_level":996.3,"humidity":77,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10d"}],"clouds":{"all":24},"wind":{"speed":3.86,"deg":301.003},"rain":{"3h":0.005},"snow":{},"sys":{"pod":"d"},"dt_txt":"2018-12-29 15:00:00"},{"dt":1546106400,"main":{"temp":0.42,"temp_min":0.42,"temp_max":0.42,"pressure":995.92,"sea_level":1043.06,"grnd_level":995.92,"humidity":78,"temp_kf":0},"weather":[{"id":800,"main":"Clear","description":"Klarer Himmel","icon":"02n"}],"clouds":{"all":8},"wind":{"speed":4.36,"deg":294},"rain":{},"snow":{},"sys":{"pod":"n"},"dt_txt":"2018-12-29 18:00:00"},{"dt":1546117200,"main":{"temp":0.92,"temp_min":0.92,"temp_max":0.92,"pressure":994.42,"sea_level":1041.81,"grnd_level":994.42,"humidity":78,"temp_kf":0},"weather":[{"id":802,"main":"Clouds","description":"Überwiegend bewölkt","icon":"03n"}],"clouds":{"all":48},"wind":{"speed":4.76,"deg":292.002},"rain":{},"snow":{},"sys":{"pod":"n"},"dt_txt":"2018-12-29 21:00:00"},{"dt":1546128000,"main":{"temp":1.91,"temp_min":1.91,"temp_max":1.91,"pressure":993.07,"sea_level":1040.19,"grnd_level":993.07,"humidity":77,"temp_kf":0},"weather":[{"id":803,"main":"Clouds","description":"Überwiegend bewölkt","icon":"04n"}],"clouds":{"all":80},"wind":{"speed":5.56,"deg":286.5},"rain":{},"snow":{},"sys":{"pod":"n"},"dt_txt":"2018-12-30 00:00:00"},{"dt":1546138800,"main":{"temp":2.56,"temp_min":2.56,"temp_max":2.56,"pressure":991.21,"sea_level":1038.03,"grnd_level":991.21,"humidity":86,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10n"}],"clouds":{"all":80},"wind":{"speed":5.11,"deg":283.001},"rain":{"3h":0.51},"snow":{},"sys":{"pod":"n"},"dt_txt":"2018-12-30 03:00:00"},{"dt":1546149600,"main":{"temp":1.62,"temp_min":1.62,"temp_max":1.62,"pressure":991.43,"sea_level":1038.3,"grnd_level":991.43,"humidity":90,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10n"}],"clouds":{"all":76},"wind":{"speed":6.36,"deg":288.5},"rain":{"3h":0.605},"snow":{"3h":0.03},"sys":{"pod":"n"},"dt_txt":"2018-12-30 06:00:00"},{"dt":1546160400,"main":{"temp":2.88,"temp_min":2.88,"temp_max":2.88,"pressure":991.11,"sea_level":1037.74,"grnd_level":991.11,"humidity":91,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10d"}],"clouds":{"all":80},"wind":{"speed":7.46,"deg":289.5},"rain":{"3h":0.235},"snow":{"3h":0.0025},"sys":{"pod":"d"},"dt_txt":"2018-12-30 09:00:00"},{"dt":1546171200,"main":{"temp":4.16,"temp_min":4.16,"temp_max":4.16,"pressure":991.96,"sea_level":1038.19,"grnd_level":991.96,"humidity":92,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10d"}],"clouds":{"all":56},"wind":{"speed":7.76,"deg":300},"rain":{"3h":0.34},"snow":{},"sys":{"pod":"d"},"dt_txt":"2018-12-30 12:00:00"},{"dt":1546182000,"main":{"temp":3.45,"temp_min":3.45,"temp_max":3.45,"pressure":992.95,"sea_level":1039.3,"grnd_level":992.95,"humidity":85,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10d"}],"clouds":{"all":68},"wind":{"speed":7.46,"deg":297.509},"rain":{"3h":0.14},"snow":{},"sys":{"pod":"d"},"dt_txt":"2018-12-30 15:00:00"},{"dt":1546192800,"main":{"temp":2.94,"temp_min":2.94,"temp_max":2.94,"pressure":992.64,"sea_level":1039.14,"grnd_level":992.64,"humidity":84,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10n"}],"clouds":{"all":68},"wind":{"speed":7.57,"deg":295.5},"rain":{"3h":0.105},"snow":{},"sys":{"pod":"n"},"dt_txt":"2018-12-30 18:00:00"},{"dt":1546203600,"main":{"temp":2.42,"temp_min":2.42,"temp_max":2.42,"pressure":992.44,"sea_level":1039.02,"grnd_level":992.44,"humidity":92,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10n"}],"clouds":{"all":88},"wind":{"speed":7.63,"deg":300.501},"rain":{"3h":0.615},"snow":{},"sys":{"pod":"n"},"dt_txt":"2018-12-30 21:00:00"},{"dt":1546214400,"main":{"temp":2.38,"temp_min":2.38,"temp_max":2.38,"pressure":992.87,"sea_level":1039.53,"grnd_level":992.87,"humidity":98,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10n"}],"clouds":{"all":92},"wind":{"speed":6.27,"deg":316},"rain":{"3h":1.38},"snow":{"3h":0.06},"sys":{"pod":"n"},"dt_txt":"2018-12-31 00:00:00"},{"dt":1546225200,"main":{"temp":2.53,"temp_min":2.53,"temp_max":2.53,"pressure":992.73,"sea_level":1039.38,"grnd_level":992.73,"humidity":93,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10n"}],"clouds":{"all":88},"wind":{"speed":5.72,"deg":325.004},"rain":{"3h":0.18},"snow":{"3h":0.155},"sys":{"pod":"n"},"dt_txt":"2018-12-31 03:00:00"},{"dt":1546236000,"main":{"temp":1.71,"temp_min":1.71,"temp_max":1.71,"pressure":993.12,"sea_level":1039.82,"grnd_level":993.12,"humidity":87,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10n"}],"clouds":{"all":44},"wind":{"speed":6.01,"deg":329.502},"rain":{"3h":0.02},"snow":{"3h":0.05},"sys":{"pod":"n"},"dt_txt":"2018-12-31 06:00:00"},{"dt":1546246800,"main":{"temp":1.52,"temp_min":1.52,"temp_max":1.52,"pressure":994.7,"sea_level":1041.38,"grnd_level":994.7,"humidity":89,"temp_kf":0},"weather":[{"id":800,"main":"Clear","description":"Klarer Himmel","icon":"01d"}],"clouds":{"all":80},"wind":{"speed":6.01,"deg":328},"rain":{},"snow":{"3h":0.01},"sys":{"pod":"d"},"dt_txt":"2018-12-31 09:00:00"},{"dt":1546257600,"main":{"temp":1.49,"temp_min":1.49,"temp_max":1.49,"pressure":995.54,"sea_level":1042.17,"grnd_level":995.54,"humidity":89,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10d"}],"clouds":{"all":88},"wind":{"speed":6.11,"deg":331},"rain":{"3h":0.05},"snow":{"3h":0.07},"sys":{"pod":"d"},"dt_txt":"2018-12-31 12:00:00"},{"dt":1546268400,"main":{"temp":0.89,"temp_min":0.89,"temp_max":0.89,"pressure":998.03,"sea_level":1044.78,"grnd_level":998.03,"humidity":88,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10d"}],"clouds":{"all":88},"wind":{"speed":5.34,"deg":333.504},"rain":{"3h":0.02},"snow":{"3h":0.09},"sys":{"pod":"d"},"dt_txt":"2018-12-31 15:00:00"},{"dt":1546279200,"main":{"temp":0.24,"temp_min":0.24,"temp_max":0.24,"pressure":1000.23,"sea_level":1047.32,"grnd_level":1000.23,"humidity":85,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10n"}],"clouds":{"all":68},"wind":{"speed":5.16,"deg":329.003},"rain":{"3h":0.010000000000001},"snow":{"3h":0.08},"sys":{"pod":"n"},"dt_txt":"2018-12-31 18:00:00"},{"dt":1546290000,"main":{"temp":-0.41,"temp_min":-0.41,"temp_max":-0.41,"pressure":1001.72,"sea_level":1049.09,"grnd_level":1001.72,"humidity":86,"temp_kf":0},"weather":[{"id":600,"main":"Snow","description":"Mäßiger Schnee","icon":"13n"}],"clouds":{"all":56},"wind":{"speed":5.11,"deg":323.501},"rain":{},"snow":{"3h":0.05},"sys":{"pod":"n"},"dt_txt":"2018-12-31 21:00:00"},{"dt":1546300800,"main":{"temp":-1.15,"temp_min":-1.15,"temp_max":-1.15,"pressure":1002.51,"sea_level":1049.93,"grnd_level":1002.51,"humidity":86,"temp_kf":0},"weather":[{"id":800,"main":"Clear","description":"Klarer Himmel","icon":"01n"}],"clouds":{"all":48},"wind":{"speed":4.71,"deg":321.5},"rain":{},"snow":{"3h":0.01},"sys":{"pod":"n"},"dt_txt":"2019-01-01 00:00:00"},{"dt":1546311600,"main":{"temp":-1.47,"temp_min":-1.47,"temp_max":-1.47,"pressure":1001.38,"sea_level":1049.03,"grnd_level":1001.38,"humidity":82,"temp_kf":0},"weather":[{"id":800,"main":"Clear","description":"Klarer Himmel","icon":"02n"}],"clouds":{"all":8},"wind":{"speed":4.11,"deg":312.5},"rain":{},"snow":{},"sys":{"pod":"n"},"dt_txt":"2019-01-01 03:00:00"},{"dt":1546322400,"main":{"temp":-0.88,"temp_min":-0.88,"temp_max":-0.88,"pressure":999.87,"sea_level":1047.63,"grnd_level":999.87,"humidity":78,"temp_kf":0},"weather":[{"id":801,"main":"Clouds","description":"Ein paar Wolken","icon":"02n"}],"clouds":{"all":20},"wind":{"speed":4.01,"deg":298.501},"rain":{},"snow":{},"sys":{"pod":"n"},"dt_txt":"2019-01-01 06:00:00"},{"dt":1546333200,"main":{"temp":1.3,"temp_min":1.3,"temp_max":1.3,"pressure":998.44,"sea_level":1045.8,"grnd_level":998.44,"humidity":81,"temp_kf":0},"weather":[{"id":800,"main":"Clear","description":"Klarer Himmel","icon":"02d"}],"clouds":{"all":8},"wind":{"speed":5.21,"deg":291.006},"rain":{},"snow":{},"sys":{"pod":"d"},"dt_txt":"2019-01-01 09:00:00"},{"dt":1546344000,"main":{"temp":3.75,"temp_min":3.75,"temp_max":3.75,"pressure":995.76,"sea_level":1042.54,"grnd_level":995.76,"humidity":76,"temp_kf":0},"weather":[{"id":800,"main":"Clear","description":"Klarer Himmel","icon":"01d"}],"clouds":{"all":0},"wind":{"speed":5.56,"deg":289.002},"rain":{},"snow":{},"sys":{"pod":"d"},"dt_txt":"2019-01-01 12:00:00"},{"dt":1546354800,"main":{"temp":3.4,"temp_min":3.4,"temp_max":3.4,"pressure":993.28,"sea_level":1040.11,"grnd_level":993.28,"humidity":73,"temp_kf":0},"weather":[{"id":801,"main":"Clouds","description":"Ein paar Wolken","icon":"02d"}],"clouds":{"all":12},"wind":{"speed":5.67,"deg":285.503},"rain":{},"snow":{},"sys":{"pod":"d"},"dt_txt":"2019-01-01 15:00:00"},{"dt":1546365600,"main":{"temp":2.88,"temp_min":2.88,"temp_max":2.88,"pressure":991.55,"sea_level":1038.26,"grnd_level":991.55,"humidity":80,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10n"}],"clouds":{"all":44},"wind":{"speed":6.81,"deg":289.002},"rain":{"3h":0.08},"snow":{},"sys":{"pod":"n"},"dt_txt":"2019-01-01 18:00:00"},{"dt":1546376400,"main":{"temp":3,"temp_min":3,"temp_max":3,"pressure":989.64,"sea_level":1036.16,"grnd_level":989.64,"humidity":81,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10n"}],"clouds":{"all":12},"wind":{"speed":7.36,"deg":288.004},"rain":{"3h":0.069999999999999},"snow":{},"sys":{"pod":"n"},"dt_txt":"2019-01-01 21:00:00"},{"dt":1546387200,"main":{"temp":3.46,"temp_min":3.46,"temp_max":3.46,"pressure":987.24,"sea_level":1033.68,"grnd_level":987.24,"humidity":79,"temp_kf":0},"weather":[{"id":800,"main":"Clear","description":"Klarer Himmel","icon":"01n"}],"clouds":{"all":0},"wind":{"speed":8.61,"deg":289.001},"rain":{},"snow":{},"sys":{"pod":"n"},"dt_txt":"2019-01-02 00:00:00"},{"dt":1546398000,"main":{"temp":3.62,"temp_min":3.62,"temp_max":3.62,"pressure":985.64,"sea_level":1031.87,"grnd_level":985.64,"humidity":81,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10n"}],"clouds":{"all":36},"wind":{"speed":8.96,"deg":294.503},"rain":{"3h":0.24},"snow":{},"sys":{"pod":"n"},"dt_txt":"2019-01-02 03:00:00"},{"dt":1546408800,"main":{"temp":3.31,"temp_min":3.31,"temp_max":3.31,"pressure":986.21,"sea_level":1032.51,"grnd_level":986.21,"humidity":87,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10n"}],"clouds":{"all":88},"wind":{"speed":8.42,"deg":311.5},"rain":{"3h":0.52},"snow":{},"sys":{"pod":"n"},"dt_txt":"2019-01-02 06:00:00"},{"dt":1546419600,"main":{"temp":2.05,"temp_min":2.05,"temp_max":2.05,"pressure":987.92,"sea_level":1034.4,"grnd_level":987.92,"humidity":94,"temp_kf":0},"weather":[{"id":500,"main":"Rain","description":"Leichter Regen","icon":"10d"}],"clouds":{"all":80},"wind":{"speed":7.51,"deg":327.002},"rain":{"3h":0.59},"snow":{"3h":0.38},"sys":{"pod":"d"},"dt_txt":"2019-01-02 09:00:00"}],"city":{"id":2768348,"name":"Pressbaum","coord":{"lat":48.1833,"lon":16.0833},"country":"AT"}}
Code:
\"dt\":.*?\"dt_txt\":\".*?\"
Um mich heranzutasten, habe ich mal versucht, eine ganz einfache Regular Expression einzugeben:
Code:
mess
(Gesamt: 1) (Work: 0) (Typ: RegExp) (OK: 0) |
Gruß
GKap
Kommentar