NEWS
Daten aus Url abfragen und in Datenpunkt schreiben
-
-
Hallo, ich versuche gerade aus einer Url einen Datenpunkt zu beschreiben.(Strompreis) Leider mache ich da was falsch. Ich habe mich einer alten Anleitung von paul53 bedient. Jedoch stimmt da was bei der Attributsabfrage nicht.
Danke vorab für die Lösung!
https://apis.smartenergy.at/market/v1/price

18:26:00.502 error javascript.0 (451) script.js.Verschiedenes.Strompreis_Abfrage: Cannot get value of undefined -
-
@keksn
Die API liefert unter "data" eine Liste mit 192 Objekten, beginnend heute um 0:00 Uhr für alle 15 Minuten. Es muss also ganz anders gehandhabt werden.
Sollen 192 Datenpunkte befüllt werden?
-
@keksn sagte: nur den Strompreis sonst nichts, also nur einer.
Welchen? Den von der aktuellen Uhrzeit?
-
-
meintest Du so ?...DANKE für die Hilfe! Denke Paul hilft mir schon bist zur Lösung.
@keksn sagte in Daten aus Url abfragen und in Datenpunkt schreiben:
Denke Paul hilft mir schon bist zur Lösung.
klar tut er das, aber ich wollte dir auch zeigen wie du es beim nächsten mal selbst schaffen kannst!
@keksn sagte in Daten aus Url abfragen und in Datenpunkt schreiben:
meintest Du so ?..
ja!
und bitte den logeintrag dazu hier posten -
@paul53 sagte in Daten aus Url abfragen und in Datenpunkt schreiben:
Den von der aktuellen Uhrzeit?
Ja genau den aktuellen.
-
@keksn sagte in Daten aus Url abfragen und in Datenpunkt schreiben:
Das wäre mir zu schwierig gewesen...
nöö, du weisst nur nicht was dahintersteckt
-
@keksn sagte in Daten aus Url abfragen und in Datenpunkt schreiben:
Denke Paul hilft mir schon bist zur Lösung.
klar tut er das, aber ich wollte dir auch zeigen wie du es beim nächsten mal selbst schaffen kannst!
@keksn sagte in Daten aus Url abfragen und in Datenpunkt schreiben:
meintest Du so ?..
ja!
und bitte den logeintrag dazu hier posten@homoran Du erwartest Dir ein wenig zu viel

