# General

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

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

**Page:** 406

---

## [How to change the default marker icon in the node-red worldmap node from a function node?](https://discourse.nodered.org/t/how-to-change-the-default-marker-icon-in-the-node-red-worldmap-node-from-a-function-node/59812)

<div class="topic-metadata">

**Author:** [@oliver](https://discourse.nodered.org/u/oliver)\
**Replies:** 3\
**Last updated:** [15 March 2022 10:25 UTC](https://discourse.nodered.org/t/how-to-change-the-default-marker-icon-in-the-node-red-worldmap-node-from-a-function-node/59812 "2022-03-15T10:25:48Z")

</div>

Hi the default red marker is very large, I wonder if there is a way to change it. I did not find a property in the worldmap node settings. I know it is possible to add it in every record but that is not the way I prefe…

---

## [Pass data throught a button to SQL Table](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649)

<div class="topic-metadata">

**Author:** [@QGIO](https://discourse.nodered.org/u/QGIO)\
**Replies:** 27\
**Last updated:** [15 March 2022 09:09 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649 "2022-03-15T09:09:55Z")

</div>

Hello! I have created a UI like this: \</\> When I press the button 'CARICA' I would insert the inserted data to an SQL table (already created). Which flow can I use? How can I pass inserted data to the SQL table (I…

---

## [Entity could not be found in cache](https://discourse.nodered.org/t/entity-could-not-be-found-in-cache/59845)

<div class="topic-metadata">

**Author:** [@Luminary](https://discourse.nodered.org/u/Luminary)\
**Replies:** 1\
**Last updated:** [15 March 2022 08:45 UTC](https://discourse.nodered.org/t/entity-could-not-be-found-in-cache/59845 "2022-03-15T08:45:03Z")

</div>

I'm running NR in Home Assistant. I'm trying to set up a flow that will check if we're home at a specific time during the day, and if we are, turn on a light. I've configured current state nodes to check the locations of…

---

## [Nextcloud Oauth 2 Login](https://discourse.nodered.org/t/nextcloud-oauth-2-login/4403)

<div class="topic-metadata">

**Author:** [@dugite-code](https://discourse.nodered.org/u/dugite-code)\
**Replies:** 7\
**Last updated:** [15 March 2022 06:55 UTC](https://discourse.nodered.org/t/nextcloud-oauth-2-login/4403 "2022-03-15T06:55:18Z")

</div>

I'm trying to log into my Node-red instance using Nextcloud 14's new Oath2 implementation. I get through the login with nextcloud and get re-directed to the callback url https://example.tld/node-red/auth/strategy/callba…

---

## [Looks like node-red-contrib-dns has been orphaned, and once you move to node14, install fails?](https://discourse.nodered.org/t/looks-like-node-red-contrib-dns-has-been-orphaned-and-once-you-move-to-node14-install-fails/59857)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 2\
**Last updated:** [15 March 2022 03:54 UTC](https://discourse.nodered.org/t/looks-like-node-red-contrib-dns-has-been-orphaned-and-once-you-move-to-node14-install-fails/59857 "2022-03-15T03:54:03Z")

</div>

Looks like node-red-contrib-dns has been orphaned, and once you move to node 14, install fails? Violates version range, per the package details. I can of course change the package details to force the issue and test. …

---

## [Add array object value from two arrays and return one array with the add values](https://discourse.nodered.org/t/add-array-object-value-from-two-arrays-and-return-one-array-with-the-add-values/59826)

<div class="topic-metadata">

**Author:** [@Gitsaibot](https://discourse.nodered.org/u/Gitsaibot)\
**Replies:** 4\
**Last updated:** [15 March 2022 02:24 UTC](https://discourse.nodered.org/t/add-array-object-value-from-two-arrays-and-return-one-array-with-the-add-values/59826 "2022-03-15T02:24:40Z")

</div>

Hello, is it possible to add an object value from two arrays without changing the other objects in the array? The two arrays should become one array.

---

## [High CPU usage due to watchdirectory contrib node](https://discourse.nodered.org/t/high-cpu-usage-due-to-watchdirectory-contrib-node/59800)

<div class="topic-metadata">

**Author:** [@CreativeWarlock](https://discourse.nodered.org/u/CreativeWarlock)\
**Replies:** 13\
**Last updated:** [14 March 2022 21:37 UTC](https://discourse.nodered.org/t/high-cpu-usage-due-to-watchdirectory-contrib-node/59800 "2022-03-14T21:37:55Z")

</div>

Just a heads-up in case anyone else has the problem of his/her Node Red using high CPU usage + high LOAD values: Would be great if there's a way to install a throttle or delay cause my Node Red platform became more and…

---

## [How to check user input text is not in already in SQL results](https://discourse.nodered.org/t/how-to-check-user-input-text-is-not-in-already-in-sql-results/59850)

<div class="topic-metadata">

**Author:** [@QGIO](https://discourse.nodered.org/u/QGIO)\
**Replies:** 1\
**Last updated:** [14 March 2022 15:49 UTC](https://discourse.nodered.org/t/how-to-check-user-input-text-is-not-in-already-in-sql-results/59850 "2022-03-14T15:49:53Z")

</div>

Hello Forum, Could you suggest me some post or link where I can see how to make a comparison between an input text and the result of a query made to an SQL table? The result of the query is a column extracted from an S…

---

## [How to change json property with the value in a text input node?](https://discourse.nodered.org/t/how-to-change-json-property-with-the-value-in-a-text-input-node/59835)

<div class="topic-metadata">

**Author:** [@thoraz](https://discourse.nodered.org/u/thoraz)\
**Replies:** 3\
**Last updated:** [14 March 2022 15:25 UTC](https://discourse.nodered.org/t/how-to-change-json-property-with-the-value-in-a-text-input-node/59835 "2022-03-14T15:25:10Z")

</div>

A simple question: how to change json property with the value in a text input node? I have a button node that generates a json object to send via mqtt. Now I want to use a text input node to change the value of data prop…

---

## [Node Red on openwrt and serial port](https://discourse.nodered.org/t/node-red-on-openwrt-and-serial-port/59837)

<div class="topic-metadata">

**Author:** [@plouc](https://discourse.nodered.org/u/plouc)\
**Replies:** 6\
**Last updated:** [14 March 2022 15:11 UTC](https://discourse.nodered.org/t/node-red-on-openwrt-and-serial-port/59837 "2022-03-14T15:11:53Z")

</div>

Hello, I installed node-red alongside openmtcprouter which is openwrt based. PACKAGE: openmptcprouter VERSION: v0.58.5 TARGET: rpi4 ARCH: aarch64\_cortex-a72 The goal is to add automation on a sy…

---

## [User context in httpAdminMiddleware?](https://discourse.nodered.org/t/user-context-in-httpadminmiddleware/57542)

<div class="topic-metadata">

**Author:** [@mw75](https://discourse.nodered.org/u/mw75)\
**Replies:** 5\
**Last updated:** [14 March 2022 15:00 UTC](https://discourse.nodered.org/t/user-context-in-httpadminmiddleware/57542 "2022-03-14T15:00:30Z")

</div>

Hi all, i'm currently integrating node-red in an OpenID-connect context using keycloak as provider - see OAuth/OpenID logout with Keycloak . In this context i found the httpAdminMiddleware settings and tried it out. I …

---

## [Plotting values wont work](https://discourse.nodered.org/t/plotting-values-wont-work/59829)

<div class="topic-metadata">

**Author:** [@Olivia](https://discourse.nodered.org/u/Olivia)\
**Replies:** 5\
**Last updated:** [14 March 2022 13:49 UTC](https://discourse.nodered.org/t/plotting-values-wont-work/59829 "2022-03-14T13:49:10Z")

</div>

Hello evryone, i have a script where i wanna print the output. I tried many things, from a chart to a table but i cant print the output. i prefer to see te values is a linechart. but i thing it will be to difficult to …

---

## [Docker NodeRed on Unraid Applestreudal File Path](https://discourse.nodered.org/t/docker-nodered-on-unraid-applestreudal-file-path/59823)

<div class="topic-metadata">

**Author:** [@CAL37](https://discourse.nodered.org/u/CAL37)\
**Replies:** 6\
**Last updated:** [14 March 2022 13:09 UTC](https://discourse.nodered.org/t/docker-nodered-on-unraid-applestreudal-file-path/59823 "2022-03-14T13:09:58Z")

</div>

Does anyone run Node-Red using docker on Unraid? I'm trying to authenticate my Alexa and have narrowed it down to possibly being a access issue to save the cookie. I tried to see if I could just get to /mnt, but got EISD…

---

## [ISSUE with storing MQTT values to mySQL database : the values store as "undefined". Any guidence is much appreciated](https://discourse.nodered.org/t/issue-with-storing-mqtt-values-to-mysql-database-the-values-store-as-undefined-any-guidence-is-much-appreciated/59811)

<div class="topic-metadata">

**Author:** [@Evan7](https://discourse.nodered.org/u/Evan7)\
**Replies:** 9\
**Last updated:** [14 March 2022 13:08 UTC](https://discourse.nodered.org/t/issue-with-storing-mqtt-values-to-mysql-database-the-values-store-as-undefined-any-guidence-is-much-appreciated/59811 "2022-03-14T13:08:52Z")

</div>

DEBUG WINDOW: INSERT INTO readingsreceived(ssid,rssi,scan\_mac,sensor\_mac)VALUES('undefined','NaN','undefined','undefined'); : msg.payload : ResultSetHeader "\[object Object\]" FUNCTION NODE QUERY: ssid = msg.payload.ssi…

---

## [How to use the Email Node](https://discourse.nodered.org/t/how-to-use-the-email-node/59834)

<div class="topic-metadata">

**Author:** [@soxprox](https://discourse.nodered.org/u/soxprox)\
**Replies:** 6\
**Last updated:** [14 March 2022 12:21 UTC](https://discourse.nodered.org/t/how-to-use-the-email-node/59834 "2022-03-14T12:21:38Z")

</div>

I have a basic flow working with an IMAP email account. When there is unread email my inbox an LED is turned on. I have two issues that I am trying resolve. In order to turn off the LED when there is no unread email,…

---

## [Settings.js issue after upgrading to 2.2.2](https://discourse.nodered.org/t/settings-js-issue-after-upgrading-to-2-2-2/59769)

<div class="topic-metadata">

**Author:** [@GasTurbineMan](https://discourse.nodered.org/u/GasTurbineMan)\
**Replies:** 15\
**Last updated:** [14 March 2022 10:46 UTC](https://discourse.nodered.org/t/settings-js-issue-after-upgrading-to-2-2-2/59769 "2022-03-14T10:46:55Z")

</div>

Just upgraded from 2.1.x to 2.2.2 on RaspberryPi using the script on Node-Red site. Upgrade went normally except at the end, I got a message informing me that my settings.js did not match the format of the new settings.…

---

## [Node-red crash with node-red-contrib-telegrambot-home](https://discourse.nodered.org/t/node-red-crash-with-node-red-contrib-telegrambot-home/59806)

<div class="topic-metadata">

**Author:** [@achrafb](https://discourse.nodered.org/u/achrafb)\
**Replies:** 13\
**Last updated:** [14 March 2022 09:32 UTC](https://discourse.nodered.org/t/node-red-crash-with-node-red-contrib-telegrambot-home/59806 "2022-03-14T09:32:47Z")

</div>

Hi all :slight\_smile: Lately I have been using the nodes: node-red-contrib-telegrambot-home, I have seen that if any user blocks the BOT, the whole Node-red service restarts, I have tried with the catch to receive the e…

---

## [Is there any way to stream data from MongoDB?](https://discourse.nodered.org/t/is-there-any-way-to-stream-data-from-mongodb/59830)

<div class="topic-metadata">

**Author:** [@sarthakpundir](https://discourse.nodered.org/u/sarthakpundir)\
**Replies:** 0\
**Last updated:** [14 March 2022 08:50 UTC](https://discourse.nodered.org/t/is-there-any-way-to-stream-data-from-mongodb/59830 "2022-03-14T08:50:50Z")

</div>

Hello everyone, I'm trying to create a flow where I'll be reading documents from a MongoDB collection, perform some operations on it and save them to another MongoDB collection. I'm totally new to Node-RED and looking …

---

## [Mqtt mariadb function query](https://discourse.nodered.org/t/mqtt-mariadb-function-query/59820)

<div class="topic-metadata">

**Author:** [@nbaglietto](https://discourse.nodered.org/u/nbaglietto)\
**Replies:** 3\
**Last updated:** [14 March 2022 07:52 UTC](https://discourse.nodered.org/t/mqtt-mariadb-function-query/59820 "2022-03-14T07:52:35Z")

</div>

Good trades, I have a wemos d1 with espeasy that now only has a switch that sends status to domoticz open or closed. What I want is for node to connect to the mqtt broker, receive status and do an INSERT INTO event with…

---

## [Node-red-contrib-telegrambot polling error](https://discourse.nodered.org/t/node-red-contrib-telegrambot-polling-error/59588)

<div class="topic-metadata">

**Author:** [@nico25](https://discourse.nodered.org/u/nico25)\
**Replies:** 10\
**Last updated:** [14 March 2022 05:57 UTC](https://discourse.nodered.org/t/node-red-contrib-telegrambot-polling-error/59588 "2022-03-14T05:57:00Z")

</div>

This has beed discussed here before, but I couldn´t find a working solution for me. I tried to produce a simple echo with receiver and sender node like in the example. Unfortunately all I get is "polling error" from th…

---

## [Select files within a date range and merge them into one file](https://discourse.nodered.org/t/select-files-within-a-date-range-and-merge-them-into-one-file/59701)

<div class="topic-metadata">

**Author:** [@Gitsaibot](https://discourse.nodered.org/u/Gitsaibot)\
**Replies:** 20\
**Last updated:** [14 March 2022 04:30 UTC](https://discourse.nodered.org/t/select-files-within-a-date-range-and-merge-them-into-one-file/59701 "2022-03-14T04:30:30Z")

</div>

Hello, I have a directory that contains a csv file for each day. I now want to select all files within a month e.g. May and merge them into one big csv file. The csv files all have the same structure. I have already ex…

---

## [Modify JSON property to include additional text -maybe using regex?](https://discourse.nodered.org/t/modify-json-property-to-include-additional-text-maybe-using-regex/59822)

<div class="topic-metadata">

**Author:** [@anakaine](https://discourse.nodered.org/u/anakaine)\
**Replies:** 2\
**Last updated:** [14 March 2022 04:03 UTC](https://discourse.nodered.org/t/modify-json-property-to-include-additional-text-maybe-using-regex/59822 "2022-03-14T04:03:16Z")

</div>

I have some JSON that looks like the following: { "StationNum": 32109, "Height": 3.686 }, { "StationNum": 32152, "Height": 1.598 }, { "StationNum": 32155, …

---

## [External youtube-dl-exec library crashes NR](https://discourse.nodered.org/t/external-youtube-dl-exec-library-crashes-nr/59807)

<div class="topic-metadata">

**Author:** [@mickym2](https://discourse.nodered.org/u/mickym2)\
**Replies:** 10\
**Last updated:** [14 March 2022 02:56 UTC](https://discourse.nodered.org/t/external-youtube-dl-exec-library-crashes-nr/59807 "2022-03-14T02:56:19Z")

</div>

In January 2022 - I had the following flow, using a function Node to get information about a YouTube video. It uses the youtube-dl-exec library. The function code was quite simple: const myTimeout = setTimeout(NoReturn…

---

## [Removing elements from JSON, including bringing child elements up a level?](https://discourse.nodered.org/t/removing-elements-from-json-including-bringing-child-elements-up-a-level/59819)

<div class="topic-metadata">

**Author:** [@anakaine](https://discourse.nodered.org/u/anakaine)\
**Replies:** 2\
**Last updated:** [14 March 2022 02:19 UTC](https://discourse.nodered.org/t/removing-elements-from-json-including-bringing-child-elements-up-a-level/59819 "2022-03-14T02:19:26Z")

</div>

I have a JSON string that's being returned by a HTTP Request to an external service. I have a format into which I need this JSON string to be parsed for a library that comes downstream in my flow. I'm not sure where to s…

---

## [How to get this data into influx db](https://discourse.nodered.org/t/how-to-get-this-data-into-influx-db/59815)

<div class="topic-metadata">

**Author:** [@Clutch](https://discourse.nodered.org/u/Clutch)\
**Replies:** 1\
**Last updated:** [13 March 2022 22:02 UTC](https://discourse.nodered.org/t/how-to-get-this-data-into-influx-db/59815 "2022-03-13T22:02:28Z")

</div>

I'm using a mqtt example with my Nano 33 IOT The data I am seeing is below. The arduino code is below. I can't figure out how to get the data into a influx database. Can someone give me a clue? This is on a RP3, Bul…

---

## [Need help to output sensor's temperature value on demand](https://discourse.nodered.org/t/need-help-to-output-sensors-temperature-value-on-demand/59625)

<div class="topic-metadata">

**Author:** [@Solid](https://discourse.nodered.org/u/Solid)\
**Replies:** 2\
**Last updated:** [13 March 2022 20:19 UTC](https://discourse.nodered.org/t/need-help-to-output-sensors-temperature-value-on-demand/59625 "2022-03-13T20:19:09Z")

</div>

he flow that I have the problem is called TextToSpeech As you can see value of payload.SI7021.Temperature is from the mqtt node tele/tasmota\_D7C816/SENSOR and when the sensor outputs the value(every 5 min) the text to …

---

## [Unable to send message to telegram](https://discourse.nodered.org/t/unable-to-send-message-to-telegram/59773)

<div class="topic-metadata">

**Author:** [@smartgirl62](https://discourse.nodered.org/u/smartgirl62)\
**Replies:** 7\
**Last updated:** [13 March 2022 16:58 UTC](https://discourse.nodered.org/t/unable-to-send-message-to-telegram/59773 "2022-03-13T16:58:59Z")

</div>

I set up our local water agency to send me a daily email of our previous day's water usage. I am able to extract out the number of gallons but when I try to send a message to telegram, I receive an error. (TypeError: Can…

---

## [Flow with two magnet sensors controlling if a heater is allowed to run or not](https://discourse.nodered.org/t/flow-with-two-magnet-sensors-controlling-if-a-heater-is-allowed-to-run-or-not/59767)

<div class="topic-metadata">

**Author:** [@pimmen85](https://discourse.nodered.org/u/pimmen85)\
**Replies:** 4\
**Last updated:** [13 March 2022 14:35 UTC](https://discourse.nodered.org/t/flow-with-two-magnet-sensors-controlling-if-a-heater-is-allowed-to-run-or-not/59767 "2022-03-13T14:35:34Z")

</div>

i have one magnet sensor for each entry to my garage, and i have a backup heater fan, i would like to create a flow that basically does the following "when one of the doors are open a plug that controlls the heater shoul…

---

## [Node-red-contrib-pca9685 0.1.4 fall](https://discourse.nodered.org/t/node-red-contrib-pca9685-0-1-4-fall/59777)

<div class="topic-metadata">

**Author:** [@ld202167](https://discourse.nodered.org/u/ld202167)\
**Replies:** 9\
**Last updated:** [13 March 2022 14:26 UTC](https://discourse.nodered.org/t/node-red-contrib-pca9685-0-1-4-fall/59777 "2022-03-13T14:26:33Z")

</div>

2022-03-12T21:15:52.565Z npm install --no-audit --no-update-notifier --no-fund --save --save-prefix=~ --production --engine-strict node-red-contrib-pca9685@0.1.4 2022-03-12T21:16:18.245Z \[err\] npm 2022-03-12T21:16:18.2…

---

## [Playing audio in uibuilder](https://discourse.nodered.org/t/playing-audio-in-uibuilder/58973)

<div class="topic-metadata">

**Author:** [@eltigrezinno](https://discourse.nodered.org/u/eltigrezinno)\
**Replies:** 8\
**Last updated:** [13 March 2022 14:23 UTC](https://discourse.nodered.org/t/playing-audio-in-uibuilder/58973 "2022-03-13T14:23:15Z")

</div>

Hello everyone, First, sorry for my english which is not my native language ! I'm trying to create a "Control Center" for an Escape Game Room. One of the issue I have is that I try to make an audio file (.mp3) playing…

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

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