# General

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

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

**Page:** 84

---

## [Change msg to object](https://discourse.nodered.org/t/change-msg-to-object/91114)

<div class="topic-metadata">

**Author:** [@platinum](https://discourse.nodered.org/u/platinum)\
**Replies:** 3\
**Last updated:** [20 September 2024 16:11 UTC](https://discourse.nodered.org/t/change-msg-to-object/91114 "2024-09-20T16:11:17Z")

</div>

Hi there, I’m new to node red and have probably an easy problem which I can't solve: I receive data via mqtt and need to write it to an ifluxdb2 database. The mqtt data comes from two different sources. The first flo…

---

## [Node context not a function?](https://discourse.nodered.org/t/node-context-not-a-function/91141)

<div class="topic-metadata">

**Author:** [@ThingsTinkerer](https://discourse.nodered.org/u/ThingsTinkerer)\
**Replies:** 3\
**Last updated:** [20 September 2024 14:24 UTC](https://discourse.nodered.org/t/node-context-not-a-function/91141 "2024-09-20T14:24:25Z")

</div>

Have used context successfully for both global and flow. According to documentation, there is also node context. But can't get this to work and don't find any examples. For example: node.get("key"); node.set("key", ms…

---

## [API GET /nodes returns a string?](https://discourse.nodered.org/t/api-get-nodes-returns-a-string/91132)

<div class="topic-metadata">

**Author:** [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Replies:** 1\
**Last updated:** [20 September 2024 06:29 UTC](https://discourse.nodered.org/t/api-get-nodes-returns-a-string/91132 "2024-09-20T06:29:21Z")

</div>

When performing a GET /nodes, it returns: This does not seem correct ? I was expecting an array of objects as per docs

---

## [Node-RED crash after write boolean to CPU1500 OPC UA](https://discourse.nodered.org/t/node-red-crash-after-write-boolean-to-cpu1500-opc-ua/91107)

<div class="topic-metadata">

**Author:** [@Michal](https://discourse.nodered.org/u/Michal)\
**Replies:** 2\
**Last updated:** [20 September 2024 06:19 UTC](https://discourse.nodered.org/t/node-red-crash-after-write-boolean-to-cpu1500-opc-ua/91107 "2024-09-20T06:19:04Z")

</div>

Hi I have Node-RED version 4.0.3 and CPU Siemens 1518F-4 PN/DP with OPC UA server. After exporting data from PLC to CSV, I want to write one bool in the plc that the export was successful created and then I could delet…

---

## [String Array from Exec Node to JSON Object](https://discourse.nodered.org/t/string-array-from-exec-node-to-json-object/91127)

<div class="topic-metadata">

**Author:** [@iotemylabs](https://discourse.nodered.org/u/iotemylabs)\
**Replies:** 4\
**Last updated:** [20 September 2024 05:45 UTC](https://discourse.nodered.org/t/string-array-from-exec-node-to-json-object/91127 "2024-09-20T05:45:57Z")

</div>

Hi! I have been racking my brain for hours trying to get a JSON output. After calling a CLI command using the Exec node, I get this string array: "\[↵ {↵ id: 'djtxrc3qclpy62pvpleh33vs',↵ createdAt: 2024-09-19T19:51:33.…

---

## [Issue with accumulative values of a table in dashboard](https://discourse.nodered.org/t/issue-with-accumulative-values-of-a-table-in-dashboard/90794)

<div class="topic-metadata">

**Author:** [@wcordova](https://discourse.nodered.org/u/wcordova)\
**Replies:** 6\
**Last updated:** [19 September 2024 19:31 UTC](https://discourse.nodered.org/t/issue-with-accumulative-values-of-a-table-in-dashboard/90794 "2024-09-19T19:31:09Z")

</div>

Hi all with raspberry pi, I' am getting values from logo siemens PLC. My idea is to show these values in a table inside the dashboard. Current it is working and I can read the data and this data is visible in the ta…

---

## [CLI query succeeds but NR fails](https://discourse.nodered.org/t/cli-query-succeeds-but-nr-fails/91082)

<div class="topic-metadata">

**Author:** [@ralvez](https://discourse.nodered.org/u/ralvez)\
**Replies:** 12\
**Last updated:** [19 September 2024 16:44 UTC](https://discourse.nodered.org/t/cli-query-succeeds-but-nr-fails/91082 "2024-09-19T16:44:55Z")

</div>

I have this query: DECLARE p\_term\_code\_sturec VARCHAR2(6); BEGIN SELECT SHRDGMR\_TERM\_CODE\_STUREC INTO p\_term\_code\_sturec FROM SHRDGMR WHERE SHRDGMR\_PIDM = 123456 AND SHRDGMR\_SEQ\_NO = 2; …

---

## [Help with error in code](https://discourse.nodered.org/t/help-with-error-in-code/91109)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 3\
**Last updated:** [19 September 2024 15:05 UTC](https://discourse.nodered.org/t/help-with-error-in-code/91109 "2024-09-19T15:05:36Z")

</div>

Sorry, I tried Chat-GPT and the code it gives me looks good - in theory - but I am getting an error. const startDate = new Date('2024-9-17'); // Replace with your start date const now = new Date(); const msPerDay = 1000…

---

## [Computer and Node-RED](https://discourse.nodered.org/t/computer-and-node-red/91102)

<div class="topic-metadata">

**Author:** [@zmoey12](https://discourse.nodered.org/u/zmoey12)\
**Replies:** 3\
**Last updated:** [19 September 2024 10:59 UTC](https://discourse.nodered.org/t/computer-and-node-red/91102 "2024-09-19T10:59:50Z")

</div>

Hi Guys, I'm struggling with using Node-RED. I had my friend run my simple code I followed from youtube to read to a .txt file, and it worked for him, however it just won't work for me. I've got a windows laptop, so if …

---

## [JSON structure - checking](https://discourse.nodered.org/t/json-structure-checking/91085)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 4\
**Last updated:** [19 September 2024 09:20 UTC](https://discourse.nodered.org/t/json-structure-checking/91085 "2024-09-19T09:20:21Z")

</div>

Sorry folks. I need to clarify this confusion at my end. msg.payload = { "Who": device\_name, "Modem": A, "UpLink": B }; Given all other things are set. This works. Or seems to. and yet in ot…

---

## [Change font size in excel file](https://discourse.nodered.org/t/change-font-size-in-excel-file/91066)

<div class="topic-metadata">

**Author:** [@amr](https://discourse.nodered.org/u/amr)\
**Replies:** 3\
**Last updated:** [19 September 2024 07:48 UTC](https://discourse.nodered.org/t/change-font-size-in-excel-file/91066 "2024-09-19T07:48:47Z")

</div>

Hello everyone! i need to help me I'm 1st time to used Node-Red i need to change font size in excel file function node is msg.payload = \[{ header: { 'author': 'authorName', 'title': …

---

## [Convert from base16 to base64](https://discourse.nodered.org/t/convert-from-base16-to-base64/91094)

<div class="topic-metadata">

**Author:** [@Sirhc](https://discourse.nodered.org/u/Sirhc)\
**Replies:** 1\
**Last updated:** [19 September 2024 07:37 UTC](https://discourse.nodered.org/t/convert-from-base16-to-base64/91094 "2024-09-19T07:37:29Z")

</div>

hello - is there a feature within nodered that can convert a base16 number to base64?

---

## [Only make node-red accessible from localmachine](https://discourse.nodered.org/t/only-make-node-red-accessible-from-localmachine/91086)

<div class="topic-metadata">

**Author:** [@JePi](https://discourse.nodered.org/u/JePi)\
**Replies:** 4\
**Last updated:** [19 September 2024 06:53 UTC](https://discourse.nodered.org/t/only-make-node-red-accessible-from-localmachine/91086 "2024-09-19T06:53:17Z")

</div>

I run node-red in a container (in raspian) but what I do I cant get it to accept only connection on the localhost. Either its world or its no one. Have tried enable the settings.js row uiHost: "127.0.0.1", but that mak…

---

## [DB2 multi state switch revisited](https://discourse.nodered.org/t/db2-multi-state-switch-revisited/91084)

<div class="topic-metadata">

**Author:** [@gerry](https://discourse.nodered.org/u/gerry)\
**Replies:** 2\
**Last updated:** [19 September 2024 05:32 UTC](https://discourse.nodered.org/t/db2-multi-state-switch-revisited/91084 "2024-09-19T05:32:04Z")

</div>

@BartButenaers and @hotNipi posted some multi state switch code and rather than flog that thread I opened a new one. Modified the code somewhat, consolidated it really but what I would like to do is make it multi line if…

---

## [Running NR on a Mikrotik (docker container)](https://discourse.nodered.org/t/running-nr-on-a-mikrotik-docker-container/91087)

<div class="topic-metadata">

**Author:** [@GiovanniG](https://discourse.nodered.org/u/GiovanniG)\
**Replies:** 1\
**Last updated:** [18 September 2024 21:54 UTC](https://discourse.nodered.org/t/running-nr-on-a-mikrotik-docker-container/91087 "2024-09-18T21:54:28Z")

</div>

Hi, I need to create some automations and I would love to use NR for them, running inside a MIkrotik will give me the chance to don't add external hardware. Yesterday I've created my first CHR Mikrotik on an ubuntu 22 s…

---

## [Date problem with now === stopTime](https://discourse.nodered.org/t/date-problem-with-now-stoptime/91064)

<div class="topic-metadata">

**Author:** [@Frida](https://discourse.nodered.org/u/Frida)\
**Replies:** 10\
**Last updated:** [18 September 2024 21:09 UTC](https://discourse.nodered.org/t/date-problem-with-now-stoptime/91064 "2024-09-18T21:09:29Z")

</div>

Why now.getTime === stopTime.getTime() works, but not now === stopTime? \[{"id":"9d15a9187c914833","type":"tab","label":"Flow 12","disabled":false,"info":"","env":\[\]},{"id":"c43a8169fed4b72e","type":"junction","z":"9…

---

## [What do you think about bundling flows?](https://discourse.nodered.org/t/what-do-you-think-about-bundling-flows/91081)

<div class="topic-metadata">

**Author:** [@AllanOricil](https://discourse.nodered.org/u/AllanOricil)\
**Replies:** 4\
**Last updated:** [18 September 2024 20:50 UTC](https://discourse.nodered.org/t/what-do-you-think-about-bundling-flows/91081 "2024-09-18T20:50:49Z")

</div>

I've been thinking about it for a week now. What if I scan a flow.json, get all node types, find their nodes, and then build a single bundled dependency which has all nodes required to run that flow? It is going to feel …

---

## [Information security for internal project](https://discourse.nodered.org/t/information-security-for-internal-project/91075)

<div class="topic-metadata">

**Author:** [@andrepereira](https://discourse.nodered.org/u/andrepereira)\
**Replies:** 1\
**Last updated:** [18 September 2024 15:43 UTC](https://discourse.nodered.org/t/information-security-for-internal-project/91075 "2024-09-18T15:43:30Z")

</div>

Hello, I am suggesting a project and our information security team did not find information to support the release of the node-red installation, I want to install it on an internal Windows server for processing MQTT data…

---

## [Debug nodes are not in debug window](https://discourse.nodered.org/t/debug-nodes-are-not-in-debug-window/91062)

<div class="topic-metadata">

**Author:** [@KRR](https://discourse.nodered.org/u/KRR)\
**Replies:** 8\
**Last updated:** [18 September 2024 11:51 UTC](https://discourse.nodered.org/t/debug-nodes-are-not-in-debug-window/91062 "2024-09-18T11:51:06Z")

</div>

Hi together, since installation of 4.0.2 and Node.Js 22 i got a unusual problem with debug window. I trigger my flows with two "http in" Nodes. They are only differ in the url. The flows after the "http in" nodes are th…

---

## [Change "null" to "0" in an array](https://discourse.nodered.org/t/change-null-to-0-in-an-array/91054)

<div class="topic-metadata">

**Author:** [@Becker](https://discourse.nodered.org/u/Becker)\
**Replies:** 5\
**Last updated:** [18 September 2024 07:39 UTC](https://discourse.nodered.org/t/change-null-to-0-in-an-array/91054 "2024-09-18T07:39:36Z")

</div>

Hi, I´ve an big array like this: \[{"from":"2024-09-16T22:00:00.000+02:00","cost":0.0014874048,"unitPrice":0.2479008,"consumption":0.006},{"from":"2024-09-16T23:00:00.000+02:00","cost":0.001255688,"unitPrice":0.2511376,"…

---

## [Extract point value using change node](https://discourse.nodered.org/t/extract-point-value-using-change-node/90801)

<div class="topic-metadata">

**Author:** [@bobster1](https://discourse.nodered.org/u/bobster1)\
**Replies:** 6\
**Last updated:** [18 September 2024 06:31 UTC](https://discourse.nodered.org/t/extract-point-value-using-change-node/90801 "2024-09-18T06:31:23Z")

</div>

hi all, As subject and as follows .. Tried all sorts of things but i am stuck. Any tips .. or help appreciated. thx

---

## [Significant Rainfall Event SRE](https://discourse.nodered.org/t/significant-rainfall-event-sre/91052)

<div class="topic-metadata">

**Author:** [@abhmeh](https://discourse.nodered.org/u/abhmeh)\
**Replies:** 9\
**Last updated:** [17 September 2024 21:42 UTC](https://discourse.nodered.org/t/significant-rainfall-event-sre/91052 "2024-09-17T21:42:17Z")

</div>

Hi All, I am developing a application that detects a significant rainfall event every 24 hours SRE Definition: Rainfall \>= 25 mm in 24 hr I am using open microsoft to get ranifall data for last 24 hours After a SRE …

---

## [@iiot2k/node-red-gpiox / Raspberry Pi / "chip error"](https://discourse.nodered.org/t/iiot2k-node-red-gpiox-raspberry-pi-chip-error/91055)

<div class="topic-metadata">

**Author:** [@irotier](https://discourse.nodered.org/u/irotier)\
**Replies:** 3\
**Last updated:** [17 September 2024 20:48 UTC](https://discourse.nodered.org/t/iiot2k-node-red-gpiox-raspberry-pi-chip-error/91055 "2024-09-17T20:48:58Z")

</div>

I'm runnning Node-red on a Raspberry Pi 3b+ in 64 bit (Python 3.11.2). Because i have flickering in my LEDs with the onboard gpio-pwm-node, i tried node-red-gpiox by iiot2k. The Node worked perfectly fine, but as i playe…

---

## [Send wav file using udp node](https://discourse.nodered.org/t/send-wav-file-using-udp-node/91030)

<div class="topic-metadata">

**Author:** [@azxo1](https://discourse.nodered.org/u/azxo1)\
**Replies:** 8\
**Last updated:** [16 September 2024 20:22 UTC](https://discourse.nodered.org/t/send-wav-file-using-udp-node/91030 "2024-09-16T20:22:41Z")

</div>

Hello everyone! So I have a wav file that I want to send via udp. How can it be? Thank you very much for the answers! I'm trying this, but it doesn't work: \[{"id":"6e4886616b135e02","type":"inject","z":"f41a27cc00143f0…

---

## [Add mysql node via package.json but node-red doesnt load it](https://discourse.nodered.org/t/add-mysql-node-via-package-json-but-node-red-doesnt-load-it/91040)

<div class="topic-metadata">

**Author:** [@JePi](https://discourse.nodered.org/u/JePi)\
**Replies:** 1\
**Last updated:** [17 September 2024 12:30 UTC](https://discourse.nodered.org/t/add-mysql-node-via-package-json-but-node-red-doesnt-load-it/91040 "2024-09-17T12:30:32Z")

</div>

Add mysql node via package.json but node-red doesnt load it. But If enter the container and run npm install node-red-node-mysql it installs it and it works. But if restart the container its gone . Running Node-red in co…

---

## [How can I get the current state of my device?](https://discourse.nodered.org/t/how-can-i-get-the-current-state-of-my-device/91015)

<div class="topic-metadata">

**Author:** [@hogka](https://discourse.nodered.org/u/hogka)\
**Replies:** 8\
**Last updated:** [17 September 2024 09:39 UTC](https://discourse.nodered.org/t/how-can-i-get-the-current-state-of-my-device/91015 "2024-09-17T09:39:37Z")

</div>

Hello everyone! I'm kinda new to Node Red and I'm facing some issues, so I hope somebody more experienced than me can help me. The thing is I'm trying to get the current state of my LoRa device using a GET HTTP in node…

---

## [Updated to NR 3, now getting errors](https://discourse.nodered.org/t/updated-to-nr-3-now-getting-errors/91031)

<div class="topic-metadata">

**Author:** [@daxliniere](https://discourse.nodered.org/u/daxliniere)\
**Replies:** 5\
**Last updated:** [16 September 2024 20:25 UTC](https://discourse.nodered.org/t/updated-to-nr-3-now-getting-errors/91031 "2024-09-16T20:25:15Z")

</div>

Hey gang, I recently updated to NR v3 and now one of my function nodes is throwing the error "TypeError: msg.payload\[0\].filter is not a function" This is processing the output of the Unifi node which is generating a li…

---

## [RequestError: connect ECONNREFUSED , Get Request](https://discourse.nodered.org/t/requesterror-connect-econnrefused-get-request/91019)

<div class="topic-metadata">

**Author:** [@Lorry\_96](https://discourse.nodered.org/u/Lorry_96)\
**Replies:** 5\
**Last updated:** [16 September 2024 16:07 UTC](https://discourse.nodered.org/t/requesterror-connect-econnrefused-get-request/91019 "2024-09-16T16:07:07Z")

</div>

Hi, I'm having an issue with https get request ; error "RequestError: connect ECONNREFUSED " . Anyone has an idea about this?

---

## [Node-red-contrib-redis, help with JSON.set and argument format](https://discourse.nodered.org/t/node-red-contrib-redis-help-with-json-set-and-argument-format/90920)

<div class="topic-metadata">

**Author:** [@HarryPottar](https://discourse.nodered.org/u/HarryPottar)\
**Replies:** 2\
**Last updated:** [16 September 2024 16:04 UTC](https://discourse.nodered.org/t/node-red-contrib-redis-help-with-json-set-and-argument-format/90920 "2024-09-16T16:04:18Z")

</div>

Hello, This is the module I'm I'm using I'm familiar with Redis and have successfully set up Publish and Subscribe workflows. Also, I successfully set up LPUSH and RPOPLPUSH workflows. By default, Redis stores inform…

---

## [I am receiving MQTT messages from a device that is not powered on](https://discourse.nodered.org/t/i-am-receiving-mqtt-messages-from-a-device-that-is-not-powered-on/90929)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 45\
**Last updated:** [16 September 2024 14:08 UTC](https://discourse.nodered.org/t/i-am-receiving-mqtt-messages-from-a-device-that-is-not-powered-on/90929 "2024-09-16T14:08:23Z")

</div>

Sorry, but this has thrown me. Usually I have a thing happen daily. It works. Or maybe more correctly now: workED! (Past tense) Got home and I had a notification the device was UNKNOWN. Did some testing. Status…

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

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