# General

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

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

**Page:** 537

---

## [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 …

---

## [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: …

---

## [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.…

---

## [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 …

---

## [Loop through an array and return index of a specific value](https://discourse.nodered.org/t/loop-through-an-array-and-return-index-of-a-specific-value/47063)

<div class="topic-metadata">

**Author:** [@craigcurtin](https://discourse.nodered.org/u/craigcurtin)\
**Replies:** 13\
**Last updated:** [16 June 2021 23:03 UTC](https://discourse.nodered.org/t/loop-through-an-array-and-return-index-of-a-specific-value/47063 "2021-06-16T23:03:22Z")

</div>

Hey Guys, I have a flow that does a query on my energy provider and this returns an array with 120 objects in it (1/2 hour increments of pricing for electricity) The first x (arbitrary number) of these are in the past …

---

## [Use day time in function nodes](https://discourse.nodered.org/t/use-day-time-in-function-nodes/47243)

<div class="topic-metadata">

**Author:** [@RonMa](https://discourse.nodered.org/u/RonMa)\
**Replies:** 3\
**Last updated:** [16 June 2021 19:36 UTC](https://discourse.nodered.org/t/use-day-time-in-function-nodes/47243 "2021-06-16T19:36:59Z")

</div>

Hi Java Script heroes :slight\_smile: I have a really simple question but I just don't find any input on this in the forum. Here is what I would like to achieve: Within a function node, I would like to initiate different …

---

## [Timer cant trigger second Timer \[solved\]](https://discourse.nodered.org/t/timer-cant-trigger-second-timer-solved/47241)

<div class="topic-metadata">

**Author:** [@gotsila](https://discourse.nodered.org/u/gotsila)\
**Replies:** 2\
**Last updated:** [16 June 2021 18:17 UTC](https://discourse.nodered.org/t/timer-cant-trigger-second-timer-solved/47241 "2021-06-16T18:17:13Z")

</div>

Hello, i have a Timer e.g. 3s this timer triggers then a Timer 8s. that's only working before i send a stop from other node. then the timer 3s couldn't trigger the timer 8s. i build an example flow: Testreihe 1 inj…

---

## [Using Interval Length to send an email](https://discourse.nodered.org/t/using-interval-length-to-send-an-email/47252)

<div class="topic-metadata">

**Author:** [@WarmCat](https://discourse.nodered.org/u/WarmCat)\
**Replies:** 2\
**Last updated:** [16 June 2021 16:15 UTC](https://discourse.nodered.org/t/using-interval-length-to-send-an-email/47252 "2021-06-16T16:15:30Z")

</div>

Hi, I read from a MQTT topic, and if there is no message within a set time (say 10 minutes), I wish to send an email with the last MQTT message. Currently, the last MQTT message arrives as msg.payload into an interval-l…

---

## [Export node red graph to pdf](https://discourse.nodered.org/t/export-node-red-graph-to-pdf/47229)

<div class="topic-metadata">

**Author:** [@ultim0](https://discourse.nodered.org/u/ultim0)\
**Replies:** 0\
**Last updated:** [16 June 2021 11:08 UTC](https://discourse.nodered.org/t/export-node-red-graph-to-pdf/47229 "2021-06-16T11:08:58Z")

</div>

I need help, how can I export a node red graph to .pdf or another format? thank you

---

## [Encode Error with OPCUA-Browser Node](https://discourse.nodered.org/t/encode-error-with-opcua-browser-node/45270)

<div class="topic-metadata">

**Author:** [@LeFish](https://discourse.nodered.org/u/LeFish)\
**Replies:** 1\
**Last updated:** [16 June 2021 11:04 UTC](https://discourse.nodered.org/t/encode-error-with-opcua-browser-node/45270 "2021-06-16T11:04:30Z")

</div>

I am using the node-red-contrib-opcua node version 0.2.117 in NodeRed on a Raspberry Pi. On the same system I have CodeSys running with an OPCUA-Server enabled. For developing I try to browse a part of my OPCUA-Dashboar…

---

## [Mongo db connection](https://discourse.nodered.org/t/mongo-db-connection/47217)

<div class="topic-metadata">

**Author:** [@OmkarNodered](https://discourse.nodered.org/u/OmkarNodered)\
**Replies:** 1\
**Last updated:** [16 June 2021 09:53 UTC](https://discourse.nodered.org/t/mongo-db-connection/47217 "2021-06-16T09:53:42Z")

</div>

I am trying to connect to "mongo-db in" node but it is showing MongoError: Authentication failed.

---

## [Error during inject into database](https://discourse.nodered.org/t/error-during-inject-into-database/47205)

<div class="topic-metadata">

**Author:** [@sarah](https://discourse.nodered.org/u/sarah)\
**Replies:** 5\
**Last updated:** [16 June 2021 09:53 UTC](https://discourse.nodered.org/t/error-during-inject-into-database/47205 "2021-06-16T09:53:12Z")

</div>

Hi there! I'm creating flow to get csv data from opengov website. the csv data contain daily vaccination and I want to put into my database, during the process I face some problem regarding the rows that I want to exclu…

---

## [Mongo db in node red](https://discourse.nodered.org/t/mongo-db-in-node-red/47216)

<div class="topic-metadata">

**Author:** [@OmkarNodered](https://discourse.nodered.org/u/OmkarNodered)\
**Replies:** 1\
**Last updated:** [16 June 2021 09:52 UTC](https://discourse.nodered.org/t/mongo-db-in-node-red/47216 "2021-06-16T09:52:13Z")

</div>

I have installed mongo db connector in node red. My mongo db collection has date values in timestamp format. I just want to write a query using mongo db connector so that I should get only last 8 hours date values. How c…

---

## [How to loop data from HTTP Request Node?](https://discourse.nodered.org/t/how-to-loop-data-from-http-request-node/44012)

<div class="topic-metadata">

**Author:** [@marwinwijaya](https://discourse.nodered.org/u/marwinwijaya)\
**Replies:** 4\
**Last updated:** [16 June 2021 08:59 UTC](https://discourse.nodered.org/t/how-to-loop-data-from-http-request-node/44012 "2021-06-16T08:59:45Z")

</div>

I have the HTTP Request Node result data in the form of an Array in the image below, how do I make the data loop to be entered into the MySQL database? One array has several objects, the object variables can be seen …

---

## [MySQL Cluster (3 nodes) with MySQL node](https://discourse.nodered.org/t/mysql-cluster-3-nodes-with-mysql-node/47181)

<div class="topic-metadata">

**Author:** [@janedoe123](https://discourse.nodered.org/u/janedoe123)\
**Replies:** 4\
**Last updated:** [16 June 2021 08:51 UTC](https://discourse.nodered.org/t/mysql-cluster-3-nodes-with-mysql-node/47181 "2021-06-16T08:51:12Z")

</div>

Hello all, I know that a standalone mySQL server can be connected to node-red via the mySQL node meant for that. However my question is, can we connect a mySQL cluster (composed of 3 nodes) to node-red, using the same …

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

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