# General

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

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

**Page:** 283

---

## [Call service data number](https://discourse.nodered.org/t/call-service-data-number/71772)

<div class="topic-metadata">

**Author:** [@dowermyr](https://discourse.nodered.org/u/dowermyr)\
**Replies:** 1\
**Last updated:** [6 December 2022 15:16 UTC](https://discourse.nodered.org/t/call-service-data-number/71772 "2022-12-06T15:16:38Z")

</div>

Hi! How do I set the payload to a data value number? Se below:

---

## [Conditional iptus for data from MQTT to inserst into a new database table](https://discourse.nodered.org/t/conditional-iptus-for-data-from-mqtt-to-inserst-into-a-new-database-table/71766)

<div class="topic-metadata">

**Author:** [@Deh89](https://discourse.nodered.org/u/Deh89)\
**Replies:** 1\
**Last updated:** [6 December 2022 14:50 UTC](https://discourse.nodered.org/t/conditional-iptus-for-data-from-mqtt-to-inserst-into-a-new-database-table/71766 "2022-12-06T14:50:15Z")

</div>

Hello community members, I'm not familiar with Node Red and javascript but I decided to start this challenge. I want to collect data from a MQTT and insert the data into a new posgresql database. This data has this st…

---

## [Problem connected MySQL](https://discourse.nodered.org/t/problem-connected-mysql/71729)

<div class="topic-metadata">

**Author:** [@Misiek](https://discourse.nodered.org/u/Misiek)\
**Replies:** 1\
**Last updated:** [6 December 2022 14:10 UTC](https://discourse.nodered.org/t/problem-connected-mysql/71729 "2022-12-06T14:10:18Z")

</div>

I have problem connected with my database server I use QNAP storage My Node Red installed in Docker MariaDb in sytem Qnap How config my flow mysql - IP adress my flow answer me --\> Error: connect ECONNREFUSED 127.…

---

## [Advice on how to approach my use case](https://discourse.nodered.org/t/advice-on-how-to-approach-my-use-case/71727)

<div class="topic-metadata">

**Author:** [@TomkinsG](https://discourse.nodered.org/u/TomkinsG)\
**Replies:** 4\
**Last updated:** [6 December 2022 13:47 UTC](https://discourse.nodered.org/t/advice-on-how-to-approach-my-use-case/71727 "2022-12-06T13:47:47Z")

</div>

I am working on a project with n (n is approx 9 in this case) wood working tools in a woodshop where each of them has a vacuum hose to suck away the sawdust. There is a central vacuum where the pipes return to through a…

---

## [JSON objects not importing into influxDB](https://discourse.nodered.org/t/json-objects-not-importing-into-influxdb/70784)

<div class="topic-metadata">

**Author:** [@Jimdowding](https://discourse.nodered.org/u/Jimdowding)\
**Replies:** 10\
**Last updated:** [6 December 2022 10:58 UTC](https://discourse.nodered.org/t/json-objects-not-importing-into-influxdb/70784 "2022-12-06T10:58:32Z")

</div>

Hi All, Super new here and new to node red (and influxDB and all coding as well) so sorry if this issue is simple. firstly I'm using node red and influx DB set up on a raspberry pi zero 2 in Docker containers. My data…

---

## [How to send mqtt to turn on a Shelly 1 device](https://discourse.nodered.org/t/how-to-send-mqtt-to-turn-on-a-shelly-1-device/71718)

<div class="topic-metadata">

**Author:** [@lindeskovfrank](https://discourse.nodered.org/u/lindeskovfrank)\
**Replies:** 4\
**Last updated:** [6 December 2022 09:21 UTC](https://discourse.nodered.org/t/how-to-send-mqtt-to-turn-on-a-shelly-1-device/71718 "2022-12-06T09:21:32Z")

</div>

I want to test a Shelly temperature, test if it is above or below and send a mqtt message to the Shelly to turn it on or off. \[ { "id": "311ddb3abbfbce82", "type": "debug", "z": "f96ed7468bad…

---

## [Node red Arduino installation failed](https://discourse.nodered.org/t/node-red-arduino-installation-failed/71746)

<div class="topic-metadata">

**Author:** [@TharinduSachinthaka](https://discourse.nodered.org/u/TharinduSachinthaka)\
**Replies:** 1\
**Last updated:** [6 December 2022 07:20 UTC](https://discourse.nodered.org/t/node-red-arduino-installation-failed/71746 "2022-12-06T07:20:33Z")

</div>

I am an university student. I used node red to do my final project. But Arduino installation was failed. Can anybody help me to solve this. Error coed attached. ----------------------------------------------------------…

---

## [Help using one button dimmer node](https://discourse.nodered.org/t/help-using-one-button-dimmer-node/71740)

<div class="topic-metadata">

**Author:** [@keelium](https://discourse.nodered.org/u/keelium)\
**Replies:** 0\
**Last updated:** [6 December 2022 02:14 UTC](https://discourse.nodered.org/t/help-using-one-button-dimmer-node/71740 "2022-12-06T02:14:51Z")

</div>

Hi, I’m using one-button-dimmer node for my ikea remote to dim my lights (with homeassistant) I was able to get it working before this however I've lost the flows because of sdcard crash so I can’t recall exactly how I …

---

## [How do I filter array for required parameters by Hour](https://discourse.nodered.org/t/how-do-i-filter-array-for-required-parameters-by-hour/71585)

<div class="topic-metadata">

**Author:** [@amit\_meld](https://discourse.nodered.org/u/amit_meld)\
**Replies:** 4\
**Last updated:** [5 December 2022 23:27 UTC](https://discourse.nodered.org/t/how-do-i-filter-array-for-required-parameters-by-hour/71585 "2022-12-05T23:27:19Z")

</div>

Hi, I am trying to fetch the Air Quality data of PM10 and CO from the JSON file I receive from the API call. The file looks like below - \[{"Site\_Id":1001,"Parameter":{"ParameterCode":"CO","ParameterDescription":"Carbo…

---

## [Convert Millisecond to H](https://discourse.nodered.org/t/convert-millisecond-to-h/71733)

<div class="topic-metadata">

**Author:** [@axdig](https://discourse.nodered.org/u/axdig)\
**Replies:** 1\
**Last updated:** [5 December 2022 22:33 UTC](https://discourse.nodered.org/t/convert-millisecond-to-h/71733 "2022-12-05T22:33:14Z")

</div>

Hi I'm stuck, again... I want to change/convert the date format in my whole array, feels like it would be very easy but after hours of googling I haven't succeeded, hope someone here can give me a hint :slight\_smile: T…

---

## [How to enable access to the Node-RED Editor over HTTPS](https://discourse.nodered.org/t/how-to-enable-access-to-the-node-red-editor-over-https/71609)

<div class="topic-metadata">

**Author:** [@nodeBoy816](https://discourse.nodered.org/u/nodeBoy816)\
**Replies:** 3\
**Last updated:** [5 December 2022 19:55 UTC](https://discourse.nodered.org/t/how-to-enable-access-to-the-node-red-editor-over-https/71609 "2022-12-05T19:55:50Z")

</div>

Howdy all! I'm in the midst of trying to set up a node red system that will power a water pump (see Motion sensors to turn on an outlet that powers a water pump - #24 by nodeBoy816) and am in the process of securing node…

---

## [How to measure the delay in node red between the mqtt gateway](https://discourse.nodered.org/t/how-to-measure-the-delay-in-node-red-between-the-mqtt-gateway/71396)

<div class="topic-metadata">

**Author:** [@Johnson](https://discourse.nodered.org/u/Johnson)\
**Replies:** 18\
**Last updated:** [5 December 2022 18:55 UTC](https://discourse.nodered.org/t/how-to-measure-the-delay-in-node-red-between-the-mqtt-gateway/71396 "2022-12-05T18:55:23Z")

</div>

I am new to node red . I would like to know if there is a node that can be used to measure the delay between the nodes in node red flow

---

## [Split messages arriving out of order](https://discourse.nodered.org/t/split-messages-arriving-out-of-order/71661)

<div class="topic-metadata">

**Author:** [@cymplecy](https://discourse.nodered.org/u/cymplecy)\
**Replies:** 28\
**Last updated:** [5 December 2022 17:24 UTC](https://discourse.nodered.org/t/split-messages-arriving-out-of-order/71661 "2022-12-05T17:24:53Z")

</div>

As part of my Advent of Code efforts, I'm having to be creative in splitting messages In Day 3, I need to split a message into two equal parts so I'm using a switch to add msg.complete after half the number of messages …

---

## [Source text ui dashboard](https://discourse.nodered.org/t/source-text-ui-dashboard/71663)

<div class="topic-metadata">

**Author:** [@denissanga](https://discourse.nodered.org/u/denissanga)\
**Replies:** 6\
**Last updated:** [5 December 2022 16:48 UTC](https://discourse.nodered.org/t/source-text-ui-dashboard/71663 "2022-12-05T16:48:32Z")

</div>

Hi all I would like create a source text input in dashboard and it propose automatically the solution. This is possible? Many thanks in advance

---

## [Patch function, assistance requested](https://discourse.nodered.org/t/patch-function-assistance-requested/71628)

<div class="topic-metadata">

**Author:** [@Timmer2022](https://discourse.nodered.org/u/Timmer2022)\
**Replies:** 4\
**Last updated:** [5 December 2022 14:00 UTC](https://discourse.nodered.org/t/patch-function-assistance-requested/71628 "2022-12-05T14:00:43Z")

</div>

Hello everyone. I want to use node-red to PATCH (update) a row in baserow through API.. I'm able to retrieve row information using the HTTP-in and GET function no problem but editing a row with PATCH is where I fall dow…

---

## [Function code to switch Relays over ESP Easy](https://discourse.nodered.org/t/function-code-to-switch-relays-over-esp-easy/71637)

<div class="topic-metadata">

**Author:** [@at-bh](https://discourse.nodered.org/u/at-bh)\
**Replies:** 16\
**Last updated:** [5 December 2022 13:28 UTC](https://discourse.nodered.org/t/function-code-to-switch-relays-over-esp-easy/71637 "2022-12-05T13:28:26Z")

</div>

Seemed easy, but my relais on a D1 mini (over GPIO5) do not switch with function code on a ESP Easy flashed device. Switching via http works perfect. Using Mqtt and Node Red, just a simple flow inject node - function - …

---

## [Node-red-contrib-cx-alarm-log: Error 'node\_version' field is missing in the CSV config](https://discourse.nodered.org/t/node-red-contrib-cx-alarm-log-error-node-version-field-is-missing-in-the-csv-config/71709)

<div class="topic-metadata">

**Author:** [@Joelew](https://discourse.nodered.org/u/Joelew)\
**Replies:** 2\
**Last updated:** [5 December 2022 12:54 UTC](https://discourse.nodered.org/t/node-red-contrib-cx-alarm-log-error-node-version-field-is-missing-in-the-csv-config/71709 "2022-12-05T12:54:10Z")

</div>

When first initiating this Node, I get the error: 'node\_version' field is missing in the CSV config. From what I can tell I have setup the csv file correctly: node\_version,1.1.0,required. It is version of the Alarm Log…

---

## [MQTT IN node - today's dumb question](https://discourse.nodered.org/t/mqtt-in-node-todays-dumb-question/71632)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 9\
**Last updated:** [5 December 2022 10:13 UTC](https://discourse.nodered.org/t/mqtt-in-node-todays-dumb-question/71632 "2022-12-05T10:13:30Z")

</div>

Sorry, NOT the latest NR, but close. NR 3.0.2 (I'm still running OLD versions on other machines.) MQTT IN node. Status quo: depricated. Ok. Go to the newer option. And.... The other was CONNECTED. Sorry…

---

## [Shelly 1 temperature, how to read?](https://discourse.nodered.org/t/shelly-1-temperature-how-to-read/71545)

<div class="topic-metadata">

**Author:** [@lindeskovfrank](https://discourse.nodered.org/u/lindeskovfrank)\
**Replies:** 10\
**Last updated:** [5 December 2022 08:48 UTC](https://discourse.nodered.org/t/shelly-1-temperature-how-to-read/71545 "2022-12-05T08:48:40Z")

</div>

I have a RPI4 with Mosquitto and Node Red installed. It is setup with an access-point that connects all the Shelly devices to the RPI. I can get all info from a specific Shelly with the mqtt commnd shellies/# and I can…

---

## [Inject Node - Max size of JSON payload](https://discourse.nodered.org/t/inject-node-max-size-of-json-payload/71695)

<div class="topic-metadata">

**Author:** [@ScheepersJohan](https://discourse.nodered.org/u/ScheepersJohan)\
**Replies:** 1\
**Last updated:** [5 December 2022 07:17 UTC](https://discourse.nodered.org/t/inject-node-max-size-of-json-payload/71695 "2022-12-05T07:17:49Z")

</div>

Hi, What is the max size for the payload in a inject node? I have a JSON it say it is too large PayloadTooLargeError: request entity too large at readStream (C:\\Users\\xxxx\\AppData\\Roaming\\npm\\node\_modules\\node-red…

---

## [Is there a node that will do multiple time triggers in a given day?](https://discourse.nodered.org/t/is-there-a-node-that-will-do-multiple-time-triggers-in-a-given-day/71694)

<div class="topic-metadata">

**Author:** [@arretx](https://discourse.nodered.org/u/arretx)\
**Replies:** 1\
**Last updated:** [5 December 2022 03:36 UTC](https://discourse.nodered.org/t/is-there-a-node-that-will-do-multiple-time-triggers-in-a-given-day/71694 "2022-12-05T03:36:28Z")

</div>

It seems Bigtimer will do two 'ON' settings, but I'm looking for a way to use a single node to send multiple triggers, much like the inject node, but at non-specific intervals. Does that exist?

---

## [My nodered has problem](https://discourse.nodered.org/t/my-nodered-has-problem/71471)

<div class="topic-metadata">

**Author:** [@QeeQA](https://discourse.nodered.org/u/QeeQA)\
**Replies:** 28\
**Last updated:** [5 December 2022 03:18 UTC](https://discourse.nodered.org/t/my-nodered-has-problem/71471 "2022-12-05T03:18:28Z")

</div>

i open my node red using command prompt...but then the server load too long, and even if it can open the server, it cant be deployed second time...

---

## [Need help to read data from BLE temperature sensor in Node-red (LYWSD03MMC)](https://discourse.nodered.org/t/need-help-to-read-data-from-ble-temperature-sensor-in-node-red-lywsd03mmc/71692)

<div class="topic-metadata">

**Author:** [@fnx2k](https://discourse.nodered.org/u/fnx2k)\
**Replies:** 1\
**Last updated:** [4 December 2022 23:24 UTC](https://discourse.nodered.org/t/need-help-to-read-data-from-ble-temperature-sensor-in-node-red-lywsd03mmc/71692 "2022-12-04T23:24:30Z")

</div>

Hi, First of all, I am beginning with node-RED, so excuse me if I miss some basic points or do not use the correct vocabulary My project is to run replace a broken thermostat of my central heating. I need help to be …

---

## [Npm fix inside Node-RED docker container](https://discourse.nodered.org/t/npm-fix-inside-node-red-docker-container/71655)

<div class="topic-metadata">

**Author:** [@Virgus](https://discourse.nodered.org/u/Virgus)\
**Replies:** 10\
**Last updated:** [4 December 2022 22:33 UTC](https://discourse.nodered.org/t/npm-fix-inside-node-red-docker-container/71655 "2022-12-04T22:33:12Z")

</div>

Hello everybody, I have an issue I'm not able to solve and hope to find some answers here. I migrated my Node-RED from Armbian to Debian and I imported all the data directory structure from the old instance to the new o…

---

## [Raspberry pi outdated software](https://discourse.nodered.org/t/raspberry-pi-outdated-software/71458)

<div class="topic-metadata">

**Author:** [@henkkas](https://discourse.nodered.org/u/henkkas)\
**Replies:** 29\
**Last updated:** [4 December 2022 21:09 UTC](https://discourse.nodered.org/t/raspberry-pi-outdated-software/71458 "2022-12-04T21:09:16Z")

</div>

I use the command npm outdated -g --depth=0 on my rpi to check if I have outdated software. It turns out my 'corepack' is outdated. This package seems not to be getting updated with the usual APT commands. I also canno…

---

## [How do I set and then reference a global variable in an expression?](https://discourse.nodered.org/t/how-do-i-set-and-then-reference-a-global-variable-in-an-expression/71679)

<div class="topic-metadata">

**Author:** [@UngluedChalice](https://discourse.nodered.org/u/UngluedChalice)\
**Replies:** 3\
**Last updated:** [4 December 2022 18:57 UTC](https://discourse.nodered.org/t/how-do-i-set-and-then-reference-a-global-variable-in-an-expression/71679 "2022-12-04T18:57:53Z")

</div>

I'm using Node Red 13.5.3 in Home Assistant and using a call service node that is part of the Home Assistant "node package" (not sure what the proper term is). I want to set my shades to not close all the way in the win…

---

## [Call "Link call" from function](https://discourse.nodered.org/t/call-link-call-from-function/71651)

<div class="topic-metadata">

**Author:** [@S0T0](https://discourse.nodered.org/u/S0T0)\
**Replies:** 3\
**Last updated:** [4 December 2022 17:54 UTC](https://discourse.nodered.org/t/call-link-call-from-function/71651 "2022-12-04T17:54:59Z")

</div>

Is it possible to call "link call" from a function and then work with what it returns? Thank you and take care!

---

## [Microsoft Forms Creation In Node-Red](https://discourse.nodered.org/t/microsoft-forms-creation-in-node-red/71603)

<div class="topic-metadata">

**Author:** [@ganeshiac](https://discourse.nodered.org/u/ganeshiac)\
**Replies:** 6\
**Last updated:** [4 December 2022 16:57 UTC](https://discourse.nodered.org/t/microsoft-forms-creation-in-node-red/71603 "2022-12-04T16:57:36Z")

</div>

Hi, Is there possible to communicate with Microsoft Forms in node-red. Actually, we want to know the How to install in node. Can you able to suggest me. Thanks,

---

## [Flexdash iframe: Cannot GET /home/my/Pictures/image2048x2048.jpg](https://discourse.nodered.org/t/flexdash-iframe-cannot-get-home-my-pictures-image2048x2048-jpg/71085)

<div class="topic-metadata">

**Author:** [@tree-frog](https://discourse.nodered.org/u/tree-frog)\
**Replies:** 1\
**Last updated:** [4 December 2022 16:41 UTC](https://discourse.nodered.org/t/flexdash-iframe-cannot-get-home-my-pictures-image2048x2048-jpg/71085 "2022-12-04T16:41:54Z")

</div>

Linux running flexdash Node-RED 3.02. How can you reference an image on local disk vs. URL?

---

## [Flexdash 'Time Plot Raw' chart formatting (uPlot)](https://discourse.nodered.org/t/flexdash-time-plot-raw-chart-formatting-uplot/71646)

<div class="topic-metadata">

**Author:** [@Paul-Reed](https://discourse.nodered.org/u/Paul-Reed)\
**Replies:** 5\
**Last updated:** [4 December 2022 16:24 UTC](https://discourse.nodered.org/t/flexdash-time-plot-raw-chart-formatting-uplot/71646 "2022-12-04T16:24:55Z")

</div>

Anybody using the Flexdash Time Plot Raw or uPlot? I've used the Flexdash Time Plot node so far for charts, which is much easier to use, but I wanted the flexibility to create a High/Low bands chart, and use more advanc…

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

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