# General

**URL:** https://discourse.nodered.org/c/general/7.md?page=367

[Latest](https://discourse.nodered.org/latest.md) · [Categories](https://discourse.nodered.org/categories.md) · [Tags](https://discourse.nodered.org/tags.md)

**Page:** 368

---

## [UDP Netvar data to JSON for InfluxDB2](https://discourse.nodered.org/t/udp-netvar-data-to-json-for-influxdb2/63521)

<div class="topic-metadata">

**Author:** [@bceyresy](https://discourse.nodered.org/u/bceyresy)\
**Replies:** 12\
**Last updated:** [7 June 2022 18:31 UTC](https://discourse.nodered.org/t/udp-netvar-data-to-json-for-influxdb2/63521 "2022-06-07T18:31:21Z")

</div>

Hi, How can I get the data from tis string back to JSON so I can put the values with the heading into InfluxDB, also without the "REAL" {"0":\["Fan01\_BoolP","REAL "\],"1":\[" Fan01\_Power","REAL",0\],"2":\["Fan01\_Current ","…

---

## [JSONata bug? how come 0.1 \> 0.1 returns true?](https://discourse.nodered.org/t/jsonata-bug-how-come-0-1-0-1-returns-true/63252)

<div class="topic-metadata">

**Author:** [@bogorad](https://discourse.nodered.org/u/bogorad)\
**Replies:** 11\
**Last updated:** [7 June 2022 17:17 UTC](https://discourse.nodered.org/t/jsonata-bug-how-come-0-1-0-1-returns-true/63252 "2022-06-07T17:17:58Z")

</div>

Am I missing something? This is from try.jsonata.org but it certainly is the same in Node-red. This should be 'false', right?

---

## [MSSQL and MySQL timestamp issue](https://discourse.nodered.org/t/mssql-and-mysql-timestamp-issue/63557)

<div class="topic-metadata">

**Author:** [@ALIEN](https://discourse.nodered.org/u/ALIEN)\
**Replies:** 17\
**Last updated:** [7 June 2022 15:10 UTC](https://discourse.nodered.org/t/mssql-and-mysql-timestamp-issue/63557 "2022-06-07T15:10:41Z")

</div>

Dear friends, Hello, its been a while that I'm checking my database and I noticed that the stored data in each table has a common issue! The problem is, in flows, data is colllecing from Modbus read every 2 second and s…

---

## [Connecting to Node RED Raspberry Pi dashboard shows an unsecure connection on both Pi and PC](https://discourse.nodered.org/t/connecting-to-node-red-raspberry-pi-dashboard-shows-an-unsecure-connection-on-both-pi-and-pc/63578)

<div class="topic-metadata">

**Author:** [@idkwhatimgoing](https://discourse.nodered.org/u/idkwhatimgoing)\
**Replies:** 3\
**Last updated:** [7 June 2022 14:30 UTC](https://discourse.nodered.org/t/connecting-to-node-red-raspberry-pi-dashboard-shows-an-unsecure-connection-on-both-pi-and-pc/63578 "2022-06-07T14:30:11Z")

</div>

Node-RED version: v2.2.2 Node.js version: v14.19.3 After installing Node RED on my Raspberry Pi A+ using the installation command and configuring the inital options when I tried to open the dashboard it would bring up…

---

## [High CPU usage for a (mostly) simple flow](https://discourse.nodered.org/t/high-cpu-usage-for-a-mostly-simple-flow/63548)

<div class="topic-metadata">

**Author:** [@CRCinAU](https://discourse.nodered.org/u/CRCinAU)\
**Replies:** 9\
**Last updated:** [7 June 2022 14:17 UTC](https://discourse.nodered.org/t/high-cpu-usage-for-a-mostly-simple-flow/63548 "2022-06-07T14:17:15Z")

</div>

So, this is my flow: \[ { "id": "b7765500.4889a8", "type": "subflow", "name": "Iterate", "in": \[ { "x": 220, "y": 219, "wire…

---

## [Trouble to use PID Autotune](https://discourse.nodered.org/t/trouble-to-use-pid-autotune/63573)

<div class="topic-metadata">

**Author:** [@McRMX](https://discourse.nodered.org/u/McRMX)\
**Replies:** 0\
**Last updated:** [7 June 2022 13:00 UTC](https://discourse.nodered.org/t/trouble-to-use-pid-autotune/63573 "2022-06-07T13:00:04Z")

</div>

Hi All ! I meet some trouble to use node-red-contrib-pid-autotune. If someone can share his flow to show me how it work ? Thanks

---

## [How to export / import MSSQL username and password](https://discourse.nodered.org/t/how-to-export-import-mssql-username-and-password/63561)

<div class="topic-metadata">

**Author:** [@HoussemLajili](https://discourse.nodered.org/u/HoussemLajili)\
**Replies:** 3\
**Last updated:** [7 June 2022 12:45 UTC](https://discourse.nodered.org/t/how-to-export-import-mssql-username-and-password/63561 "2022-06-07T12:45:19Z")

</div>

MSSQL username and password ( variable env) but when export / import, these are lost

---

## [OPC UA to SQL Problem](https://discourse.nodered.org/t/opc-ua-to-sql-problem/63550)

<div class="topic-metadata">

**Author:** [@DiveDeepNorway](https://discourse.nodered.org/u/DiveDeepNorway)\
**Replies:** 5\
**Last updated:** [7 June 2022 08:18 UTC](https://discourse.nodered.org/t/opc-ua-to-sql-problem/63550 "2022-06-07T08:18:55Z")

</div>

I have problem sending data from OPC UA to MS SQL database. I have 3 tags that i read from my PLC (seconds, minutes and houre). This works find. But when I try to extract the value and put it into my SQL database, I get…

---

## [SOLVED: Node Red running on a device with 2 IP connections](https://discourse.nodered.org/t/solved-node-red-running-on-a-device-with-2-ip-connections/62740)

<div class="topic-metadata">

**Author:** [@kvramji](https://discourse.nodered.org/u/kvramji)\
**Replies:** 21\
**Last updated:** [7 June 2022 07:30 UTC](https://discourse.nodered.org/t/solved-node-red-running-on-a-device-with-2-ip-connections/62740 "2022-06-07T07:30:50Z")

</div>

Can someone who has worked with this please tell me if there is something which can be configured in the settings.js file where i can have node red work on the 2 IP addresses which are connected to my pi? I have a custo…

---

## [Track with “worldmap” node including the owntracks app](https://discourse.nodered.org/t/track-with-worldmap-node-including-the-owntracks-app/63530)

<div class="topic-metadata">

**Author:** [@anairamy](https://discourse.nodered.org/u/anairamy)\
**Replies:** 1\
**Last updated:** [7 June 2022 06:33 UTC](https://discourse.nodered.org/t/track-with-worldmap-node-including-the-owntracks-app/63530 "2022-06-07T06:33:07Z")

</div>

Hi there, Does anyone know how to track an transport, ensuring the product makes the necessary journey from farm to restaurant with “worldmap” node including the owntracks app? P.S.: I know this question is broad but i…

---

## [Auto forwarding of bot messages](https://discourse.nodered.org/t/auto-forwarding-of-bot-messages/63503)

<div class="topic-metadata">

**Author:** [@GorkaUrzelai](https://discourse.nodered.org/u/GorkaUrzelai)\
**Replies:** 4\
**Last updated:** [7 June 2022 06:18 UTC](https://discourse.nodered.org/t/auto-forwarding-of-bot-messages/63503 "2022-06-07T06:18:36Z")

</div>

Hello, I created a new bot that only sends one menssage after client sends something. After sent that message I want the client (not bot) to have the forwarding to the bots message. I can not do this and I need help. I …

---

## [Payload + URL (msg.url) on Button press for POST request](https://discourse.nodered.org/t/payload-url-msg-url-on-button-press-for-post-request/63540)

<div class="topic-metadata">

**Author:** [@DanielEcheverri](https://discourse.nodered.org/u/DanielEcheverri)\
**Replies:** 4\
**Last updated:** [7 June 2022 02:47 UTC](https://discourse.nodered.org/t/payload-url-msg-url-on-button-press-for-post-request/63540 "2022-06-07T02:47:09Z")

</div>

Hi everyone. I have two variables entered by the user using text input. Let's call them variables A and B. Based on the value entered in Variable A, I have a function that sets a specific IP address as msg.url for HTTP r…

---

## [Open Port RS485](https://discourse.nodered.org/t/open-port-rs485/63429)

<div class="topic-metadata">

**Author:** [@Michell\_Iron\_Man](https://discourse.nodered.org/u/Michell_Iron_Man)\
**Replies:** 1\
**Last updated:** [7 June 2022 01:53 UTC](https://discourse.nodered.org/t/open-port-rs485/63429 "2022-06-07T01:53:14Z")

</div>

I have a CM4-IO-POE-4G-box gateway based on raspberry, I want to know how to activate the RS485 port to be able to carry out serial communication in Node-RED

---

## [How do I use serialport node to write to a RS485](https://discourse.nodered.org/t/how-do-i-use-serialport-node-to-write-to-a-rs485/63484)

<div class="topic-metadata">

**Author:** [@SP-Mushrooms](https://discourse.nodered.org/u/SP-Mushrooms)\
**Replies:** 6\
**Last updated:** [7 June 2022 01:48 UTC](https://discourse.nodered.org/t/how-do-i-use-serialport-node-to-write-to-a-rs485/63484 "2022-06-07T01:48:50Z")

</div>

Sorry for this qn but I cant find a solution for my problem my problemis how to I write to a RS485 device using simple serial communication. I am trying to google search and look through the forum but I keep on finding …

---

## [Web page data mining](https://discourse.nodered.org/t/web-page-data-mining/63394)

<div class="topic-metadata">

**Author:** [@Xenos](https://discourse.nodered.org/u/Xenos)\
**Replies:** 2\
**Last updated:** [7 June 2022 00:19 UTC](https://discourse.nodered.org/t/web-page-data-mining/63394 "2022-06-07T00:19:12Z")

</div>

Nube here with a nube question.. The section of webpage code I’m trying to capture is as follows. rem. \<div class=”col -sm3”\> rem. \<span class =”ieso-data-value up”\>$22.86 I'm using the edit HTML node with “div.co…

---

## [Pass an html template to pdf, any ideas?](https://discourse.nodered.org/t/pass-an-html-template-to-pdf-any-ideas/63536)

<div class="topic-metadata">

**Author:** [@LilGrundy](https://discourse.nodered.org/u/LilGrundy)\
**Replies:** 0\
**Last updated:** [6 June 2022 22:21 UTC](https://discourse.nodered.org/t/pass-an-html-template-to-pdf-any-ideas/63536 "2022-06-06T22:21:33Z")

</div>

Good morning to the entire node red community, I am new to this, as you will see I am learning from node red, and of course I have a question, I have a template of an html table that I use to view some data from my mysql…

---

## [Ui-level node without min/max values?](https://discourse.nodered.org/t/ui-level-node-without-min-max-values/63510)

<div class="topic-metadata">

**Author:** [@stefan24](https://discourse.nodered.org/u/stefan24)\
**Replies:** 2\
**Last updated:** [6 June 2022 21:42 UTC](https://discourse.nodered.org/t/ui-level-node-without-min-max-values/63510 "2022-06-06T21:42:31Z")

</div>

@hotNipi, (how) can I disable the min and max values? I want to use ui\_level for the current position of my roller shutter and do not need these values.

---

## [How to send a message when time is expired](https://discourse.nodered.org/t/how-to-send-a-message-when-time-is-expired/63497)

<div class="topic-metadata">

**Author:** [@jmicks8](https://discourse.nodered.org/u/jmicks8)\
**Replies:** 2\
**Last updated:** [6 June 2022 20:50 UTC](https://discourse.nodered.org/t/how-to-send-a-message-when-time-is-expired/63497 "2022-06-06T20:50:44Z")

</div>

Hi, I am still pretty new with NodeRed and could use some help getting a message to send at the right time. I have a garage door sensor connected to Hubitat and get status using the Hubitat device node. I only want to s…

---

## [Multi-site MQTT Topic](https://discourse.nodered.org/t/multi-site-mqtt-topic/63532)

<div class="topic-metadata">

**Author:** [@LinkView\_Maze](https://discourse.nodered.org/u/LinkView_Maze)\
**Replies:** 1\
**Last updated:** [6 June 2022 20:03 UTC](https://discourse.nodered.org/t/multi-site-mqtt-topic/63532 "2022-06-06T20:03:14Z")

</div>

hello I plan to deploy several raspberries with node red and an MQTT broker to monitor in a "PCVUE" hypervisor. Each site has a 4-digit number in a text file in /home/pi/Documents/sitenumber.txt . My node-red has a lo…

---

## [Alerts/Notification](https://discourse.nodered.org/t/alerts-notification/63525)

<div class="topic-metadata">

**Author:** [@anairamy](https://discourse.nodered.org/u/anairamy)\
**Replies:** 9\
**Last updated:** [6 June 2022 19:09 UTC](https://discourse.nodered.org/t/alerts-notification/63525 "2022-06-06T19:09:34Z")

</div>

Hi everyone! I've some difficult to use "notification" on node-red. When i use this method, i get nonstop notifications and as I use two mqtt's, the notifications end up on top of each other. In this function (next …

---

## [Rate Limits for HTTP requests](https://discourse.nodered.org/t/rate-limits-for-http-requests/63490)

<div class="topic-metadata">

**Author:** [@lizzardguki](https://discourse.nodered.org/u/lizzardguki)\
**Replies:** 2\
**Last updated:** [6 June 2022 17:57 UTC](https://discourse.nodered.org/t/rate-limits-for-http-requests/63490 "2022-06-06T17:57:25Z")

</div>

So the problem I had in the previous post was caused by the API rate limit. so string to figure out a design for rate limit, after each message I receive back headers X-RateLimit-Reset & X-RateLimit-Limit (Airthings fo…

---

## [PermissionError: \[Errno 13\] Permission denied: '/home/user/ - PythonScript](https://discourse.nodered.org/t/permissionerror-errno-13-permission-denied-home-user-pythonscript/63182)

<div class="topic-metadata">

**Author:** [@cyrillschuerch](https://discourse.nodered.org/u/cyrillschuerch)\
**Replies:** 8\
**Last updated:** [6 June 2022 14:43 UTC](https://discourse.nodered.org/t/permissionerror-errno-13-permission-denied-home-user-pythonscript/63182 "2022-06-06T14:43:03Z")

</div>

Hello Node-Red Community I am a beginner. I would like to start a python script with Node-red. A PDF should be generated and saved. I installed the "node-red-contrib-pythonshell" adapter and installed a corresponding V…

---

## [Get Windows Services list from Ubuntu Installation?](https://discourse.nodered.org/t/get-windows-services-list-from-ubuntu-installation/63512)

<div class="topic-metadata">

**Author:** [@MyRandomThoughts](https://discourse.nodered.org/u/MyRandomThoughts)\
**Replies:** 1\
**Last updated:** [6 June 2022 14:10 UTC](https://discourse.nodered.org/t/get-windows-services-list-from-ubuntu-installation/63512 "2022-06-06T14:10:33Z")

</div>

I am running Node-RED on ubuntu and want to be able to check on a couple of Windows services. Does anyone know how I can do this? I was thinking maybe WMIC or such, but finding working tool is proving hard. Thanks

---

## [Missing ";" before statement in if statement](https://discourse.nodered.org/t/missing-before-statement-in-if-statement/63504)

<div class="topic-metadata">

**Author:** [@Nice\_to\_have](https://discourse.nodered.org/u/Nice_to_have)\
**Replies:** 2\
**Last updated:** [6 June 2022 07:25 UTC](https://discourse.nodered.org/t/missing-before-statement-in-if-statement/63504 "2022-06-06T07:25:58Z")

</div>

Hi everyone, I have been reading the forum on how to write an if statement. I thought I was doing okay, but right at the end it gives me a 'Missing ";" before statement'. Not sure what to do here. var wave = msg.payl…

---

## [How can i get web-cookie in my running flow?](https://discourse.nodered.org/t/how-can-i-get-web-cookie-in-my-running-flow/63380)

<div class="topic-metadata">

**Author:** [@weber\_j](https://discourse.nodered.org/u/weber_j)\
**Replies:** 4\
**Last updated:** [6 June 2022 03:04 UTC](https://discourse.nodered.org/t/how-can-i-get-web-cookie-in-my-running-flow/63380 "2022-06-06T03:04:01Z")

</div>

i want to get web cookie when i use function-node, i want to use dynamic cookie to send request thanks for help

---

## [Trigger CLI command on user's PC](https://discourse.nodered.org/t/trigger-cli-command-on-users-pc/63491)

<div class="topic-metadata">

**Author:** [@CBianca](https://discourse.nodered.org/u/CBianca)\
**Replies:** 1\
**Last updated:** [5 June 2022 21:38 UTC](https://discourse.nodered.org/t/trigger-cli-command-on-users-pc/63491 "2022-06-05T21:38:33Z")

</div>

Hello guys! I have a question about the possibility of an implementation, I just want a direction so I can dig more into that. I have my node-red server on my laptop. Let's say another user from another laptop connects…

---

## [Set environment variable node MSSQL username ,password](https://discourse.nodered.org/t/set-environment-variable-node-mssql-username-password/63486)

<div class="topic-metadata">

**Author:** [@HoussemLajili](https://discourse.nodered.org/u/HoussemLajili)\
**Replies:** 7\
**Last updated:** [5 June 2022 18:11 UTC](https://discourse.nodered.org/t/set-environment-variable-node-mssql-username-password/63486 "2022-06-05T18:11:38Z")

</div>

is impossible to set an environment variable username, password in node-red-contrib-mssql-plus ?? I tried {{username}} and {{{username}}} but it didn't work

---

## [Node-red payload](https://discourse.nodered.org/t/node-red-payload/63482)

<div class="topic-metadata">

**Author:** [@a45293](https://discourse.nodered.org/u/a45293)\
**Replies:** 17\
**Last updated:** [5 June 2022 16:37 UTC](https://discourse.nodered.org/t/node-red-payload/63482 "2022-06-05T16:37:59Z")

</div>

Boa tarde, alguem me consegue ajudar, eu quero imprimir do meu payload todos os elementos que estão em \_value mas quando faço msg.payload.\_value ele da me "undefined" mas qunado eu faço msg.pauload\[0\].\_value ele imprime …

---

## [Call Node-RED flow from Node.js](https://discourse.nodered.org/t/call-node-red-flow-from-node-js/63480)

<div class="topic-metadata">

**Author:** [@vitaliimarushko](https://discourse.nodered.org/u/vitaliimarushko)\
**Replies:** 9\
**Last updated:** [5 June 2022 14:38 UTC](https://discourse.nodered.org/t/call-node-red-flow-from-node-js/63480 "2022-06-05T14:38:51Z")

</div>

Hi! I built a flow in Node-RED where I make an HTTP request and get some response. Now I need to call this already built flow from Express (Node.js) application and get the calling result inside my server. If I underst…

---

## [Multiple device data to table](https://discourse.nodered.org/t/multiple-device-data-to-table/63476)

<div class="topic-metadata">

**Author:** [@lovenodered](https://discourse.nodered.org/u/lovenodered)\
**Replies:** 2\
**Last updated:** [5 June 2022 13:27 UTC](https://discourse.nodered.org/t/multiple-device-data-to-table/63476 "2022-06-05T13:27:23Z")

</div>

Hello , im trying to put multiple modbus device data into one table,, the result is weird.. its show only first column and sometimes disapear due to different timing of device transmit. how to get this work? THANK…

[Previous page](https://discourse.nodered.org/c/general/7.md?page=366)

[Next page](https://discourse.nodered.org/c/general/7.md?page=368)