# Latest

**URL:** https://discourse.nodered.org/latest.md?page=1190

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

**Page:** 1191

---

## [Concatenate two strings into one](https://discourse.nodered.org/t/concatenate-two-strings-into-one/18857)

<div class="topic-metadata">

**Author:** [@aryeduino](https://discourse.nodered.org/u/aryeduino)\
**Replies:** 10\
**Last updated:** [6 December 2019 13:17 UTC](https://discourse.nodered.org/t/concatenate-two-strings-into-one/18857 "2019-12-06T13:17:48Z")

</div>

Hi All, I am NEW to node red and I want to learn and understand it further deeply, I am also using hass.io and node red is NOW going to take a part in my Home Automation. I want to be able to send a value to my MQTT br…

---

## [My first node is not integrated by Node-RED flow](https://discourse.nodered.org/t/my-first-node-is-not-integrated-by-node-red-flow/18852)

<div class="topic-metadata">

**Author:** [@Arnaud](https://discourse.nodered.org/u/Arnaud)\
**Replies:** 7\
**Last updated:** [6 December 2019 10:24 UTC](https://discourse.nodered.org/t/my-first-node-is-not-integrated-by-node-red-flow/18852 "2019-12-06T10:24:05Z")

</div>

Hi, I have delivered yesterday my first node yesterday (18h ago) : @adeunis/node-red-contrib-adeunis-codecs I'm able to install it manually in node-red (under windows 10) but it seems that something is going wrong as i…

---

## [Command line format for Exec node](https://discourse.nodered.org/t/command-line-format-for-exec-node/18830)

<div class="topic-metadata">

**Author:** [@nomi](https://discourse.nodered.org/u/nomi)\
**Replies:** 2\
**Last updated:** [6 December 2019 09:58 UTC](https://discourse.nodered.org/t/command-line-format-for-exec-node/18830 "2019-12-06T09:58:21Z")

</div>

Hi, some issue to create a command line for an exec node from a json object. the object is this one :slight\_smile: and i would like to format the object as individual command line parameter like this: I try a spli…

---

## [Sending data from node-red to local webpage](https://discourse.nodered.org/t/sending-data-from-node-red-to-local-webpage/18826)

<div class="topic-metadata">

**Author:** [@YLM](https://discourse.nodered.org/u/YLM)\
**Replies:** 4\
**Last updated:** [6 December 2019 09:35 UTC](https://discourse.nodered.org/t/sending-data-from-node-red-to-local-webpage/18826 "2019-12-06T09:35:40Z")

</div>

I'd like some help to my project, I do not know how to proceed. Actually, I have a python code which send data to mosquitto and in my node I have a mqtt listener which get my data from my python code. Then I send those …

---

## [Recover lost flows](https://discourse.nodered.org/t/recover-lost-flows/18829)

<div class="topic-metadata">

**Author:** [@insanoff](https://discourse.nodered.org/u/insanoff)\
**Replies:** 5\
**Last updated:** [6 December 2019 08:45 UTC](https://discourse.nodered.org/t/recover-lost-flows/18829 "2019-12-06T08:45:03Z")

</div>

Hi Folks, I am running Node-Red in Raspberry Docker Container. I have created a parallel flow copying the existing one and made a small change. After that, I couldn't deploy it anymore and returned an error Error savin…

---

## [Can MSSQL node connect with tcp database?](https://discourse.nodered.org/t/can-mssql-node-connect-with-tcp-database/18849)

<div class="topic-metadata">

**Author:** [@Steven](https://discourse.nodered.org/u/Steven)\
**Replies:** 3\
**Last updated:** [6 December 2019 08:24 UTC](https://discourse.nodered.org/t/can-mssql-node-connect-with-tcp-database/18849 "2019-12-06T08:24:04Z")

</div>

Greetings, I am trying to use a local sql server (SQL Management Studio DB from another PC) on my project. Is there possible to connect sql server via TCP? What node or configuration should I do if can? Thanks.

---

## [To simulate a smart cradle](https://discourse.nodered.org/t/to-simulate-a-smart-cradle/18785)

<div class="topic-metadata">

**Author:** [@tijosetom](https://discourse.nodered.org/u/tijosetom)\
**Replies:** 5\
**Last updated:** [6 December 2019 08:11 UTC](https://discourse.nodered.org/t/to-simulate-a-smart-cradle/18785 "2019-12-06T08:11:49Z")

</div>

Hi, I am new to Node-Red, please excuse me if my questions looks silly. For my Masters degree project, I am making a smart cradle with some features like baby cry detection using a particular algorithm and based on tha…

---

## [Login and home page Routing](https://discourse.nodered.org/t/login-and-home-page-routing/18850)

<div class="topic-metadata">

**Author:** [@pavan](https://discourse.nodered.org/u/pavan)\
**Replies:** 1\
**Last updated:** [6 December 2019 07:41 UTC](https://discourse.nodered.org/t/login-and-home-page-routing/18850 "2019-12-06T07:41:39Z")

</div>

I am wondering to find the way there I can specify the login to the main page flow control. Can some someone help me through this

---

## [It's a beginner's question (form to button)](https://discourse.nodered.org/t/its-a-beginners-question-form-to-button/18789)

<div class="topic-metadata">

**Author:** [@semsisarac](https://discourse.nodered.org/u/semsisarac)\
**Replies:** 3\
**Last updated:** [6 December 2019 05:00 UTC](https://discourse.nodered.org/t/its-a-beginners-question-form-to-button/18789 "2019-12-06T05:00:59Z")

</div>

I want the contents of the button to be taken from the form. The layout line is fixed. the result should be as follows. (VeriT and VeriN fields from ui form node); { "layout": "Test", "data": { "Veri…

---

## [Sentiment@2.1.1 dependency?](https://discourse.nodered.org/t/sentiment-2-1-1-dependency/18840)

<div class="topic-metadata">

**Author:** [@RobP](https://discourse.nodered.org/u/RobP)\
**Replies:** 2\
**Last updated:** [5 December 2019 23:08 UTC](https://discourse.nodered.org/t/sentiment-2-1-1-dependency/18840 "2019-12-05T23:08:27Z")

</div>

I have been successfully building my docker image of node-red based on alpine for a couple weeks now, and I have an "update coreutils" in there before the build. Within the last couple days, the build no longer works and…

---

## [Switch Node - rules limitation](https://discourse.nodered.org/t/switch-node-rules-limitation/18659)

<div class="topic-metadata">

**Author:** [@StrongTown](https://discourse.nodered.org/u/StrongTown)\
**Replies:** 6\
**Last updated:** [5 December 2019 21:08 UTC](https://discourse.nodered.org/t/switch-node-rules-limitation/18659 "2019-12-05T21:08:21Z")

</div>

When utilizing the switch node, is it possible to provide multiple variables on a single rule /test such as: or does each word need to be a separate check? st

---

## [Upgrade to latest dashboard version](https://discourse.nodered.org/t/upgrade-to-latest-dashboard-version/18804)

<div class="topic-metadata">

**Author:** [@gerry](https://discourse.nodered.org/u/gerry)\
**Replies:** 2\
**Last updated:** [5 December 2019 18:29 UTC](https://discourse.nodered.org/t/upgrade-to-latest-dashboard-version/18804 "2019-12-05T18:29:32Z")

</div>

upgraded pi last night and today I got this when navigating dashboard. I'm not sure but I don't think this is right. Deleted dashboard and had it reload and this stayed the same

---

## [Flow fails to load result page after Ajax form submit](https://discourse.nodered.org/t/flow-fails-to-load-result-page-after-ajax-form-submit/18809)

<div class="topic-metadata">

**Author:** [@FriendlyDre](https://discourse.nodered.org/u/FriendlyDre)\
**Replies:** 3\
**Last updated:** [5 December 2019 18:21 UTC](https://discourse.nodered.org/t/flow-fails-to-load-result-page-after-ajax-form-submit/18809 "2019-12-05T18:21:45Z")

</div>

I have a flow that is a simple HTML page that allows one to select a file then submits it to another flow the second flow starts with an "HTTP Node In" then passes it to a "function node that makes a web service request …

---

## [PIN to confirm command](https://discourse.nodered.org/t/pin-to-confirm-command/18795)

<div class="topic-metadata">

**Author:** [@manjha](https://discourse.nodered.org/u/manjha)\
**Replies:** 2\
**Last updated:** [5 December 2019 16:57 UTC](https://discourse.nodered.org/t/pin-to-confirm-command/18795 "2019-12-05T16:57:28Z")

</div>

I am using Node-Red as a go-between for Google Home and Domoticz. Works great, I've already created several flows to switch lights etcetera. But I have a special switch that I want to secure with a PIN: the alarm. I w…

---

## [Create a single Json object with MQTT response](https://discourse.nodered.org/t/create-a-single-json-object-with-mqtt-response/18599)

<div class="topic-metadata">

**Author:** [@YLM](https://discourse.nodered.org/u/YLM)\
**Replies:** 2\
**Last updated:** [5 December 2019 15:39 UTC](https://discourse.nodered.org/t/create-a-single-json-object-with-mqtt-response/18599 "2019-12-05T15:39:31Z")

</div>

I have a python code which send 2 values to the same channel. "sensor/X" and "sensor/Y", and I would like to merge them into a single Json object {X : value of sensor/X, Y : value of sensor/Y}. I have done this node : …

---

## [Node configuration](https://discourse.nodered.org/t/node-configuration/18823)

<div class="topic-metadata">

**Author:** [@mohammedtaha](https://discourse.nodered.org/u/mohammedtaha)\
**Replies:** 4\
**Last updated:** [5 December 2019 14:56 UTC](https://discourse.nodered.org/t/node-configuration/18823 "2019-12-05T14:56:13Z")

</div>

hello, please i need help, i want to assign the payload (string 9570..) to the set rule

---

## [Adafruit DRV2605L Haptic Controller Breakout](https://discourse.nodered.org/t/adafruit-drv2605l-haptic-controller-breakout/18825)

<div class="topic-metadata">

**Author:** [@n0th1ng](https://discourse.nodered.org/u/n0th1ng)\
**Replies:** 0\
**Last updated:** [5 December 2019 14:33 UTC](https://discourse.nodered.org/t/adafruit-drv2605l-haptic-controller-breakout/18825 "2019-12-05T14:33:46Z")

</div>

Hi folks, Am new to node red, and i have started a little project and is make me exploring the IoT world witch is kinda motivating to learn new stuff :slight\_smile: so i got an adafruit-drv2605-haptic-controller-break…

---

## [Postgres to Chart](https://discourse.nodered.org/t/postgres-to-chart/18815)

<div class="topic-metadata">

**Author:** [@lesterkelly](https://discourse.nodered.org/u/lesterkelly)\
**Replies:** 4\
**Last updated:** [5 December 2019 11:45 UTC](https://discourse.nodered.org/t/postgres-to-chart/18815 "2019-12-05T11:45:15Z")

</div>

Hi, I'm new to Node Red so please try to bare with me. I'm running it on a raspberry pi 3 with a postgresql database on the same device. I have no issue pulling the data from the database but for some reason I can not …

---

## [Deploy failed: no response from server](https://discourse.nodered.org/t/deploy-failed-no-response-from-server/9461)

<div class="topic-metadata">

**Author:** [@Csstenersen](https://discourse.nodered.org/u/Csstenersen)\
**Replies:** 9\
**Last updated:** [5 December 2019 11:15 UTC](https://discourse.nodered.org/t/deploy-failed-no-response-from-server/9461 "2019-12-05T11:15:47Z")

</div>

Hi. After installing Node Red V 0.20.3 I have some troubles.. the message: deploy failed: no response from server keep appearing when i hit Deploy and i have to reload my browser and then it works fine to Deploy aga…

---

## [API to get subflow as json by ID](https://discourse.nodered.org/t/api-to-get-subflow-as-json-by-id/18791)

<div class="topic-metadata">

**Author:** [@tleflond](https://discourse.nodered.org/u/tleflond)\
**Replies:** 5\
**Last updated:** [5 December 2019 10:51 UTC](https://discourse.nodered.org/t/api-to-get-subflow-as-json-by-id/18791 "2019-12-05T10:51:06Z")

</div>

I am trying to retrieve the subflow by ID (are even better all the subflows as an array). I have taken a look at the node red APIs available but non suits my need (there is one for retrieving flows but it does not work w…

---

## [MQTT - TLS encryption example](https://discourse.nodered.org/t/mqtt-tls-encryption-example/17691)

<div class="topic-metadata">

**Author:** [@Paul-Reed](https://discourse.nodered.org/u/Paul-Reed)\
**Replies:** 26\
**Last updated:** [5 December 2019 10:36 UTC](https://discourse.nodered.org/t/mqtt-tls-encryption-example/17691 "2019-12-05T10:36:54Z")

</div>

In this previous post I used Certbot & Letsencrypt to secure a node-RED server, and wanted to use the same Letsencrypt certificates to secure MQTT communication with a remote server. I also wanted to ensure that all loc…

---

## [Select Array from MSSQL and insert into postgresql](https://discourse.nodered.org/t/select-array-from-mssql-and-insert-into-postgresql/18820)

<div class="topic-metadata">

**Author:** [@nameegal](https://discourse.nodered.org/u/nameegal)\
**Replies:** 0\
**Last updated:** [5 December 2019 10:01 UTC](https://discourse.nodered.org/t/select-array-from-mssql-and-insert-into-postgresql/18820 "2019-12-05T10:01:24Z")

</div>

Hi. I try to read an array from MSSQL database and insert the Array data into a postgresql database. From the postgres node I get the "Error: msg.payload must be an array of queries". The Output from mssql is an Array …

---

## [Convert csv format to JSON format](https://discourse.nodered.org/t/convert-csv-format-to-json-format/18810)

<div class="topic-metadata">

**Author:** [@rajendran20](https://discourse.nodered.org/u/rajendran20)\
**Replies:** 6\
**Last updated:** [5 December 2019 09:14 UTC](https://discourse.nodered.org/t/convert-csv-format-to-json-format/18810 "2019-12-05T09:14:21Z")

</div>

Hi I am getting a MQTT data in csv data format 1,1.4439263,103.7842,1575539820. Basically its a GPS data in the following format (#, lat, lng, timestamp) I need to create a JSON file in this manner. \[ 1, { "lat" : 1.44…

---

## [Flows Starting without login](https://discourse.nodered.org/t/flows-starting-without-login/18806)

<div class="topic-metadata">

**Author:** [@Devbrat](https://discourse.nodered.org/u/Devbrat)\
**Replies:** 5\
**Last updated:** [5 December 2019 08:35 UTC](https://discourse.nodered.org/t/flows-starting-without-login/18806 "2019-12-05T08:35:51Z")

</div>

I have enabled authentication in node-red, But I assume according to development, flows are getting started before login and keeps running after logout. Is this correct behavior? If yes then is there any way to stop th…

---

## [NodeRed doesn’t start](https://discourse.nodered.org/t/nodered-doesn-t-start/18542)

<div class="topic-metadata">

**Author:** [@rajendran20](https://discourse.nodered.org/u/rajendran20)\
**Replies:** 4\
**Last updated:** [5 December 2019 05:11 UTC](https://discourse.nodered.org/t/nodered-doesn-t-start/18542 "2019-12-05T05:11:26Z")

</div>

I had installed node red and started the dashboard. Installed some Firebase modes and did some testing. When deploy, the server prompts connection has been lost. Now my node-red can’t startup from the terminal. It exits…

---

## [Node-red stops when i quit Kodi](https://discourse.nodered.org/t/node-red-stops-when-i-quit-kodi/18706)

<div class="topic-metadata">

**Author:** [@Pipo1nsano](https://discourse.nodered.org/u/Pipo1nsano)\
**Replies:** 2\
**Last updated:** [4 December 2019 20:46 UTC](https://discourse.nodered.org/t/node-red-stops-when-i-quit-kodi/18706 "2019-12-04T20:46:00Z")

</div>

I use " node-red-contrib-kodi" to control my light when watching movies but when i quit kodi node-red crashes.. I cannot understand why.. Does anyone have a clue? 2 Dec 19:38:06 - \[red\] Uncaught Exception: 2 Dec 19:38:…

---

## [Wemo Switch Long Press](https://discourse.nodered.org/t/wemo-switch-long-press/18800)

<div class="topic-metadata">

**Author:** [@stbraley](https://discourse.nodered.org/u/stbraley)\
**Replies:** 0\
**Last updated:** [4 December 2019 20:15 UTC](https://discourse.nodered.org/t/wemo-switch-long-press/18800 "2019-12-04T20:15:04Z")

</div>

All, it would be nice if the Wemo integration could detect the long press event from the Wemo switch. It looks like I just get on or off. The Wemo app supports it so I'm assuming it can be hooked into. I apologize if thi…

---

## [Convert datetime - template](https://discourse.nodered.org/t/convert-datetime-template/18606)

<div class="topic-metadata">

**Author:** [@EL\_tech](https://discourse.nodered.org/u/EL_tech)\
**Replies:** 17\
**Last updated:** [4 December 2019 18:27 UTC](https://discourse.nodered.org/t/convert-datetime-template/18606 "2019-12-04T18:27:20Z")

</div>

Hay! I try to convert a datetime (format: YYYY-MM-DDT00:00:00) from a json format and put it in a cell of a table to display it on the dashboard. It doesn't work and I don´t know how I get it. Sorry, I'm a beginner wi…

---

## [ Not too sure what I've messed up here. I'm trying to send a command to an API to control my aircon system](https://discourse.nodered.org/t/not-too-sure-what-ive-messed-up-here-im-trying-to-send-a-command-to-an-api-to-control-my-aircon-system/10213)

<div class="topic-metadata">

**Author:** [@simonk83](https://discourse.nodered.org/u/simonk83)\
**Replies:** 17\
**Last updated:** [4 December 2019 17:20 UTC](https://discourse.nodered.org/t/not-too-sure-what-ive-messed-up-here-im-trying-to-send-a-command-to-an-api-to-control-my-aircon-system/10213 "2019-12-04T17:20:12Z")

</div>

Hi all, So If I send the following command via curl in a terminal, it does work fine: curl \\ -H 'Host: que.actronair.com.au' \\ -H 'Accept: application/json' \\ -H 'Accept-Language: en-AU;q=1' \\ -H 'User-Agent: nxgen-ios…

---

## [CSV node access to deeper JSON object properties](https://discourse.nodered.org/t/csv-node-access-to-deeper-json-object-properties/18690)

<div class="topic-metadata">

**Author:** [@johngouk](https://discourse.nodered.org/u/johngouk)\
**Replies:** 5\
**Last updated:** [4 December 2019 16:22 UTC](https://discourse.nodered.org/t/csv-node-access-to-deeper-json-object-properties/18690 "2019-12-04T16:22:48Z")

</div>

I have JSON data with sub-structures which I'd like to convert to CSV e.g. {"Time":"2019-12-01T18:12:55" ,"SHT3X\_0x44”:{“Temperature":20.6,"Humidity":50.8} ,"SHT3X\_0x45":{"Temperature":20.6,"Humidity":50.8} ,"TempUni…

[Previous page](https://discourse.nodered.org/latest.md?page=1189)

[Next page](https://discourse.nodered.org/latest.md?page=1191)