# Latest

**URL:** https://discourse.nodered.org/latest.md?page=681

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

**Page:** 682

---

## [How to run command line after installing the node-red with snap](https://discourse.nodered.org/t/how-to-run-command-line-after-installing-the-node-red-with-snap/54614)

<div class="topic-metadata">

**Author:** [@yang](https://discourse.nodered.org/u/yang)\
**Replies:** 4\
**Last updated:** [2 December 2021 09:11 UTC](https://discourse.nodered.org/t/how-to-run-command-line-after-installing-the-node-red-with-snap/54614 "2021-12-02T09:11:55Z")

</div>

hello, everyone I installed the nodered on ubuntu 18.04 with snap, now I want to enable the HTTPS Access and the Username/password based authentication, it takes me much time to find the setting.js file, at last, I foun…

---

## [Code function to collect data from mqtt](https://discourse.nodered.org/t/code-function-to-collect-data-from-mqtt/54588)

<div class="topic-metadata">

**Author:** [@huuthang911](https://discourse.nodered.org/u/huuthang911)\
**Replies:** 4\
**Last updated:** [2 December 2021 08:34 UTC](https://discourse.nodered.org/t/code-function-to-collect-data-from-mqtt/54588 "2021-12-02T08:34:31Z")

</div>

Hi folks, I have 3 topics in MQTT. I want to use the data of these topics but I don't know how to write code in the function node. Can you suggest to me the code to declare variables in the function node.

---

## [Getting session of TCP Connection without direct connection to the node](https://discourse.nodered.org/t/getting-session-of-tcp-connection-without-direct-connection-to-the-node/54452)

<div class="topic-metadata">

**Author:** [@ChristianOvesen](https://discourse.nodered.org/u/ChristianOvesen)\
**Replies:** 4\
**Last updated:** [2 December 2021 07:35 UTC](https://discourse.nodered.org/t/getting-session-of-tcp-connection-without-direct-connection-to-the-node/54452 "2021-12-02T07:35:50Z")

</div>

Hello, I am fairly new to node-red and I have run into an issue. So I have a TCP connection that sends nothing until it has received an initiation message, then it will begin sending constantly and won't need other messa…

---

## [I am having trouble opening excel files when using the Excel Sheets node](https://discourse.nodered.org/t/i-am-having-trouble-opening-excel-files-when-using-the-excel-sheets-node/54430)

<div class="topic-metadata">

**Author:** [@Aaron1](https://discourse.nodered.org/u/Aaron1)\
**Replies:** 9\
**Last updated:** [2 December 2021 05:28 UTC](https://discourse.nodered.org/t/i-am-having-trouble-opening-excel-files-when-using-the-excel-sheets-node/54430 "2021-12-02T05:28:00Z")

</div>

I tried to use The Excel Sheets node to write data, but it couldn't be opened after writing. I don't know what the problem is, please help me solve it or give me an example, thank you

---

## [Help wanted with flow intended to turn lights off and on based on sun elevation](https://discourse.nodered.org/t/help-wanted-with-flow-intended-to-turn-lights-off-and-on-based-on-sun-elevation/54616)

<div class="topic-metadata">

**Author:** [@thromer](https://discourse.nodered.org/u/thromer)\
**Replies:** 2\
**Last updated:** [2 December 2021 05:22 UTC](https://discourse.nodered.org/t/help-wanted-with-flow-intended-to-turn-lights-off-and-on-based-on-sun-elevation/54616 "2021-12-02T05:22:02Z")

</div>

I'm new to Node-Red and I think there is something about flows or RBEs that I don't understand, and need some help figuring out. As the subject suggests, I expect this flow to turn the lights off when the sun goes above…

---

## [Can I skip undefined in array in a function node?](https://discourse.nodered.org/t/can-i-skip-undefined-in-array-in-a-function-node/54594)

<div class="topic-metadata">

**Author:** [@Nice\_to\_have](https://discourse.nodered.org/u/Nice_to_have)\
**Replies:** 9\
**Last updated:** [1 December 2021 22:22 UTC](https://discourse.nodered.org/t/can-i-skip-undefined-in-array-in-a-function-node/54594 "2021-12-01T22:22:30Z")

</div>

Good day everyone, I come up with a hobby project which for sure is keeping me active on this forum. Searching for, and learning a lot from, other forum entries. I have searched the forum for topics that might tell me…

---

## [How can I listen to an External REQUEST (POST)?](https://discourse.nodered.org/t/how-can-i-listen-to-an-external-request-post/54599)

<div class="topic-metadata">

**Author:** [@elvissouza](https://discourse.nodered.org/u/elvissouza)\
**Replies:** 2\
**Last updated:** [1 December 2021 19:57 UTC](https://discourse.nodered.org/t/how-can-i-listen-to-an-external-request-post/54599 "2021-12-01T19:57:46Z")

</div>

First sorry for my English grammar. So I don't know if it's possible to listen to an external request in my case a POST I have two Node-Red one that is in the CLOUD and another LOCAL. When requesting a POST on Node-RE…

---

## [Problem running SQL stored procedure](https://discourse.nodered.org/t/problem-running-sql-stored-procedure/54542)

<div class="topic-metadata">

**Author:** [@GregHNZ](https://discourse.nodered.org/u/GregHNZ)\
**Replies:** 2\
**Last updated:** [1 December 2021 19:18 UTC](https://discourse.nodered.org/t/problem-running-sql-stored-procedure/54542 "2021-12-01T19:18:54Z")

</div>

Using node-red-contrib-mssql-plus to connect to SQL server Have got Select query running but getting an error when trying to execute a stored procedure, failing with error Could not find stored procedure ''. Both …

---

## [Developing external connectivity nodes](https://discourse.nodered.org/t/developing-external-connectivity-nodes/54590)

<div class="topic-metadata">

**Author:** [@cloud-rocket](https://discourse.nodered.org/u/cloud-rocket)\
**Replies:** 3\
**Last updated:** [1 December 2021 18:01 UTC](https://discourse.nodered.org/t/developing-external-connectivity-nodes/54590 "2021-12-01T18:01:31Z")

</div>

Hi, I am developing custom connectivity nodes (database, AMQP and etc.). I am still struggling to understand what should be the best approach to connections reuse. All of the packages I looked into are using "config" n…

---

## [Sunset / sunrise give other values in dashboard then in debug window](https://discourse.nodered.org/t/sunset-sunrise-give-other-values-in-dashboard-then-in-debug-window/54575)

<div class="topic-metadata">

**Author:** [@Leo](https://discourse.nodered.org/u/Leo)\
**Replies:** 2\
**Last updated:** [1 December 2021 17:50 UTC](https://discourse.nodered.org/t/sunset-sunrise-give-other-values-in-dashboard-then-in-debug-window/54575 "2021-12-01T17:50:50Z")

</div>

Hi, I'm new with node-red and I'm struggling with sunset / sunrise from openweathermap. I getting sunset / sunrise from openweathermap and via a function node, I convert the epoch to a more readable format (just our da…

---

## [Node-RED dashboard can't handle high freq. data](https://discourse.nodered.org/t/node-red-dashboard-cant-handle-high-freq-data/54265)

<div class="topic-metadata">

**Author:** [@hkayan](https://discourse.nodered.org/u/hkayan)\
**Replies:** 21\
**Last updated:** [1 December 2021 16:23 UTC](https://discourse.nodered.org/t/node-red-dashboard-cant-handle-high-freq-data/54265 "2021-12-01T16:23:40Z")

</div>

Hi, I am outputting accelerometer data at high freq. (119 Hz) to Node-RED dashboard via line chart node. I realized when we have lower freq. (1 Hz) there are no issues, but at higher frequencies, the dashboard can't cat…

---

## [Where can I find an explanation of the most basic terms like "node" "flow" deploying" "LTS" "npm-module](https://discourse.nodered.org/t/where-can-i-find-an-explanation-of-the-most-basic-terms-like-node-flow-deploying-lts-npm-module/54569)

<div class="topic-metadata">

**Author:** [@StefanL38](https://discourse.nodered.org/u/StefanL38)\
**Replies:** 6\
**Last updated:** [1 December 2021 16:11 UTC](https://discourse.nodered.org/t/where-can-i-find-an-explanation-of-the-most-basic-terms-like-node-flow-deploying-lts-npm-module/54569 "2021-12-01T16:11:47Z")

</div>

Hello everybody, I started to read at Creating your first node the text starts with Nodes get created when a flow is deployed.. oopps ! as a newcomer I ask myself what is a "node"? what is a "flow"? how do I "…

---

## [Localtime instead of UTC](https://discourse.nodered.org/t/localtime-instead-of-utc/54585)

<div class="topic-metadata">

**Author:** [@saalty](https://discourse.nodered.org/u/saalty)\
**Replies:** 2\
**Last updated:** [1 December 2021 16:11 UTC](https://discourse.nodered.org/t/localtime-instead-of-utc/54585 "2021-12-01T16:11:30Z")

</div>

Hello all! I have problem with timezone in Node-Red. I read a lot about this issue but cannot find the solution yet. I use opcda-read node to read out data from OPC DA server. This node gives an object about the data in…

---

## [Exec node with "timedatectl" call started to return a buffer instead of string](https://discourse.nodered.org/t/exec-node-with-timedatectl-call-started-to-return-a-buffer-instead-of-string/54553)

<div class="topic-metadata">

**Author:** [@janedoe123](https://discourse.nodered.org/u/janedoe123)\
**Replies:** 11\
**Last updated:** [1 December 2021 16:01 UTC](https://discourse.nodered.org/t/exec-node-with-timedatectl-call-started-to-return-a-buffer-instead-of-string/54553 "2021-12-01T16:01:09Z")

</div>

Hi all, I'm facing a super weird issue. I'm using an exec node with a "timedatectl" call, but suddenly it started to return a buffer instead of string. Because of that, I can't use any JSONata expression anymore since …

---

## [Problem with node-red-contrib-google-calendar](https://discourse.nodered.org/t/problem-with-node-red-contrib-google-calendar/54467)

<div class="topic-metadata">

**Author:** [@WernerM96](https://discourse.nodered.org/u/WernerM96)\
**Replies:** 1\
**Last updated:** [1 December 2021 15:59 UTC](https://discourse.nodered.org/t/problem-with-node-red-contrib-google-calendar/54467 "2021-12-01T15:59:40Z")

</div>

Hey, i have a problem with the node-red-contrib-google-calendar. I would like to get some events of the current day with this function: const startDate = new Date(); const endDate = new Date(); endDate.setHours(22); …

---

## [Cannot install node-red-contrib-ui-clock after dashboard update](https://discourse.nodered.org/t/cannot-install-node-red-contrib-ui-clock-after-dashboard-update/54570)

<div class="topic-metadata">

**Author:** [@NPT](https://discourse.nodered.org/u/NPT)\
**Replies:** 5\
**Last updated:** [1 December 2021 14:22 UTC](https://discourse.nodered.org/t/cannot-install-node-red-contrib-ui-clock-after-dashboard-update/54570 "2021-12-01T14:22:39Z")

</div>

I wonder if anyone can offer some guidance please? Whilst attempting to upgrade Dashboard from 2.30 to 3.1.2, I discovered node-red-contrib-ui-clock was causing issues. After deleting this, the upgrade was fine. Howe…

---

## [Change static IP address from dashboard](https://discourse.nodered.org/t/change-static-ip-address-from-dashboard/54531)

<div class="topic-metadata">

**Author:** [@traderjoe](https://discourse.nodered.org/u/traderjoe)\
**Replies:** 10\
**Last updated:** [1 December 2021 14:13 UTC](https://discourse.nodered.org/t/change-static-ip-address-from-dashboard/54531 "2021-12-01T14:13:57Z")

</div>

I'm trying to change the static IP address of my PI from a node red dashboard. I found this link https://flows.nodered.org/flow/520df02be955b412ddb89bcbf70cce34 \[{"id":"2d2bd18e.3e4abe","type":"tab","label":"IP Settin…

---

## [Use of environment variables to set editor user name and password](https://discourse.nodered.org/t/use-of-environment-variables-to-set-editor-user-name-and-password/54345)

<div class="topic-metadata">

**Author:** [@hammoaj](https://discourse.nodered.org/u/hammoaj)\
**Replies:** 9\
**Last updated:** [1 December 2021 13:39 UTC](https://discourse.nodered.org/t/use-of-environment-variables-to-set-editor-user-name-and-password/54345 "2021-12-01T13:39:14Z")

</div>

Has the option to use NODE\_RED\_USERNAME and NODE\_RED\_PASSWORD to set an admin login for the editor been removed? It works in NR 1.x, but apparently not in NR 2.x. Thanks

---

## [Expected ':' and instead saw '+' in function node](https://discourse.nodered.org/t/expected-and-instead-saw-in-function-node/54571)

<div class="topic-metadata">

**Author:** [@Nice\_to\_have](https://discourse.nodered.org/u/Nice_to_have)\
**Replies:** 1\
**Last updated:** [1 December 2021 13:08 UTC](https://discourse.nodered.org/t/expected-and-instead-saw-in-function-node/54571 "2021-12-01T13:08:43Z")

</div>

I am using a function node to query MYSQL. How ever, the function node says: Expected ':' and instead saw '+ msg.topic = { "INSERT or REPLACE INTO RANDOMNUM VALUES ( " + msg.payload\[0\].mmsi + "," + msg.payload\[0\].ch…

---

## [Mustache notation](https://discourse.nodered.org/t/mustache-notation/54558)

<div class="topic-metadata">

**Author:** [@bombjackit](https://discourse.nodered.org/u/bombjackit)\
**Replies:** 2\
**Last updated:** [1 December 2021 12:29 UTC](https://discourse.nodered.org/t/mustache-notation/54558 "2021-12-01T12:29:51Z")

</div>

Hello to everybody, working with nodered I have discovered the mustache notation that is a great simplification, but I have some problem with a particular type of data. I have this payload\["Ox.V.fVar\_5"\] : what is the c…

---

## ["Error: Cannot set headers after they are sent to the client"](https://discourse.nodered.org/t/error-cannot-set-headers-after-they-are-sent-to-the-client/54527)

<div class="topic-metadata">

**Author:** [@wjr1506](https://discourse.nodered.org/u/wjr1506)\
**Replies:** 4\
**Last updated:** [1 December 2021 12:22 UTC](https://discourse.nodered.org/t/error-cannot-set-headers-after-they-are-sent-to-the-client/54527 "2021-12-01T12:22:25Z")

</div>

Hello everyone! I have a question, is there any way to loop a flow that has an http node? I'm trying to integrate a chatbot created in Watson Assistan into instagram. As I didn't find a specific node for sending messag…

---

## [IoT Security Assured Scheme](https://discourse.nodered.org/t/iot-security-assured-scheme/54563)

<div class="topic-metadata">

**Author:** [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Replies:** 0\
**Last updated:** [1 December 2021 11:48 UTC](https://discourse.nodered.org/t/iot-security-assured-scheme/54563 "2021-12-01T11:48:26Z")

</div>

Hi all, in case you don't know about the IASME consortium. They lead the work on the Cyber Essentials certification in the UK but also the IoT Security Assured Scheme. This may be useful if you are doing business in the…

---

## [Node-RED on docker causes regular CPU spikes](https://discourse.nodered.org/t/node-red-on-docker-causes-regular-cpu-spikes/54112)

<div class="topic-metadata">

**Author:** [@blagae](https://discourse.nodered.org/u/blagae)\
**Replies:** 17\
**Last updated:** [1 December 2021 10:30 UTC](https://discourse.nodered.org/t/node-red-on-docker-causes-regular-cpu-spikes/54112 "2021-12-01T10:30:09Z")

</div>

Docker is running on a relatively low-end Linux system with dual-core processor of type Intel Celeron N3350 and 4GB of memory. About 15 microservice containers run together, communicating with each other and to the outsi…

---

## [\[Challenge\]Solve Advent of Code puzzles without using function nodes](https://discourse.nodered.org/t/challenge-solve-advent-of-code-puzzles-without-using-function-nodes/54556)

<div class="topic-metadata">

**Author:** [@cymplecy](https://discourse.nodered.org/u/cymplecy)\
**Replies:** 0\
**Last updated:** [1 December 2021 09:56 UTC](https://discourse.nodered.org/t/challenge-solve-advent-of-code-puzzles-without-using-function-nodes/54556 "2021-12-01T09:56:37Z")

</div>

..or JSONata etc :slight\_smile: I'm doing them using Snap! but it would be fun to see how far into this years puzzles they could be done before code needed https://adventofcode.com

---

## [Node not deleting entirely](https://discourse.nodered.org/t/node-not-deleting-entirely/54482)

<div class="topic-metadata">

**Author:** [@lesmar96](https://discourse.nodered.org/u/lesmar96)\
**Replies:** 15\
**Last updated:** [1 December 2021 09:46 UTC](https://discourse.nodered.org/t/node-not-deleting-entirely/54482 "2021-12-01T09:46:58Z")

</div>

I have a small flow running that I had previously being pushing some data to ubidots via the ubidots-out node. I have quit using ubidots so I deleted the node from my flow. It no longer shows up in my flow anywhere, but…

---

## [Consistency on Chart Colors With Live Data](https://discourse.nodered.org/t/consistency-on-chart-colors-with-live-data/54530)

<div class="topic-metadata">

**Author:** [@aa0z](https://discourse.nodered.org/u/aa0z)\
**Replies:** 3\
**Last updated:** [1 December 2021 09:45 UTC](https://discourse.nodered.org/t/consistency-on-chart-colors-with-live-data/54530 "2021-12-01T09:45:31Z")

</div>

I've got quite a few charts & bar graphs in my dashboard that populate with live data. Being a newbie to charts and populating them with live data, no matter at the time interval the data gets pushed to a chart node, ho…

---

## [Iterate over config-nodes](https://discourse.nodered.org/t/iterate-over-config-nodes/54554)

<div class="topic-metadata">

**Author:** [@Dunken](https://discourse.nodered.org/u/Dunken)\
**Replies:** 1\
**Last updated:** [1 December 2021 09:31 UTC](https://discourse.nodered.org/t/iterate-over-config-nodes/54554 "2021-12-01T09:31:45Z")

</div>

Does Node-RED provide an API to iterate over the instances of my config-node on all flows in the backend? Any way how to achieve this?

---

## [Multiple Projects running at once](https://discourse.nodered.org/t/multiple-projects-running-at-once/54545)

<div class="topic-metadata">

**Author:** [@notscottsmith](https://discourse.nodered.org/u/notscottsmith)\
**Replies:** 1\
**Last updated:** [1 December 2021 08:09 UTC](https://discourse.nodered.org/t/multiple-projects-running-at-once/54545 "2021-12-01T08:09:06Z")

</div>

I've got Node Red v2 running with multiple instances to handle simultaneous projects. I've got a reverse proxy (traefik) sitting in front of it to handle the url component so that it's same except for the uri. I did read…

---

## [Node-red-contrib-influxdb function to pass a specific time query](https://discourse.nodered.org/t/node-red-contrib-influxdb-function-to-pass-a-specific-time-query/54414)

<div class="topic-metadata">

**Author:** [@adgardo](https://discourse.nodered.org/u/adgardo)\
**Replies:** 12\
**Last updated:** [1 December 2021 07:45 UTC](https://discourse.nodered.org/t/node-red-contrib-influxdb-function-to-pass-a-specific-time-query/54414 "2021-12-01T07:45:51Z")

</div>

Hello, I'm new to Node-RED and javascript... hope you can help! I want to perform a influxdb query between two specitic timestamps: boot, and now (being now the moment at which GPIO 21 turns to 0). I don't manage to c…

---

## [Problem with string.includes inside a function node](https://discourse.nodered.org/t/problem-with-string-includes-inside-a-function-node/54523)

<div class="topic-metadata">

**Author:** [@OriolFM](https://discourse.nodered.org/u/OriolFM)\
**Replies:** 2\
**Last updated:** [1 December 2021 07:43 UTC](https://discourse.nodered.org/t/problem-with-string-includes-inside-a-function-node/54523 "2021-12-01T07:43:24Z")

</div>

I have a function where I read a series of OPC-UA nodes from a machine. The OPC-UA node returns a message where msg.payload is an array of objects where the value, type of the variable and the timestamp are located. It …

[Previous page](https://discourse.nodered.org/latest.md?page=680)

[Next page](https://discourse.nodered.org/latest.md?page=682)