Daten aus Url abfragen und in Datenpunkt schreiben

[Homoran]

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

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

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

[keksn]

@homoran

wollen klar, Können, Zeit und vor allem Basics sind oft nicht vorhanden...bin aber schon viel weiter als vor einigen Jahren

[Homoran]

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

ändert nichts das steht im Datenpunkt

hast du 15 Minuten gewartet?

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

bin aber schon viel weiter als vor einigen Jahren

siehste!
geht schon los

[keksn]

@homoran haha habe eigentlich 15 Sekunden abfrage eingebaut und beim Nachbauen 15 min ...naja. es kommt aber ein Fehler

9:56:48.168	error	javascript.0 (451) script.js.Verschiedenes.Strompreisabfrage: Cannot get value of undefined

[Homoran]

@keksn zeig bitte nochmal dein aktuelles Blockly
15 minuten reicht. der Preis ist auch nur im 15 Minutenraster im JSON

[keksn]

@keksn alles zurück ..Fehler ist weg und er Datenpunkt ist mit dem Wert aktualisiert worden.

[paul53]

@keksn sagte: habe eigentlich 15 Sekunden abfrage eingebaut

Damit funktioniert das Skript nicht, da dann die Division durch 15 keinen Integer-Wert liefert. Wert bei mir seit 20:00 Uhr:

[keksn]

@homoran

der Fehler ist jetzt wieder da. Der Datenpunkt ist aber Aktualisiert worden.

[Homoran]

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

der Fehler ist jetzt wieder da.

siehe

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

@keksn sagte: habe eigentlich 15 Sekunden abfrage eingebaut

Damit funktioniert das Skript nicht, da dann die Division durch 15 keinen Integer-Wert liefert. Wert bei mir:

was soll das br7ngen alle 15 sec?

[keksn]

@paul53 aha , muss das Script komplett neu gemacht werden wenn man eine kürzere Abfrage macht?

[Homoran]

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

wenn man eine kürzere Abfrage macht?

nochmal:
was bringt dir das?
abgesehen, dass die API das wohl nicht gerne sieht.

[keksn]

@keksn Ich werde es wieder auf 15 Minuten ändern!

Vielen Dank an euch beide für die Hilfe!!! (beim Stromsparen)

Schönen Abend!

LG

[Homoran]

@keksn nicht dass du bei der API geblockt wirst.
Du kannst das result Morgens um 0:01 herunterladen und in einem DP (und einer Variablen) speichern.
Darin sind die Preise von 191 Viertelstunden ab 0:00 dr7n.
Nach meinem Verständnis ändern die sich auch in dieser Zeit nicht mehr.

Warum also dauernd wieder herunterladen?

Man könnte auch direkt die günstigsten Stunden heraussuchen und in Datenpunkte schreiben, und, und, und...

(ohne dauernd die API zu belasten)

[Homoran]

ich hab das mal nach Blockly verschoben. Mit der Forensoftware hat das ja nichts zu tun.

[keksn]

@homoran ok klingt gut. Schau mir morgen mal an ob wirklich alle Preise für den ganzen Tag schon um 0:01 enthalten sind. Für die Umsetzung werde ich dann wohl nochmals Hilfe brauchen.

[keksn]

@homoran ok danke!

[Homoran]

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

alle Preise für den ganzen Tag schon um 0:01 enthalten sind.

und für den nächsten

[keksn]

@paul53

GM, ursprünglich wollte ich einen Schwellwert definieren und bei dessen unterschreiten des aktuellen Strompreises eine Batterieladung, Speicherheizung mit WP usw. auslösen.
Mit Homorans Idee alle Werte am Anfang des Tages auf einmal herunter zu laden und in Datenpunkte zu schreiben, könnte man diesen Bezugszeiträume schon für den ganzen Tag im Vorhinein definieren.

Wie würde man das am besten machen, beziehungsweise wie fragt man alle Werte auf einmal ab um sie in Datenpunkt zu Schreiben.