# General

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

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

**Page:** 838

---

## [Trouble Converting JS Object](https://discourse.nodered.org/t/trouble-converting-js-object/16699)

<div class="topic-metadata">

**Author:** [@jstou](https://discourse.nodered.org/u/jstou)\
**Replies:** 15\
**Last updated:** [15 October 2019 15:30 UTC](https://discourse.nodered.org/t/trouble-converting-js-object/16699 "2019-10-15T15:30:00Z")

</div>

Hi, I am having trouble in Node Red converting a JavaScript object to an array or format where I can manipulate the data. Below is what the object looks like, basically a single object "array" with data, where the keys …

---

## [File-in node drops payload properties?](https://discourse.nodered.org/t/file-in-node-drops-payload-properties/16724)

<div class="topic-metadata">

**Author:** [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Replies:** 6\
**Last updated:** [15 October 2019 15:19 UTC](https://discourse.nodered.org/t/file-in-node-drops-payload-properties/16724 "2019-10-15T15:19:25Z")

</div>

Consider following flow: Inject node sets payload.category to "Business" (this part will to become dynamic). Retrieve text file, payload.category is dropped. In the change node I want to use jsonata: \*.$\[$contains(…

---

## [Excel and Nodered](https://discourse.nodered.org/t/excel-and-nodered/16707)

<div class="topic-metadata">

**Author:** [@ricardokemp](https://discourse.nodered.org/u/ricardokemp)\
**Replies:** 5\
**Last updated:** [15 October 2019 11:09 UTC](https://discourse.nodered.org/t/excel-and-nodered/16707 "2019-10-15T11:09:58Z")

</div>

Hello Please, have any resource in Nodered to work with "recipes" ? For exemple, if I have one Excel with 6 Colums (A to F), and 6 lines Depending on the recipe selected, nodered already extracts the cell values ​​I n…

---

## [How to use latest node-red version?](https://discourse.nodered.org/t/how-to-use-latest-node-red-version/16727)

<div class="topic-metadata">

**Author:** [@gelbo123](https://discourse.nodered.org/u/gelbo123)\
**Replies:** 4\
**Last updated:** [15 October 2019 10:29 UTC](https://discourse.nodered.org/t/how-to-use-latest-node-red-version/16727 "2019-10-15T10:29:47Z")

</div>

Hello everyone, I'm using the following code from Embedding into an existing app https://nodered.org/docs/user-guide/runtime/embedding and everything works fine but the version of node-red is not the latest. I've alrea…

---

## [Bug report - Link nodes](https://discourse.nodered.org/t/bug-report-link-nodes/16648)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 9\
**Last updated:** [15 October 2019 08:01 UTC](https://discourse.nodered.org/t/bug-report-link-nodes/16648 "2019-10-15T08:01:21Z")

</div>

I am messing around with link nodes. I have buttons and a lot of inter-button connections. (Sorry I goofed with the screen shots.) First one you can see the nodes with the links. I delete the one indicated. (Croppe…

---

## [A clock node that will emit correct payload on startup?](https://discourse.nodered.org/t/a-clock-node-that-will-emit-correct-payload-on-startup/16712)

<div class="topic-metadata">

**Author:** [@st2000](https://discourse.nodered.org/u/st2000)\
**Replies:** 2\
**Last updated:** [15 October 2019 07:39 UTC](https://discourse.nodered.org/t/a-clock-node-that-will-emit-correct-payload-on-startup/16712 "2019-10-15T07:39:05Z")

</div>

Is there an existing clock node that will emit the correct payload (for example, "on" or "off) on start up? Specifically, is there a clock node that will GO BACKWARDS to the last event in time and correctly set the payl…

---

## [How can I load image file into the RGB array?](https://discourse.nodered.org/t/how-can-i-load-image-file-into-the-rgb-array/16670)

<div class="topic-metadata">

**Author:** [@ded\_banzai](https://discourse.nodered.org/u/ded_banzai)\
**Replies:** 8\
**Last updated:** [15 October 2019 03:24 UTC](https://discourse.nodered.org/t/how-can-i-load-image-file-into-the-rgb-array/16670 "2019-10-15T03:24:57Z")

</div>

I am trying to play with 16x16 WS2812B LED Matix controlled by ESP8266 with WLED firmware. It allows controlling it with UDP packets which are simply the sequence of R,G,B values. For example first three pixels where fir…

---

## [On off timer switch mqtt node](https://discourse.nodered.org/t/on-off-timer-switch-mqtt-node/16616)

<div class="topic-metadata">

**Author:** [@mwawrzyniec](https://discourse.nodered.org/u/mwawrzyniec)\
**Replies:** 16\
**Last updated:** [14 October 2019 21:25 UTC](https://discourse.nodered.org/t/on-off-timer-switch-mqtt-node/16616 "2019-10-14T21:25:37Z")

</div>

I'm looking for a way to switch an mqtt node on for 5 minutes and off for 25. Anyone have any ideas?

---

## [Audio Player Options](https://discourse.nodered.org/t/audio-player-options/16669)

<div class="topic-metadata">

**Author:** [@manfacro](https://discourse.nodered.org/u/manfacro)\
**Replies:** 5\
**Last updated:** [14 October 2019 15:23 UTC](https://discourse.nodered.org/t/audio-player-options/16669 "2019-10-14T15:23:46Z")

</div>

Hi all, with the play sound node, I'm trying to figure out the best way to loop some audio...lets say the application is for a background music player. I see the options to pause/resume, but no option to loop. I'm tryin…

---

## [Node-Red security (LockDown)](https://discourse.nodered.org/t/node-red-security-lockdown/16692)

<div class="topic-metadata">

**Author:** [@MisterDraegus](https://discourse.nodered.org/u/MisterDraegus)\
**Replies:** 1\
**Last updated:** [14 October 2019 13:50 UTC](https://discourse.nodered.org/t/node-red-security-lockdown/16692 "2019-10-14T13:50:35Z")

</div>

Hello, i am rather new to this platform. I was wondering if there is a way to LockDown Node-Red, meaning: Certain users can do certain stuff, but others can not. Each action/change can be logged (with if possible by w…

---

## [How do you find missing node types?](https://discourse.nodered.org/t/how-do-you-find-missing-node-types/16625)

<div class="topic-metadata">

**Author:** [@nodecentral](https://discourse.nodered.org/u/nodecentral)\
**Replies:** 10\
**Last updated:** [14 October 2019 13:09 UTC](https://discourse.nodered.org/t/how-do-you-find-missing-node-types/16625 "2019-10-14T13:09:19Z")

</div>

The great thing about Node Red is the ability to share/import other peoples flows, this allows instant rewards, however it can be a little tricky when the flow being imported includes a node you don’t have, and the messa…

---

## [Advice setting up node-red for a class](https://discourse.nodered.org/t/advice-setting-up-node-red-for-a-class/16650)

<div class="topic-metadata">

**Author:** [@geoffreymbrown](https://discourse.nodered.org/u/geoffreymbrown)\
**Replies:** 10\
**Last updated:** [14 October 2019 10:56 UTC](https://discourse.nodered.org/t/advice-setting-up-node-red-for-a-class/16650 "2019-10-14T10:56:10Z")

</div>

Here's the basic problem I want to use node-red in a cs course The students will likely work on multiple machines and multiple plaforms (lab, their own, etc) The students will each have one git repo for the course I'd …

---

## [Node-red-contrib-mssql doesn't apear to install on thethingbox running on RPI](https://discourse.nodered.org/t/node-red-contrib-mssql-doesnt-apear-to-install-on-thethingbox-running-on-rpi/16647)

<div class="topic-metadata">

**Author:** [@mauro\_mars](https://discourse.nodered.org/u/mauro_mars)\
**Replies:** 6\
**Last updated:** [14 October 2019 09:13 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-doesnt-apear-to-install-on-thethingbox-running-on-rpi/16647 "2019-10-14T09:13:38Z")

</div>

I was doing a tutorial to get started with node red and at the tutorial they use mssql and install with the built menage pallete option. But on my interface it doesn't appear. i tried to install through console with the…

---

## [\[SOLVED\]Motion sensor flow will not work](https://discourse.nodered.org/t/solved-motion-sensor-flow-will-not-work/16659)

<div class="topic-metadata">

**Author:** [@Jvdm](https://discourse.nodered.org/u/Jvdm)\
**Replies:** 4\
**Last updated:** [14 October 2019 08:23 UTC](https://discourse.nodered.org/t/solved-motion-sensor-flow-will-not-work/16659 "2019-10-14T08:23:13Z")

</div>

Hello there i am new to the forum and i did everything right but my flow will not work.. I have a fibaro motion sensor and want them to turn a light on and off. But i cant get it right. Looked over the internet but it wi…

---

## [Hourly, Daily and Monthly Payload](https://discourse.nodered.org/t/hourly-daily-and-monthly-payload/16642)

<div class="topic-metadata">

**Author:** [@abajolle](https://discourse.nodered.org/u/abajolle)\
**Replies:** 6\
**Last updated:** [14 October 2019 04:10 UTC](https://discourse.nodered.org/t/hourly-daily-and-monthly-payload/16642 "2019-10-14T04:10:26Z")

</div>

Hi guys, I am looking at a way to get a reset signal generated on a couple of occasions : Hourly, on the hour. Daily at midnight. Monthly, at midnight on the last day of the month. For the hourly, the inject node wor…

---

## [Node Red Watson Discovery Node](https://discourse.nodered.org/t/node-red-watson-discovery-node/16655)

<div class="topic-metadata">

**Author:** [@kabonker](https://discourse.nodered.org/u/kabonker)\
**Replies:** 2\
**Last updated:** [14 October 2019 01:21 UTC](https://discourse.nodered.org/t/node-red-watson-discovery-node/16655 "2019-10-14T01:21:35Z")

</div>

I set up a node red flow for Watson Assistant.. It was simple and worked well, had an input with an inject node, then a watson assistant node and a debug output. Easy. Then I went to set up the same pattern for the…

---

## [\[Help\] How to get all GoogleCalendar events using node-red-contrib-google?](https://discourse.nodered.org/t/help-how-to-get-all-googlecalendar-events-using-node-red-contrib-google/16667)

<div class="topic-metadata">

**Author:** [@JuliusDB](https://discourse.nodered.org/u/JuliusDB)\
**Replies:** 0\
**Last updated:** [13 October 2019 20:34 UTC](https://discourse.nodered.org/t/help-how-to-get-all-googlecalendar-events-using-node-red-contrib-google/16667 "2019-10-13T20:34:34Z")

</div>

Hello, I am using node-red-contrib-google to get all events between a given timeMin and timeMax, however, I can only get my All-Day events? How do I instead get All-Day events as well as regular time bound events? I …

---

## [Node-red Windows7x64 serialport missing bindings file](https://discourse.nodered.org/t/node-red-windows7x64-serialport-missing-bindings-file/16657)

<div class="topic-metadata">

**Author:** [@m\_elias](https://discourse.nodered.org/u/m_elias)\
**Replies:** 1\
**Last updated:** [13 October 2019 19:29 UTC](https://discourse.nodered.org/t/node-red-windows7x64-serialport-missing-bindings-file/16657 "2019-10-13T19:29:44Z")

</div>

I'm trying to get contrib-gpio package installed on windows. I followed this guide for installing Node-Red, https://nodered.org/docs/getting-started/windows I installed the build tools. It looks like contrib-gpio needs …

---

## [These errors occurred on the installation node](https://discourse.nodered.org/t/these-errors-occurred-on-the-installation-node/16652)

<div class="topic-metadata">

**Author:** [@shj-123558](https://discourse.nodered.org/u/shj-123558)\
**Replies:** 3\
**Last updated:** [13 October 2019 14:32 UTC](https://discourse.nodered.org/t/these-errors-occurred-on-the-installation-node/16652 "2019-10-13T14:32:34Z")

</div>

Node-red version: v1.0.1 node.js version: v10.0.0 visual studio version: visual studio 2017 2019-10-13T12:54:26.412Z 安装 : node-red-contrib-gpio 0.14.0 2019-10-13T12:54:26.428Z npm.cmd install --no-audit --no-update-…

---

## [Node-red-node-arduino bord node and node-red-contrib-gpio nodebot node lost](https://discourse.nodered.org/t/node-red-node-arduino-bord-node-and-node-red-contrib-gpio-nodebot-node-lost/16637)

<div class="topic-metadata">

**Author:** [@shj-123558](https://discourse.nodered.org/u/shj-123558)\
**Replies:** 14\
**Last updated:** [13 October 2019 13:23 UTC](https://discourse.nodered.org/t/node-red-node-arduino-bord-node-and-node-red-contrib-gpio-nodebot-node-lost/16637 "2019-10-13T13:23:32Z")

</div>

Node-red-node-arduino bord node and node-red-contrib-gpio nodebot node lost,how to solve

---

## [SQLite Foreign key ignored](https://discourse.nodered.org/t/sqlite-foreign-key-ignored/16624)

<div class="topic-metadata">

**Author:** [@AsHex\_66](https://discourse.nodered.org/u/AsHex_66)\
**Replies:** 29\
**Last updated:** [12 October 2019 22:06 UTC](https://discourse.nodered.org/t/sqlite-foreign-key-ignored/16624 "2019-10-12T22:06:41Z")

</div>

I have an issue an unsure if this a bug or not. I created a test database (SQLite) as follows: -- DataBase example CREATE TABLE artist( artistid INTEGER PRIMARY KEY, artistname TEXT ); CREATE TABLE track( tra…

---

## [Can I use \_msgid for naming temporary file](https://discourse.nodered.org/t/can-i-use-msgid-for-naming-temporary-file/14428)

<div class="topic-metadata">

**Author:** [@ianmacs](https://discourse.nodered.org/u/ianmacs)\
**Replies:** 5\
**Last updated:** [12 October 2019 20:24 UTC](https://discourse.nodered.org/t/can-i-use-msgid-for-naming-temporary-file/14428 "2019-10-12T20:24:05Z")

</div>

I want to create a temporary file with a unique name alongside an execution path in a node-red flow. I know that this would be safe: Node1 - exec, calls mktemp, which creates a temporary file with a unique name Node2, …

---

## [Value out of range stopping node red?](https://discourse.nodered.org/t/value-out-of-range-stopping-node-red/16632)

<div class="topic-metadata">

**Author:** [@Matt](https://discourse.nodered.org/u/Matt)\
**Replies:** 4\
**Last updated:** [12 October 2019 19:11 UTC](https://discourse.nodered.org/t/value-out-of-range-stopping-node-red/16632 "2019-10-12T19:11:36Z")

</div>

After a power outage i have lost the service of node red. if i SSH into the Pi that is running node red and entering: node red --safe i can briefly load the UI and deploy a change then the connection fails after a c…

---

## [How to action MySQL queries inside function node?](https://discourse.nodered.org/t/how-to-action-mysql-queries-inside-function-node/16631)

<div class="topic-metadata">

**Author:** [@swiftnesses](https://discourse.nodered.org/u/swiftnesses)\
**Replies:** 3\
**Last updated:** [12 October 2019 18:40 UTC](https://discourse.nodered.org/t/how-to-action-mysql-queries-inside-function-node/16631 "2019-10-12T18:40:07Z")

</div>

Good day, I'm trying to transition one of my flows away from using global context, to MySQL so the data is available to other sources outside Node-RED. It's a real headache. The function in question is rather complex …

---

## [Node Red stopped - Max call stack size exceeded](https://discourse.nodered.org/t/node-red-stopped-max-call-stack-size-exceeded/16620)

<div class="topic-metadata">

**Author:** [@Thewaver](https://discourse.nodered.org/u/Thewaver)\
**Replies:** 20\
**Last updated:** [12 October 2019 11:43 UTC](https://discourse.nodered.org/t/node-red-stopped-max-call-stack-size-exceeded/16620 "2019-10-12T11:43:34Z")

</div>

Hi, Node-red just suddenly stopped and I can't access it anymore. I was working on a flow when this happened and not matter what I try, I cant get it to display with the :1880. Is there a way I can get this going as th…

---

## [RPi hangs/freezes after running a few days](https://discourse.nodered.org/t/rpi-hangs-freezes-after-running-a-few-days/16381)

<div class="topic-metadata">

**Author:** [@FarfarGoHai](https://discourse.nodered.org/u/FarfarGoHai)\
**Replies:** 16\
**Last updated:** [12 October 2019 10:26 UTC](https://discourse.nodered.org/t/rpi-hangs-freezes-after-running-a-few-days/16381 "2019-10-12T10:26:15Z")

</div>

Hi, I've done a Node-red code for a home automated ventilation system - that freezes after running a few days :frowning: I have tested changing the update interval of some of my nodes (data reads and date/time updates e…

---

## [Key 'node-red-node-email/email: (en\_US)' object not string](https://discourse.nodered.org/t/key-node-red-node-email-email-en-us-object-not-string/16311)

<div class="topic-metadata">

**Author:** [@communig8-public](https://discourse.nodered.org/u/communig8-public)\
**Replies:** 3\
**Last updated:** [12 October 2019 09:51 UTC](https://discourse.nodered.org/t/key-node-red-node-email-email-en-us-object-not-string/16311 "2019-10-12T09:51:41Z")

</div>

Node-RED V0.19.3 running on an Amazon Lightsail Ubuntu 16.04.5 LTS instance. I have a simple flow for testing sending an email that used to work without any error. However, it is now showing "key 'node-red-node-email/e…

---

## [Node-red-contrib-knxjs not working with node-red 1.0](https://discourse.nodered.org/t/node-red-contrib-knxjs-not-working-with-node-red-1-0/16427)

<div class="topic-metadata">

**Author:** [@zieherf](https://discourse.nodered.org/u/zieherf)\
**Replies:** 4\
**Last updated:** [12 October 2019 07:51 UTC](https://discourse.nodered.org/t/node-red-contrib-knxjs-not-working-with-node-red-1-0/16427 "2019-10-12T07:51:13Z")

</div>

Hi, https://bitbucket.org/ekarak/node-red-contrib-knxjs offers three nodes knx-in, knx-out, and a knx-device node. After upgrading node-red to 1.0, the knx-in is not working anymore. Instead of outputting knx telegram me…

---

## [SOAP Request Not Working - WSDL Config Error](https://discourse.nodered.org/t/soap-request-not-working-wsdl-config-error/16482)

<div class="topic-metadata">

**Author:** [@joneda1](https://discourse.nodered.org/u/joneda1)\
**Replies:** 4\
**Last updated:** [11 October 2019 22:58 UTC](https://discourse.nodered.org/t/soap-request-not-working-wsdl-config-error/16482 "2019-10-11T22:58:45Z")

</div>

I have been trying to get a SOAP request working using the node-red-contrib-soap-httpcode node. I have put the WSDL http://www.opensolardb.org/wssolardata?wsdl into the WSDL field of the configuration but whenever I run …

---

## [Msg.payload help](https://discourse.nodered.org/t/msg-payload-help/16611)

<div class="topic-metadata">

**Author:** [@Navybrandon](https://discourse.nodered.org/u/Navybrandon)\
**Replies:** 20\
**Last updated:** [11 October 2019 21:36 UTC](https://discourse.nodered.org/t/msg-payload-help/16611 "2019-10-11T21:36:13Z")

</div>

Hello All, I am having issues converting a message payload ex ample value from debug "15" to '15'. I need the payload to be in the format 'x' so that my function node will work. \[{"id":"4d9bb02d.3c221","type":"tab","la…

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

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