Guten Abend Zusammen,
seit gestern bin ich auch am rätseln, wie man so ein JSON Objekt "zerlegen" kann.
Es geht bei mir auch um die Tibber-Preise (aktuell) und die zukünftigen (morgen).
Die Daten kommen auch als JSONArray an, allerdings fehlt mir die Ahnung, wie ich daraus einen Wert "auswerten" kann.
Die Werte die als String über die API kommen sehen für den heutigen Tag (07.12.2023) so aus:
Code: Alles auswählen
[{"startsAt":"2023-12-07T00:00:00.000+01:00","total":0.2745},
{"startsAt":"2023-12-07T01:00:00.000+01:00","total":0.2729},
{"startsAt":"2023-12-07T02:00:00.000+01:00","total":0.2717},
{"startsAt":"2023-12-07T03:00:00.000+01:00","total":0.2657},
{"startsAt":"2023-12-07T04:00:00.000+01:00","total":0.2635},
{"startsAt":"2023-12-07T05:00:00.000+01:00","total":0.269},
{"startsAt":"2023-12-07T06:00:00.000+01:00","total":0.2952},
{"startsAt":"2023-12-07T07:00:00.000+01:00","total":0.3126},
{"startsAt":"2023-12-07T08:00:00.000+01:00","total":0.335},
{"startsAt":"2023-12-07T09:00:00.000+01:00","total":0.3203},
{"startsAt":"2023-12-07T10:00:00.000+01:00","total":0.3163},
{"startsAt":"2023-12-07T11:00:00.000+01:00","total":0.3209},
{"startsAt":"2023-12-07T12:00:00.000+01:00","total":0.3207},
{"startsAt":"2023-12-07T13:00:00.000+01:00","total":0.3211},
{"startsAt":"2023-12-07T14:00:00.000+01:00","total":0.3208},
{"startsAt":"2023-12-07T15:00:00.000+01:00","total":0.3207},
{"startsAt":"2023-12-07T16:00:00.000+01:00","total":0.3158},
{"startsAt":"2023-12-07T17:00:00.000+01:00","total":0.3095},
{"startsAt":"2023-12-07T18:00:00.000+01:00","total":0.2997},
{"startsAt":"2023-12-07T19:00:00.000+01:00","total":0.2804},
{"startsAt":"2023-12-07T20:00:00.000+01:00","total":0.2759},
{"startsAt":"2023-12-07T21:00:00.000+01:00","total":0.2719},
{"startsAt":"2023-12-07T22:00:00.000+01:00","total":0.2712},
{"startsAt":"2023-12-07T23:00:00.000+01:00","total":0.2601}]
Für den morgigen Tag (08.12.2023) sieht der String so aus:
Code: Alles auswählen
[{"startsAt":"2023-12-08T00:00:00.000+01:00","total":0.2601},
{"startsAt":"2023-12-08T01:00:00.000+01:00","total":0.2555},
{"startsAt":"2023-12-08T02:00:00.000+01:00","total":0.2534},
{"startsAt":"2023-12-08T03:00:00.000+01:00","total":0.2511},
{"startsAt":"2023-12-08T04:00:00.000+01:00","total":0.2517},
{"startsAt":"2023-12-08T05:00:00.000+01:00","total":0.26},
{"startsAt":"2023-12-08T06:00:00.000+01:00","total":0.2751},
{"startsAt":"2023-12-08T07:00:00.000+01:00","total":0.2841},
{"startsAt":"2023-12-08T08:00:00.000+01:00","total":0.2905},
{"startsAt":"2023-12-08T09:00:00.000+01:00","total":0.2975},
{"startsAt":"2023-12-08T10:00:00.000+01:00","total":0.2978},
{"startsAt":"2023-12-08T11:00:00.000+01:00","total":0.2969},
{"startsAt":"2023-12-08T12:00:00.000+01:00","total":0.2953},
{"startsAt":"2023-12-08T13:00:00.000+01:00","total":0.2895},
{"startsAt":"2023-12-08T14:00:00.000+01:00","total":0.2911},
{"startsAt":"2023-12-08T15:00:00.000+01:00","total":0.2973},
{"startsAt":"2023-12-08T16:00:00.000+01:00","total":0.2933},
{"startsAt":"2023-12-08T17:00:00.000+01:00","total":0.2969},
{"startsAt":"2023-12-08T18:00:00.000+01:00","total":0.2976},
{"startsAt":"2023-12-08T19:00:00.000+01:00","total":0.2821},
{"startsAt":"2023-12-08T20:00:00.000+01:00","total":0.281},
{"startsAt":"2023-12-08T21:00:00.000+01:00","total":0.2768},
{"startsAt":"2023-12-08T22:00:00.000+01:00","total":0.2775},
{"startsAt":"2023-12-08T23:00:00.000+01:00","total":0.2643}]
Mein "gescheiteter-Versuch" mit dem Ausdruck $startsAt.+01total war erfolglos.
Kann jemand helfen?
Liebe Grüße
Tim
Openhab3 auf einem Raspberry-PI4, Wemos D1 mini über MQTT, AVM Fritz!, Wifi LED, Diverse Shelly Produkte, Gardena Smart Produkte, Reolink-IP Cams, Wansview-IP Cams, Foscam-IP Cams.