# Latest

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

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

**Page:** 678

---

## [\[ANNOUNCE\] node-red-contrib-ui-svg: 2.3.1](https://discourse.nodered.org/t/announce-node-red-contrib-ui-svg-2-3-1/54894)

<div class="topic-metadata">

**Author:** [@BartButenaers](https://discourse.nodered.org/u/BartButenaers)\
**Replies:** 0\
**Last updated:** [8 December 2021 21:21 UTC](https://discourse.nodered.org/t/announce-node-red-contrib-ui-svg-2-3-1/54894 "2021-12-08T21:21:28Z")

</div>

Hi folks, Version 2.3.1 of the SVG node is available on NPM. See the release notes for more information. Bart

---

## [Is there a node available like the "events state" node of Home Assistant that gives updates of the final time (when the node is waiting) when the node will continue with the output?](https://discourse.nodered.org/t/is-there-a-node-available-like-the-events-state-node-of-home-assistant-that-gives-updates-of-the-final-time-when-the-node-is-waiting-when-the-node-will-continue-with-the-output/54835)

<div class="topic-metadata">

**Author:** [@martinst](https://discourse.nodered.org/u/martinst)\
**Replies:** 8\
**Last updated:** [8 December 2021 21:14 UTC](https://discourse.nodered.org/t/is-there-a-node-available-like-the-events-state-node-of-home-assistant-that-gives-updates-of-the-final-time-when-the-node-is-waiting-when-the-node-will-continue-with-the-output/54835 "2021-12-08T21:14:10Z")

</div>

I have created a flow to control my covers to go up or down depending if the sun is shining at my windows by using an illuminance sensor. For this I'm using the "events state" node for Home Assistant in Node-RED. So I …

---

## [4 lane traffic light control with raspberry Pi and Node red](https://discourse.nodered.org/t/4-lane-traffic-light-control-with-raspberry-pi-and-node-red/54852)

<div class="topic-metadata">

**Author:** [@hasan\_s\_m](https://discourse.nodered.org/u/hasan_s_m)\
**Replies:** 1\
**Last updated:** [8 December 2021 20:33 UTC](https://discourse.nodered.org/t/4-lane-traffic-light-control-with-raspberry-pi-and-node-red/54852 "2021-12-08T20:33:05Z")

</div>

flows.json (72.8 KB)

---

## [Uploading data to a mySQL database](https://discourse.nodered.org/t/uploading-data-to-a-mysql-database/54844)

<div class="topic-metadata">

**Author:** [@evanic14](https://discourse.nodered.org/u/evanic14)\
**Replies:** 33\
**Last updated:** [8 December 2021 20:10 UTC](https://discourse.nodered.org/t/uploading-data-to-a-mysql-database/54844 "2021-12-08T20:10:57Z")

</div>

hello, i'm trying to upload diffrent variables to my mySQL database but i can't get it to inject the info correctly. this has something to do with my queries. Can someone help me? This is one of the queries i'm using: …

---

## [I cant use python function a lot of errors keep appearing](https://discourse.nodered.org/t/i-cant-use-python-function-a-lot-of-errors-keep-appearing/54878)

<div class="topic-metadata">

**Author:** [@Mahmoud19](https://discourse.nodered.org/u/Mahmoud19)\
**Replies:** 4\
**Last updated:** [8 December 2021 19:27 UTC](https://discourse.nodered.org/t/i-cant-use-python-function-a-lot-of-errors-keep-appearing/54878 "2021-12-08T19:27:34Z")

</div>

I cant use the python function a lot of errors keep appearing on debug panel deploying is successful but when I inject or run it keep showing 4 error on debug these are the 4 errors \*\*Traceback (most recent call last)…

---

## [Coloured syntax helpers in function node disappeared. Now all code is black](https://discourse.nodered.org/t/coloured-syntax-helpers-in-function-node-disappeared-now-all-code-is-black/54842)

<div class="topic-metadata">

**Author:** [@metter](https://discourse.nodered.org/u/metter)\
**Replies:** 2\
**Last updated:** [8 December 2021 19:03 UTC](https://discourse.nodered.org/t/coloured-syntax-helpers-in-function-node-disappeared-now-all-code-is-black/54842 "2021-12-08T19:03:20Z")

</div>

all the code in all my function nodes is all the sudden all black. I cannot tell exactly from when that happened, but all the coloured code markup has disappeared and the code is now displayed all in black. I have rest…

---

## [Sqlite large file import - best practice?](https://discourse.nodered.org/t/sqlite-large-file-import-best-practice/54753)

<div class="topic-metadata">

**Author:** [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Replies:** 2\
**Last updated:** [8 December 2021 18:33 UTC](https://discourse.nodered.org/t/sqlite-large-file-import-best-practice/54753 "2021-12-08T18:33:10Z")

</div>

I have a large (700MB+) tab separated file and want to insert this into a sqlite db. On the commandline I could do a dot command and perform an import using mode tabs or read commands, which is extremely fast. Let's as…

---

## [How can I work with ioBroker-variables in Node-red function?](https://discourse.nodered.org/t/how-can-i-work-with-iobroker-variables-in-node-red-function/54884)

<div class="topic-metadata">

**Author:** [@JonasBu](https://discourse.nodered.org/u/JonasBu)\
**Replies:** 7\
**Last updated:** [8 December 2021 17:37 UTC](https://discourse.nodered.org/t/how-can-i-work-with-iobroker-variables-in-node-red-function/54884 "2021-12-08T17:37:35Z")

</div>

Hi I want to read sensor-data, store these values in iobroker and later i want to sum the variables in a function-node. My function code: var dcPower = env.get("msg.dc.power"); var wallbox1Power = env.get("msg.wallbo…

---

## [HTTP GET request help needed](https://discourse.nodered.org/t/http-get-request-help-needed/54710)

<div class="topic-metadata">

**Author:** [@grant1](https://discourse.nodered.org/u/grant1)\
**Replies:** 15\
**Last updated:** [8 December 2021 17:17 UTC](https://discourse.nodered.org/t/http-get-request-help-needed/54710 "2021-12-08T17:17:21Z")

</div>

Over a year ago, I was trying to find a way to acquire values from a compressor that is connected to our LAN. The device (at 192.168.8.134) supplies a simple web page that displays live operating data. I am interested …

---

## [Inject nodes not started with node 16](https://discourse.nodered.org/t/inject-nodes-not-started-with-node-16/54393)

<div class="topic-metadata">

**Author:** [@augjoh](https://discourse.nodered.org/u/augjoh)\
**Replies:** 8\
**Last updated:** [8 December 2021 15:58 UTC](https://discourse.nodered.org/t/inject-nodes-not-started-with-node-16/54393 "2021-12-08T15:58:47Z")

</div>

When using node 16 inject nodes do not start anymore: 27 Nov 19:35:08 - \[info\] Welcome to Node-RED =================== 27 Nov 19:35:08 - \[info\] Node-RED version: v2.1.3-git 27 Nov 19:35:08 - \[info\] Node.js version: v…

---

## [In node-red snap how to change the settings.js file](https://discourse.nodered.org/t/in-node-red-snap-how-to-change-the-settings-js-file/8411)

<div class="topic-metadata">

**Author:** [@VIKRAMAS](https://discourse.nodered.org/u/VIKRAMAS)\
**Replies:** 4\
**Last updated:** [8 December 2021 14:59 UTC](https://discourse.nodered.org/t/in-node-red-snap-how-to-change-the-settings-js-file/8411 "2021-12-08T14:59:24Z")

</div>

I have deployed the node-red snap in ubuntu 16 core. Now i want to change the settings.js file how can I change.

---

## [Node red + InfluxDB question](https://discourse.nodered.org/t/node-red-influxdb-question/54877)

<div class="topic-metadata">

**Author:** [@traderjoe](https://discourse.nodered.org/u/traderjoe)\
**Replies:** 6\
**Last updated:** [8 December 2021 14:58 UTC](https://discourse.nodered.org/t/node-red-influxdb-question/54877 "2021-12-08T14:58:37Z")

</div>

I have a project that uses NR + influxDB. I have grafana displaying my data, but the chart is embedded into an NR page. I'm trying to avoid using grafana dashboard. I'm just embedding the charts. from NR, how do I do…

---

## [Struggling with string, arrays and JSONobjects](https://discourse.nodered.org/t/struggling-with-string-arrays-and-jsonobjects/54879)

<div class="topic-metadata">

**Author:** [@Melliott](https://discourse.nodered.org/u/Melliott)\
**Replies:** 2\
**Last updated:** [8 December 2021 14:37 UTC](https://discourse.nodered.org/t/struggling-with-string-arrays-and-jsonobjects/54879 "2021-12-08T14:37:47Z")

</div>

I've been trying to set up a flow to look at a certain website, extract a value and then return a colour based on what was on the website. That bit is all fine, but it's the next step where I need to then display this in…

---

## [Dashboard adjust next few days off](https://discourse.nodered.org/t/dashboard-adjust-next-few-days-off/54822)

<div class="topic-metadata">

**Author:** [@RGebel](https://discourse.nodered.org/u/RGebel)\
**Replies:** 3\
**Last updated:** [8 December 2021 13:53 UTC](https://discourse.nodered.org/t/dashboard-adjust-next-few-days-off/54822 "2021-12-08T13:53:38Z")

</div>

looking for any ideas, I have node-red in an work environment. If a worker does not show up for work or takes vacation i would like to alter that event to not turn on while worker is off.

---

## [Extracting from a string that can change](https://discourse.nodered.org/t/extracting-from-a-string-that-can-change/54863)

<div class="topic-metadata">

**Author:** [@dougle03](https://discourse.nodered.org/u/dougle03)\
**Replies:** 9\
**Last updated:** [8 December 2021 13:33 UTC](https://discourse.nodered.org/t/extracting-from-a-string-that-can-change/54863 "2021-12-08T13:33:57Z")

</div>

Morning all, got a little problem that's stumpted me. I get an SMS message from an RV HVAC system that bears several metrics in a single string. I've used a change node with regex strings to extract the variables, howev…

---

## [Number of times a value appears in a object](https://discourse.nodered.org/t/number-of-times-a-value-appears-in-a-object/54833)

<div class="topic-metadata">

**Author:** [@DVSL](https://discourse.nodered.org/u/DVSL)\
**Replies:** 4\
**Last updated:** [8 December 2021 13:40 UTC](https://discourse.nodered.org/t/number-of-times-a-value-appears-in-a-object/54833 "2021-12-08T13:40:54Z")

</div>

Hi, hope this find you well. I have an object like the one in the image bellow, and I would like to know the number of times a value appear in a certain key. So, In the key "Type" I would like to have an output like "Lem…

---

## [How to make http-request not encode uri?](https://discourse.nodered.org/t/how-to-make-http-request-not-encode-uri/54867)

<div class="topic-metadata">

**Author:** [@kjellskogsrud](https://discourse.nodered.org/u/kjellskogsrud)\
**Replies:** 6\
**Last updated:** [8 December 2021 11:58 UTC](https://discourse.nodered.org/t/how-to-make-http-request-not-encode-uri/54867 "2021-12-08T11:58:49Z")

</div>

Hi, I am using node-red to get some data from a REST-like API endpoint. The general endpoint is like this: some.domain.here/controller/value/signalname filling in the values for the controller, value, and the signal h…

---

## [How to render the following template?](https://discourse.nodered.org/t/how-to-render-the-following-template/54869)

<div class="topic-metadata">

**Author:** [@gitmirko](https://discourse.nodered.org/u/gitmirko)\
**Replies:** 5\
**Last updated:** [8 December 2021 12:10 UTC](https://discourse.nodered.org/t/how-to-render-the-following-template/54869 "2021-12-08T12:10:55Z")

</div>

Hi, I'm struggling for hours to find the right approach to render the following template to be rendered by Home Assistant at the end. Right now I was able to use the template node to render the following template: sta…

---

## [Sending payload if other payload is true](https://discourse.nodered.org/t/sending-payload-if-other-payload-is-true/54824)

<div class="topic-metadata">

**Author:** [@MR76](https://discourse.nodered.org/u/MR76)\
**Replies:** 4\
**Last updated:** [8 December 2021 12:09 UTC](https://discourse.nodered.org/t/sending-payload-if-other-payload-is-true/54824 "2021-12-08T12:09:52Z")

</div>

Hi, I'm new to Node-RED and don't a lot of experience with Java. I have a payload containing a number that I only want to send if another payload I have has the number 1. If it is 0 I want the flow to stop. What is the …

---

## [Syntax Highlighting gone](https://discourse.nodered.org/t/syntax-highlighting-gone/54201)

<div class="topic-metadata">

**Author:** [@Chorum](https://discourse.nodered.org/u/Chorum)\
**Replies:** 6\
**Last updated:** [8 December 2021 11:08 UTC](https://discourse.nodered.org/t/syntax-highlighting-gone/54201 "2021-12-08T11:08:41Z")

</div>

Hello, as i opened my first function node today, i realized that the javascript highlighting was gone. Its like there no syntax detection. no automatic "",() and so on. Is there a way to get it back ? Greetings Chor…

---

## [Debug - 'Filter this node' - behavior (bug?)](https://discourse.nodered.org/t/debug-filter-this-node-behavior-bug/54861)

<div class="topic-metadata">

**Author:** [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Replies:** 2\
**Last updated:** [8 December 2021 09:41 UTC](https://discourse.nodered.org/t/debug-filter-this-node-behavior-bug/54861 "2021-12-08T09:41:08Z")

</div>

In the debug window This does not appear to do anything when selected. Should this update the selected nodes ? No errors in console. 8 Dec 09:25:53 - \[info\] Node-RED version: v2.1.4 8 Dec 09:25:53 - \[info\] Node.js …

---

## [Error: Disconnected from MQTT broker](https://discourse.nodered.org/t/error-disconnected-from-mqtt-broker/54772)

<div class="topic-metadata">

**Author:** [@Utkarsh](https://discourse.nodered.org/u/Utkarsh)\
**Replies:** 22\
**Last updated:** [8 December 2021 07:20 UTC](https://discourse.nodered.org/t/error-disconnected-from-mqtt-broker/54772 "2021-12-08T07:20:49Z")

</div>

I am using Node-red to listen the data form The things stack (LoRa) with MQTT node and then save the data to SQL and showing it on Dashboard. The integration works fine but every night node red stops running with the er…

---

## [Sigfox callback - Nodered](https://discourse.nodered.org/t/sigfox-callback-nodered/54671)

<div class="topic-metadata">

**Author:** [@FeliceM](https://discourse.nodered.org/u/FeliceM)\
**Replies:** 7\
**Last updated:** [8 December 2021 06:45 UTC](https://discourse.nodered.org/t/sigfox-callback-nodered/54671 "2021-12-08T06:45:43Z")

</div>

A generic question for a specific application. I have started testing Sigfox and I see the messages being sent by the Pi and well received on the Sigfox backend service. I would like now to get the message from the Sig…

---

## [\[Announce\] node-red-contrib-ui-contextmenu](https://discourse.nodered.org/t/announce-node-red-contrib-ui-contextmenu/16211)

<div class="topic-metadata">

**Author:** [@BartButenaers](https://discourse.nodered.org/u/BartButenaers)\
**Replies:** 55\
**Last updated:** [8 December 2021 03:20 UTC](https://discourse.nodered.org/t/announce-node-red-contrib-ui-contextmenu/16211 "2021-12-08T03:20:08Z")

</div>

Hi folks, The new node-red-contrib-ui-contextmenu node allows users to add a popup context menu to their Node-RED dasbhoard. My partner in crime (@Steve-Mcl) and myself have developed this new node to be used in combin…

---

## [Reading a Node's message payload when the state changes and putting that into another Node](https://discourse.nodered.org/t/reading-a-nodes-message-payload-when-the-state-changes-and-putting-that-into-another-node/54805)

<div class="topic-metadata">

**Author:** [@dastrix](https://discourse.nodered.org/u/dastrix)\
**Replies:** 13\
**Last updated:** [8 December 2021 03:10 UTC](https://discourse.nodered.org/t/reading-a-nodes-message-payload-when-the-state-changes-and-putting-that-into-another-node/54805 "2021-12-08T03:10:17Z")

</div>

Hi All, I have a reed switch on a gate, when the switch triggers it updates on my device from false, to true. Is there a way that when this occurs, that it populates a node? Intention is to get this information into Op…

---

## [Editor Tab names restart from Flow 1 upon browser restart/refresh](https://discourse.nodered.org/t/editor-tab-names-restart-from-flow-1-upon-browser-restart-refresh/54828)

<div class="topic-metadata">

**Author:** [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Replies:** 4\
**Last updated:** [8 December 2021 01:16 UTC](https://discourse.nodered.org/t/editor-tab-names-restart-from-flow-1-upon-browser-restart-refresh/54828 "2021-12-08T01:16:32Z")

</div>

The tab names restart from Flow 1 upon browser refresh, even though already tab name is present. is this a known feature ? if yes, please ignore my observation. Will duplicate tab name have any issue in our project ? i…

---

## [A handy way for testing different ways of doing something in your flows](https://discourse.nodered.org/t/a-handy-way-for-testing-different-ways-of-doing-something-in-your-flows/54724)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 12\
**Last updated:** [7 December 2021 22:14 UTC](https://discourse.nodered.org/t/a-handy-way-for-testing-different-ways-of-doing-something-in-your-flows/54724 "2021-12-07T22:14:49Z")

</div>

If you are only clawing your way through node-red and are open to trying different ways to get something done, this maybe handy for you. Here you can see how I have one incoming message and you are not sure which cod…

---

## [Fail to build node-red-node-sqlite](https://discourse.nodered.org/t/fail-to-build-node-red-node-sqlite/54836)

<div class="topic-metadata">

**Author:** [@Pane19](https://discourse.nodered.org/u/Pane19)\
**Replies:** 7\
**Last updated:** [7 December 2021 22:16 UTC](https://discourse.nodered.org/t/fail-to-build-node-red-node-sqlite/54836 "2021-12-07T22:16:12Z")

</div>

Hello there! Long time playing around node-red but I never had unknown issues so far, until today... I was testing few things with node-sqlite in home assistant node-red add on, running on vmware virtual machine. Insta…

---

## [WebSocket connection handshake 404 on /comms (nginx to Node-RED does block Websocket communication)](https://discourse.nodered.org/t/websocket-connection-handshake-404-on-comms-nginx-to-node-red-does-block-websocket-communication/15619)

<div class="topic-metadata">

**Author:** [@Navid](https://discourse.nodered.org/u/Navid)\
**Replies:** 5\
**Last updated:** [7 December 2021 20:07 UTC](https://discourse.nodered.org/t/websocket-connection-handshake-404-on-comms-nginx-to-node-red-does-block-websocket-communication/15619 "2021-12-07T20:07:36Z")

</div>

Hello the community, I am actually facing a problem related to Nginx configuration. Through the nginx.conf, we redirect all the http/https traffic from a specific server\_name to the port 1880 where Node-RED is running …

---

## [Configuring Header to work with a specific API](https://discourse.nodered.org/t/configuring-header-to-work-with-a-specific-api/54832)

<div class="topic-metadata">

**Author:** [@cabh](https://discourse.nodered.org/u/cabh)\
**Replies:** 6\
**Last updated:** [7 December 2021 19:32 UTC](https://discourse.nodered.org/t/configuring-header-to-work-with-a-specific-api/54832 "2021-12-07T19:32:37Z")

</div>

I am attempting to get an HTTP API request to work. I have multiple different connections to various products / API's / Websites / hardware using . Just one I am struggling with and it is to my ignorance on configuring t…

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

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