Ich bin auf keinen besseren Titel gekommen. Ich brauch etwas Hilfe bei der Interpretation von Daten aus einem HTTP-API und wie ich diese in die InfluxDB kriege.
Was will ich machen?
Daten aus einem PM10 (Smog) Sensor in die InfluxDB und weiter in Grafana bringen
Welche Daten
Ich bekomme die Daten ueber die API als Stunden-Durchschnitt. Hier der API-Link.
Code: Alles auswählen
{"key":"PM10","values":[{"date":"2024-04-14 00:00:00","value":null},{"date":"2024-04-13 23:00:00","value":null},{"date":"2024-04-13 22:00:00","value":47.1014},{"date":"2024-04-13 21:00:00","value":29.4315},{"date":"2024-04-13 20:00:00","value":26.969},{"date":"2024-04-13 19:00:00","value":19.2261},{"date":"2024-04-13 18:00:00","value":13.6227},{"date":"2024-04-13 17:00:00","value":17.4531},{"date":"2024-04-13 16:00:00","value":15.408},{"date":"2024-04-13 15:00:00","value":19.6642},{"date":"2024-04-13 14:00:00","value":22.4598},{"date":"2024-04-13 13:00:00","value":20.917},{"date":"2024-04-13 12:00:00","value":22.4817},{"date":"2024-04-13 11:00:00","value":26.0218},{"date":"2024-04-13 10:00:00","value":28.5203},{"date":"2024-04-13 09:00:00","value":30.0228},{"date":"2024-04-13 08:00:00","value":34.3197},{"date":"2024-04-13 07:00:00","value":39.7655},{"date":"2024-04-13 06:00:00","value":45.2811},{"date":"2024-04-13 05:00:00","value":40.2013},{"date":"2024-04-13 04:00:00","value":39.4061},{"date":"2024-04-13 03:00:00","value":39.4717},{"date":"2024-04-13 02:00:00","value":45.1994},{"date":"2024-04-13 01:00:00","value":53.3304},{"date":"2024-04-13 00:00:00","value":49.5936},{"date":"2024-04-12 23:00:00","value":44.5269},{"date":"2024-04-12 22:00:00","value":45.888},{"date":"2024-04-12 21:00:00","value":null},{"date":"2024-04-12 20:00:00","value":25.8567},{"date":"2024-04-12 19:00:00","value":30.6745},{"date":"2024-04-12 18:00:00","value":25.3573},{"date":"2024-04-12 17:00:00","value":25.2729},{"date":"2024-04-12 16:00:00","value":18.7357},{"date":"2024-04-12 15:00:00","value":21.3768},{"date":"2024-04-12 14:00:00","value":20.8551},{"date":"2024-04-12 13:00:00","value":17.1416},{"date":"2024-04-12 12:00:00","value":21.2267},{"date":"2024-04-12 11:00:00","value":30.914},{"date":"2024-04-12 10:00:00","value":43.5125},{"date":"2024-04-12 09:00:00","value":61.0938},{"date":"2024-04-12 08:00:00","value":65.0691},{"date":"2024-04-12 07:00:00","value":53.0703},{"date":"2024-04-12 06:00:00","value":50.2484},{"date":"2024-04-12 05:00:00","value":45.0144},{"date":"2024-04-12 04:00:00","value":44.6426},{"date":"2024-04-12 03:00:00","value":44.7471},{"date":"2024-04-12 02:00:00","value":42.7786},{"date":"2024-04-12 01:00:00","value":null}]}
Code: Alles auswählen
values[1].value
Was ist denn dann das Problem?
Vielleicht ist es nur ein Verstaendnissproblem. Soll ich nur den "value" in die Influxdb schreiben? Und den Timestamp generiert die DB? Oder lieber beides? Aber kann ich dann diesen Timestamp fuer die Zeitachse bei Grafana nutzen?
Oder einfach besser die Transaktion alle 60 Minuten laufen lassen, und dann so getimed dass es zur vollen Stude ist? Dann waeren die Timestamps aus dem JSON und in der InfluxDB ja mehr oder weniger synchronisiert.
Danke fuer Eure Hilfe!
Aleksander