Daten aus Url abfragen und in Datenpunkt schreiben

[Homoran]

@keksn was kommt denn da als result beim request?
kannst du über einen debug Baustein auswerfen

edit
es muss result und nicht Result heissen

[keksn]

@homoran danke mal für die Findung des ersten Fehlers!

debug Baustein

18:44:39.135	error	javascript.0 (451) script.js.Verschiedenes.Strompreisabfrage compile failed:
 at script.js.Verschiedenes.Strompreisabfrage:12

[Homoran]

@keksn sagte in Daten aus Url abfragen und in Datenpunkt schreiben:

debug Baustein

zeigen

[keksn]

@homoran

[paul53]

@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?

[Homoran]

@keksn sagte in Daten aus Url abfragen und in Datenpunkt schreiben:

@homoran

nur den result in den debug!

[keksn]

@paul53 Hallo, ich brauche eigentlich nur den Strompreis sonst nichts, also nur einer.

[paul53]

@keksn sagte: nur den Strompreis sonst nichts, also nur einer.

Welchen? Den von der aktuellen Uhrzeit?

[keksn]

@paul53 sagte in Daten aus Url abfragen und in Datenpunkt schreiben:

Den von der aktuellen Uhrzeit?

Ja genau den aktuellen.

[keksn]

@homoran

meintest Du so ?...DANKE für die Hilfe! Denke Paul hilft mir schon bist zur Lösung.

[Homoran]

@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]

@keksn sagte: Ja genau den aktuellen.

[keksn]

@paul53 VIELEN DANK! Das wäre mir zu schwierig gewesen...

[Homoran]

@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]

@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]

@paul53

Ich habe das jetzt genau so nachgebaut. Wie schreibe ich jetzt in meinem Datenpunkt?

[Homoran]

@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

[keksn]

@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?

[paul53]

@keksn sagte: Wie schreibe ich jetzt in meinem Datenpunkt?

Anstelle von "debug" nimm "aktualisiere". Das Attribut "value" separiert den Preis.

[keksn]

@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....