# General

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

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

**Page:** 661

---

## [Smartthings 2019 power outlet - acting on current\_power\_w](https://discourse.nodered.org/t/smartthings-2019-power-outlet-acting-on-current-power-w/35220)

<div class="topic-metadata">

**Author:** [@derekcfoley](https://discourse.nodered.org/u/derekcfoley)\
**Replies:** 0\
**Last updated:** [2 November 2020 15:35 UTC](https://discourse.nodered.org/t/smartthings-2019-power-outlet-acting-on-current-power-w/35220 "2020-11-02T15:35:19Z")

</div>

Hi there - I have a 2019 Smartthings socket outlet paired with a Smarthings V2 hub. I run Node Red on a Raspberry Pi and HomeAssistant. The socket device has built in energy monitoring - I can toggle it on and off via t…

---

## [Question about RBE](https://discourse.nodered.org/t/question-about-rbe/35213)

<div class="topic-metadata">

**Author:** [@softy2k](https://discourse.nodered.org/u/softy2k)\
**Replies:** 1\
**Last updated:** [2 November 2020 16:51 UTC](https://discourse.nodered.org/t/question-about-rbe/35213 "2020-11-02T16:51:25Z")

</div>

Hello, Shouldn't I just have rising values at the exit? In other words, just something like 1, 2, 3? Never 3, 2, 1 (or decreasing combinations of these numbers)? \[{"id":"ca451102.306ac","type":"inject","z":"cdf5d921.…

---

## [Connect to multiple oracle DB's](https://discourse.nodered.org/t/connect-to-multiple-oracle-dbs/35204)

<div class="topic-metadata">

**Author:** [@rey](https://discourse.nodered.org/u/rey)\
**Replies:** 3\
**Last updated:** [2 November 2020 14:58 UTC](https://discourse.nodered.org/t/connect-to-multiple-oracle-dbs/35204 "2020-11-02T14:58:15Z")

</div>

Hi, I make use of the node-red-contrib-oracledb-mod plugin. I can connect to an oracle DB and run queries. However I have no idea how to access another oracle DB within the same flow, or even in a different flow in the …

---

## [GET nodes of Admin API broken?](https://discourse.nodered.org/t/get-nodes-of-admin-api-broken/35215)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 2\
**Last updated:** [2 November 2020 14:48 UTC](https://discourse.nodered.org/t/get-nodes-of-admin-api-broken/35215 "2020-11-02T14:48:53Z")

</div>

I have been trying to use more of the Admin API in reworking my backup flows solution. The GET flows, Get (specific) flow content methods work. But when I try the GET nodes (list) method, I get HTML back? Not a list o…

---

## [Slow database output +4 seconds](https://discourse.nodered.org/t/slow-database-output-4-seconds/35152)

<div class="topic-metadata">

**Author:** [@RogierQ](https://discourse.nodered.org/u/RogierQ)\
**Replies:** 15\
**Last updated:** [2 November 2020 14:21 UTC](https://discourse.nodered.org/t/slow-database-output-4-seconds/35152 "2020-11-02T14:21:32Z")

</div>

Hi! I made a complex game with node red that uses 130 mysql nodes The sql nodes a triggered between 1 sec and 30 seconds repeating In the beginning it worked very fast but now more and more the replies become slowly …

---

## [Combine and Status node question?](https://discourse.nodered.org/t/combine-and-status-node-question/35186)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 4\
**Last updated:** [2 November 2020 14:17 UTC](https://discourse.nodered.org/t/combine-and-status-node-question/35186 "2020-11-02T14:17:43Z")

</div>

Given the following flow? \[{"id":"11cd268d.ac2249","type":"inject","z":"d9c9f5b0.34c538","name":"","props":\[{"p":"payload"}\],"repeat":"","crontab":"","once":true,"onceDelay":0.1,"topic":"","payload":"","payloadType":"da…

---

## [Detect value in msg.payload.body](https://discourse.nodered.org/t/detect-value-in-msg-payload-body/35206)

<div class="topic-metadata">

**Author:** [@CKL1976](https://discourse.nodered.org/u/CKL1976)\
**Replies:** 2\
**Last updated:** [2 November 2020 13:57 UTC](https://discourse.nodered.org/t/detect-value-in-msg-payload-body/35206 "2020-11-02T13:57:51Z")

</div>

Hi Newbie here :slight\_smile: I have a msg.payload.body that contains one long string of text, please see below part of the payload. "deviceModel":"MT10","alertId":"645140646630744781","alertType":"Sensor change detec…

---

## [Node forking etiquette?](https://discourse.nodered.org/t/node-forking-etiquette/35163)

<div class="topic-metadata">

**Author:** [@hepcat72](https://discourse.nodered.org/u/hepcat72)\
**Replies:** 5\
**Last updated:** [2 November 2020 13:57 UTC](https://discourse.nodered.org/t/node-forking-etiquette/35163 "2020-11-02T13:57:29Z")

</div>

So I found some bugs in a node I installed and created 2 issues on the repo's github page, hoping that the author may fix the issues I'd found. He responded saying he didn't have time to work on it. Totally understandab…

---

## ["Too many errors" in function node, but works ok](https://discourse.nodered.org/t/too-many-errors-in-function-node-but-works-ok/35088)

<div class="topic-metadata">

**Author:** [@Colin](https://discourse.nodered.org/u/Colin)\
**Replies:** 22\
**Last updated:** [1 November 2020 23:35 UTC](https://discourse.nodered.org/t/too-many-errors-in-function-node-but-works-ok/35088 "2020-11-01T23:35:41Z")

</div>

Following on from another thread @Huda has a Function node that works correctly but in the node-red editor it shows a yellow warning triangle which shows the error "Too many errors 70% scanned". Google suggested that th…

---

## [TypeError: runtime.flows.loadFlows is not a function](https://discourse.nodered.org/t/typeerror-runtime-flows-loadflows-is-not-a-function/35175)

<div class="topic-metadata">

**Author:** [@yogy](https://discourse.nodered.org/u/yogy)\
**Replies:** 17\
**Last updated:** [2 November 2020 12:29 UTC](https://discourse.nodered.org/t/typeerror-runtime-flows-loadflows-is-not-a-function/35175 "2020-11-02T12:29:57Z")

</div>

Imported a via palette manager a node json-db-node-red. Did not worked as I hoped it would. After some trials witch did not worked for me I wanted to delete the node. But the deploy button stays red and there is no r…

---

## [Can not install new node](https://discourse.nodered.org/t/can-not-install-new-node/35199)

<div class="topic-metadata">

**Author:** [@Madhumati](https://discourse.nodered.org/u/Madhumati)\
**Replies:** 2\
**Last updated:** [2 November 2020 12:13 UTC](https://discourse.nodered.org/t/can-not-install-new-node/35199 "2020-11-02T12:13:55Z")

</div>

Hello, I am using raspberry pi based device using node-RED with it, I am trying to install " node-red-contrib-thingrest " But it gives me error as attached in log : can you give me some hint about the cause of this…

---

## [Removing negative latitude and longitude coordinates](https://discourse.nodered.org/t/removing-negative-latitude-and-longitude-coordinates/34665)

<div class="topic-metadata">

**Author:** [@bachloo.rahul](https://discourse.nodered.org/u/bachloo.rahul)\
**Replies:** 47\
**Last updated:** [2 November 2020 11:59 UTC](https://discourse.nodered.org/t/removing-negative-latitude-and-longitude-coordinates/34665 "2020-11-02T11:59:15Z")

</div>

My Gps Sensor is sending 2 payloads of messages containing latitude and longitude at the same time.So want to remove the extra latitude and longitude coordinates. Here is the flow flows.json (632 Bytes)

---

## [Listening to key input from other pi devices in the dashbord](https://discourse.nodered.org/t/listening-to-key-input-from-other-pi-devices-in-the-dashbord/35102)

<div class="topic-metadata">

**Author:** [@thepianocian](https://discourse.nodered.org/u/thepianocian)\
**Replies:** 20\
**Last updated:** [2 November 2020 11:49 UTC](https://discourse.nodered.org/t/listening-to-key-input-from-other-pi-devices-in-the-dashbord/35102 "2020-11-02T11:49:16Z")

</div>

Hello everyone, this may sound like a dumb question but I am very new to node-red and was wondering if you had any thoughts on this. I am running node-red from a main Windows device. I have multiple pi devices that I wo…

---

## [Sqlite choose only previous day data?](https://discourse.nodered.org/t/sqlite-choose-only-previous-day-data/35078)

<div class="topic-metadata">

**Author:** [@questuk](https://discourse.nodered.org/u/questuk)\
**Replies:** 8\
**Last updated:** [2 November 2020 11:02 UTC](https://discourse.nodered.org/t/sqlite-choose-only-previous-day-data/35078 "2020-11-02T11:02:00Z")

</div>

Hi, I have a Sqlite database eventually I want to show the last 1 days data on a chart. But first I need to sort the date. Today as I write this it is Friday. I have the following .. SELECT \* FROM DATA WHERE ID LIK…

---

## [Python code in node-red](https://discourse.nodered.org/t/python-code-in-node-red/35106)

<div class="topic-metadata">

**Author:** [@varunyc](https://discourse.nodered.org/u/varunyc)\
**Replies:** 11\
**Last updated:** [2 November 2020 10:59 UTC](https://discourse.nodered.org/t/python-code-in-node-red/35106 "2020-11-02T10:59:20Z")

</div>

Dear All, I am writing python code which uses machine learning algorithm like LSTM to forecast the future stock data. The entire code is developed in Jupyter notebook. So the extension of file in ipynb. Is there any no…

---

## [Forward original TCP/IP received msg to WAN](https://discourse.nodered.org/t/forward-original-tcp-ip-received-msg-to-wan/34972)

<div class="topic-metadata">

**Author:** [@kslb](https://discourse.nodered.org/u/kslb)\
**Replies:** 6\
**Last updated:** [2 November 2020 08:20 UTC](https://discourse.nodered.org/t/forward-original-tcp-ip-received-msg-to-wan/34972 "2020-11-02T08:20:06Z")

</div>

I have task on which I want to receive some msg via TCP/IP on port 8037 and then value of this msg will be used on Home Assistant + at the same time I need to forward this msg to WAN, so that also native app of OilFox wi…

---

## [Another lookup but this time with text](https://discourse.nodered.org/t/another-lookup-but-this-time-with-text/35188)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 3\
**Last updated:** [2 November 2020 06:02 UTC](https://discourse.nodered.org/t/another-lookup-but-this-time-with-text/35188 "2020-11-02T06:02:54Z")

</div>

I really don't like having this many things happening, but ..... needs must. This is the structure: { "nine":{"number":100}, "foxone":{"number":101}, "abc":{"number":102}, "sbs":{"number":104}, "uk…

---

## [Not able to read CSV in pandas](https://discourse.nodered.org/t/not-able-to-read-csv-in-pandas/35183)

<div class="topic-metadata">

**Author:** [@varunyc](https://discourse.nodered.org/u/varunyc)\
**Replies:** 1\
**Last updated:** [2 November 2020 05:15 UTC](https://discourse.nodered.org/t/not-able-to-read-csv-in-pandas/35183 "2020-11-02T05:15:46Z")

</div>

Dear All, I am reading CSV file using panda in python. I am executing the code using exec node in node red. When I tested it in windows machine using CSV file panda is able to read and it is working fine, But same fi…

---

## [Do I have to comment on the revised content of settings.js?](https://discourse.nodered.org/t/do-i-have-to-comment-on-the-revised-content-of-settings-js/35008)

<div class="topic-metadata">

**Author:** [@p\_1760](https://discourse.nodered.org/u/p_1760)\
**Replies:** 2\
**Last updated:** [2 November 2020 00:32 UTC](https://discourse.nodered.org/t/do-i-have-to-comment-on-the-revised-content-of-settings-js/35008 "2020-11-02T00:32:42Z")

</div>

Hello, I'm using Node-RED to develop applications for commercial use. I know that Node-RED's settings.js have Apache license 2.0. And I looked it up because I was curious about the license and found that the license sh…

---

## [Ideas or suggestions on monitor NAS or SAMBA via NR?](https://discourse.nodered.org/t/ideas-or-suggestions-on-monitor-nas-or-samba-via-nr/35124)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 6\
**Last updated:** [1 November 2020 22:01 UTC](https://discourse.nodered.org/t/ideas-or-suggestions-on-monitor-nas-or-samba-via-nr/35124 "2020-11-01T22:01:50Z")

</div>

One idea is to use a service such as https://www.site24x7.com/ which is only $9 a year for personal scale use, and then have NR consolidate said service reporting. But I got to think that collection the data such a serv…

---

## ["Truth tables" and how to build them - help required](https://discourse.nodered.org/t/truth-tables-and-how-to-build-them-help-required/35142)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 28\
**Last updated:** [1 November 2020 21:57 UTC](https://discourse.nodered.org/t/truth-tables-and-how-to-build-them-help-required/35142 "2020-11-01T21:57:49Z")

</div>

Gee, I am good at digging myself into holes. (No! Don't say it!) :wink: I am seeing problem after problem with this recent venture with weather. Clouds, rain and wind. That is before the day/night part. I am seei…

---

## [Camera Snapshot](https://discourse.nodered.org/t/camera-snapshot/35174)

<div class="topic-metadata">

**Author:** [@rnormore](https://discourse.nodered.org/u/rnormore)\
**Replies:** 1\
**Last updated:** [1 November 2020 21:03 UTC](https://discourse.nodered.org/t/camera-snapshot/35174 "2020-11-01T21:03:44Z")

</div>

I have two IP Cameras. Both work fine and stream within the Home Assistant but only one will show up in Node-Red. Any ideas what I maybe missing with the other camera setup? Thanks

---

## [Msg.length is returning an empty object as a result?](https://discourse.nodered.org/t/msg-length-is-returning-an-empty-object-as-a-result/35136)

<div class="topic-metadata">

**Author:** [@gwking11](https://discourse.nodered.org/u/gwking11)\
**Replies:** 12\
**Last updated:** [1 November 2020 19:38 UTC](https://discourse.nodered.org/t/msg-length-is-returning-an-empty-object-as-a-result/35136 "2020-11-01T19:38:18Z")

</div>

Hey all, I am new to Node-Red and am running it in Home Assistant. I am also new to HTML with very little previous programming knowledge(some Basic/Visual Basic/Access/C++). Yes that says Basic. I am pulling an https …

---

## [Unable to visualise points on worldmap on NodeRed](https://discourse.nodered.org/t/unable-to-visualise-points-on-worldmap-on-nodered/35171)

<div class="topic-metadata">

**Author:** [@Karen123](https://discourse.nodered.org/u/Karen123)\
**Replies:** 3\
**Last updated:** [1 November 2020 18:35 UTC](https://discourse.nodered.org/t/unable-to-visualise-points-on-worldmap-on-nodered/35171 "2020-11-01T18:35:20Z")

</div>

Hi All, I am new to NodeRed an am trying to plot a map on NodeRed. However, the data points cannot be visualised on the map. May you please share your advice on how it could be resolved? The flow I used is as below: …

---

## [Logical OR within mustache expression within data](https://discourse.nodered.org/t/logical-or-within-mustache-expression-within-data/35173)

<div class="topic-metadata">

**Author:** [@cburkins](https://discourse.nodered.org/u/cburkins)\
**Replies:** 6\
**Last updated:** [1 November 2020 18:13 UTC](https://discourse.nodered.org/t/logical-or-within-mustache-expression-within-data/35173 "2020-11-01T18:13:52Z")

</div>

Within the JSON portion (or "Data" field), you can obviously make use of a {{variable}} substitution. In my case, I'd like to reference msg.media\_player, unless it's not set, then default to flow.media\_player. Obvio…

---

## [Bigtimer output issue when off manually override](https://discourse.nodered.org/t/bigtimer-output-issue-when-off-manually-override/35117)

<div class="topic-metadata">

**Author:** [@cranx](https://discourse.nodered.org/u/cranx)\
**Replies:** 11\
**Last updated:** [1 November 2020 14:20 UTC](https://discourse.nodered.org/t/bigtimer-output-issue-when-off-manually-override/35117 "2020-11-01T14:20:12Z")

</div>

Hello all, I've an issue with the Bigtimer palette. For some reason and I really cannot figure out why, the Bigtimer is sending out an off payload while the Bigtimer has been "Off Manually Override" by an input signal …

---

## [Ethernet relay connect cloud by TCP or MQTT? which stable?](https://discourse.nodered.org/t/ethernet-relay-connect-cloud-by-tcp-or-mqtt-which-stable/34928)

<div class="topic-metadata">

**Author:** [@kincony](https://discourse.nodered.org/u/kincony)\
**Replies:** 3\
**Last updated:** [1 November 2020 13:50 UTC](https://discourse.nodered.org/t/ethernet-relay-connect-cloud-by-tcp-or-mqtt-which-stable/34928 "2020-11-01T13:50:32Z")

</div>

i have a ethernet relay, STM32 chip,now it's work with TCP socket by private text protocol. i want to ask , can i install Node-Red on the cloud server, then 1: relay board work as TCP Client connect with cloud server. …

---

## [Need help dynamically setting delay for q-gate messages](https://discourse.nodered.org/t/need-help-dynamically-setting-delay-for-q-gate-messages/35100)

<div class="topic-metadata">

**Author:** [@chrismo16](https://discourse.nodered.org/u/chrismo16)\
**Replies:** 7\
**Last updated:** [1 November 2020 13:11 UTC](https://discourse.nodered.org/t/need-help-dynamically-setting-delay-for-q-gate-messages/35100 "2020-11-01T13:11:46Z")

</div>

I have the below flow (my first after lots of reading and trial/error) that plays a doorbell chime on all of my Google Home devices when a button is clicked. \[{"id":"74892af.da407d4","type":"tab","label":"Flow 2","dis…

---

## [Deployed flow in Azure Container Instances disappears](https://discourse.nodered.org/t/deployed-flow-in-azure-container-instances-disappears/34618)

<div class="topic-metadata">

**Author:** [@tobiaspe](https://discourse.nodered.org/u/tobiaspe)\
**Replies:** 11\
**Last updated:** [1 November 2020 11:59 UTC](https://discourse.nodered.org/t/deployed-flow-in-azure-container-instances-disappears/34618 "2020-11-01T11:59:26Z")

</div>

I have used Azure Container Instances to stand-up different Node-Red containers multiple times. It is quickly done and everything seem to go as intended. I can access and deploy Node-Red flows without any problems, set…

---

## [Editor stuck at "Adding Flows to workspace"](https://discourse.nodered.org/t/editor-stuck-at-adding-flows-to-workspace/34306)

<div class="topic-metadata">

**Author:** [@taisau](https://discourse.nodered.org/u/taisau)\
**Replies:** 12\
**Last updated:** [1 November 2020 11:49 UTC](https://discourse.nodered.org/t/editor-stuck-at-adding-flows-to-workspace/34306 "2020-11-01T11:49:59Z")

</div>

After upgrade to 1.2, the editor stops at "Adding Flows to workspace". It appears to be the same issue experienced here: I'm afraid I cannot follow the debugging steps used before. Is there an easier way to find and …

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

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