# Node Red into InfluxDB Problems

**URL:** <https://discourse.nodered.org/t/node-red-into-influxdb-problems/38548>\
**Category:** General\
**Created:** [4 January 2021 21:12 UTC](https://discourse.nodered.org/t/node-red-into-influxdb-problems/38548 "2021-01-04T21:12:43Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![vikozo](https://avatars.discourse-cdn.com/v4/letter/v/858c86/32.png) [@vikozo](https://discourse.nodered.org/u/vikozo)\
**Post date:** [4 January 2021 21:12 UTC](https://discourse.nodered.org/t/node-red-into-influxdb-problems/38548/1 "2021-01-04T21:12:43Z")

</div>

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

```auto
[{"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

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [4 January 2021 21:52 UTC](https://discourse.nodered.org/t/node-red-into-influxdb-problems/38548/2 "2021-01-04T21:52:24Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![vikozo](https://avatars.discourse-cdn.com/v4/letter/v/858c86/32.png) [@vikozo](https://discourse.nodered.org/u/vikozo)\
**Post date:** [4 January 2021 23:27 UTC](https://discourse.nodered.org/t/node-red-into-influxdb-problems/38548/3 "2021-01-04T23:27:21Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [18 January 2021 23:27 UTC](https://discourse.nodered.org/t/node-red-into-influxdb-problems/38548/4 "2021-01-18T23:27:35Z")

</div>

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