javascript.0 (451) script.js.Verschiedenes.Strompreisabfrage: {"tariff":"EPEXSPOTAT","unit":"ct/kWh","interval":15,"data":[{"date":"2023-10-26T00:00:00+02:00","value":10.872},{"date":"2023-10-26T00:15:00+02:00","value":10.872},{"date":"2023-10-26T00:30:00+02:00","value":10.872},{"date":"2023-10-26T00:45:00+02:00","value":10.872},{"date":"2023-10-26T01:00:00+02:00","value":10.945},{"date":"2023-10-26T01:15:00+02:00","value":10.945},{"date":"2023-10-26T01:30:00+02:00","value":10.945},{"date":"2023-10-26T01:45:00+02:00","value":10.945},{"date":"2023-10-26T02:00:00+02:00","value":10.720},{"date":"2023-10-26T02:15:00+02:00","value":10.720},{"date":"2023-10-26T02:30:00+02:00","value":10.720},{"date":"2023-10-26T02:45:00+02:00","value":10.720},{"date":"2023-10-26T03:00:00+02:00","value":10.574},{"date":"2023-10-26T03:15:00+02:00","value":10.574},{"date":"2023-10-26T03:30:00+02:00","value":10.574},{"date":"2023-10-26T03:45:00+02:00","value":10.574},{"date":"2023-10-26T04:00:00+02:00","value":10.867},{"date":"2023-10-26T04:15:00+02:00","value":10.867},{"date":"2023-10-26T04:30:00+02:00","value":10.867},{"date":"2023-10-26T04:45:00+02:00","value":10.867},{"date":"2023-10-26T05:00:00+02:00","value":12.000},{"date":"2023-10-26T05:15:00+02:00","value":12.000},{"date":"2023-10-26T05:30:00+02:00","value":12.000},{"date":"2023-10-26T05:45:00+02:00","value":12.000},{"date":"2023-10-26T06:00:00+02:00","value":14.753},{"date":"2023-10-26T06:15:00+02:00","value":14.753},{"date":"2023-10-26T06:30:00+02:00","value":14.753},{"date":"2023-10-26T06:45:00+02:00","value":14.753},{"date":"2023-10-26T07:00:00+02:00","value":15.583},{"date":"2023-10-26T07:15:00+02:00","value":15.583},{"date":"2023-10-26T07:30:00+02:00","value":15.583},{"date":"2023-10-26T07:45:00+02:00","value":15.583},{"date":"2023-10-26T08:00:00+02:00","value":16.933},{"date":"2023-10-26T08:15:00+02:00","value":16.933},{"date":"2023-10-26T08:30:00+02:00","value":16.933},{"date":"2023-10-26T08:45:00+02:00","value":16.933},{"date":"2023-10-26T09:00:00+02:00","value":17.880},{"date":"2023-10-26T09:15:00+02:00","value":17.880},{"date":"2023-10-26T09:30:00+02:00","value":17.880},{"date":"2023-10-26T09:45:00+02:00","value":17.880},{"date":"2023-10-26T10:00:00+02:00","value":17.564},{"date":"2023-10-26T10:15:00+02:00","value":17.564},{"date":"2023-10-26T10:30:00+02:00","value":17.564},{"date":"2023-10-26T10:45:00+02:00","value":17.564},{"date":"2023-10-26T11:00:00+02:00","value":16.800},{"date":"2023-10-26T11:15:00+02:00","value":16.800},{"date":"2023-10-26T11:30:00+02:00","value":16.800},{"date":"2023-10-26T11:45:00+02:00","value":16.800},{"date":"2023-10-26T12:00:00+02:00","value":15.733},{"date":"2023-10-26T12:15:00+02:00","value":15.733},{"date":"2023-10-26T12:30:00+02:00","value":15.733},{"date":"2023-10-26T12:45:00+02:00","value":15.733},{"date":"2023-10-26T13:00:00+02:00","value":14.411},{"date":"2023-10-26T13:15:00+02:00","value":14.411},{"date":"2023-10-26T13:30:00+02:00","value":14.411},{"date":"2023-10-26T13:45:00+02:00","value":14.411},{"date":"2023-10-26T14:00:00+02:00","value":14.352},{"date":"2023-10-26T14:15:00+02:00","value":14.352},{"date":"2023-10-26T14:30:00+02:00","value":14.352},{"date":"2023-10-26T14:45:00+02:00","value":14.352},{"date":"2023-10-26T15:00:00+02:00","value":14.527},{"date":"2023-10-26T15:15:00+02:00","value":14.527},{"date":"2023-10-26T15:30:00+02:00","value":14.527},{"date":"2023-10-26T15:45:00+02:00","value":14.527},{"date":"2023-10-26T16:00:00+02:00","value":15.461},{"date":"2023-10-26T16:15:00+02:00","value":15.461},{"date":"2023-10-26T16:30:00+02:00","value":15.461},{"date":"2023-10-26T16:45:00+02:00","value":15.461},{"date":"2023-10-26T17:00:00+02:00","value":16.812},{"date":"2023-10-26T17:15:00+02:00","value":16.812},{"date":"2023-10-26T17:30:00+02:00","value":16.812},{"date":"2023-10-26T17:45:00+02:00","value":16.812},{"date":"2023-10-26T18:00:00+02:00","value":17.725},{"date":"2023-10-26T18:15:00+02:00","value":17.725},{"date":"2023-10-26T18:30:00+02:00","value":17.725},{"date":"2023-10-26T18:45:00+02:00","value":17.725},{"date":"2023-10-26T19:00:00+02:00","value":18.251},{"date":"2023-10-26T19:15:00+02:00","value":18.251},{"date":"2023-10-26T19:30:00+02:00","value":18.251},{"date":"2023-10-26T19:45:00+02:00","value":18.251},{"date":"2023-10-26T20:00:00+02:00","value":16.188},{"date":"2023-10-26T20:15:00+02:00","value":16.188},{"date":"2023-10-26T20:30:00+02:00","value":16.188},{"date":"2023-10-26T20:45:00+02:00","value":16.188},{"date":"2023-10-26T21:00:00+02:00","value":14.484},{"date":"2023-10-26T21:15:00+02:00","value":14.484},{"date":"2023-10-26T21:30:00+02:00","value":14.484},{"date":"2023-10-26T21:45:00+02:00","value":14.484},{"date":"2023-10-26T22:00:00+02:00","value":14.047},{"date":"2023-10-26T22:15:00+02:00","value":14.047},{"date":"2023-10-26T22:30:00+02:00","value":14.047},{"date":"2023-10-26T22:45:00+02:00","value":14.047},{"date":"2023-10-26T23:00:00+02:00","value":12.582},{"date":"2023-10-26T23:15:00+02:00","value":12.582},{"date":"2023-10-26T23:30:00+02:00","value":12.582},{"date":"2023-10-26T23:45:00+02:00","value":12.582},{"date":"2023-10-27T00:00:00+02:00","value":12.547},{"date":"2023-10-27T00:15:00+02:00","value":12.547},{"date":"2023-10-27T00:30:00+02:00","value":12.547},{"date":"2023-10-27T00:45:00+02:00","value":12.547},{"date":"2023-10-27T01:00:00+02:00","value":11.632},{"date":"2023-10-27T01:15:00+02:00","value":11.632},{"date":"2023-10-27T01:30:00+02:00","value":11.632},{"date":"2023-10-27T01:45:00+02:00","value":11.632},{"date":"2023-10-27T02:00:00+02:00","value":11.052},{"date":"2023-10-27T02:15:00+02:00","value":11.052},{"date":"2023-10-27T02:30:00+02:00","value":11.052},{"date":"2023-10-27T02:45:00+02:00","value":11.052},{"date":"2023-10-27T03:00:00+02:00","value":10.745},{"date":"2023-10-27T03:15:00+02:00","value":10.745},{"date":"2023-10-27T03:30:00+02:00","value":10.745},{"date":"2023-10-27T03:45:00+02:00","value":10.745},{"date":"2023-10-27T04:00:00+02:00","value":10.763},{"date":"2023-10-27T04:15:00+02:00","value":10.763},{"date":"2023-10-27T04:30:00+02:00","value":10.763},{"date":"2023-10-27T04:45:00+02:00","value":10.763},{"date":"2023-10-27T05:00:00+02:00","value":11.831},{"date":"2023-10-27T05:15:00+02:00","value":11.831},{"date":"2023-10-27T05:30:00+02:00","value":11.831},{"date":"2023-10-27T05:45:00+02:00","value":11.831},{"date":"2023-10-27T06:00:00+02:00","value":14.850},{"date":"2023-10-27T06:15:00+02:00","value":14.850},{"date":"2023-10-27T06:30:00+02:00","value":14.850},{"date":"2023-10-27T06:45:00+02:00","value":14.850},{"date":"2023-10-27T07:00:00+02:00","value":17.245},{"date":"2023-10-27T07:15:00+02:00","value":17.245},{"date":"2023-10-27T07:30:00+02:00","value":17.245},{"date":"2023-10-27T07:45:00+02:00","value":17.245},{"date":"2023-10-27T08:00:00+02:00","value":18.540},{"date":"2023-10-27T08:15:00+02:00","value":18.540},{"date":"2023-10-27T08:30:00+02:00","value":18.540},{"date":"2023-10-27T08:45:00+02:00","value":18.540},{"date":"2023-10-27T09:00:00+02:00","value":18.324},{"date":"2023-10-27T09:15:00+02:00","value":18.324},{"date":"2023-10-27T09:30:00+02:00","value":18.324},{"date":"2023-10-27T09:45:00+02:00","value":18.324},{"date":"2023-10-27T10:00:00+02:00","value":17.045},{"date":"2023-10-27T10:15:00+02:00","value":17.045},{"date":"2023-10-27T10:30:00+02:00","value":17.045},{"date":"2023-10-27T10:45:00+02:00","value":17.045},{"date":"2023-10-27T11:00:00+02:00","value":15.877},{"date":"2023-10-27T11:15:00+02:00","value":15.877},{"date":"2023-10-27T11:30:00+02:00","value":15.877},{"date":"2023-10-27T11:45:00+02:00","value":15.877},{"date":"2023-10-27T12:00:00+02:00","value":14.312},{"date":"2023-10-27T12:15:00+02:00","value":14.312},{"date":"2023-10-27T12:30:00+02:00","value":14.312},{"date":"2023-10-27T12:45:00+02:00","value":14.312},{"date":"2023-10-27T13:00:00+02:00","value":13.459},{"date":"2023-10-27T13:15:00+02:00","value":13.459},{"date":"2023-10-27T13:30:00+02:00","value":13.459},{"date":"2023-10-27T13:45:00+02:00","value":13.459},{"date":"2023-10-27T14:00:00+02:00","value":12.523},{"date":"2023-10-27T14:15:00+02:00","value":12.523},{"date":"2023-10-27T14:30:00+02:00","value":12.523},{"date":"2023-10-27T14:45:00+02:00","value":12.523},{"date":"2023-10-27T15:00:00+02:00","value":13.440},{"date":"2023-10-27T15:15:00+02:00","value":13.440},{"date":"2023-10-27T15:30:00+02:00","value":13.440},{"date":"2023-10-27T15:45:00+02:00","value":13.440},{"date":"2023-10-27T16:00:00+02:00","value":14.749},{"date":"2023-10-27T16:15:00+02:00","value":14.749},{"date":"2023-10-27T16:30:00+02:00","value":14.749},{"date":"2023-10-27T16:45:00+02:00","value":14.749},{"date":"2023-10-27T17:00:00+02:00","value":15.824},{"date":"2023-10-27T17:15:00+02:00","value":15.824},{"date":"2023-10-27T17:30:00+02:00","value":15.824},{"date":"2023-10-27T17:45:00+02:00","value":15.824},{"date":"2023-10-27T18:00:00+02:00","value":17.276},{"date":"2023-10-27T18:15:00+02:00","value":17.276},{"date":"2023-10-27T18:30:00+02:00","value":17.276},{"date":"2023-10-27T18:45:00+02:00","value":17.276},{"date":"2023-10-27T19:00:00+02:00","value":17.252},{"date":"2023-10-27T19:15:00+02:00","value":17.252},{"date":"2023-10-27T19:30:00+02:00","value":17.252},{"date":"2023-10-27T19:45:00+02:00","value":17.252},{"date":"2023-10-27T20:00:00+02:00","value":15.080},{"date":"2023-10-27T20:15:00+02:00","value":15.080},{"date":"2023-10-27T20:30:00+02:00","value":15.080},{"date":"2023-10-27T20:45:00+02:00","value":15.080},{"date":"2023-10-27T21:00:00+02:00","value":12.329},{"date":"2023-10-27T21:15:00+02:00","value":12.329},{"date":"2023-10-27T21:30:00+02:00","value":12.329},{"date":"2023-10-27T21:45:00+02:00","value":12.329},{"date":"2023-10-27T22:00:00+02:00","value":11.724},{"date":"2023-10-27T22:15:00+02:00","value":11.724},{"date":"2023-10-27T22:30:00+02:00","value":11.724},{"date":"2023-10-27T22:45:00+02:00","value":11.724},{"date":"2023-10-27T23:00:00+02:00","value":11.244},{"date":"2023-10-27T23:15:00+02:00","value":11.244},{"date":"2023-10-27T23:30:00+02:00","value":11.244},{"date":"2023-10-27T23:45:00+02:00","value":11.244}]} 19:15:00.178 debug mqtt.0 (575) stateChange javascript.0.Meine_Datenpunkte.Energie.Strompreis: {"val":null,"ack":true,"ts":1698340500174,"q":0,"c":"script.js.Verschiedenes.Strompreisabfrage","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1698340500174} -
@homoran Du erwartest Dir ein wenig zu viel

javascript.0 (451) script.js.Verschiedenes.Strompreisabfrage: {"tariff":"EPEXSPOTAT","unit":"ct/kWh","interval":15,"data":[{"date":"2023-10-26T00:00:00+02:00","value":10.872},{"date":"2023-10-26T00:15:00+02:00","value":10.872},{"date":"2023-10-26T00:30:00+02:00","value":10.872},{"date":"2023-10-26T00:45:00+02:00","value":10.872},{"date":"2023-10-26T01:00:00+02:00","value":10.945},{"date":"2023-10-26T01:15:00+02:00","value":10.945},{"date":"2023-10-26T01:30:00+02:00","value":10.945},{"date":"2023-10-26T01:45:00+02:00","value":10.945},{"date":"2023-10-26T02:00:00+02:00","value":10.720},{"date":"2023-10-26T02:15:00+02:00","value":10.720},{"date":"2023-10-26T02:30:00+02:00","value":10.720},{"date":"2023-10-26T02:45:00+02:00","value":10.720},{"date":"2023-10-26T03:00:00+02:00","value":10.574},{"date":"2023-10-26T03:15:00+02:00","value":10.574},{"date":"2023-10-26T03:30:00+02:00","value":10.574},{"date":"2023-10-26T03:45:00+02:00","value":10.574},{"date":"2023-10-26T04:00:00+02:00","value":10.867},{"date":"2023-10-26T04:15:00+02:00","value":10.867},{"date":"2023-10-26T04:30:00+02:00","value":10.867},{"date":"2023-10-26T04:45:00+02:00","value":10.867},{"date":"2023-10-26T05:00:00+02:00","value":12.000},{"date":"2023-10-26T05:15:00+02:00","value":12.000},{"date":"2023-10-26T05:30:00+02:00","value":12.000},{"date":"2023-10-26T05:45:00+02:00","value":12.000},{"date":"2023-10-26T06:00:00+02:00","value":14.753},{"date":"2023-10-26T06:15:00+02:00","value":14.753},{"date":"2023-10-26T06:30:00+02:00","value":14.753},{"date":"2023-10-26T06:45:00+02:00","value":14.753},{"date":"2023-10-26T07:00:00+02:00","value":15.583},{"date":"2023-10-26T07:15:00+02:00","value":15.583},{"date":"2023-10-26T07:30:00+02:00","value":15.583},{"date":"2023-10-26T07:45:00+02:00","value":15.583},{"date":"2023-10-26T08:00:00+02:00","value":16.933},{"date":"2023-10-26T08:15:00+02:00","value":16.933},{"date":"2023-10-26T08:30:00+02:00","value":16.933},{"date":"2023-10-26T08:45:00+02:00","value":16.933},{"date":"2023-10-26T09:00:00+02:00","value":17.880},{"date":"2023-10-26T09:15:00+02:00","value":17.880},{"date":"2023-10-26T09:30:00+02:00","value":17.880},{"date":"2023-10-26T09:45:00+02:00","value":17.880},{"date":"2023-10-26T10:00:00+02:00","value":17.564},{"date":"2023-10-26T10:15:00+02:00","value":17.564},{"date":"2023-10-26T10:30:00+02:00","value":17.564},{"date":"2023-10-26T10:45:00+02:00","value":17.564},{"date":"2023-10-26T11:00:00+02:00","value":16.800},{"date":"2023-10-26T11:15:00+02:00","value":16.800},{"date":"2023-10-26T11:30:00+02:00","value":16.800},{"date":"2023-10-26T11:45:00+02:00","value":16.800},{"date":"2023-10-26T12:00:00+02:00","value":15.733},{"date":"2023-10-26T12:15:00+02:00","value":15.733},{"date":"2023-10-26T12:30:00+02:00","value":15.733},{"date":"2023-10-26T12:45:00+02:00","value":15.733},{"date":"2023-10-26T13:00:00+02:00","value":14.411},{"date":"2023-10-26T13:15:00+02:00","value":14.411},{"date":"2023-10-26T13:30:00+02:00","value":14.411},{"date":"2023-10-26T13:45:00+02:00","value":14.411},{"date":"2023-10-26T14:00:00+02:00","value":14.352},{"date":"2023-10-26T14:15:00+02:00","value":14.352},{"date":"2023-10-26T14:30:00+02:00","value":14.352},{"date":"2023-10-26T14:45:00+02:00","value":14.352},{"date":"2023-10-26T15:00:00+02:00","value":14.527},{"date":"2023-10-26T15:15:00+02:00","value":14.527},{"date":"2023-10-26T15:30:00+02:00","value":14.527},{"date":"2023-10-26T15:45:00+02:00","value":14.527},{"date":"2023-10-26T16:00:00+02:00","value":15.461},{"date":"2023-10-26T16:15:00+02:00","value":15.461},{"date":"2023-10-26T16:30:00+02:00","value":15.461},{"date":"2023-10-26T16:45:00+02:00","value":15.461},{"date":"2023-10-26T17:00:00+02:00","value":16.812},{"date":"2023-10-26T17:15:00+02:00","value":16.812},{"date":"2023-10-26T17:30:00+02:00","value":16.812},{"date":"2023-10-26T17:45:00+02:00","value":16.812},{"date":"2023-10-26T18:00:00+02:00","value":17.725},{"date":"2023-10-26T18:15:00+02:00","value":17.725},{"date":"2023-10-26T18:30:00+02:00","value":17.725},{"date":"2023-10-26T18:45:00+02:00","value":17.725},{"date":"2023-10-26T19:00:00+02:00","value":18.251},{"date":"2023-10-26T19:15:00+02:00","value":18.251},{"date":"2023-10-26T19:30:00+02:00","value":18.251},{"date":"2023-10-26T19:45:00+02:00","value":18.251},{"date":"2023-10-26T20:00:00+02:00","value":16.188},{"date":"2023-10-26T20:15:00+02:00","value":16.188},{"date":"2023-10-26T20:30:00+02:00","value":16.188},{"date":"2023-10-26T20:45:00+02:00","value":16.188},{"date":"2023-10-26T21:00:00+02:00","value":14.484},{"date":"2023-10-26T21:15:00+02:00","value":14.484},{"date":"2023-10-26T21:30:00+02:00","value":14.484},{"date":"2023-10-26T21:45:00+02:00","value":14.484},{"date":"2023-10-26T22:00:00+02:00","value":14.047},{"date":"2023-10-26T22:15:00+02:00","value":14.047},{"date":"2023-10-26T22:30:00+02:00","value":14.047},{"date":"2023-10-26T22:45:00+02:00","value":14.047},{"date":"2023-10-26T23:00:00+02:00","value":12.582},{"date":"2023-10-26T23:15:00+02:00","value":12.582},{"date":"2023-10-26T23:30:00+02:00","value":12.582},{"date":"2023-10-26T23:45:00+02:00","value":12.582},{"date":"2023-10-27T00:00:00+02:00","value":12.547},{"date":"2023-10-27T00:15:00+02:00","value":12.547},{"date":"2023-10-27T00:30:00+02:00","value":12.547},{"date":"2023-10-27T00:45:00+02:00","value":12.547},{"date":"2023-10-27T01:00:00+02:00","value":11.632},{"date":"2023-10-27T01:15:00+02:00","value":11.632},{"date":"2023-10-27T01:30:00+02:00","value":11.632},{"date":"2023-10-27T01:45:00+02:00","value":11.632},{"date":"2023-10-27T02:00:00+02:00","value":11.052},{"date":"2023-10-27T02:15:00+02:00","value":11.052},{"date":"2023-10-27T02:30:00+02:00","value":11.052},{"date":"2023-10-27T02:45:00+02:00","value":11.052},{"date":"2023-10-27T03:00:00+02:00","value":10.745},{"date":"2023-10-27T03:15:00+02:00","value":10.745},{"date":"2023-10-27T03:30:00+02:00","value":10.745},{"date":"2023-10-27T03:45:00+02:00","value":10.745},{"date":"2023-10-27T04:00:00+02:00","value":10.763},{"date":"2023-10-27T04:15:00+02:00","value":10.763},{"date":"2023-10-27T04:30:00+02:00","value":10.763},{"date":"2023-10-27T04:45:00+02:00","value":10.763},{"date":"2023-10-27T05:00:00+02:00","value":11.831},{"date":"2023-10-27T05:15:00+02:00","value":11.831},{"date":"2023-10-27T05:30:00+02:00","value":11.831},{"date":"2023-10-27T05:45:00+02:00","value":11.831},{"date":"2023-10-27T06:00:00+02:00","value":14.850},{"date":"2023-10-27T06:15:00+02:00","value":14.850},{"date":"2023-10-27T06:30:00+02:00","value":14.850},{"date":"2023-10-27T06:45:00+02:00","value":14.850},{"date":"2023-10-27T07:00:00+02:00","value":17.245},{"date":"2023-10-27T07:15:00+02:00","value":17.245},{"date":"2023-10-27T07:30:00+02:00","value":17.245},{"date":"2023-10-27T07:45:00+02:00","value":17.245},{"date":"2023-10-27T08:00:00+02:00","value":18.540},{"date":"2023-10-27T08:15:00+02:00","value":18.540},{"date":"2023-10-27T08:30:00+02:00","value":18.540},{"date":"2023-10-27T08:45:00+02:00","value":18.540},{"date":"2023-10-27T09:00:00+02:00","value":18.324},{"date":"2023-10-27T09:15:00+02:00","value":18.324},{"date":"2023-10-27T09:30:00+02:00","value":18.324},{"date":"2023-10-27T09:45:00+02:00","value":18.324},{"date":"2023-10-27T10:00:00+02:00","value":17.045},{"date":"2023-10-27T10:15:00+02:00","value":17.045},{"date":"2023-10-27T10:30:00+02:00","value":17.045},{"date":"2023-10-27T10:45:00+02:00","value":17.045},{"date":"2023-10-27T11:00:00+02:00","value":15.877},{"date":"2023-10-27T11:15:00+02:00","value":15.877},{"date":"2023-10-27T11:30:00+02:00","value":15.877},{"date":"2023-10-27T11:45:00+02:00","value":15.877},{"date":"2023-10-27T12:00:00+02:00","value":14.312},{"date":"2023-10-27T12:15:00+02:00","value":14.312},{"date":"2023-10-27T12:30:00+02:00","value":14.312},{"date":"2023-10-27T12:45:00+02:00","value":14.312},{"date":"2023-10-27T13:00:00+02:00","value":13.459},{"date":"2023-10-27T13:15:00+02:00","value":13.459},{"date":"2023-10-27T13:30:00+02:00","value":13.459},{"date":"2023-10-27T13:45:00+02:00","value":13.459},{"date":"2023-10-27T14:00:00+02:00","value":12.523},{"date":"2023-10-27T14:15:00+02:00","value":12.523},{"date":"2023-10-27T14:30:00+02:00","value":12.523},{"date":"2023-10-27T14:45:00+02:00","value":12.523},{"date":"2023-10-27T15:00:00+02:00","value":13.440},{"date":"2023-10-27T15:15:00+02:00","value":13.440},{"date":"2023-10-27T15:30:00+02:00","value":13.440},{"date":"2023-10-27T15:45:00+02:00","value":13.440},{"date":"2023-10-27T16:00:00+02:00","value":14.749},{"date":"2023-10-27T16:15:00+02:00","value":14.749},{"date":"2023-10-27T16:30:00+02:00","value":14.749},{"date":"2023-10-27T16:45:00+02:00","value":14.749},{"date":"2023-10-27T17:00:00+02:00","value":15.824},{"date":"2023-10-27T17:15:00+02:00","value":15.824},{"date":"2023-10-27T17:30:00+02:00","value":15.824},{"date":"2023-10-27T17:45:00+02:00","value":15.824},{"date":"2023-10-27T18:00:00+02:00","value":17.276},{"date":"2023-10-27T18:15:00+02:00","value":17.276},{"date":"2023-10-27T18:30:00+02:00","value":17.276},{"date":"2023-10-27T18:45:00+02:00","value":17.276},{"date":"2023-10-27T19:00:00+02:00","value":17.252},{"date":"2023-10-27T19:15:00+02:00","value":17.252},{"date":"2023-10-27T19:30:00+02:00","value":17.252},{"date":"2023-10-27T19:45:00+02:00","value":17.252},{"date":"2023-10-27T20:00:00+02:00","value":15.080},{"date":"2023-10-27T20:15:00+02:00","value":15.080},{"date":"2023-10-27T20:30:00+02:00","value":15.080},{"date":"2023-10-27T20:45:00+02:00","value":15.080},{"date":"2023-10-27T21:00:00+02:00","value":12.329},{"date":"2023-10-27T21:15:00+02:00","value":12.329},{"date":"2023-10-27T21:30:00+02:00","value":12.329},{"date":"2023-10-27T21:45:00+02:00","value":12.329},{"date":"2023-10-27T22:00:00+02:00","value":11.724},{"date":"2023-10-27T22:15:00+02:00","value":11.724},{"date":"2023-10-27T22:30:00+02:00","value":11.724},{"date":"2023-10-27T22:45:00+02:00","value":11.724},{"date":"2023-10-27T23:00:00+02:00","value":11.244},{"date":"2023-10-27T23:15:00+02:00","value":11.244},{"date":"2023-10-27T23:30:00+02:00","value":11.244},{"date":"2023-10-27T23:45:00+02:00","value":11.244}]} 19:15:00.178 debug mqtt.0 (575) stateChange javascript.0.Meine_Datenpunkte.Energie.Strompreis: {"val":null,"ack":true,"ts":1698340500174,"q":0,"c":"script.js.Verschiedenes.Strompreisabfrage","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1698340500174}@keksn sagte in Daten aus Url abfragen und in Datenpunkt schreiben:
Du erwartest Dir ein wenig zu viel
OK, in diesem Fall ist es etwas komplexer.
Dadurch dass du den richtigen Eintrag über seine Nummer suchen und diese über die aktuelle Zeit ausrechnen musst.Prinzipiell schnappst du dir so ein JSON, das der result liefert und kopierst es in die folgende Website

Dort wird dir die Struktur angezeigt, mit der du den gewünschten Wert erhältst.
hier leider 191 Viertelstunden, die nur über die laufende Nummer zu erreichen sind.
in den Datenpunkt schreibst du wie gehabt, anstelle des debug
-
Ich habe das jetzt genau so nachgebaut. Wie schreibe ich jetzt in meinem Datenpunkt?
-
@keksn sagte in Daten aus Url abfragen und in Datenpunkt schreiben:
Du erwartest Dir ein wenig zu viel
OK, in diesem Fall ist es etwas komplexer.
Dadurch dass du den richtigen Eintrag über seine Nummer suchen und diese über die aktuelle Zeit ausrechnen musst.Prinzipiell schnappst du dir so ein JSON, das der result liefert und kopierst es in die folgende Website

Dort wird dir die Struktur angezeigt, mit der du den gewünschten Wert erhältst.
hier leider 191 Viertelstunden, die nur über die laufende Nummer zu erreichen sind.
in den Datenpunkt schreibst du wie gehabt, anstelle des debug
-
@paul53 a ok, ich habe den Datenpunkt mit dem idx aktualisiert. Was muss ich noch umbauen dass ich nur den Wert ohne Datum und Uhrzeit in den Datenpunkt schreibe kann?
@keksn sagte in Daten aus Url abfragen und in Datenpunkt schreiben:
ich habe den Datenpunkt mit dem idx aktualisiert.
nein!
du nimmst die letzte Zeile und tauschst den debug Baustein gegen einen aktualisiere Baustein.fertig!
-
@homoran Ok Ihr seit da auf einem ganz anderem Level..komm eigentlich mit viel nachbauen und lesen meistens durch...denke da werde ich noch ein wenig auf das Wissen der Profis zurückgreifen wenn das möglich ist....

@keksn sagte in Daten aus Url abfragen und in Datenpunkt schreiben:
Ihr seit da auf einem ganz anderem Level.
da kommst du auch noch hin.
aber nicht nur
@keksn sagte in Daten aus Url abfragen und in Datenpunkt schreiben:
nachbauen und lesen
sondern auch lernen und verstehen (wollen)
-
@keksn sagte: Wie schreibe ich jetzt in meinem Datenpunkt?
Anstelle von "debug" nimm "aktualisiere". Das Attribut "value" separiert den Preis.

@paul53 ändert nichts das steht im Datenpunkt

{"tariff":"EPEXSPOTAT","unit":"ct/kWh","interval":15,"data":[{"date":"2023-10-26T00:00:00+02:00","value":10.872},{"date":"2023-10-26T00:15:00+02:00","value":10.872},{"date":"2023-10-26T00:30:00+02:00","value":10.872},{"date":"2023-10-26T00:45:00+02:00","value":10.872},{"date":"2023-10-26T01:00:00+02:00","value":10.945},{"date":"2023-10-26T01:15:00+02:00","value":10.945},{"date":"2023-10-26T01:30:00+02:00","value":10.945},{"date":"2023-10-26T01:45:00+02:00","value":10.945},{"date":"2023-10-26T02:00:00+02:00","value":10.720},{"date":"2023-10-26T02:15:00+02:00","value":10.720},{"date":"2023-10-26T02:30:00+02:00","value":10.720},{"date":"2023-10-26T02:45:00+02:00","value":10.720},{"date":"2023-10-26T03:00:00+02:00","value":10.574},{"date":"2023-10-26T03:15:00+02:00","value":10.574},{"date":"2023-10-26T03:30:00+02:00","value":10.574},{"date":"2023-10-26T03:45:00+02:00","value":10.574},{"date":"2023-10-26T04:00:00+02:00","value":10.867},{"date":"2023-10-26T04:15:00+02:00","value":10.867},{"date":"2023-10-26T04:30:00+02:00","value":10.867},{"date":"2023-10-26T04:45:00+02:00","value":10.867},{"date":"2023-10-26T05:00:00+02:00","value":12.000},{"date":"2023-10-26T05:15:00+02:00","value":12.000},{"date":"2023-10-26T05:30:00+02:00","value":12.000},{"date":"2023-10-26T05:45:00+02:00","value":12.000},{"date":"2023-10-26T06:00:00+02:00","value":14.753},{"date":"2023-10-26T06:15:00+02:00","value":14.753},{"date":"2023-10-26T06:30:00+02:00","value":14.753},{"date":"2023-10-26T06:45:00+02:00","value":14.753},{"date":"2023-10-26T07:00:00+02:00","value":15.583},{"date":"2023-10-26T07:15:00+02:00","value":15.583},{"date":"2023-10-26T07:30:00+02:00","value":15.583},{"date":"2023-10-26T07:45:00+02:00","value":15.583},{"date":"2023-10-26T08:00:00+02:00","value":16.933},{"date":"2023-10-26T08:15:00+02:00","value":16.933},{"date":"2023-10-26T08:30:00+02:00","value":16.933},{"date":"2023-10-26T08:45:00+02:00","value":16.933},{"date":"2023-10-26T09:00:00+02:00","value":17.880},{"date":"2023-10-26T09:15:00+02:00","value":17.880},{"date":"2023-10-26T09:30:00+02:00","value":17.880},{"date":"2023-10-26T09:45:00+02:00","value":17.880},{"date":"2023-10-26T10:00:00+02:00","value":17.564},{"date":"2023-10-26T10:15:00+02:00","value":17.564},{"date":"2023-10-26T10:30:00+02:00","value":17.564},{"date":"2023-10-26T10:45:00+02:00","value":17.564},{"date":"2023-10-26T11:00:00+02:00","value":16.800},{"date":"2023-10-26T11:15:00+02:00","value":16.800},{"date":"2023-10-26T11:30:00+02:00","value":16.800},{"date":"2023-10-26T11:45:00+02:00","value":16.800},{"date":"2023-10-26T12:00:00+02:00","value":15.733},{"date":"2023-10-26T12:15:00+02:00","value":15.733},{"date":"2023-10-26T12:30:00+02:00","value":15.733},{"date":"2023-10-26T12:45:00+02:00","value":15.733},{"date":"2023-10-26T13:00:00+02:00","value":14.411},{"date":"2023-10-26T13:15:00+02:00","value":14.411},{"date":"2023-10-26T13:30:00+02:00","value":14.411},{"date":"2023-10-26T13:45:00+02:00","value":14.411},{"date":"2023-10-26T14:00:00+02:00","value":14.352},{"date":"2023-10-26T14:15:00+02:00","value":14.352},{"date":"2023-10-26T14:30:00+02:00","value":14.352},{"date":"2023-10-26T14:45:00+02:00","value":14.352},{"date":"2023-10-26T15:00:00+02:00","value":14.527},{"date":"2023-10-26T15:15:00+02:00","value":14.527},{"date":"2023-10-26T15:30:00+02:00","value":14.527},{"date":"2023-10-26T15:45:00+02:00","value":14.527},{"date":"2023-10-26T16:00:00+02:00","value":15.461},{"date":"2023-10-26T16:15:00+02:00","value":15.461},{"date":"2023-10-26T16:30:00+02:00","value":15.461},{"date":"2023-10-26T16:45:00+02:00","value":15.461},{"date":"2023-10-26T17:00:00+02:00","value":16.812},{"date":"2023-10-26T17:15:00+02:00","value":16.812},{"date":"2023-10-26T17:30:00+02:00","value":16.812},{"date":"2023-10-26T17:45:00+02:00","value":16.812},{"date":"2023-10-26T18:00:00+02:00","value":17.725},{"date":"2023-10-26T18:15:00+02:00","value":17.725},{"date":"2023-10-26T18:30:00+02:00","value":17.725},{"date":"2023-10-26T18:45:00+02:00","value":17.725},{"date":"2023-10-26T19:00:00+02:00","value":18.251},{"date":"2023-10-26T19:15:00+02:00","value":18.251},{"date":"2023-10-26T19:30:00+02:00","value":18.251},{"date":"2023-10-26T19:45:00+02:00","value":18.251},{"date":"2023-10-26T20:00:00+02:00","value":16.188},{"date":"2023-10-26T20:15:00+02:00","value":16.188},{"date":"2023-10-26T20:30:00+02:00","value":16.188},{"date":"2023-10-26T20:45:00+02:00","value":16.188},{"date":"2023-10-26T21:00:00+02:00","value":14.484},{"date":"2023-10-26T21:15:00+02:00","value":14.484},{"date":"2023-10-26T21:30:00+02:00","value":14.484},{"date":"2023-10-26T21:45:00+02:00","value":14.484},{"date":"2023-10-26T22:00:00+02:00","value":14.047},{"date":"2023-10-26T22:15:00+02:00","value":14.047},{"date":"2023-10-26T22:30:00+02:00","value":14.047},{"date":"2023-10-26T22:45:00+02:00","value":14.047},{"date":"2023-10-26T23:00:00+02:00","value":12.582},{"date":"2023-10-26T23:15:00+02:00","value":12.582},{"date":"2023-10-26T23:30:00+02:00","value":12.582},{"date":"2023-10-26T23:45:00+02:00","value":12.582},{"date":"2023-10-27T00:00:00+02:00","value":12.547},{"date":"2023-10-27T00:15:00+02:00","value":12.547},{"date":"2023-10-27T00:30:00+02:00","value":12.547},{"date":"2023-10-27T00:45:00+02:00","value":12.547},{"date":"2023-10-27T01:00:00+02:00","value":11.632},{"date":"2023-10-27T01:15:00+02:00","value":11.632},{"date":"2023-10-27T01:30:00+02:00","value":11.632},{"date":"2023-10-27T01:45:00+02:00","value":11.632},{"date":"2023-10-27T02:00:00+02:00","value":11.052},{"date":"2023-10-27T02:15:00+02:00","value":11.052},{"date":"2023-10-27T02:30:00+02:00","value":11.052},{"date":"2023-10-27T02:45:00+02:00","value":11.052},{"date":"2023-10-27T03:00:00+02:00","value":10.745},{"date":"2023-10-27T03:15:00+02:00","value":10.745},{"date":"2023-10-27T03:30:00+02:00","value":10.745},{"date":"2023-10-27T03:45:00+02:00","value":10.745},{"date":"2023-10-27T04:00:00+02:00","value":10.763},{"date":"2023-10-27T04:15:00+02:00","value":10.763},{"date":"2023-10-27T04:30:00+02:00","value":10.763},{"date":"2023-10-27T04:45:00+02:00","value":10.763},{"date":"2023-10-27T05:00:00+02:00","value":11.831},{"date":"2023-10-27T05:15:00+02:00","value":11.831},{"date":"2023-10-27T05:30:00+02:00","value":11.831},{"date":"2023-10-27T05:45:00+02:00","value":11.831},{"date":"2023-10-27T06:00:00+02:00","value":14.850},{"date":"2023-10-27T06:15:00+02:00","value":14.850},{"date":"2023-10-27T06:30:00+02:00","value":14.850},{"date":"2023-10-27T06:45:00+02:00","value":14.850},{"date":"2023-10-27T07:00:00+02:00","value":17.245},{"date":"2023-10-27T07:15:00+02:00","value":17.245},{"date":"2023-10-27T07:30:00+02:00","value":17.245},{"date":"2023-10-27T07:45:00+02:00","value":17.245},{"date":"2023-10-27T08:00:00+02:00","value":18.540},{"date":"2023-10-27T08:15:00+02:00","value":18.540},{"date":"2023-10-27T08:30:00+02:00","value":18.540},{"date":"2023-10-27T08:45:00+02:00","value":18.540},{"date":"2023-10-27T09:00:00+02:00","value":18.324},{"date":"2023-10-27T09:15:00+02:00","value":18.324},{"date":"2023-10-27T09:30:00+02:00","value":18.324},{"date":"2023-10-27T09:45:00+02:00","value":18.324},{"date":"2023-10-27T10:00:00+02:00","value":17.045},{"date":"2023-10-27T10:15:00+02:00","value":17.045},{"date":"2023-10-27T10:30:00+02:00","value":17.045},{"date":"2023-10-27T10:45:00+02:00","value":17.045},{"date":"2023-10-27T11:00:00+02:00","value":15.877},{"date":"2023-10-27T11:15:00+02:00","value":15.877},{"date":"2023-10-27T11:30:00+02:00","value":15.877},{"date":"2023-10-27T11:45:00+02:00","value":15.877},{"date":"2023-10-27T12:00:00+02:00","value":14.312},{"date":"2023-10-27T12:15:00+02:00","value":14.312},{"date":"2023-10-27T12:30:00+02:00","value":14.312},{"date":"2023-10-27T12:45:00+02:00","value":14.312},{"date":"2023-10-27T13:00:00+02:00","value":13.459},{"date":"2023-10-27T13:15:00+02:00","value":13.459},{"date":"2023-10-27T13:30:00+02:00","value":13.459},{"date":"2023-10-27T13:45:00+02:00","value":13.459},{"date":"2023-10-27T14:00:00+02:00","value":12.523},{"date":"2023-10-27T14:15:00+02:00","value":12.523},{"date":"2023-10-27T14:30:00+02:00","value":12.523},{"date":"2023-10-27T14:45:00+02:00","value":12.523},{"date":"2023-10-27T15:00:00+02:00","value":13.440},{"date":"2023-10-27T15:15:00+02:00","value":13.440},{"date":"2023-10-27T15:30:00+02:00","value":13.440},{"date":"2023-10-27T15:45:00+02:00","value":13.440},{"date":"2023-10-27T16:00:00+02:00","value":14.749},{"date":"2023-10-27T16:15:00+02:00","value":14.749},{"date":"2023-10-27T16:30:00+02:00","value":14.749},{"date":"2023-10-27T16:45:00+02:00","value":14.749},{"date":"2023-10-27T17:00:00+02:00","value":15.824},{"date":"2023-10-27T17:15:00+02:00","value":15.824},{"date":"2023-10-27T17:30:00+02:00","value":15.824},{"date":"2023-10-27T17:45:00+02:00","value":15.824},{"date":"2023-10-27T18:00:00+02:00","value":17.276},{"date":"2023-10-27T18:15:00+02:00","value":17.276},{"date":"2023-10-27T18:30:00+02:00","value":17.276},{"date":"2023-10-27T18:45:00+02:00","value":17.276},{"date":"2023-10-27T19:00:00+02:00","value":17.252},{"date":"2023-10-27T19:15:00+02:00","value":17.252},{"date":"2023-10-27T19:30:00+02:00","value":17.252},{"date":"2023-10-27T19:45:00+02:00","value":17.252},{"date":"2023-10-27T20:00:00+02:00","value":15.080},{"date":"2023-10-27T20:15:00+02:00","value":15.080},{"date":"2023-10-27T20:30:00+02:00","value":15.080},{"date":"2023-10-27T20:45:00+02:00","value":15.080},{"date":"2023-10-27T21:00:00+02:00","value":12.329},{"date":"2023-10-27T21:15:00+02:00","value":12.329},{"date":"2023-10-27T21:30:00+02:00","value":12.329},{"date":"2023-10-27T21:45:00+02:00","value":12.329},{"date":"2023-10-27T22:00:00+02:00","value":11.724},{"date":"2023-10-27T22:15:00+02:00","value":11.724},{"date":"2023-10-27T22:30:00+02:00","value":11.724},{"date":"2023-10-27T22:45:00+02:00","value":11.724},{"date":"2023-10-27T23:00:00+02:00","value":11.244},{"date":"2023-10-27T23:15:00+02:00","value":11.244},{"date":"2023-10-27T23:30:00+02:00","value":11.244},{"date":"2023-10-27T23:45:00+02:00","value":11.244}]}


