Also ich bin auch nimmer so fit - mit der normalen Influx bekomme ich es nicht hin, sondern nur mit der Batch-Node.
358b2243-ef46-45d8-94a4-2a904e4e45c7-image.png
5a8871af-fd53-4be2-b29c-c86f6a0f06fd-image.png
Hier der Flow:
Spoiler [{"id":"29339e62b7a1b9e3","type":"inject","z":"5ad55a7b0d4580eb","name":"","props":[{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{\"preferredNextApiRequestAt\":{\"secondOfHour\":408,\"epochTimeUtc\":1713276408},\"status\":0,\"iLastPredictionGenerationEpochTime\":1713275949,\"weather_source_text\":\"Kurzfristig (3 Tage): Powered by <a href='https: //www.weatherapi.com/title=\",\"datalinename\":\"Germany > Pichelsdorf\",\"data\":{\"1713236400\":[0,0],\"1713240000\":[0.003,0.003],\"1713243600\":[0.112,0.115],\"1713247200\":[0.269,0.384],\"1713250800\":[0.403,0.787],\"1713254400\":[0.621,1.408],\"1713258000\":[0.599,2.007],\"1713261600\":[0.697,2.704],\"1713265200\":[0.835,3.539],\"1713268800\":[0.679,4.218],\"1713272400\":[0.581,4.799],\"1713276000\":[0.496,5.295],\"1713279600\":[0.405,5.7],\"1713283200\":[0.272,5.972],\"1713286800\":[0.115,6.087],\"1713290400\":[0,6.087],\"1713322800\":[0,0],\"1713326400\":[0.019,0.019],\"1713330000\":[0.395,0.414],\"1713333600\":[0.775,1.189],\"1713337200\":[1.039,2.228],\"1713340800\":[0.858,3.086],\"1713344400\":[1.022,4.108],\"1713348000\":[0.623,4.731],\"1713351600\":[0.961,5.692],\"1713355200\":[0.644,6.336],\"1713358800\":[0.579,6.915],\"1713362400\":[0.656,7.571],\"1713366000\":[0.566,8.137],\"1713369600\":[0.298,8.435],\"1713373200\":[0.084,8.519],\"1713376800\":[0,8.519]}}","payloadType":"json","x":150,"y":2500,"wires":[["586029ecb69d46e0"]]},{"id":"586029ecb69d46e0","type":"change","z":"5ad55a7b0d4580eb","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"$zip(\t $keys(payload.data),\t $zip(\t payload.data.*#$i[($i%2)=0],\t payload.data.*#$i[($i%2)=1]\t )\t).\t {\t \"measurement\" : \"Solarprognose2\",\t \"timestamp\":$number($[0])*1000,\t \"fields\":{\t \"Datum\": ($moment($[0],'X').format('DD.MM.YYYY HH:mm:ss'))[0],\t \"Prognose_W\":$[1],\t \"Prognose_Wh\":$[2]}\t }\t","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":330,"y":2500,"wires":[["6ac97ec264377ff5","276d267403e20027"]]},{"id":"6ac97ec264377ff5","type":"debug","z":"5ad55a7b0d4580eb","name":"Daten","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":550,"y":2600,"wires":[]},{"id":"276d267403e20027","type":"influxdb batch","z":"5ad55a7b0d4580eb","influxdb":"492dfce8b90a8cc8","precision":"","retentionPolicy":"","name":"","database":"database","precisionV18FluxV20":"ms","retentionPolicyV18Flux":"","org":"mwdebian","bucket":"Node-Red Test","x":650,"y":2500,"wires":[]},{"id":"492dfce8b90a8cc8","type":"influxdb","hostname":"127.0.0.1","port":"8086","protocol":"http","database":"database","name":"","usetls":false,"tls":"","influxdbVersion":"2.0","url":"http://mwdebian.fritz.box:8086","rejectUnauthorized":false}]