Daten aus Url abfragen und in Datenpunkt schreiben

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

[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)