# General

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

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

**Page:** 281

---

## [Post API to Zulip server](https://discourse.nodered.org/t/post-api-to-zulip-server/71831)

<div class="topic-metadata">

**Author:** [@lesmar96](https://discourse.nodered.org/u/lesmar96)\
**Replies:** 6\
**Last updated:** [9 December 2022 18:16 UTC](https://discourse.nodered.org/t/post-api-to-zulip-server/71831 "2022-12-09T18:16:01Z")

</div>

I have the basics of Node-Red, but I am pretty green on APIs to web services. I have done it once or twice in the past and Node-Red made it so easy, such as the OpenWeatherMap node. But now I am trying a POST Api to our…

---

## [Multi-state switch + passthrough / msg parts](https://discourse.nodered.org/t/multi-state-switch-passthrough-msg-parts/70069)

<div class="topic-metadata">

**Author:** [@interscope101](https://discourse.nodered.org/u/interscope101)\
**Replies:** 52\
**Last updated:** [9 December 2022 17:38 UTC](https://discourse.nodered.org/t/multi-state-switch-passthrough-msg-parts/70069 "2022-12-09T17:38:48Z")

</div>

Hi there, I've been going in circles trying to get this (seemingly simple) config. I have a UI input template sending data to UI text node display. From the same input there is going to be two independent sets of d…

---

## [Reading data from MSSQL for a date range using DatePicker](https://discourse.nodered.org/t/reading-data-from-mssql-for-a-date-range-using-datepicker/71928)

<div class="topic-metadata">

**Author:** [@maskmanwithsword](https://discourse.nodered.org/u/maskmanwithsword)\
**Replies:** 5\
**Last updated:** [9 December 2022 17:31 UTC](https://discourse.nodered.org/t/reading-data-from-mssql-for-a-date-range-using-datepicker/71928 "2022-12-09T17:31:42Z")

</div>

Hi, Im having problem when reading data from MSSQL. I can't get the SQL statement right and get this error always. I did try to change the format type to the same as MSSQL, but it didn't work. this is my flow: f…

---

## [WASM powered Node-RED in a browser?](https://discourse.nodered.org/t/wasm-powered-node-red-in-a-browser/71898)

<div class="topic-metadata">

**Author:** [@Steveorevo](https://discourse.nodered.org/u/Steveorevo)\
**Replies:** 4\
**Last updated:** [9 December 2022 17:18 UTC](https://discourse.nodered.org/t/wasm-powered-node-red-in-a-browser/71898 "2022-12-09T17:18:31Z")

</div>

WASM Node-RED. Yeah, it’s a little cRazY, off the beaten path, and just plain nuts. But it does give birth to possibilities (if one’s creative enough to think out of the box). What is it? WASM (or WebAssembly), with a t…

---

## [Address multiple Outputs in a function node by name](https://discourse.nodered.org/t/address-multiple-outputs-in-a-function-node-by-name/71927)

<div class="topic-metadata">

**Author:** [@TheArcher](https://discourse.nodered.org/u/TheArcher)\
**Replies:** 2\
**Last updated:** [9 December 2022 16:38 UTC](https://discourse.nodered.org/t/address-multiple-outputs-in-a-function-node-by-name/71927 "2022-12-09T16:38:11Z")

</div>

Hello, I am currently using function nodes with multiple outputs. I know how to address them in the return statement, but I would like to address outputs defined directly with node.send() either via their index or, if a…

---

## [Russian translations for Node-RED](https://discourse.nodered.org/t/russian-translations-for-node-red/71916)

<div class="topic-metadata">

**Author:** [@dodther](https://discourse.nodered.org/u/dodther)\
**Replies:** 2\
**Last updated:** [9 December 2022 16:36 UTC](https://discourse.nodered.org/t/russian-translations-for-node-red/71916 "2022-12-09T16:36:22Z")

</div>

hi all. I like the project and would like to see it in my native language. To begin with, I decided to try my hand at a small module that I use myself. And now I want to add it to the general branch. The description say…

---

## [How do I set flow variables to preserve their value over a restart?](https://discourse.nodered.org/t/how-do-i-set-flow-variables-to-preserve-their-value-over-a-restart/71923)

<div class="topic-metadata">

**Author:** [@Mikee1234K](https://discourse.nodered.org/u/Mikee1234K)\
**Replies:** 6\
**Last updated:** [9 December 2022 16:35 UTC](https://discourse.nodered.org/t/how-do-i-set-flow-variables-to-preserve-their-value-over-a-restart/71923 "2022-12-09T16:35:38Z")

</div>

I have variables which add up during the day, for example power usgae, solar production etc. At midnight, I reset them to 0. So all is fine until I restart Node Red, as these values (I use flow.set/flow.get) then get los…

---

## [Trying to convert string to time](https://discourse.nodered.org/t/trying-to-convert-string-to-time/71915)

<div class="topic-metadata">

**Author:** [@Mikee1234K](https://discourse.nodered.org/u/Mikee1234K)\
**Replies:** 9\
**Last updated:** [9 December 2022 16:17 UTC](https://discourse.nodered.org/t/trying-to-convert-string-to-time/71915 "2022-12-09T16:17:44Z")

</div>

I am trying to convert a string to a time. The string is in payload.last\_change and is something like this: "/Date(1670584440811+0000)/" If I use this to convert the number to the time it works: var a = new Date(16705…

---

## [Connection lost - dashboard (and editor)](https://discourse.nodered.org/t/connection-lost-dashboard-and-editor/71890)

<div class="topic-metadata">

**Author:** [@aams](https://discourse.nodered.org/u/aams)\
**Replies:** 15\
**Last updated:** [9 December 2022 16:14 UTC](https://discourse.nodered.org/t/connection-lost-dashboard-and-editor/71890 "2022-12-09T16:14:12Z")

</div>

Hi, I had an issue earlier this week that you all helped solve (Thank you!). I have another, not sure if anyone has advice how to solve it. Seemingly randomly, the "connection lost" error will show up on the dashboard,…

---

## [Mosquttio tls works - but nodered needs no certificates?](https://discourse.nodered.org/t/mosquttio-tls-works-but-nodered-needs-no-certificates/71909)

<div class="topic-metadata">

**Author:** [@escapist3734](https://discourse.nodered.org/u/escapist3734)\
**Replies:** 3\
**Last updated:** [9 December 2022 15:26 UTC](https://discourse.nodered.org/t/mosquttio-tls-works-but-nodered-needs-no-certificates/71909 "2022-12-09T15:26:58Z")

</div>

Hey I've managed to implement tls on mosquitto broker. on CLI everything works fine. I connect the broker to my nodered and ticked "TLS" but in the configuration I have NOT upload any certificate and it works!? my c…

---

## [Data in influxdb](https://discourse.nodered.org/t/data-in-influxdb/71753)

<div class="topic-metadata">

**Author:** [@HansPeter](https://discourse.nodered.org/u/HansPeter)\
**Replies:** 6\
**Last updated:** [9 December 2022 13:56 UTC](https://discourse.nodered.org/t/data-in-influxdb/71753 "2022-12-09T13:56:40Z")

</div>

Hello, i have no experience with Node-Red, please help, because I tried for hours without success. I read my energy counter with Tasmota flashed NodeMCU and sent the values over MQTT to Mosquitto broker. With MQTT Expl…

---

## [Is Node-Red feasible for ETL](https://discourse.nodered.org/t/is-node-red-feasible-for-etl/71855)

<div class="topic-metadata">

**Author:** [@carl](https://discourse.nodered.org/u/carl)\
**Replies:** 6\
**Last updated:** [9 December 2022 13:00 UTC](https://discourse.nodered.org/t/is-node-red-feasible-for-etl/71855 "2022-12-09T13:00:19Z")

</div>

Hi All. I'm a Node-RED noob. Trying to figure out if Node-RED is a feasible option to import multiple csv files, perform some transforms ie. merges, joins, field level changes and mappings across staging tables. Usual E…

---

## [Count how many times the same unknown json value comes thru](https://discourse.nodered.org/t/count-how-many-times-the-same-unknown-json-value-comes-thru/71736)

<div class="topic-metadata">

**Author:** [@s3m1s0n1c](https://discourse.nodered.org/u/s3m1s0n1c)\
**Replies:** 17\
**Last updated:** [9 December 2022 12:53 UTC](https://discourse.nodered.org/t/count-how-many-times-the-same-unknown-json-value-comes-thru/71736 "2022-12-09T12:53:30Z")

</div>

Hey Brains Trust, I'm trying to do some stats for paging decoder I used a tcp to receive the JSON data from paging system I separate the data into Address, Alias and Agency & timestamp I would like to graph or get st…

---

## [Smart Nora + temperature?](https://discourse.nodered.org/t/smart-nora-temperature/71911)

<div class="topic-metadata">

**Author:** [@myozone](https://discourse.nodered.org/u/myozone)\
**Replies:** 7\
**Last updated:** [9 December 2022 11:53 UTC](https://discourse.nodered.org/t/smart-nora-temperature/71911 "2022-12-09T11:53:47Z")

</div>

I've just started playing with Smart Nora and wondering how to send temperature to a SN sensor node? I have a test that works but not sure the right way to implement it in a flow. the test inject is like this { "te…

---

## [Unable to create another node-red instance](https://discourse.nodered.org/t/unable-to-create-another-node-red-instance/71902)

<div class="topic-metadata">

**Author:** [@sahsha](https://discourse.nodered.org/u/sahsha)\
**Replies:** 4\
**Last updated:** [9 December 2022 10:25 UTC](https://discourse.nodered.org/t/unable-to-create-another-node-red-instance/71902 "2022-12-09T10:25:13Z")

</div>

I followed the above :point\_up: post. and using the below :point\_down: command to create another Node-RED instance. node-red -u /node-red-1881 -p 1881 But got an error :point\_down: node:internal/fs/utils:347 throw…

---

## [OPC UA Multiple Interval settings while using Subscription Option](https://discourse.nodered.org/t/opc-ua-multiple-interval-settings-while-using-subscription-option/71910)

<div class="topic-metadata">

**Author:** [@Manikandan](https://discourse.nodered.org/u/Manikandan)\
**Replies:** 0\
**Last updated:** [9 December 2022 10:15 UTC](https://discourse.nodered.org/t/opc-ua-multiple-interval-settings-while-using-subscription-option/71910 "2022-12-09T10:15:53Z")

</div>

hi, In my project, I was trying to set the OPC UA Subscription with two intervals using specific variable value \[ true \] from the read information received from the opc ua Client.and as soon as the value of variable cha…

---

## [Debug node disabled but keep printing](https://discourse.nodered.org/t/debug-node-disabled-but-keep-printing/71886)

<div class="topic-metadata">

**Author:** [@andre\_x](https://discourse.nodered.org/u/andre_x)\
**Replies:** 5\
**Last updated:** [9 December 2022 10:01 UTC](https://discourse.nodered.org/t/debug-node-disabled-but-keep-printing/71886 "2022-12-09T10:01:07Z")

</div>

Hi all! I have a couple of debug node that I've disabled but they keep printing in the debug section. I've tried to enable them, deploy, disable them and deploy again, but they keep printing!!! I don't know what else …

---

## [Please help me understand this error](https://discourse.nodered.org/t/please-help-me-understand-this-error/71906)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 6\
**Last updated:** [9 December 2022 09:51 UTC](https://discourse.nodered.org/t/please-help-me-understand-this-error/71906 "2022-12-09T09:51:52Z")

</div>

I'll keep it brief: I'm getting this error and can't find the person causing it. {"topic":"ERROR\_REPORT/TimePi/Telemetry","error":{"message":"ping: sendmsg: Network is unreachable\\n Please check that your service prov…

---

## [Can we use Jest for unit test?](https://discourse.nodered.org/t/can-we-use-jest-for-unit-test/13154)

<div class="topic-metadata">

**Author:** [@fangzhu](https://discourse.nodered.org/u/fangzhu)\
**Replies:** 3\
**Last updated:** [9 December 2022 09:41 UTC](https://discourse.nodered.org/t/can-we-use-jest-for-unit-test/13154 "2022-12-09T09:41:17Z")

</div>

The example in the document uses mocha for unit test using de-red-node-test-helper . Can we use Jest to test node?

---

## [How do I disable a helper button once a physical switch is toggled?](https://discourse.nodered.org/t/how-do-i-disable-a-helper-button-once-a-physical-switch-is-toggled/71904)

<div class="topic-metadata">

**Author:** [@technokul](https://discourse.nodered.org/u/technokul)\
**Replies:** 1\
**Last updated:** [9 December 2022 07:56 UTC](https://discourse.nodered.org/t/how-do-i-disable-a-helper-button-once-a-physical-switch-is-toggled/71904 "2022-12-09T07:56:59Z")

</div>

All my motion inputs have been converted to helper button to have a single press output rather than an on or a off out put. I use these button and their presses to set various lights "on" and "off" in our office. Probl…

---

## [Not able to start two streams after recovery](https://discourse.nodered.org/t/not-able-to-start-two-streams-after-recovery/71848)

<div class="topic-metadata">

**Author:** [@technokul](https://discourse.nodered.org/u/technokul)\
**Replies:** 8\
**Last updated:** [9 December 2022 06:26 UTC](https://discourse.nodered.org/t/not-able-to-start-two-streams-after-recovery/71848 "2022-12-09T06:26:41Z")

</div>

This flow was working flawlessly until I deleted Node-RED and recovered it from a back up. The second stream i.e. resetting the timer and then switching off the lights doesnt at all work now. The second stream or ou…

---

## [How to compose a array in required format](https://discourse.nodered.org/t/how-to-compose-a-array-in-required-format/71895)

<div class="topic-metadata">

**Author:** [@amit\_meld](https://discourse.nodered.org/u/amit_meld)\
**Replies:** 4\
**Last updated:** [9 December 2022 06:14 UTC](https://discourse.nodered.org/t/how-to-compose-a-array-in-required-format/71895 "2022-12-09T06:14:21Z")

</div>

Hi, I am trying to format and push an array to a Powerbi Streaming dataset using HTTP request node. Below is my code in the function node where data arrives from LORAWAN and after this I directly connect it to HTTP nod…

---

## [Easily create HTTP triggers with authentication in Node-RED using FlowForge](https://discourse.nodered.org/t/easily-create-http-triggers-with-authentication-in-node-red-using-flowforge/71896)

<div class="topic-metadata">

**Author:** [@robmarcer](https://discourse.nodered.org/u/robmarcer)\
**Replies:** 0\
**Last updated:** [9 December 2022 03:05 UTC](https://discourse.nodered.org/t/easily-create-http-triggers-with-authentication-in-node-red-using-flowforge/71896 "2022-12-09T03:05:44Z")

</div>

---

## [Sql query of Datetime column returning UTC time not the table data](https://discourse.nodered.org/t/sql-query-of-datetime-column-returning-utc-time-not-the-table-data/71814)

<div class="topic-metadata">

**Author:** [@Kimo](https://discourse.nodered.org/u/Kimo)\
**Replies:** 10\
**Last updated:** [9 December 2022 01:00 UTC](https://discourse.nodered.org/t/sql-query-of-datetime-column-returning-utc-time-not-the-table-data/71814 "2022-12-09T01:00:49Z")

</div>

Hi, I got an issue where I store a timestamp into a datetime table in sql and get result like this But then the problem is when I select query this data into nodered ui, it return the data in UTC format How I can …

---

## [French translations for Node-RED - call for help](https://discourse.nodered.org/t/french-translations-for-node-red-call-for-help/71660)

<div class="topic-metadata">

**Author:** [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Replies:** 5\
**Last updated:** [8 December 2022 21:25 UTC](https://discourse.nodered.org/t/french-translations-for-node-red-call-for-help/71660 "2022-12-08T21:25:40Z")

</div>

Hi all, @GogoVega has very kindly raised pull requests for bringing French translations to the node-red editor and nodes. Unfortunately, my French is pas très bien & we cannot merge changes without peer review. Are the…

---

## [Error: Hostname/IP doesn't match certificate's altnames](https://discourse.nodered.org/t/error-hostname-ip-doesnt-match-certificates-altnames/71837)

<div class="topic-metadata">

**Author:** [@benhelps](https://discourse.nodered.org/u/benhelps)\
**Replies:** 3\
**Last updated:** [8 December 2022 20:24 UTC](https://discourse.nodered.org/t/error-hostname-ip-doesnt-match-certificates-altnames/71837 "2022-12-08T20:24:16Z")

</div>

Recently I started getting the below from an external endpoint. "Error: Hostname/IP doesn't match certificate's altnames: "Host: wap.tplinkcloud.com. is not in the cert's altnames: DNS:rbictg.com, DNS:\*.rbictg.com"" I …

---

## [Help with JSONata](https://discourse.nodered.org/t/help-with-jsonata/71757)

<div class="topic-metadata">

**Author:** [@Kaij3](https://discourse.nodered.org/u/Kaij3)\
**Replies:** 13\
**Last updated:** [8 December 2022 17:44 UTC](https://discourse.nodered.org/t/help-with-jsonata/71757 "2022-12-08T17:44:39Z")

</div>

Hello everyone! I am facing issues where I am trying to query specific data from an array, example, if i only want the names for both routers , how do i do it? As I searched up, using jsonata would be easier but i am st…

---

## [Possible EventEmitter memory leak detected \[CommandEmitter\]](https://discourse.nodered.org/t/possible-eventemitter-memory-leak-detected-commandemitter/71857)

<div class="topic-metadata">

**Author:** [@Yury](https://discourse.nodered.org/u/Yury)\
**Replies:** 8\
**Last updated:** [8 December 2022 17:43 UTC](https://discourse.nodered.org/t/possible-eventemitter-memory-leak-detected-commandemitter/71857 "2022-12-08T17:43:17Z")

</div>

Greetings to all. Accidentally launched Node-RED from the command line and found: root@GigaIII-YN:/opt/etc/init.d$ ./S30node-red start0 root@GigaIII-YN:/opt/etc/init.d$ (node:11889) MaxListenersExceededWarning: Possibl…

---

## [Problem - npm: not found](https://discourse.nodered.org/t/problem-npm-not-found/71856)

<div class="topic-metadata">

**Author:** [@Yury](https://discourse.nodered.org/u/Yury)\
**Replies:** 10\
**Last updated:** [8 December 2022 17:35 UTC](https://discourse.nodered.org/t/problem-npm-not-found/71856 "2022-12-08T17:35:21Z")

</div>

Good afternoon, everyone. Please help. root@GigaIII-YN:/opt/bin$ node -v v16.16.0 Decided to update NPM: npm install -g npm@9.2.0 As a result: root@GigaIII-YN:/opt/bin$ npm -v /opt/bin/sh: npm: not found root@GigaI…

---

## [Need Help - Gives me error that it's looking for an ARRAY](https://discourse.nodered.org/t/need-help-gives-me-error-that-its-looking-for-an-array/71884)

<div class="topic-metadata">

**Author:** [@damica51](https://discourse.nodered.org/u/damica51)\
**Replies:** 4\
**Last updated:** [8 December 2022 17:22 UTC](https://discourse.nodered.org/t/need-help-gives-me-error-that-its-looking-for-an-array/71884 "2022-12-08T17:22:05Z")

</div>

I have a flow that I think is working the way it should but I'm getting an error when I try to Publish with MQTT Sparkplug. It tells me the "metrics" is looking for array. The problem is that I do have an array in the me…

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

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