# Latest

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

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

**Page:** 792

---

## [Syntax for sending mqtt variable](https://discourse.nodered.org/t/syntax-for-sending-mqtt-variable/47318)

<div class="topic-metadata">

**Author:** [@kenkoknz](https://discourse.nodered.org/u/kenkoknz)\
**Replies:** 1\
**Last updated:** [18 June 2021 05:49 UTC](https://discourse.nodered.org/t/syntax-for-sending-mqtt-variable/47318 "2021-06-18T05:49:36Z")

</div>

Hi, This sould be a simple one. I set up an espeasy connected to a lcd, listening for cmd from mqtt to display data. In NR I use a mqtt node and inject a payload of: lcd,3,1,abc and the lcd display abc, so all good t…

---

## [Embed node red with node JS](https://discourse.nodered.org/t/embed-node-red-with-node-js/47319)

<div class="topic-metadata">

**Author:** [@OmkarNodered](https://discourse.nodered.org/u/OmkarNodered)\
**Replies:** 0\
**Last updated:** [18 June 2021 04:57 UTC](https://discourse.nodered.org/t/embed-node-red-with-node-js/47319 "2021-06-18T04:57:47Z")

</div>

Hello, I have node red flow which I want to embed with node js and run it. Can anyone help me with that how we can use node red and node js together?

---

## [Better way to do this flow?](https://discourse.nodered.org/t/better-way-to-do-this-flow/47269)

<div class="topic-metadata">

**Author:** [@grafix707](https://discourse.nodered.org/u/grafix707)\
**Replies:** 9\
**Last updated:** [18 June 2021 04:47 UTC](https://discourse.nodered.org/t/better-way-to-do-this-flow/47269 "2021-06-18T04:47:07Z")

</div>

I'm trying to cycle through 4 different lights from sunset to sunrise. I'm sure there is a better/cleaner approach to this, looking for someone to point me in the right direction.

---

## [Best way for emulating time of use electricity rates?](https://discourse.nodered.org/t/best-way-for-emulating-time-of-use-electricity-rates/46062)

<div class="topic-metadata">

**Author:** [@poldim](https://discourse.nodered.org/u/poldim)\
**Replies:** 20\
**Last updated:** [18 June 2021 03:31 UTC](https://discourse.nodered.org/t/best-way-for-emulating-time-of-use-electricity-rates/46062 "2021-06-18T03:31:30Z")

</div>

I'm trying to set a variable in home assistant of which electricity rate I'm currently on. My utility has 3 different rates (peak, partial peak, and off peak) which vary based on day of the week (weekday vs weekend) and…

---

## [MSSQL node imports "xxx... & ... " to "xxx... &amp; ..."](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298)

<div class="topic-metadata">

**Author:** [@IoTPlay](https://discourse.nodered.org/u/IoTPlay)\
**Replies:** 18\
**Last updated:** [17 June 2021 20:48 UTC](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298 "2021-06-17T20:48:17Z")

</div>

Hi, MSQL node converts the "&" into "&amp;" in a text field. Here is the code in the MSSQL node: INSERT INTO \[mrs\_Work\] (PrjNo, ProjectName) VALUES ( '{{{payload.PrjNo}}}', '{{{payload.ProjectName}}}' ) The inb…

---

## [Http node: simple website url & port](https://discourse.nodered.org/t/http-node-simple-website-url-port/47270)

<div class="topic-metadata">

**Author:** [@kenkoknz](https://discourse.nodered.org/u/kenkoknz)\
**Replies:** 3\
**Last updated:** [17 June 2021 19:45 UTC](https://discourse.nodered.org/t/http-node-simple-website-url-port/47270 "2021-06-17T19:45:54Z")

</div>

Hi, I was playing around with http nodes and created a simple webpage. To access the page, the url I type in is ipaddr:1880/webservername. I can access the page ok and send data to the page (with ipaddr:1880/webserverna…

---

## [Change a value in a message object](https://discourse.nodered.org/t/change-a-value-in-a-message-object/47304)

<div class="topic-metadata">

**Author:** [@descoward](https://discourse.nodered.org/u/descoward)\
**Replies:** 2\
**Last updated:** [17 June 2021 18:32 UTC](https://discourse.nodered.org/t/change-a-value-in-a-message-object/47304 "2021-06-17T18:32:48Z")

</div>

Hi I have the following function as part of my weather station dashboard- var m = { "series": \["Rainfall"\], "data":\[msg.payload\[0\] \["sum(RAINFALL)"\]\], "labels":\["Todays Rainfall"\] }; return {payload:\[m\]}; Long st…

---

## [Zigbe Xiaomi TrHP sensor + CC2531](https://discourse.nodered.org/t/zigbe-xiaomi-trhp-sensor-cc2531/47297)

<div class="topic-metadata">

**Author:** [@farcry](https://discourse.nodered.org/u/farcry)\
**Replies:** 1\
**Last updated:** [17 June 2021 15:46 UTC](https://discourse.nodered.org/t/zigbe-xiaomi-trhp-sensor-cc2531/47297 "2021-06-17T15:46:12Z")

</div>

Hello. Is it possible to use CC2531 to sniff ZigBee packets without using zigbee2mqtt? Thanks.

---

## [Quickstart nao esta conectando](https://discourse.nodered.org/t/quickstart-nao-esta-conectando/47299)

<div class="topic-metadata">

**Author:** [@emerson4594](https://discourse.nodered.org/u/emerson4594)\
**Replies:** 0\
**Last updated:** [17 June 2021 14:32 UTC](https://discourse.nodered.org/t/quickstart-nao-esta-conectando/47299 "2021-06-17T14:32:09Z")

</div>

ola, estava usando o nó watson para comunicar com o nó ibmiot porem parou de funcionar

---

## [Is there a way to disable password auth when using upstream 2FA?](https://discourse.nodered.org/t/is-there-a-way-to-disable-password-auth-when-using-upstream-2fa/47087)

<div class="topic-metadata">

**Author:** [@poldim](https://discourse.nodered.org/u/poldim)\
**Replies:** 2\
**Last updated:** [17 June 2021 14:30 UTC](https://discourse.nodered.org/t/is-there-a-way-to-disable-password-auth-when-using-upstream-2fa/47087 "2021-06-17T14:30:29Z")

</div>

Looking at the docs, I don't see an obvious way to disable the login requirements. Is this an option? I'm using a combination of reverse proxy and 2FA authentication through Authelia and Duo. As it's configured now, I…

---

## [Unable to reach Node-red editor after install on AWS](https://discourse.nodered.org/t/unable-to-reach-node-red-editor-after-install-on-aws/47289)

<div class="topic-metadata">

**Author:** [@ninjamoba](https://discourse.nodered.org/u/ninjamoba)\
**Replies:** 1\
**Last updated:** [17 June 2021 13:43 UTC](https://discourse.nodered.org/t/unable-to-reach-node-red-editor-after-install-on-aws/47289 "2021-06-17T13:43:01Z")

</div>

HI can someone spin up an instance on a EC2 instance please and successfully connect - Amazon help staff confirms this error is repeatable. Im not getting access to the webpage at publicIP:1880 after following Running …

---

## [OMRON FINS Write](https://discourse.nodered.org/t/omron-fins-write/47295)

<div class="topic-metadata">

**Author:** [@JoshuaG](https://discourse.nodered.org/u/JoshuaG)\
**Replies:** 2\
**Last updated:** [17 June 2021 13:41 UTC](https://discourse.nodered.org/t/omron-fins-write/47295 "2021-06-17T13:41:53Z")

</div>

Trying to write a bit to OMROM PLC using FINS Write node. I have E0\_22228.2 set as my address. I am passing a payload of 1 and 0, 5 seconds apart, i have even formatted them to be arrays i.e. \[1\] and \[0\]. the node ret…

---

## [RPI Passive Heatsink getting hot running new install RPI with Node Red](https://discourse.nodered.org/t/rpi-passive-heatsink-getting-hot-running-new-install-rpi-with-node-red/47296)

<div class="topic-metadata">

**Author:** [@CarloJongen](https://discourse.nodered.org/u/CarloJongen)\
**Replies:** 1\
**Last updated:** [17 June 2021 13:29 UTC](https://discourse.nodered.org/t/rpi-passive-heatsink-getting-hot-running-new-install-rpi-with-node-red/47296 "2021-06-17T13:29:34Z")

</div>

I'm not sure if this is Node Red related but I've noticed this issue when I installed everything to run Node Red on a new RPI. I've installed Node Red on an RPI ( see details below RPI A ) in 2019 and all runs fine. The…

---

## [Help with Flow - Compare 2 temperatures and send pushover to close windows](https://discourse.nodered.org/t/help-with-flow-compare-2-temperatures-and-send-pushover-to-close-windows/47278)

<div class="topic-metadata">

**Author:** [@m4a0x4](https://discourse.nodered.org/u/m4a0x4)\
**Replies:** 4\
**Last updated:** [17 June 2021 11:56 UTC](https://discourse.nodered.org/t/help-with-flow-compare-2-temperatures-and-send-pushover-to-close-windows/47278 "2021-06-17T11:56:13Z")

</div>

Dear community, I am quite new to node red and already managed some flows. But there is one thing I cannot figure out. I want to compare two temperature readings (one indoor, one outdoor) and then send a pushover (k…

---

## [Node red-Aqara devices not working](https://discourse.nodered.org/t/node-red-aqara-devices-not-working/47253)

<div class="topic-metadata">

**Author:** [@Justin\_C](https://discourse.nodered.org/u/Justin_C)\
**Replies:** 3\
**Last updated:** [17 June 2021 11:50 UTC](https://discourse.nodered.org/t/node-red-aqara-devices-not-working/47253 "2021-06-17T11:50:21Z")

</div>

i am new to HA and Node Red. i have the devices(mini switch, door sensor, body sensor, Smart outlet, wall Light switch) connected the the hub and the hub is connected to HA. i can use all the devices including the hub in…

---

## [Setting http request url parmaters from msg.payload values](https://discourse.nodered.org/t/setting-http-request-url-parmaters-from-msg-payload-values/47279)

<div class="topic-metadata">

**Author:** [@laurialo](https://discourse.nodered.org/u/laurialo)\
**Replies:** 4\
**Last updated:** [17 June 2021 11:06 UTC](https://discourse.nodered.org/t/setting-http-request-url-parmaters-from-msg-payload-values/47279 "2021-06-17T11:06:36Z")

</div>

Hello ! I created a following flow: After the split node i use the change node where i want use the payload values as url parameters to make new API request. My change node: My split node output debug console: …

---

## [Unit testing can't load node in my it block?](https://discourse.nodered.org/t/unit-testing-cant-load-node-in-my-it-block/47288)

<div class="topic-metadata">

**Author:** [@zoujagger](https://discourse.nodered.org/u/zoujagger)\
**Replies:** 4\
**Last updated:** [17 June 2021 10:39 UTC](https://discourse.nodered.org/t/unit-testing-cant-load-node-in-my-it-block/47288 "2021-06-17T10:39:33Z")

</div>

hi guys, I've node-red installed globally and from my custom node project i've installed npm install node-red-node-test-helper node-red --save-dev test fail when i run npm test from my custom node project. should b…

---

## [How to attach (client side generated) excel file to email](https://discourse.nodered.org/t/how-to-attach-client-side-generated-excel-file-to-email/46826)

<div class="topic-metadata">

**Author:** [@pranavthakkar](https://discourse.nodered.org/u/pranavthakkar)\
**Replies:** 20\
**Last updated:** [17 June 2021 10:13 UTC](https://discourse.nodered.org/t/how-to-attach-client-side-generated-excel-file-to-email/46826 "2021-06-17T10:13:28Z")

</div>

Hey folks! I have a flow where I'm able to get the data from the database to the HTML table. after that, on the dashboard, I can click the export excel button and get the excel sheet of that data. But I wanted to attach…

---

## [Email with csv attachment. Open with Excel](https://discourse.nodered.org/t/email-with-csv-attachment-open-with-excel/47236)

<div class="topic-metadata">

**Author:** [@Kanban](https://discourse.nodered.org/u/Kanban)\
**Replies:** 5\
**Last updated:** [17 June 2021 09:59 UTC](https://discourse.nodered.org/t/email-with-csv-attachment-open-with-excel/47236 "2021-06-17T09:59:16Z")

</div>

Hey everybody, i know that there are already quite similar topics discussing this issue. But non of the solutions there worked for me. I'm creating a csv file to store an order list and then sending this file per Email.…

---

## [Angular Notifications](https://discourse.nodered.org/t/angular-notifications/47232)

<div class="topic-metadata">

**Author:** [@d0d04m3](https://discourse.nodered.org/u/d0d04m3)\
**Replies:** 11\
**Last updated:** [17 June 2021 09:51 UTC](https://discourse.nodered.org/t/angular-notifications/47232 "2021-06-17T09:51:44Z")

</div>

hi Can you use Angular Notifications in red dashboard I am interested in such ngx-Notifications Soft Notifications How are they used with NR Dashboard ???

---

## [Node-RED Dashboard Audio Out voice options](https://discourse.nodered.org/t/node-red-dashboard-audio-out-voice-options/47281)

<div class="topic-metadata">

**Author:** [@Skandha](https://discourse.nodered.org/u/Skandha)\
**Replies:** 2\
**Last updated:** [17 June 2021 09:25 UTC](https://discourse.nodered.org/t/node-red-dashboard-audio-out-voice-options/47281 "2021-06-17T09:25:23Z")

</div>

Hello Node-RED community, this is the first time I posted a question in this forum. Please forgive me if there is anything that I said that might be inappropriate. I'm interested in using the Dashboard node audio out i…

---

## [Error loading node-red](https://discourse.nodered.org/t/error-loading-node-red/47219)

<div class="topic-metadata">

**Author:** [@sahsha](https://discourse.nodered.org/u/sahsha)\
**Replies:** 13\
**Last updated:** [17 June 2021 09:21 UTC](https://discourse.nodered.org/t/error-loading-node-red/47219 "2021-06-17T09:21:34Z")

</div>

I'm getting error while running node-red. I followed the forum: Added the DEBUG line & getting the details as follows. SyntaxError: missing ) after argument list at Object.compileFunction (node:vm:353:18) at wrapSa…

---

## [Deploy failing. No response from server (node:function)](https://discourse.nodered.org/t/deploy-failing-no-response-from-server-node-function/47244)

<div class="topic-metadata">

**Author:** [@lostbits](https://discourse.nodered.org/u/lostbits)\
**Replies:** 5\
**Last updated:** [17 June 2021 09:17 UTC](https://discourse.nodered.org/t/deploy-failing-no-response-from-server-node-function/47244 "2021-06-17T09:17:46Z")

</div>

Hey I got a strange behavior with node Red. I installed version node Red v1.3.5 with Node JS 14.16 on 3 PCs. On one PC I cant update function blocks! I already testet the following: I closed node Red and then startet…

---

## [Redundant node-red instances plugged on AWS IOT CORE](https://discourse.nodered.org/t/redundant-node-red-instances-plugged-on-aws-iot-core/45856)

<div class="topic-metadata">

**Author:** [@etawyy](https://discourse.nodered.org/u/etawyy)\
**Replies:** 6\
**Last updated:** [17 June 2021 09:16 UTC](https://discourse.nodered.org/t/redundant-node-red-instances-plugged-on-aws-iot-core/45856 "2021-06-17T09:16:35Z")

</div>

I am using node red after some IOT connectivity layer: IBM IOT cloud now, but migrating to AWS core IOT. The IOT messages come through the IOT layer on MQTT, and are sent to one or several rednode Instances. The issue …

---

## [Using AWK on CSV file using function node](https://discourse.nodered.org/t/using-awk-on-csv-file-using-function-node/47251)

<div class="topic-metadata">

**Author:** [@sahsha](https://discourse.nodered.org/u/sahsha)\
**Replies:** 5\
**Last updated:** [17 June 2021 07:31 UTC](https://discourse.nodered.org/t/using-awk-on-csv-file-using-function-node/47251 "2021-06-17T07:31:44Z")

</div>

Hello! Need to extract a column from a CSV file into another CSV file. I was searching and found that using AWK could help but have no idea how to proceed. Site link for reference https://www.joeldare.com/wiki/using\_aw…

---

## [Select which nodes to show in interface](https://discourse.nodered.org/t/select-which-nodes-to-show-in-interface/2509)

<div class="topic-metadata">

**Author:** [@CatalinFetoiu](https://discourse.nodered.org/u/CatalinFetoiu)\
**Replies:** 6\
**Last updated:** [17 June 2021 07:20 UTC](https://discourse.nodered.org/t/select-which-nodes-to-show-in-interface/2509 "2021-06-17T07:20:46Z")

</div>

Hello, Is there a way to select which nodes to be shown in the UI for the user to work with? I tried to remove some of the files associated with the installation of node-red but it did not work. I was wondering if it ca…

---

## [LINE notify を使って画像ファイルを定期的に送りたい](https://discourse.nodered.org/t/line-notify/47125)

<div class="topic-metadata">

**Author:** [@wtaro513](https://discourse.nodered.org/u/wtaro513)\
**Replies:** 3\
**Last updated:** [17 June 2021 06:56 UTC](https://discourse.nodered.org/t/line-notify/47125 "2021-06-17T06:56:20Z")

</div>

ラズパイにUSBカメラを接続し、１時間毎に撮影した画像データをLINEを使って送りたいと考えています。 単純にインジェクトノード、momentノード、usbcameraノード、imageノードでラズパイ内には保存できるようになったのですが、LINE notifyノードに接続してもLINEに画像を送れません。 LINEに通知は来るのですが、日時データのみで画像が添付できません。不可能なのでしょうか？ LINEがいいのですが、他に画像…

---

## [Serial Port Cannot Open Error Tracking with Flow (ID or Name)](https://discourse.nodered.org/t/serial-port-cannot-open-error-tracking-with-flow-id-or-name/46541)

<div class="topic-metadata">

**Author:** [@avinash-choudhary](https://discourse.nodered.org/u/avinash-choudhary)\
**Replies:** 15\
**Last updated:** [17 June 2021 06:08 UTC](https://discourse.nodered.org/t/serial-port-cannot-open-error-tracking-with-flow-id-or-name/46541 "2021-06-17T06:08:03Z")

</div>

Hi Team I am having two flows Flow - Using COM1 Flow - Using COM2 But by COM2 is down or disconnected , an error is displayed in Terminal/Command console : (\[error\] serial port COM3 error: Error: Error: No such file …

---

## [Dashboard in other devices](https://discourse.nodered.org/t/dashboard-in-other-devices/47214)

<div class="topic-metadata">

**Author:** [@Atzumu](https://discourse.nodered.org/u/Atzumu)\
**Replies:** 2\
**Last updated:** [17 June 2021 03:39 UTC](https://discourse.nodered.org/t/dashboard-in-other-devices/47214 "2021-06-17T03:39:36Z")

</div>

How do I open a dashboard from other devices. I already did a Node-RED flow in the past and I opened form different devices, now I Cant. I'm running it on my windows pc and I also tried on my pi but it didn't work. pls…

---

## [Allen Bradley ML1400 Alarm Float Read](https://discourse.nodered.org/t/allen-bradley-ml1400-alarm-float-read/47272)

<div class="topic-metadata">

**Author:** [@DrdP](https://discourse.nodered.org/u/DrdP)\
**Replies:** 0\
**Last updated:** [17 June 2021 03:36 UTC](https://discourse.nodered.org/t/allen-bradley-ml1400-alarm-float-read/47272 "2021-06-17T03:36:31Z")

</div>

Hi All, I am remotely connecting to a ML1400 PLC via RPI 4B via a 3G dongle and nginx port forwarding. I want to remotely retrieve F39 that we use for alarms. PCCC seems to only have a bit value that it can retrieve? I…

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

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