# General

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

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

**Page:** 135

---

## [Xlsx file to json using function](https://discourse.nodered.org/t/xlsx-file-to-json-using-function/85254)

<div class="topic-metadata">

**Author:** [@hbadshahp](https://discourse.nodered.org/u/hbadshahp)\
**Replies:** 4\
**Last updated:** [7 February 2024 09:31 UTC](https://discourse.nodered.org/t/xlsx-file-to-json-using-function/85254 "2024-02-07T09:31:28Z")

</div>

Hii everyone, I am new to NodeRed. I want to iterate through the Row whose first column is matching with my Input. Shall writing function for these is good choice. flows.json (1.6 KB)

---

## [Issues installing node-red core](https://discourse.nodered.org/t/issues-installing-node-red-core/85202)

<div class="topic-metadata">

**Author:** [@dnguyen01123](https://discourse.nodered.org/u/dnguyen01123)\
**Replies:** 4\
**Last updated:** [7 February 2024 09:13 UTC](https://discourse.nodered.org/t/issues-installing-node-red-core/85202 "2024-02-07T09:13:36Z")

</div>

I've tried various ways to install node-red on my Raspberry PI 4 running Debian It doesn't seem to install the core when I run the command line script bash \<(curl -sL https://raw.githubusercontent.com/node-red/linux-in…

---

## [Can't set upstream branch to github on Raspberry Pi](https://discourse.nodered.org/t/cant-set-upstream-branch-to-github-on-raspberry-pi/85281)

<div class="topic-metadata">

**Author:** [@basti188bu](https://discourse.nodered.org/u/basti188bu)\
**Replies:** 0\
**Last updated:** [7 February 2024 07:22 UTC](https://discourse.nodered.org/t/cant-set-upstream-branch-to-github-on-raspberry-pi/85281 "2024-02-07T07:22:58Z")

</div>

Hello, i'm trying to connect node-red on my RaspberryPi with Github, but it doesn't work as expected. I generate a ssh-key in Node-Red and add it to GitHub Repository under Settings -\> Deploy Keys. I set up the right …

---

## [Can I have a delay / sleep inside Function node](https://discourse.nodered.org/t/can-i-have-a-delay-sleep-inside-function-node/3101)

<div class="topic-metadata">

**Author:** [@cymplecy](https://discourse.nodered.org/u/cymplecy)\
**Replies:** 34\
**Last updated:** [7 February 2024 06:39 UTC](https://discourse.nodered.org/t/can-i-have-a-delay-sleep-inside-function-node/3101 "2024-02-07T06:39:33Z")

</div>

I'm pretty certain that the answer is going to be no but can I do something in a function node - wait a bit - do something else? or do I need to have two function nodes with a Delay node in-between them?

---

## [Can't get node red to install on my rasberry PI](https://discourse.nodered.org/t/cant-get-node-red-to-install-on-my-rasberry-pi/85274)

<div class="topic-metadata">

**Author:** [@nirat7](https://discourse.nodered.org/u/nirat7)\
**Replies:** 2\
**Last updated:** [7 February 2024 00:14 UTC](https://discourse.nodered.org/t/cant-get-node-red-to-install-on-my-rasberry-pi/85274 "2024-02-07T00:14:29Z")

</div>

Trying to setup node-red (On Mac) and was wondering if anyone has experience with some of the issues of installing it on Raspberry Pi. I'm running the script and I appear to be having some issues with the Core package in…

---

## [Coding advice/approach for "odd ball" amateur radio log records](https://discourse.nodered.org/t/coding-advice-approach-for-odd-ball-amateur-radio-log-records/85221)

<div class="topic-metadata">

**Author:** [@W6PNG](https://discourse.nodered.org/u/W6PNG)\
**Replies:** 4\
**Last updated:** [6 February 2024 23:51 UTC](https://discourse.nodered.org/t/coding-advice-approach-for-odd-ball-amateur-radio-log-records/85221 "2024-02-06T23:51:13Z")

</div>

In my enjoyable wanderings around NR, I've been thrilled with how easy it is to get a result. However, I'd like to go beyond that and develop better skills as I realize I made liberal use of global context that has been …

---

## [How we can invoke/trigger the Node Red flow programmatically from Node JS app?](https://discourse.nodered.org/t/how-we-can-invoke-trigger-the-node-red-flow-programmatically-from-node-js-app/85267)

<div class="topic-metadata">

**Author:** [@akshay](https://discourse.nodered.org/u/akshay)\
**Replies:** 1\
**Last updated:** [6 February 2024 22:06 UTC](https://discourse.nodered.org/t/how-we-can-invoke-trigger-the-node-red-flow-programmatically-from-node-js-app/85267 "2024-02-06T22:06:15Z")

</div>

Hi there, We have embedded the Node-Red into existing Node JS with an express framework app & we wanted to make a sync call to the flow programmatically (without HTTP call) from the same app. Is this something possible? …

---

## [Conceptual problem with delayed response](https://discourse.nodered.org/t/conceptual-problem-with-delayed-response/85197)

<div class="topic-metadata">

**Author:** [@xtrailrunner](https://discourse.nodered.org/u/xtrailrunner)\
**Replies:** 5\
**Last updated:** [6 February 2024 21:11 UTC](https://discourse.nodered.org/t/conceptual-problem-with-delayed-response/85197 "2024-02-06T21:11:58Z")

</div>

Hello, I've build a flow to control a power storage system at home. I use a switch node from node-red-dashboard to display a binary state (ON | OFF) and to switch the binary state from ON to OFF or vice versa. This cau…

---

## [How to separate two values of an object (temperature, humidity)](https://discourse.nodered.org/t/how-to-separate-two-values-of-an-object-temperature-humidity/85261)

<div class="topic-metadata">

**Author:** [@jflopezsanchezmon](https://discourse.nodered.org/u/jflopezsanchezmon)\
**Replies:** 5\
**Last updated:** [6 February 2024 20:40 UTC](https://discourse.nodered.org/t/how-to-separate-two-values-of-an-object-temperature-humidity/85261 "2024-02-06T20:40:03Z")

</div>

Hello, I would like to separate the two values of an object. I'm trying with the split node, but it doesn't work. Thanks

---

## [Twilio sandbox with node red](https://discourse.nodered.org/t/twilio-sandbox-with-node-red/85220)

<div class="topic-metadata">

**Author:** [@joey\_ind](https://discourse.nodered.org/u/joey_ind)\
**Replies:** 2\
**Last updated:** [6 February 2024 16:55 UTC](https://discourse.nodered.org/t/twilio-sandbox-with-node-red/85220 "2024-02-06T16:55:06Z")

</div>

Hi folks, I am trying to send whatsapp messages via twilio sandbox . Is there any node to do the same? I have configured my sandbox account but not able to integrate it with node red. Pls help

---

## [Can I create / call context.name\[variable\]](https://discourse.nodered.org/t/can-i-create-call-context-name-variable/85258)

<div class="topic-metadata">

**Author:** [@StrongTown](https://discourse.nodered.org/u/StrongTown)\
**Replies:** 5\
**Last updated:** [6 February 2024 15:58 UTC](https://discourse.nodered.org/t/can-i-create-call-context-name-variable/85258 "2024-02-06T15:58:32Z")

</div>

I am creating a node that will monitor ON duration for many switches under MQTT control. Is there a way to create / identify context like this? Switch behavior can happen in any random sequence (ie: SW 1 OFF, SW 4 ON, S…

---

## [Change node - can this be done?](https://discourse.nodered.org/t/change-node-can-this-be-done/85214)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 10\
**Last updated:** [6 February 2024 15:48 UTC](https://discourse.nodered.org/t/change-node-can-this-be-done/85214 "2024-02-06T15:48:12Z")

</div>

Sorry folks, another Today's dumb question. Recent events have had me going in circles with the change node. Base line of the question is this: Say I am expecting a number value to come in and for what ever reason it …

---

## [Zigbee2 Motion sensor giving false positives](https://discourse.nodered.org/t/zigbee2-motion-sensor-giving-false-positives/85187)

<div class="topic-metadata">

**Author:** [@richiep](https://discourse.nodered.org/u/richiep)\
**Replies:** 3\
**Last updated:** [6 February 2024 12:58 UTC](https://discourse.nodered.org/t/zigbee2-motion-sensor-giving-false-positives/85187 "2024-02-06T12:58:26Z")

</div>

Hey All, I'm running a Aqara motion sensor via zigbee2mqtt. This is my only zigbee device, I've had it for a while but I can't get it working. I have it configured using the lowest sensitivity and a 30s detection inte…

---

## [Automate subflow exports](https://discourse.nodered.org/t/automate-subflow-exports/85252)

<div class="topic-metadata">

**Author:** [@hornbartho](https://discourse.nodered.org/u/hornbartho)\
**Replies:** 1\
**Last updated:** [6 February 2024 12:44 UTC](https://discourse.nodered.org/t/automate-subflow-exports/85252 "2024-02-06T12:44:47Z")

</div>

Hi Folks, We are busy trying to to automate exporting a sub-flow into its own node, with the idea of building our own library that can be used across multiple devices. What would be the best approach to achieve this goa…

---

## [Could not install node-red-contrib-smartmeter in Docker](https://discourse.nodered.org/t/could-not-install-node-red-contrib-smartmeter-in-docker/85253)

<div class="topic-metadata">

**Author:** [@Smartmeter](https://discourse.nodered.org/u/Smartmeter)\
**Replies:** 0\
**Last updated:** [6 February 2024 11:32 UTC](https://discourse.nodered.org/t/could-not-install-node-red-contrib-smartmeter-in-docker/85253 "2024-02-06T11:32:57Z")

</div>

Hi, after updating Nodered to V3.1.3 in Docker (19.03.15) I could not more install the node-red-contrib-smartmeter V0.6.3 Any ideas why? Here the logfile: \> node-red-docker@3.1.3 start \> node $NODE\_OPTIONS node\_modu…

---

## [communication between node red servers](https://discourse.nodered.org/t/communication-between-node-red-servers/85224)

<div class="topic-metadata">

**Author:** [@RafaBravo](https://discourse.nodered.org/u/RafaBravo)\
**Replies:** 9\
**Last updated:** [6 February 2024 08:34 UTC](https://discourse.nodered.org/t/communication-between-node-red-servers/85224 "2024-02-06T08:34:52Z")

</div>

Good afternoon, what would be the appropriate way to communicate 2 node-red servers? I've tried via MQTT, any other ideas?

---

## [Polling API data to make a trend - how to process data?](https://discourse.nodered.org/t/polling-api-data-to-make-a-trend-how-to-process-data/85102)

<div class="topic-metadata">

**Author:** [@Stomachbuzz](https://discourse.nodered.org/u/Stomachbuzz)\
**Replies:** 2\
**Last updated:** [6 February 2024 01:50 UTC](https://discourse.nodered.org/t/polling-api-data-to-make-a-trend-how-to-process-data/85102 "2024-02-06T01:50:56Z")

</div>

Hi there, For practice, I've gotten the idea of using Node Red to poll Google Maps API for a specific commute in both directions to trend the real commute time (taking traffic into account) during various times of day. …

---

## [Would someone mind checking this subflow for me plaese?](https://discourse.nodered.org/t/would-someone-mind-checking-this-subflow-for-me-plaese/85238)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 0\
**Last updated:** [5 February 2024 23:57 UTC](https://discourse.nodered.org/t/would-someone-mind-checking-this-subflow-for-me-plaese/85238 "2024-02-05T23:57:29Z")

</div>

This is one of my babies. I've worked on it for a long time and it is getting better - I hope - than it was. This is a bit more strict in it's inputs, but offers a lot of handy stuff if you are dealing with devices tha…

---

## [Zip with password](https://discourse.nodered.org/t/zip-with-password/85184)

<div class="topic-metadata">

**Author:** [@robvoi](https://discourse.nodered.org/u/robvoi)\
**Replies:** 16\
**Last updated:** [5 February 2024 21:49 UTC](https://discourse.nodered.org/t/zip-with-password/85184 "2024-02-05T21:49:10Z")

</div>

Hi, I'm looking for a way to generate a password protected .zip file. I want to use it to send mails with encrypted zip as attachment. Does someone know if/how this can be done? Thanks

---

## [Sidebar text size](https://discourse.nodered.org/t/sidebar-text-size/85170)

<div class="topic-metadata">

**Author:** [@perigalacticon](https://discourse.nodered.org/u/perigalacticon)\
**Replies:** 5\
**Last updated:** [5 February 2024 20:41 UTC](https://discourse.nodered.org/t/sidebar-text-size/85170 "2024-02-05T20:41:23Z")

</div>

Is there a way to change (increase) the text size of the sidebar/debug window?

---

## [This is a question about a node called node red contrib sftp ssh](https://discourse.nodered.org/t/this-is-a-question-about-a-node-called-node-red-contrib-sftp-ssh/85207)

<div class="topic-metadata">

**Author:** [@Node7189](https://discourse.nodered.org/u/Node7189)\
**Replies:** 6\
**Last updated:** [5 February 2024 14:27 UTC](https://discourse.nodered.org/t/this-is-a-question-about-a-node-called-node-red-contrib-sftp-ssh/85207 "2024-02-05T14:27:55Z")

</div>

I apologize if this is a known issue, but I would like to ask. In this node, remote path and local path can be input using the msg method. However, Host, Username, and Password cannot be passed to the msg method properly…

---

## [I want to generate excel file with Header](https://discourse.nodered.org/t/i-want-to-generate-excel-file-with-header/85210)

<div class="topic-metadata">

**Author:** [@PRABHAKAR82](https://discourse.nodered.org/u/PRABHAKAR82)\
**Replies:** 6\
**Last updated:** [5 February 2024 13:42 UTC](https://discourse.nodered.org/t/i-want-to-generate-excel-file-with-header/85210 "2024-02-05T13:42:46Z")

</div>

Currently I generate excel file using MySQL database, but I want to add header on an excel sheet. Is it possible to add header? I attached the sample picture of what I want

---

## [How to handle javascript events?](https://discourse.nodered.org/t/how-to-handle-javascript-events/85020)

<div class="topic-metadata">

**Author:** [@protonmw](https://discourse.nodered.org/u/protonmw)\
**Replies:** 7\
**Last updated:** [5 February 2024 13:18 UTC](https://discourse.nodered.org/t/how-to-handle-javascript-events/85020 "2024-02-05T13:18:19Z")

</div>

Hi experts! I want to include a CAN hardware interface into NR. How can I handle the events of the module? JavaScript Events The module emits the following events: open when the serial port is successfully opened …

---

## [About node-red-contrib-telnet-client](https://discourse.nodered.org/t/about-node-red-contrib-telnet-client/85006)

<div class="topic-metadata">

**Author:** [@Node7189](https://discourse.nodered.org/u/Node7189)\
**Replies:** 4\
**Last updated:** [5 February 2024 12:38 UTC](https://discourse.nodered.org/t/about-node-red-contrib-telnet-client/85006 "2024-02-05T12:38:32Z")

</div>

Sorry for the rather elementary question. When I check the properties of node-red-contrib-telnet-client, there is a setting item for the timeout time, but even if I enter a value, the timeout time does not change. If any…

---

## [Monthly average](https://discourse.nodered.org/t/monthly-average/85212)

<div class="topic-metadata">

**Author:** [@colin0031](https://discourse.nodered.org/u/colin0031)\
**Replies:** 1\
**Last updated:** [5 February 2024 10:58 UTC](https://discourse.nodered.org/t/monthly-average/85212 "2024-02-05T10:58:54Z")

</div>

Dear node-red family members, I am collecting data from a machine, which send out parameters(values between 20 &50) once every second. Is it possible to that I can find monthly average from Ui without the help of addit…

---

## [Same subflow, different happening on different machines](https://discourse.nodered.org/t/same-subflow-different-happening-on-different-machines/85140)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 37\
**Last updated:** [5 February 2024 02:15 UTC](https://discourse.nodered.org/t/same-subflow-different-happening-on-different-machines/85140 "2024-02-05T02:15:02Z")

</div>

Sorry folks: ..... I'm ba-ack.....! I've recently been working on a subflow and made a lot of silly mistakes. (I'll cop that.) So entered the command correctly and all should be good - yeah? :frowning: Nah. One ma…

---

## [How to process zigbee2mqtt inputs](https://discourse.nodered.org/t/how-to-process-zigbee2mqtt-inputs/85200)

<div class="topic-metadata">

**Author:** [@tmichaeltx](https://discourse.nodered.org/u/tmichaeltx)\
**Replies:** 0\
**Last updated:** [4 February 2024 22:13 UTC](https://discourse.nodered.org/t/how-to-process-zigbee2mqtt-inputs/85200 "2024-02-04T22:13:28Z")

</div>

I have been working on a lot of SmartHome related flows and have run into a bit of a challenge. While I have a lot more going on, I can describe the problem involving 3 Zigbee devices: Ikea Switch Ikea Smart Bulb Ikea …

---

## [Local httpadmin access from http request node](https://discourse.nodered.org/t/local-httpadmin-access-from-http-request-node/84983)

<div class="topic-metadata">

**Author:** [@helander](https://discourse.nodered.org/u/helander)\
**Replies:** 41\
**Last updated:** [4 February 2024 21:15 UTC](https://discourse.nodered.org/t/local-httpadmin-access-from-http-request-node/84983 "2024-02-04T21:15:51Z")

</div>

I am creating a small http admin client. The client is implemented as a Node-Red flow. This works fine, but I have to manually configure the url of the http admin api. I would like to access the admin api of the same Nod…

---

## [Split node, data split](https://discourse.nodered.org/t/split-node-data-split/85193)

<div class="topic-metadata">

**Author:** [@Pjlals](https://discourse.nodered.org/u/Pjlals)\
**Replies:** 8\
**Last updated:** [4 February 2024 18:19 UTC](https://discourse.nodered.org/t/split-node-data-split/85193 "2024-02-04T18:19:23Z")

</div>

\`\`\`\[ { "id": "bc97ba3b1120916d", "type": "tab", "label": "Flow 1", "disabled": false, "info": "", "env": \[\] }, { "id": "6b91f71dcb05eef7", "type…

---

## [Trigger flow in one instance from another instance](https://discourse.nodered.org/t/trigger-flow-in-one-instance-from-another-instance/85177)

<div class="topic-metadata">

**Author:** [@Dacron](https://discourse.nodered.org/u/Dacron)\
**Replies:** 6\
**Last updated:** [4 February 2024 17:03 UTC](https://discourse.nodered.org/t/trigger-flow-in-one-instance-from-another-instance/85177 "2024-02-04T17:03:33Z")

</div>

Hi I have node red instances setup and working on two systems, a mini pc and an inverter both on the same network. Both are working and controlling their systems perfectly. I would like to be able to trigger a flow on on…

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

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