# General

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

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

**Page:** 333

---

## [Formatting JSON Output](https://discourse.nodered.org/t/formatting-json-output/66730)

<div class="topic-metadata">

**Author:** [@Mick](https://discourse.nodered.org/u/Mick)\
**Replies:** 12\
**Last updated:** [22 August 2022 17:37 UTC](https://discourse.nodered.org/t/formatting-json-output/66730 "2022-08-22T17:37:20Z")

</div>

I have written a function to regex parse data and I am trying to get it to properly format the output to a global. I am seeing an extra object that I am can't determine where it is coming from. The current output appe…

---

## [The \`Instruction\` (Help?) option on nodes and a slight \*annoyance\*](https://discourse.nodered.org/t/the-instruction-help-option-on-nodes-and-a-slight-annoyance/66749)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 3\
**Last updated:** [22 August 2022 15:32 UTC](https://discourse.nodered.org/t/the-instruction-help-option-on-nodes-and-a-slight-annoyance/66749 "2022-08-22T15:32:22Z")

</div>

If you are using new nodes and have their Ctl g h page open to see the options. You then click on a function node (or other node to change the message) the Help screen changes to that node. I get it.... that is the s…

---

## [Developing node-red standalone applications (Extra unanted user dir creation on app execution)](https://discourse.nodered.org/t/developing-node-red-standalone-applications-extra-unanted-user-dir-creation-on-app-execution/66659)

<div class="topic-metadata">

**Author:** [@fathom](https://discourse.nodered.org/u/fathom)\
**Replies:** 3\
**Last updated:** [22 August 2022 08:52 UTC](https://discourse.nodered.org/t/developing-node-red-standalone-applications-extra-unanted-user-dir-creation-on-app-execution/66659 "2022-08-22T08:52:00Z")

</div>

I have been working on node-red projects for past 7 months and now trying to make a node js based web app with node-red at its backend embedded within the project. Steps I fallowed while making this application. Made …

---

## [How to update SQL query with an identifier has 2 strings](https://discourse.nodered.org/t/how-to-update-sql-query-with-an-identifier-has-2-strings/66647)

<div class="topic-metadata">

**Author:** [@Kimo](https://discourse.nodered.org/u/Kimo)\
**Replies:** 10\
**Last updated:** [22 August 2022 08:14 UTC](https://discourse.nodered.org/t/how-to-update-sql-query-with-an-identifier-has-2-strings/66647 "2022-08-22T08:14:39Z")

</div>

Hi. Anyone knows here is it possible if we can update sql table where the query with an id has 2 strings. The result I got is only A2 string is taken as identifier thus row contains id A1 is not updated.

---

## [Gosund SP112 energy monitoring smart plugs](https://discourse.nodered.org/t/gosund-sp112-energy-monitoring-smart-plugs/66740)

<div class="topic-metadata">

**Author:** [@Thewaver](https://discourse.nodered.org/u/Thewaver)\
**Replies:** 1\
**Last updated:** [22 August 2022 08:10 UTC](https://discourse.nodered.org/t/gosund-sp112-energy-monitoring-smart-plugs/66740 "2022-08-22T08:10:18Z")

</div>

Hi, I have bought some Gosund SP112 enegy monitoring plugs and want to control them via the node red tuya-smart-device-node. I have spent a few days searching the web but no matter what I try I cant get them to simply tu…

---

## [Hardware PWM Node-Red](https://discourse.nodered.org/t/hardware-pwm-node-red/66733)

<div class="topic-metadata">

**Author:** [@Sleep](https://discourse.nodered.org/u/Sleep)\
**Replies:** 8\
**Last updated:** [21 August 2022 21:56 UTC](https://discourse.nodered.org/t/hardware-pwm-node-red/66733 "2022-08-21T21:56:34Z")

</div>

Hi I'm looking for a way to use fully hardware PWM on my RPi Zero. I want to control a PWM fan requiring 28 kHz. The GPIO PWM nodes are software only (?). Does anyone have a script to control the PWM signal through r…

---

## [Bulk Rename files via ftp](https://discourse.nodered.org/t/bulk-rename-files-via-ftp/66701)

<div class="topic-metadata">

**Author:** [@smitterer](https://discourse.nodered.org/u/smitterer)\
**Replies:** 4\
**Last updated:** [21 August 2022 20:18 UTC](https://discourse.nodered.org/t/bulk-rename-files-via-ftp/66701 "2022-08-21T20:18:47Z")

</div>

Hi everyone, I'm try to rename about 250.000 files using node-red. They are stored in a folder called /artikelbilder and need to be renamed and moved to /renamed based on payload\[0\] (current filename) and payload\[1\] (ne…

---

## [Unable to listen ... port in use](https://discourse.nodered.org/t/unable-to-listen-port-in-use/66712)

<div class="topic-metadata">

**Author:** [@rbmgf7](https://discourse.nodered.org/u/rbmgf7)\
**Replies:** 1\
**Last updated:** [21 August 2022 20:15 UTC](https://discourse.nodered.org/t/unable-to-listen-port-in-use/66712 "2022-08-21T20:15:36Z")

</div>

After I managed to get NR running at work on a Windows server, I wanted to try it at home. I had a spare laptop I loaded Ubuntu 22.04 on. I got Mosquitto and NR loaded and running in the beginning but then I had to do a …

---

## [Create array from objects, whilst using names from current objects](https://discourse.nodered.org/t/create-array-from-objects-whilst-using-names-from-current-objects/66719)

<div class="topic-metadata">

**Author:** [@grant1](https://discourse.nodered.org/u/grant1)\
**Replies:** 4\
**Last updated:** [21 August 2022 20:05 UTC](https://discourse.nodered.org/t/create-array-from-objects-whilst-using-names-from-current-objects/66719 "2022-08-21T20:05:45Z")

</div>

Good morning. I have a simple HTTP GET request retrieving metal pricing information for a given date range. Here is the test URL returning the data that I want (3 days for testing purposes) and here is my flow shown be…

---

## [Correct format for extracting name of an object nested within an object using Function Node](https://discourse.nodered.org/t/correct-format-for-extracting-name-of-an-object-nested-within-an-object-using-function-node/66725)

<div class="topic-metadata">

**Author:** [@Purclewan](https://discourse.nodered.org/u/Purclewan)\
**Replies:** 9\
**Last updated:** [21 August 2022 14:20 UTC](https://discourse.nodered.org/t/correct-format-for-extracting-name-of-an-object-nested-within-an-object-using-function-node/66725 "2022-08-21T14:20:29Z")

</div>

Hi, I should know the answer to this but I'm get confused when trying to extract a specific piece of data from a JSON line that has an object containing the data I require nested within an object. To be specific, I have…

---

## [Is there a way to manage flow (tab) versions?](https://discourse.nodered.org/t/is-there-a-way-to-manage-flow-tab-versions/66727)

<div class="topic-metadata">

**Author:** [@omrid](https://discourse.nodered.org/u/omrid)\
**Replies:** 0\
**Last updated:** [21 August 2022 13:23 UTC](https://discourse.nodered.org/t/is-there-a-way-to-manage-flow-tab-versions/66727 "2022-08-21T13:23:03Z")

</div>

Hi, We are running Node-red in dockers (in a wide-scale deployment of over 15 different parallel environments - dev, test, production etc.). We are happy to see Node-red proving stable and performing well. We are facin…

---

## [How to make a cron with node inject](https://discourse.nodered.org/t/how-to-make-a-cron-with-node-inject/66487)

<div class="topic-metadata">

**Author:** [@mykerinos1](https://discourse.nodered.org/u/mykerinos1)\
**Replies:** 18\
**Last updated:** [21 August 2022 11:55 UTC](https://discourse.nodered.org/t/how-to-make-a-cron-with-node-inject/66487 "2022-08-21T11:55:12Z")

</div>

Hllo i'm using inject node to send data every 10 minutes for my chart but i'd prefered to add a cron to send data at specific minutes like 00,10,20,30,40,50 but i don't know hoxw to set it. Can you help me. Thanks

---

## [Error: listen EADDRNOTAVAIL: address not available 1.1.1.1:10502](https://discourse.nodered.org/t/error-listen-eaddrnotavail-address-not-available-1-1-1-1-10502/7627)

<div class="topic-metadata">

**Author:** [@eljuliman](https://discourse.nodered.org/u/eljuliman)\
**Replies:** 29\
**Last updated:** [21 August 2022 11:37 UTC](https://discourse.nodered.org/t/error-listen-eaddrnotavail-address-not-available-1-1-1-1-10502/7627 "2022-08-21T11:37:19Z")

</div>

Hello ! I have been working with modbus node red, and I configured a Server TCP in ip address 1.1.1.1:10502. When I have tried run node-red I have received this message 5 Feb 21:10:07 - Error: listen EADDRNOTAVAIL: add…

---

## [Streaming live audio data via MQTT](https://discourse.nodered.org/t/streaming-live-audio-data-via-mqtt/66602)

<div class="topic-metadata">

**Author:** [@nhiennguyenhuy](https://discourse.nodered.org/u/nhiennguyenhuy)\
**Replies:** 32\
**Last updated:** [21 August 2022 10:15 UTC](https://discourse.nodered.org/t/streaming-live-audio-data-via-mqtt/66602 "2022-08-21T10:15:25Z")

</div>

Hello, I am trying to stream live audio via MQTT in Node-red to Raspberry Pi. For testing microphone and speaker, when I connected them through a "Add WAV headers" (like the below image), the output sound is quite clea…

---

## [Node-red-modbus flex getter does not reconnect](https://discourse.nodered.org/t/node-red-modbus-flex-getter-does-not-reconnect/66708)

<div class="topic-metadata">

**Author:** [@keshavvasudeva](https://discourse.nodered.org/u/keshavvasudeva)\
**Replies:** 1\
**Last updated:** [21 August 2022 09:34 UTC](https://discourse.nodered.org/t/node-red-modbus-flex-getter-does-not-reconnect/66708 "2022-08-21T09:34:39Z")

</div>

Continuing the discussion from Node-red-contrib-modbus no reconnect: I have downgraded to v12.13 as mentioned in the above thread but I am still facing the issue. I have attached a picture of my flow for reference. I a…

---

## [Sftp keeps crashing NR](https://discourse.nodered.org/t/sftp-keeps-crashing-nr/66593)

<div class="topic-metadata">

**Author:** [@edje11](https://discourse.nodered.org/u/edje11)\
**Replies:** 8\
**Last updated:** [21 August 2022 07:46 UTC](https://discourse.nodered.org/t/sftp-keeps-crashing-nr/66593 "2022-08-21T07:46:10Z")

</div>

Hi, node-red-contrib-better-sftp will crash NR 2.2.2. In Better-Sftp LIST is working, but PUT, GET and DELETE will crash NR. In the console is then the error; 8 Aug 11:06:44 - \[red\] Uncaught Exception: 18 Aug 11:06…

---

## [Can't add blank object to array](https://discourse.nodered.org/t/cant-add-blank-object-to-array/66715)

<div class="topic-metadata">

**Author:** [@thefox07](https://discourse.nodered.org/u/thefox07)\
**Replies:** 1\
**Last updated:** [21 August 2022 06:19 UTC](https://discourse.nodered.org/t/cant-add-blank-object-to-array/66715 "2022-08-21T06:19:50Z")

</div>

Hello, The following code works fine in online JS compilers but not in the node-red function node. What am I missing? I inject the following msg.payload: { "domain": "homeassistant", "service": "turn\_on", …

---

## [Using Node Red change set value](https://discourse.nodered.org/t/using-node-red-change-set-value/66625)

<div class="topic-metadata">

**Author:** [@keshavvasudeva](https://discourse.nodered.org/u/keshavvasudeva)\
**Replies:** 7\
**Last updated:** [20 August 2022 20:17 UTC](https://discourse.nodered.org/t/using-node-red-change-set-value/66625 "2022-08-20T20:17:03Z")

</div>

New to node red. Using it to read temperature from solo controllers and wish to change the set value based on a time delay. How can I do this? Would appreciate some assistance with the code as well

---

## [How to set cron plus for a complete payload](https://discourse.nodered.org/t/how-to-set-cron-plus-for-a-complete-payload/66703)

<div class="topic-metadata">

**Author:** [@mykerinos1](https://discourse.nodered.org/u/mykerinos1)\
**Replies:** 1\
**Last updated:** [20 August 2022 18:16 UTC](https://discourse.nodered.org/t/how-to-set-cron-plus-for-a-complete-payload/66703 "2022-08-20T18:16:36Z")

</div>

hello i ve got a http request that allow only one node at the same time.This request is done each second to feed datalive. . i would like to create a second way to use "cron plus " to send complete payload every 10 minut…

---

## [Would a wemo insight have to be polled to act on energy usage changes?](https://discourse.nodered.org/t/would-a-wemo-insight-have-to-be-polled-to-act-on-energy-usage-changes/66671)

<div class="topic-metadata">

**Author:** [@hepcat72](https://discourse.nodered.org/u/hepcat72)\
**Replies:** 6\
**Last updated:** [20 August 2022 15:32 UTC](https://discourse.nodered.org/t/would-a-wemo-insight-have-to-be-polled-to-act-on-energy-usage-changes/66671 "2022-08-20T15:32:24Z")

</div>

...or does a wemo insight node instance on a flow continuously stream usage information? I'm trying to decide between getting a wemo insight versus another Sonoff S31 15A. The Sonoff (flashed with tasmota) can reach out…

---

## [Version v3.0.2 seems not compatible with @particle/node-red-contrib-particle-official 0.1.7](https://discourse.nodered.org/t/version-v3-0-2-seems-not-compatible-with-particle-node-red-contrib-particle-official-0-1-7/66505)

<div class="topic-metadata">

**Author:** [@pacitoali](https://discourse.nodered.org/u/pacitoali)\
**Replies:** 3\
**Last updated:** [20 August 2022 13:37 UTC](https://discourse.nodered.org/t/version-v3-0-2-seems-not-compatible-with-particle-node-red-contrib-particle-official-0-1-7/66505 "2022-08-20T13:37:50Z")

</div>

With version v3.0.2 my NR docker server (node.js v16) stop every 7776 seconds (about 129 minutes), the time for reauthentication. I was able to solve it in two ways: reverting NR to v2.2.2 or changing the res.body.expir…

---

## [NR + MQTT as standalone server - opinions](https://discourse.nodered.org/t/nr-mqtt-as-standalone-server-opinions/64618)

<div class="topic-metadata">

**Author:** [@PizzaProgram](https://discourse.nodered.org/u/PizzaProgram)\
**Replies:** 3\
**Last updated:** [20 August 2022 12:58 UTC](https://discourse.nodered.org/t/nr-mqtt-as-standalone-server-opinions/64618 "2022-08-20T12:58:36Z")

</div>

I've searched everything 3 weeks long, and now I'm here to ask for any opinions or experiense about: What would be the best praktice to run NR + MQTT on a "public" VPS ? The Job: ... would be to handle ca 50 pizzerias b…

---

## [Re-run different nodes at different times](https://discourse.nodered.org/t/re-run-different-nodes-at-different-times/66693)

<div class="topic-metadata">

**Author:** [@mrks1337](https://discourse.nodered.org/u/mrks1337)\
**Replies:** 1\
**Last updated:** [20 August 2022 12:16 UTC](https://discourse.nodered.org/t/re-run-different-nodes-at-different-times/66693 "2022-08-20T12:16:05Z")

</div>

Hi! I have the following Flow created to login with an API and then fetch data from a second endpoint. \[ { "id": "4d1f98b0.642758", "type": "http request", "z": "c155aa476d7d3fe2", "…

---

## [How to insert in a database?](https://discourse.nodered.org/t/how-to-insert-in-a-database/66435)

<div class="topic-metadata">

**Author:** [@mykerinos1](https://discourse.nodered.org/u/mykerinos1)\
**Replies:** 47\
**Last updated:** [20 August 2022 09:48 UTC](https://discourse.nodered.org/t/how-to-insert-in-a-database/66435 "2022-08-20T09:48:14Z")

</div>

Hello, i just created a new database and i'd like to insert data coming from a "http Request "that output is a parsed json object but i d on't know how to doCan you help me insert these data ? i created my sql node and…

---

## [How to set a global var with dynamic index on change node](https://discourse.nodered.org/t/how-to-set-a-global-var-with-dynamic-index-on-change-node/66627)

<div class="topic-metadata">

**Author:** [@VMarques](https://discourse.nodered.org/u/VMarques)\
**Replies:** 3\
**Last updated:** [20 August 2022 00:10 UTC](https://discourse.nodered.org/t/how-to-set-a-global-var-with-dynamic-index-on-change-node/66627 "2022-08-20T00:10:08Z")

</div>

Hi There guys, I am trying to, read a file containing a json string (all fine here), parse the keys and declare global vars with the name from the json, The flow looks like this, Split node loads the var name in …

---

## [How to connect node red at distance?](https://discourse.nodered.org/t/how-to-connect-node-red-at-distance/66537)

<div class="topic-metadata">

**Author:** [@azertym](https://discourse.nodered.org/u/azertym)\
**Replies:** 8\
**Last updated:** [19 August 2022 23:32 UTC](https://discourse.nodered.org/t/how-to-connect-node-red-at-distance/66537 "2022-08-19T23:32:02Z")

</div>

Hi all, I would like to know if it's possible to connect in node red at distance without local ip ? My pi is at 1000 km from me, and i would like to connect at node-red without VNC. The best method for me it's to type…

---

## [Raspberry Pi PLC Analog Read Problem](https://discourse.nodered.org/t/raspberry-pi-plc-analog-read-problem/66677)

<div class="topic-metadata">

**Author:** [@locutus](https://discourse.nodered.org/u/locutus)\
**Replies:** 3\
**Last updated:** [19 August 2022 22:22 UTC](https://discourse.nodered.org/t/raspberry-pi-plc-analog-read-problem/66677 "2022-08-19T22:22:41Z")

</div>

Hey all, completely new to node-red. I'm trying to use the analog read node to read off of an analog pressure sensor on a RPI PLC shield. Right now I'm just connecting 5 V to I0.5 pin (which is the analog/digital input p…

---

## [JSON Sqlite database query .. 2 into 1?](https://discourse.nodered.org/t/json-sqlite-database-query-2-into-1/66673)

<div class="topic-metadata">

**Author:** [@questuk](https://discourse.nodered.org/u/questuk)\
**Replies:** 1\
**Last updated:** [19 August 2022 17:08 UTC](https://discourse.nodered.org/t/json-sqlite-database-query-2-into-1/66673 "2022-08-19T17:08:48Z")

</div>

Hi, Sorry for asking here,but I have tried on a Sqlite forum and so far no answers. :pensive: But I know on here your are knowledgeable and some use JSON and SQlite. I have a JSON SQLite database, at the moment I use …

---

## [Splitting a konstant data stream into 200 sub streams](https://discourse.nodered.org/t/splitting-a-konstant-data-stream-into-200-sub-streams/66665)

<div class="topic-metadata">

**Author:** [@edstobi](https://discourse.nodered.org/u/edstobi)\
**Replies:** 2\
**Last updated:** [19 August 2022 13:35 UTC](https://discourse.nodered.org/t/splitting-a-konstant-data-stream-into-200-sub-streams/66665 "2022-08-19T13:35:19Z")

</div>

hello i am turning to you again today as i need an idea on how to implement a flow reasonably, briefly and efficiently. I get a constant stream of values via a single function. This is several hundred a minute, but th…

---

## [Run as service from c++ program](https://discourse.nodered.org/t/run-as-service-from-c-program/66653)

<div class="topic-metadata">

**Author:** [@Lupin\_III](https://discourse.nodered.org/u/Lupin_III)\
**Replies:** 6\
**Last updated:** [19 August 2022 13:24 UTC](https://discourse.nodered.org/t/run-as-service-from-c-program/66653 "2022-08-19T13:24:26Z")

</div>

Hi, I'm facing this problem, even if I know it isn't strictly related with node-red itself. I have installed node-red on debian with the raccomanded script, so I can run it as service. My problem is that I don't have t…

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

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