# General

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

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

**Page:** 757

---

## [Troubles with logic](https://discourse.nodered.org/t/troubles-with-logic/25819)

<div class="topic-metadata">

**Author:** [@nadamson](https://discourse.nodered.org/u/nadamson)\
**Replies:** 3\
**Last updated:** [30 April 2020 15:18 UTC](https://discourse.nodered.org/t/troubles-with-logic/25819 "2020-04-30T15:18:16Z")

</div>

Hey everyone, First I would like to thank everyone here as this is a great and helpful community! I'm not a programmer but I work in the automation industry. So I understand most programming with working with logic. A…

---

## [Program smart alarms](https://discourse.nodered.org/t/program-smart-alarms/25787)

<div class="topic-metadata">

**Author:** [@eduardoluiztodero](https://discourse.nodered.org/u/eduardoluiztodero)\
**Replies:** 3\
**Last updated:** [30 April 2020 14:34 UTC](https://discourse.nodered.org/t/program-smart-alarms/25787 "2020-04-30T14:34:59Z")

</div>

Good night people! I am doing the automation of my chicken farm with node red .. I am reading temperature inside the farm .. In the first week, the temperature has to be between 35 and 30 degrees, in the second, from 30 …

---

## [Format KNX values into SQL INSERT for MYSQL](https://discourse.nodered.org/t/format-knx-values-into-sql-insert-for-mysql/25774)

<div class="topic-metadata">

**Author:** [@Hyxion14](https://discourse.nodered.org/u/Hyxion14)\
**Replies:** 14\
**Last updated:** [30 April 2020 13:36 UTC](https://discourse.nodered.org/t/format-knx-values-into-sql-insert-for-mysql/25774 "2020-04-30T13:36:56Z")

</div>

Hello I have a project in which I need to save in a bbdd mysql all the states of all KNX groups in real time. In other words, I need to listen to the KNX BUS and send all the datagrams that are written to the BUS to a m…

---

## [Convert between different types of JSON](https://discourse.nodered.org/t/convert-between-different-types-of-json/25808)

<div class="topic-metadata">

**Author:** [@dclear](https://discourse.nodered.org/u/dclear)\
**Replies:** 8\
**Last updated:** [30 April 2020 13:33 UTC](https://discourse.nodered.org/t/convert-between-different-types-of-json/25808 "2020-04-30T13:33:28Z")

</div>

Just wondering if anyone knows an easy way to convert between different types of JSON? I've had a look at an online converter but it wanted to wrap each row in curly quotes whereas I'm after:- { "111222333": "the ba…

---

## [Bigtimer command question](https://discourse.nodered.org/t/bigtimer-command-question/25810)

<div class="topic-metadata">

**Author:** [@shel](https://discourse.nodered.org/u/shel)\
**Replies:** 0\
**Last updated:** [30 April 2020 10:50 UTC](https://discourse.nodered.org/t/bigtimer-command-question/25810 "2020-04-30T10:50:44Z")

</div>

I have bigtimer set to do several timer functions and like the output verbosity. However I have a need to be able to inject a command to turn on the timer for X seconds occasionally when the timer is off. Looking through…

---

## [Message count to attribute](https://discourse.nodered.org/t/message-count-to-attribute/25634)

<div class="topic-metadata">

**Author:** [@srynearson](https://discourse.nodered.org/u/srynearson)\
**Replies:** 3\
**Last updated:** [30 April 2020 10:39 UTC](https://discourse.nodered.org/t/message-count-to-attribute/25634 "2020-04-30T10:39:34Z")

</div>

Hello, amazing Node-Red Forum! I'd like to update a home assistant entity id (wifi access point) with the state being the amount of currently connected devices. I have a reoccurring Get request that contains messages ab…

---

## ["TypeError: Cannot read property 'split' of undefined"](https://discourse.nodered.org/t/typeerror-cannot-read-property-split-of-undefined/17195)

<div class="topic-metadata">

**Author:** [@injector22](https://discourse.nodered.org/u/injector22)\
**Replies:** 16\
**Last updated:** [30 April 2020 10:15 UTC](https://discourse.nodered.org/t/typeerror-cannot-read-property-split-of-undefined/17195 "2020-04-30T10:15:09Z")

</div>

I can't seem to figure out why I'm getting this error when trying to use the split method in a function node. "TypeError: Cannot read property 'split' of undefined" Here's my function code: msg.payload = (msg.\_topic.s…

---

## [How to receive a phone number by MQTT then perform an Excel style vlookup to obtain a caller name?](https://discourse.nodered.org/t/how-to-receive-a-phone-number-by-mqtt-then-perform-an-excel-style-vlookup-to-obtain-a-caller-name/25764)

<div class="topic-metadata">

**Author:** [@dclear](https://discourse.nodered.org/u/dclear)\
**Replies:** 2\
**Last updated:** [30 April 2020 09:57 UTC](https://discourse.nodered.org/t/how-to-receive-a-phone-number-by-mqtt-then-perform-an-excel-style-vlookup-to-obtain-a-caller-name/25764 "2020-04-30T09:57:24Z")

</div>

Basically I'm trying to send a phone number into nodered (this works) then get node-red to perform a lookup in a table stored somewhere (CSV?) and return a name for the caller. Getting nowhere. Have been Googling two eve…

---

## [Node-Red Rest API request using AppKey and SecretKey](https://discourse.nodered.org/t/node-red-rest-api-request-using-appkey-and-secretkey/25799)

<div class="topic-metadata">

**Author:** [@Jude.Robise](https://discourse.nodered.org/u/Jude.Robise)\
**Replies:** 5\
**Last updated:** [30 April 2020 08:50 UTC](https://discourse.nodered.org/t/node-red-rest-api-request-using-appkey-and-secretkey/25799 "2020-04-30T08:50:11Z")

</div>

Dear all, Is it possible Node-Red to make a http/https REST API request using AppKey and SecretKey. (just Like Rest API SDK does) I'm not sure about above explanation is accurate. But I wanna get REST API GET,POST req…

---

## [Connect to MQTT broker (aedes running on AWS) from public client](https://discourse.nodered.org/t/connect-to-mqtt-broker-aedes-running-on-aws-from-public-client/25732)

<div class="topic-metadata">

**Author:** [@divyansh](https://discourse.nodered.org/u/divyansh)\
**Replies:** 4\
**Last updated:** [30 April 2020 08:34 UTC](https://discourse.nodered.org/t/connect-to-mqtt-broker-aedes-running-on-aws-from-public-client/25732 "2020-04-30T08:34:21Z")

</div>

Hi, I am pretty much new to node-red but by reading blogs and forums , I was able to setup node-red. I have installed node-red on AWS EC2 - Windows Instance and enable IIS Manager and installed websockets,enabling webs…

---

## [Node-Red Beginner needing a little help!](https://discourse.nodered.org/t/node-red-beginner-needing-a-little-help/25785)

<div class="topic-metadata">

**Author:** [@lazydatagamer](https://discourse.nodered.org/u/lazydatagamer)\
**Replies:** 1\
**Last updated:** [30 April 2020 07:57 UTC](https://discourse.nodered.org/t/node-red-beginner-needing-a-little-help/25785 "2020-04-30T07:57:51Z")

</div>

Hi there, I've been on the Node-Red forums for the past week trying to solve my problem however I don't know if I am doing it correctly. I am currently building a Soil Moisture sensor with; Pi 3 Model B Dfrobot Capaci…

---

## [How to execute bash script (Beagle Board Black)](https://discourse.nodered.org/t/how-to-execute-bash-script-beagle-board-black/25798)

<div class="topic-metadata">

**Author:** [@Nic](https://discourse.nodered.org/u/Nic)\
**Replies:** 1\
**Last updated:** [30 April 2020 07:44 UTC](https://discourse.nodered.org/t/how-to-execute-bash-script-beagle-board-black/25798 "2020-04-30T07:44:43Z")

</div>

Hi, I moved my first steps using node-red on beagle bone black trying to control the gpios and playing with flows. Now I want to try to execute a script calling it via node-red. I tried to search info on the web but i …

---

## [Passing Bearer Token Not Working](https://discourse.nodered.org/t/passing-bearer-token-not-working/25786)

<div class="topic-metadata">

**Author:** [@mikeh](https://discourse.nodered.org/u/mikeh)\
**Replies:** 1\
**Last updated:** [30 April 2020 03:50 UTC](https://discourse.nodered.org/t/passing-bearer-token-not-working/25786 "2020-04-30T03:50:56Z")

</div>

I was trying to pass the API key from a function: msg.headers = {}; msg.headers\['Authorization'\] = "Bearer "+ msg.payload.token; return msg; I keep on getting 401 error. But when I copied the entire API key to the…

---

## [Convert relative URL to absolute](https://discourse.nodered.org/t/convert-relative-url-to-absolute/25783)

<div class="topic-metadata">

**Author:** [@evitiello](https://discourse.nodered.org/u/evitiello)\
**Replies:** 0\
**Last updated:** [30 April 2020 01:08 UTC](https://discourse.nodered.org/t/convert-relative-url-to-absolute/25783 "2020-04-30T01:08:47Z")

</div>

Hi - I'm looking for the cleanest way to convert a relative URL to an absolute URL in a node (I have the relative URL and the base URL) It looks like I can't include node modules (such as url). What's the best way to do…

---

## [What is this "line" I am seeing?](https://discourse.nodered.org/t/what-is-this-line-i-am-seeing/25777)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 2\
**Last updated:** [29 April 2020 23:17 UTC](https://discourse.nodered.org/t/what-is-this-line-i-am-seeing/25777 "2020-04-29T23:17:25Z")

</div>

With the original colour scheme, I thought I saw something and just put it down to I'm seeing things. But now I have the new colour scheme there is definitely a line. This one you can see 3 of these lines. (Inside …

---

## [Two events showing in debug tab instead of one](https://discourse.nodered.org/t/two-events-showing-in-debug-tab-instead-of-one/25767)

<div class="topic-metadata">

**Author:** [@akhaliq7](https://discourse.nodered.org/u/akhaliq7)\
**Replies:** 0\
**Last updated:** [29 April 2020 21:04 UTC](https://discourse.nodered.org/t/two-events-showing-in-debug-tab-instead-of-one/25767 "2020-04-29T21:04:18Z")

</div>

Problem: when i publish events to the ibm cloud watson iot platform then one even shows for each event published but when i view the same event in node red using a ibm iot input node and a debug node the debug tab shows …

---

## [Node-red-contrib-mios](https://discourse.nodered.org/t/node-red-contrib-mios/25749)

<div class="topic-metadata">

**Author:** [@ksmeltz](https://discourse.nodered.org/u/ksmeltz)\
**Replies:** 1\
**Last updated:** [29 April 2020 17:01 UTC](https://discourse.nodered.org/t/node-red-contrib-mios/25749 "2020-04-29T17:01:34Z")

</div>

I am running Node-RED on a Raspberry Pi 4 with openhabian 2.5.3-1. I am using the node 'node-red-contrib-mios', which seems to do exactly what I need. I have a problem however, when I reboot. The node seems to output …

---

## [Ds18b20 raspberry pi](https://discourse.nodered.org/t/ds18b20-raspberry-pi/25689)

<div class="topic-metadata">

**Author:** [@usmanEmder](https://discourse.nodered.org/u/usmanEmder)\
**Replies:** 13\
**Last updated:** [29 April 2020 16:29 UTC](https://discourse.nodered.org/t/ds18b20-raspberry-pi/25689 "2020-04-29T16:29:26Z")

</div>

I am using ds18b20 with the raspberry pi and I am using "node-red-contrib-sensor-ds18b20" node with inject and debug node and it shows the payload as mentioned in below picture. while I need temperature. Any suggestio…

---

## [Fine tune a "function" node](https://discourse.nodered.org/t/fine-tune-a-function-node/369)

<div class="topic-metadata">

**Author:** [@fritserasmus](https://discourse.nodered.org/u/fritserasmus)\
**Replies:** 16\
**Last updated:** [29 April 2020 16:04 UTC](https://discourse.nodered.org/t/fine-tune-a-function-node/369 "2020-04-29T16:04:31Z")

</div>

I am trying to create an INSERT SQL script when reading are sent to the MQTT server. I am 99% done just sit with two " both sides of the message that I am unable to get rid of. This is a shortened version of my code bu…

---

## [Prerequisites for Node Red project on Windows environment?](https://discourse.nodered.org/t/prerequisites-for-node-red-project-on-windows-environment/25736)

<div class="topic-metadata">

**Author:** [@CraigM](https://discourse.nodered.org/u/CraigM)\
**Replies:** 3\
**Last updated:** [29 April 2020 15:25 UTC](https://discourse.nodered.org/t/prerequisites-for-node-red-project-on-windows-environment/25736 "2020-04-29T15:25:34Z")

</div>

I am a complete newbee to Node Red and a novice programmer. I've installed it on my Windows 10 PC and slowly going through the Youtube tutorials....are there any better ones out there? Anyway, I'm learning NodeRed beca…

---

## [Cloudflare Dynamic DNS setup](https://discourse.nodered.org/t/cloudflare-dynamic-dns-setup/25750)

<div class="topic-metadata">

**Author:** [@Colin](https://discourse.nodered.org/u/Colin)\
**Replies:** 0\
**Last updated:** [29 April 2020 15:03 UTC](https://discourse.nodered.org/t/cloudflare-dynamic-dns-setup/25750 "2020-04-29T15:03:37Z")

</div>

Has anyone written a little flow to automatically update a domain DNS on cloudflare when their ISP provided IP address changes? I couldn't find anything in the flows library.

---

## [Gmail and node-red-node-email](https://discourse.nodered.org/t/gmail-and-node-red-node-email/25691)

<div class="topic-metadata">

**Author:** [@hammeronthenet](https://discourse.nodered.org/u/hammeronthenet)\
**Replies:** 8\
**Last updated:** [29 April 2020 14:04 UTC](https://discourse.nodered.org/t/gmail-and-node-red-node-email/25691 "2020-04-29T14:04:06Z")

</div>

Hi guys, I'm wondering to send an email through via gmail (gsuite) I tried various approach, and now I've got double authentication factor and an application password. Nothing. I tried from admin console to enable sm…

---

## [Nora, how to use Google Thermostat node?](https://discourse.nodered.org/t/nora-how-to-use-google-thermostat-node/25739)

<div class="topic-metadata">

**Author:** [@SteveJohnSteele](https://discourse.nodered.org/u/SteveJohnSteele)\
**Replies:** 0\
**Last updated:** [29 April 2020 12:18 UTC](https://discourse.nodered.org/t/nora-how-to-use-google-thermostat-node/25739 "2020-04-29T12:18:27Z")

</div>

Hello Andrei I have some question, I hope you can answer. In Google Home app under Thermostat (any mode) "Indoor 25" always appears. I have tried sending { "temperature:" 35 } and others but it has no affect. How do …

---

## [How to cycle several inputs to one output?](https://discourse.nodered.org/t/how-to-cycle-several-inputs-to-one-output/25702)

<div class="topic-metadata">

**Author:** [@krizniq](https://discourse.nodered.org/u/krizniq)\
**Replies:** 2\
**Last updated:** [29 April 2020 11:29 UTC](https://discourse.nodered.org/t/how-to-cycle-several-inputs-to-one-output/25702 "2020-04-29T11:29:57Z")

</div>

Hello, I need bit help here :slight\_smile: I have three inputs (temperature, water temperature and humidity) and want them display on oled display in cycle like 10second each and then redraw display with another input …

---

## [Struggling with CSV and multiple inputs](https://discourse.nodered.org/t/struggling-with-csv-and-multiple-inputs/25729)

<div class="topic-metadata">

**Author:** [@WImpie](https://discourse.nodered.org/u/WImpie)\
**Replies:** 6\
**Last updated:** [29 April 2020 11:09 UTC](https://discourse.nodered.org/t/struggling-with-csv-and-multiple-inputs/25729 "2020-04-29T11:09:08Z")

</div>

\[{"id":"e038814.cdfb78","type":"tab","label":"Flow 2","disabled":false,"info":""},{"id":"42910d99.52e794","type":"delay","z":"e038814.cdfb78","name":"","pauseType":"queue","timeout":"5","timeoutUnits":"seconds","rate":"1…

---

## [MQTT message not seeming to work](https://discourse.nodered.org/t/mqtt-message-not-seeming-to-work/25705)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 11\
**Last updated:** [29 April 2020 10:50 UTC](https://discourse.nodered.org/t/mqtt-message-not-seeming-to-work/25705 "2020-04-29T10:50:08Z")

</div>

I have a couple of Tasmota devices connected. Looking, the LWT message is retained. So I would think that when the machine is powered up the message is received and should be affected. Sorry it is a bit messed up in l…

---

## [Using a node inside a custom node](https://discourse.nodered.org/t/using-a-node-inside-a-custom-node/25727)

<div class="topic-metadata">

**Author:** [@aperez](https://discourse.nodered.org/u/aperez)\
**Replies:** 2\
**Last updated:** [29 April 2020 09:50 UTC](https://discourse.nodered.org/t/using-a-node-inside-a-custom-node/25727 "2020-04-29T09:50:50Z")

</div>

I would like to create custom node that works with a specific framework. That framework needs to be iconfigured/consumed using REST. No to "reinvent the wheel", Is there any way to use www.request node from inside the cu…

---

## [JSONata absurdities](https://discourse.nodered.org/t/jsonata-absurdities/25220)

<div class="topic-metadata">

**Author:** [@T0T4R4](https://discourse.nodered.org/u/T0T4R4)\
**Replies:** 5\
**Last updated:** [29 April 2020 05:19 UTC](https://discourse.nodered.org/t/jsonata-absurdities/25220 "2020-04-29T05:19:37Z")

</div>

Hi guys, Could someone explain me the following JSONAta absurdity ? Thanks heaps

---

## [Can't locate Setting file](https://discourse.nodered.org/t/cant-locate-setting-file/25688)

<div class="topic-metadata">

**Author:** [@1bit](https://discourse.nodered.org/u/1bit)\
**Replies:** 7\
**Last updated:** [29 April 2020 04:40 UTC](https://discourse.nodered.org/t/cant-locate-setting-file/25688 "2020-04-29T04:40:30Z")

</div>

Hello, I'm using Armbian on Orange Pi Zero and have Node-red running as a server for a healthy 6 months. To cut a long story short, I had to reinstall everything only to encouter the following at startup problem: root@…

---

## [Split TypeError: Cannot convert undefined or null to object](https://discourse.nodered.org/t/split-typeerror-cannot-convert-undefined-or-null-to-object/25712)

<div class="topic-metadata">

**Author:** [@T0T4R4](https://discourse.nodered.org/u/T0T4R4)\
**Replies:** 3\
**Last updated:** [29 April 2020 04:32 UTC](https://discourse.nodered.org/t/split-typeerror-cannot-convert-undefined-or-null-to-object/25712 "2020-04-29T04:32:20Z")

</div>

Hi all, How can I debug that kind of error which occurs visibly within a Split node ? split TypeError: Cannot convert undefined or null to object Thanks in advance Tot

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

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