# General

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

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

**Page:** 258

---

## [MYSQL2 - Dynamic info - Open or Closed Sessions?](https://discourse.nodered.org/t/mysql2-dynamic-info-open-or-closed-sessions/73934)

<div class="topic-metadata">

**Author:** [@allacmc](https://discourse.nodered.org/u/allacmc)\
**Replies:** 13\
**Last updated:** [26 January 2023 13:36 UTC](https://discourse.nodered.org/t/mysql2-dynamic-info-open-or-closed-sessions/73934 "2023-01-26T13:36:08Z")

</div>

I've recently been on a mission to make a system where the implementation of the system won't be mine. It will be a third-party team. So I need to make a system that will be configured by someone else. In this case, I…

---

## [Bunching mqtt data before passing to next node](https://discourse.nodered.org/t/bunching-mqtt-data-before-passing-to-next-node/74208)

<div class="topic-metadata">

**Author:** [@Leo](https://discourse.nodered.org/u/Leo)\
**Replies:** 8\
**Last updated:** [26 January 2023 13:26 UTC](https://discourse.nodered.org/t/bunching-mqtt-data-before-passing-to-next-node/74208 "2023-01-26T13:26:10Z")

</div>

Hi there, I have an mqtt in node that receives every second a value which is send into a function node. Now I want to get 60 values (every minute) from the mqtt, average them and only send the average to an influx data…

---

## [Checking number encoding?](https://discourse.nodered.org/t/checking-number-encoding/74181)

<div class="topic-metadata">

**Author:** [@Dyslexicbloke](https://discourse.nodered.org/u/Dyslexicbloke)\
**Replies:** 7\
**Last updated:** [26 January 2023 11:31 UTC](https://discourse.nodered.org/t/checking-number-encoding/74181 "2023-01-26T11:31:59Z")

</div>

Hi folks, I have been messing with Modbus coms and have it working now. However I am using buffer objects to change between number formats and realised I don't know how to check what format a number in node red actuall…

---

## [How to parse message parts to variables](https://discourse.nodered.org/t/how-to-parse-message-parts-to-variables/74192)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 23\
**Last updated:** [26 January 2023 11:31 UTC](https://discourse.nodered.org/t/how-to-parse-message-parts-to-variables/74192 "2023-01-26T11:31:08Z")

</div>

Sorry folks, I'm stuck again. Story: I have a message (with a LOT of extra stuff added on to save me using flow context.) and want to use one part to point to another part of the message. eg: So: msg.payload.who …

---

## [String to json array](https://discourse.nodered.org/t/string-to-json-array/74206)

<div class="topic-metadata">

**Author:** [@sahar](https://discourse.nodered.org/u/sahar)\
**Replies:** 9\
**Last updated:** [26 January 2023 11:17 UTC](https://discourse.nodered.org/t/string-to-json-array/74206 "2023-01-26T11:17:29Z")

</div>

hi , I need help again at node red , I have this string at msg.payload (receive from data base as json) "{"id":"2","sensor":"DHT11","value1":"26.20","location":"Office"}{"id":"3","sensor":"DHT11","value1":"26.10","locat…

---

## [Italy:Come Leggere più varabili in OpcUa / English: How to Read multiple variables in OpcUa](https://discourse.nodered.org/t/italy-come-leggere-piu-varabili-in-opcua-english-how-to-read-multiple-variables-in-opcua/72901)

<div class="topic-metadata">

**Author:** [@ahmedt04](https://discourse.nodered.org/u/ahmedt04)\
**Replies:** 1\
**Last updated:** [26 January 2023 09:59 UTC](https://discourse.nodered.org/t/italy-come-leggere-piu-varabili-in-opcua-english-how-to-read-multiple-variables-in-opcua/72901 "2023-01-26T09:59:36Z")

</div>

Italy: ciao, Devo leggere delle variabili tramite Opc Ua ma le variabili sono tante come faccio a leggerle usando pochi nodi? grazie. English: Hello, I have to read some variables through OpcUa but there are so many …

---

## [Trigger node - how to delay and repeat message?](https://discourse.nodered.org/t/trigger-node-how-to-delay-and-repeat-message/74117)

<div class="topic-metadata">

**Author:** [@OliverWieland](https://discourse.nodered.org/u/OliverWieland)\
**Replies:** 17\
**Last updated:** [26 January 2023 09:44 UTC](https://discourse.nodered.org/t/trigger-node-how-to-delay-and-repeat-message/74117 "2023-01-26T09:44:08Z")

</div>

Hi! I want to set a trigger node to do the following: On message do nothing Send the received message every 10 seconds, until the reset criteria is fulfilled. So I set "Send" to "nothing" and "then" to "resend it eve…

---

## [Remove palette option missing!](https://discourse.nodered.org/t/remove-palette-option-missing/74187)

<div class="topic-metadata">

**Author:** [@e-labInnovations](https://discourse.nodered.org/u/e-labInnovations)\
**Replies:** 4\
**Last updated:** [26 January 2023 09:03 UTC](https://discourse.nodered.org/t/remove-palette-option-missing/74187 "2023-01-26T09:03:05Z")

</div>

When I use Storage API (storageModule) for using a PostgreSQL database, I lose the option to remove the palette. How to get the remove the palette option?

---

## [Display remaining trigger flow time and extend trigger time](https://discourse.nodered.org/t/display-remaining-trigger-flow-time-and-extend-trigger-time/74179)

<div class="topic-metadata">

**Author:** [@tmollow](https://discourse.nodered.org/u/tmollow)\
**Replies:** 2\
**Last updated:** [26 January 2023 08:35 UTC](https://discourse.nodered.org/t/display-remaining-trigger-flow-time-and-extend-trigger-time/74179 "2023-01-26T08:35:30Z")

</div>

A small electric heater is to be controlled with Node-Red. A gate flow is used and the runtime is controlled via a trigger node. I am still missing 2 properties: The trigger is controlled via a button and then runs fo…

---

## [Html node output not what I expect](https://discourse.nodered.org/t/html-node-output-not-what-i-expect/74195)

<div class="topic-metadata">

**Author:** [@gerry](https://discourse.nodered.org/u/gerry)\
**Replies:** 1\
**Last updated:** [26 January 2023 01:50 UTC](https://discourse.nodered.org/t/html-node-output-not-what-i-expect/74195 "2023-01-26T01:50:59Z")

</div>

On another Pi this flow and node were working as expected. Of course not willing to leave it alone I traded out the Pi for another one and reloaded the flow. Now, instead of an output I get an empty array. Color me baffl…

---

## [Noob Q: What's the code to access this data?](https://discourse.nodered.org/t/noob-q-whats-the-code-to-access-this-data/74067)

<div class="topic-metadata">

**Author:** [@bacontexas](https://discourse.nodered.org/u/bacontexas)\
**Replies:** 6\
**Last updated:** [26 January 2023 00:53 UTC](https://discourse.nodered.org/t/noob-q-whats-the-code-to-access-this-data/74067 "2023-01-26T00:53:16Z")

</div>

I'm a Java noob and I have spent an hour googling to try to figure out how I access the value 125.5 in a payload represented below. I tried payload.solar\_power.value and payload.solar\_power\['value'\] but no luck. I don'…

---

## [Mqtt client's connect behavior when pub/sub to an unauthorized topic](https://discourse.nodered.org/t/mqtt-clients-connect-behavior-when-pub-sub-to-an-unauthorized-topic/74183)

<div class="topic-metadata">

**Author:** [@arlklauss](https://discourse.nodered.org/u/arlklauss)\
**Replies:** 10\
**Last updated:** [25 January 2023 20:21 UTC](https://discourse.nodered.org/t/mqtt-clients-connect-behavior-when-pub-sub-to-an-unauthorized-topic/74183 "2023-01-25T20:21:28Z")

</div>

Hello all! We are working on a setup where the mqtt broker (vernemq) authorizes the user/client\_id on publishing/subscribing certain topics (using broker's ACL). When the topic does not exist in the ACL or the user/cli…

---

## ["Hidden" subflows](https://discourse.nodered.org/t/hidden-subflows/74173)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 2\
**Last updated:** [25 January 2023 19:30 UTC](https://discourse.nodered.org/t/hidden-subflows/74173 "2023-01-25T19:30:49Z")

</div>

Ok, I asked for it. Nesting subflows - maybe. I made a subflow with 3 levels (or was it 4?) of other subflows. I exported it and imported it to a working machine. (Bad things happened) Suddenly I have 2 subflows wi…

---

## [Passing Data from Node-Red to a Node.js Script](https://discourse.nodered.org/t/passing-data-from-node-red-to-a-node-js-script/73763)

<div class="topic-metadata">

**Author:** [@psalibe](https://discourse.nodered.org/u/psalibe)\
**Replies:** 6\
**Last updated:** [25 January 2023 18:05 UTC](https://discourse.nodered.org/t/passing-data-from-node-red-to-a-node-js-script/73763 "2023-01-25T18:05:46Z")

</div>

Hi All, Our Node-Red application is getting rather large and becoming hard to scale. In short, we pull data from a PLC using an OPC database, parse them out, and then send them do a cloud platform and have been slowly i…

---

## [adminAuth question for multiple installs using same hash-pw string](https://discourse.nodered.org/t/adminauth-question-for-multiple-installs-using-same-hash-pw-string/74184)

<div class="topic-metadata">

**Author:** [@tree-frog](https://discourse.nodered.org/u/tree-frog)\
**Replies:** 1\
**Last updated:** [25 January 2023 18:05 UTC](https://discourse.nodered.org/t/adminauth-question-for-multiple-installs-using-same-hash-pw-string/74184 "2023-01-25T18:05:17Z")

</div>

Dear Sirs: I am loading different machines in Windows 10 with Node-RED, and most likely running not the same version of Node-RED (worst case scenario). If I use my desktop Windows 10 to "hash-pw" and get this code for …

---

## [SQL data return array data types? MSSQL Node](https://discourse.nodered.org/t/sql-data-return-array-data-types-mssql-node/72157)

<div class="topic-metadata">

**Author:** [@martinav](https://discourse.nodered.org/u/martinav)\
**Replies:** 16\
**Last updated:** [25 January 2023 15:14 UTC](https://discourse.nodered.org/t/sql-data-return-array-data-types-mssql-node/72157 "2023-01-25T15:14:21Z")

</div>

I have successfully accessed a table from an MSSQL node, but the data my query returns is not coming importing into an array of proper datatype. The VR1148 data fails because its not an integer? Well, how do I initi…

---

## [Worldmap marker icon alignment](https://discourse.nodered.org/t/worldmap-marker-icon-alignment/74156)

<div class="topic-metadata">

**Author:** [@rmwiseman](https://discourse.nodered.org/u/rmwiseman)\
**Replies:** 9\
**Last updated:** [25 January 2023 12:06 UTC](https://discourse.nodered.org/t/worldmap-marker-icon-alignment/74156 "2023-01-25T12:06:29Z")

</div>

Built-in markers seems to be aligned so that they point to their location, but is there a way of specifying which part of an icon should be at the precise location of the marker? Some image icons might need to be centre…

---

## [parse part of http request](https://discourse.nodered.org/t/parse-part-of-http-request/74164)

<div class="topic-metadata">

**Author:** [@SinizowN](https://discourse.nodered.org/u/SinizowN)\
**Replies:** 3\
**Last updated:** [25 January 2023 11:59 UTC](https://discourse.nodered.org/t/parse-part-of-http-request/74164 "2023-01-25T11:59:59Z")

</div>

Hello, I receive an HTTP request from a plate reading camera which contains a whole series of information but only the plate number interests me. The path is req.files\[0\].buffer It's give are raw data and when i cl…

---

## [MQTT problems with Node-RED on macOS 13.2](https://discourse.nodered.org/t/mqtt-problems-with-node-red-on-macos-13-2/74126)

<div class="topic-metadata">

**Author:** [@duaw](https://discourse.nodered.org/u/duaw)\
**Replies:** 6\
**Last updated:** [25 January 2023 11:38 UTC](https://discourse.nodered.org/t/mqtt-problems-with-node-red-on-macos-13-2/74126 "2023-01-25T11:38:42Z")

</div>

Dear all! I have an instance of the latest Node-RED Version: v3.0.2 with Node.js Version: v19.4.0 running on my M1 MacBook Pro with Darwin 22.3.0 arm64 LE just to try out things from time to time. It used to work like …

---

## [Send Trigger via Shortcut from iPhone without wifi](https://discourse.nodered.org/t/send-trigger-via-shortcut-from-iphone-without-wifi/73953)

<div class="topic-metadata">

**Author:** [@klopo36](https://discourse.nodered.org/u/klopo36)\
**Replies:** 12\
**Last updated:** [25 January 2023 10:17 UTC](https://discourse.nodered.org/t/send-trigger-via-shortcut-from-iphone-without-wifi/73953 "2023-01-25T10:17:52Z")

</div>

Hello, I want to trigger a flow in node-red just by pressing a shortcut on my iphone. But the problem is that it is supposed to work even without wifi. My hope is that I can somehow manage it with the Telegram Bot. B…

---

## [Subflows within subflows - just asking](https://discourse.nodered.org/t/subflows-within-subflows-just-asking/74147)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 8\
**Last updated:** [25 January 2023 10:10 UTC](https://discourse.nodered.org/t/subflows-within-subflows-just-asking/74147 "2023-01-25T10:10:43Z")

</div>

I am just thinking and this question came up: Ok, a subflow is a specific grouping of nodes that do something and have been put into a subflow because it is used a lot of times in different places. So is it good practi…

---

## [How to add some element in msg payload object](https://discourse.nodered.org/t/how-to-add-some-element-in-msg-payload-object/74163)

<div class="topic-metadata">

**Author:** [@nit-cyber](https://discourse.nodered.org/u/nit-cyber)\
**Replies:** 0\
**Last updated:** [25 January 2023 09:23 UTC](https://discourse.nodered.org/t/how-to-add-some-element-in-msg-payload-object/74163 "2023-01-25T09:23:42Z")

</div>

In my msg.payload i have id and description but 'a' is not there it is in different payload how to join them and generate csv

---

## [How to compare 2 or 3 input by node inject or numbers](https://discourse.nodered.org/t/how-to-compare-2-or-3-input-by-node-inject-or-numbers/74160)

<div class="topic-metadata">

**Author:** [@issambfs1](https://discourse.nodered.org/u/issambfs1)\
**Replies:** 4\
**Last updated:** [25 January 2023 09:20 UTC](https://discourse.nodered.org/t/how-to-compare-2-or-3-input-by-node-inject-or-numbers/74160 "2023-01-25T09:20:25Z")

</div>

how to compare 2 or 3 input by node inject or numbers {node red v3.0.2}

---

## [Check if message.status.text exists](https://discourse.nodered.org/t/check-if-message-status-text-exists/74155)

<div class="topic-metadata">

**Author:** [@FeliceM](https://discourse.nodered.org/u/FeliceM)\
**Replies:** 8\
**Last updated:** [25 January 2023 07:41 UTC](https://discourse.nodered.org/t/check-if-message-status-text-exists/74155 "2023-01-25T07:41:37Z")

</div>

Hi, I am using a status node to check if an exec is running. If the exec is started or killed the status is known. However if the exec has not been started or killed, the message.status.text doesn't exist and then I ge…

---

## [Help with weird messages in the wrong place](https://discourse.nodered.org/t/help-with-weird-messages-in-the-wrong-place/74150)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 2\
**Last updated:** [25 January 2023 06:55 UTC](https://discourse.nodered.org/t/help-with-weird-messages-in-the-wrong-place/74150 "2023-01-25T06:55:57Z")

</div>

I had the code and so decided to put it in a subflow. Ok: It isn't perfect. (There: I said it.) :wink: But I am not getting what is going on. This is the crux of it, and here's how it is supposed to work: Online…

---

## [Subflows, putting $env variable names into fields of \`switch\` node](https://discourse.nodered.org/t/subflows-putting-env-variable-names-into-fields-of-switch-node/74148)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 0\
**Last updated:** [25 January 2023 03:11 UTC](https://discourse.nodered.org/t/subflows-putting-env-variable-names-into-fields-of-switch-node/74148 "2023-01-25T03:11:16Z")

</div>

Today's problem: Subflow. $env variable used to make it usable on multiple devices. Because subflows are limited to 1 input, I am putting a switch node just inside the subflow to direct traffic messages as needed. S…

---

## [HTML editor @Totallyinformation mentioned](https://discourse.nodered.org/t/html-editor-totallyinformation-mentioned/74141)

<div class="topic-metadata">

**Author:** [@gerry](https://discourse.nodered.org/u/gerry)\
**Replies:** 1\
**Last updated:** [24 January 2023 23:21 UTC](https://discourse.nodered.org/t/html-editor-totallyinformation-mentioned/74141 "2023-01-24T23:21:30Z")

</div>

somewhere in here I read @TotallyInformation was looking at a couple of github editors. By the time I could get back home I am now unable to find the post he mentioned them in. There were two. Any chance someone remember…

---

## [Send multiple data in a single message](https://discourse.nodered.org/t/send-multiple-data-in-a-single-message/74138)

<div class="topic-metadata">

**Author:** [@fsaavedra](https://discourse.nodered.org/u/fsaavedra)\
**Replies:** 2\
**Last updated:** [24 January 2023 22:38 UTC](https://discourse.nodered.org/t/send-multiple-data-in-a-single-message/74138 "2023-01-24T22:38:02Z")

</div>

Hi everyone!! I hope you are very well! I have the following problem, I am receiving data via modbus in array, but I need the transformed value. The problem is that I am dividing the message into parts to be able to c…

---

## [statusCode 403 from https://www.volvocars.com/uk/support/downloads/maps/spa/europe](https://discourse.nodered.org/t/statuscode-403-from-https-www-volvocars-com-uk-support-downloads-maps-spa-europe/73499)

<div class="topic-metadata">

**Author:** [@acaminiti](https://discourse.nodered.org/u/acaminiti)\
**Replies:** 7\
**Last updated:** [24 January 2023 21:54 UTC](https://discourse.nodered.org/t/statuscode-403-from-https-www-volvocars-com-uk-support-downloads-maps-spa-europe/73499 "2023-01-24T21:54:34Z")

</div>

Hi! I made a flow to check if there is a new version of maps from: At the beginning, flow work as expected. I was able to get the payload from the page and check the new version. But one day, it "stopped working" and …

---

## [Beginner - How to after splitting an array](https://discourse.nodered.org/t/beginner-how-to-after-splitting-an-array/73992)

<div class="topic-metadata">

**Author:** [@IanH1](https://discourse.nodered.org/u/IanH1)\
**Replies:** 12\
**Last updated:** [24 January 2023 20:06 UTC](https://discourse.nodered.org/t/beginner-how-to-after-splitting-an-array/73992 "2023-01-24T20:06:56Z")

</div>

Hi all. Quick background - i have connected a modbus interface to give me 16 digital ins. Its all working and reporting binary true/false in a 0-15 array. I've also managed to use the split node to split it down into se…

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

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