Node Red into InfluxDB Problems

Hello
there i get the water Temperatur of a small River close by.
i wish to save it into InfluxDB
i think i miss something because there are no data

show databases
onl_wa_pfa
use onl_wa_pfa
show series
key
Wassertemperatur

but then i can't find some temperatur

[{"id":"20397602.17151a","type":"http request","z":"a31f62e6.bb022","name":"","method":"GET","ret":"txt","paytoqs":"ignore","url":"https://www.ag.ch/app/hydrometrie/station/?id=11566","tls":"","persist":false,"proxy":"","authType":"","x":370,"y":1180,"wires":[["844bc04a.1de77","9b6d609c.13ab8"]]},{"id":"844bc04a.1de77","type":"html","z":"a31f62e6.bb022","name":"","property":"payload","outproperty":"payload","tag":"td","ret":"text","as":"single","x":560,"y":1180,"wires":[["8ee11898.61b808","d8d54085.d599e"]]},{"id":"8ee11898.61b808","type":"debug","z":"a31f62e6.bb022","name":"value","active":false,"tosidebar":true,"console":true,"tostatus":true,"complete":"payload[5]","targetType":"msg","statusVal":"payload[5]","statusType":"auto","x":720,"y":1220,"wires":[]},{"id":"d8d54085.d599e","type":"function","z":"a31f62e6.bb022","name":"FunctionWasserTemp","func":"// split \"426.31 m\" text into an array based on space\n// and pick only the first element that is the number in text\n// finally convert the string to actual Number\n\nlet wTemp = Number(msg.payload[5].split(\" \")[0])\nnode.warn(wTemp)\nmsg.payload = wTemp\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":760,"y":1280,"wires":[["886eafbd.2d4a5","5ed4281d.810a88","d42131e8.f32d4"]]},{"id":"886eafbd.2d4a5","type":"debug","z":"a31f62e6.bb022","name":"Wassertemperatur","active":true,"tosidebar":true,"console":true,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1000,"y":1300,"wires":[]},{"id":"5ed4281d.810a88","type":"ui_chart","z":"a31f62e6.bb022","name":"","group":"ba1ec1f3.5ec4","order":1,"width":0,"height":0,"label":"Pfaffnern - Wassertemperatur C","chartType":"line","legend":"false","xformat":"HH:mm:ss","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"604800","cutout":0,"useOneColor":false,"useUTC":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"outputs":1,"x":1030,"y":1260,"wires":[[]]},{"id":"9b6d609c.13ab8","type":"debug","z":"a31f62e6.bb022","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":660,"y":1100,"wires":[]},{"id":"858dcf6a.324e","type":"inject","z":"a31f62e6.bb022","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":150,"y":1200,"wires":[["20397602.17151a"]]},{"id":"d42131e8.f32d4","type":"influxdb out","z":"a31f62e6.bb022","influxdb":"43b0a97b.1a60d8","name":"Wassertemperatur","measurement":"Wassertemperatur","precision":"","retentionPolicy":"","database":"database","precisionV18FluxV20":"ms","retentionPolicyV18Flux":"","org":"organisation","bucket":"bucket","x":990,"y":1220,"wires":[]},{"id":"ba1ec1f3.5ec4","type":"ui_group","name":"Vordemwald","tab":"6fcbe329.63a37c","order":4,"disp":true,"width":"7","collapse":false},{"id":"43b0a97b.1a60d8","type":"influxdb","hostname":"10.18.42.175","port":"8086","protocol":"http","database":"onl_wa_pfa","name":"onl_wa_pfa","usetls":false,"tls":"","influxdbVersion":"1.x","url":"127.0.0.1","rejectUnauthorized":false},{"id":"6fcbe329.63a37c","type":"ui_tab","name":"Online Wetter Daten","icon":"dashboard","order":2,"disabled":false,"hidden":false}]

what i am doing wrong?
have a nice day
vinc

Connect a debug node showing what you are sending to the influx node. Set the debug node to show Complete Message and paste what you see here.

If in the influx command line, after use onl_wa_pfa you say
select * from Wassertemperatur limit 10
what does it show?

hello @Colin
hmmm this would show correct the value - i just used the select command wrong
so i did something wrong with grafana to show it - but it looks ok, so far

select * from Wassertemperatur limit 10
name: Wassertemperatur
time value


1609793265673707483 4.6
1609793276006086963 4.6
1609793361576880485 4.6
1609793490844094322 4.6
1609793979517580842 4.6
1609794378000743426 4.6
1609794452087994734 4.6
1609795576483675874 4.6
1609796776350430273 4.6
1609797976385179160 4.6

and after a while i found them in Grafana too

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.