# General

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

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

**Page:** 928

---

## [JSONata - time picture construct not working?](https://discourse.nodered.org/t/jsonata-time-picture-construct-not-working/5981)

<div class="topic-metadata">

**Author:** [@IoTPlay](https://discourse.nodered.org/u/IoTPlay)\
**Replies:** 3\
**Last updated:** [20 December 2018 13:18 UTC](https://discourse.nodered.org/t/jsonata-time-picture-construct-not-working/5981 "2018-12-20T13:18:45Z")

</div>

Hello to JSONata bofs, This statement does not work: $fromMillis(($.timestamp), '\[D\]/\[M\]/\[Y\]') but this one does: $fromMillis(($.timestamp)') Does this mean that the picture construct per JSONata docs was not implem…

---

## [Try catch in flows](https://discourse.nodered.org/t/try-catch-in-flows/5977)

<div class="topic-metadata">

**Author:** [@akhilendharreddy](https://discourse.nodered.org/u/akhilendharreddy)\
**Replies:** 3\
**Last updated:** [20 December 2018 09:24 UTC](https://discourse.nodered.org/t/try-catch-in-flows/5977 "2018-12-20T09:24:36Z")

</div>

how can i achieve try and catch blocks in flows if any error i want to call the flow again? is this possible?

---

## [Display local image in pdf file](https://discourse.nodered.org/t/display-local-image-in-pdf-file/5702)

<div class="topic-metadata">

**Author:** [@hathemi](https://discourse.nodered.org/u/hathemi)\
**Replies:** 11\
**Last updated:** [20 December 2018 02:01 UTC](https://discourse.nodered.org/t/display-local-image-in-pdf-file/5702 "2018-12-20T02:01:36Z")

</div>

i'am using HTML-PDF node to create a a pdf file. i send a table in mustache template node as an input and it create me a pdf file containing that table. My problem is, i went to add a local image inside that table. i ha…

---

## [Specific Time format?](https://discourse.nodered.org/t/specific-time-format/5945)

<div class="topic-metadata">

**Author:** [@Naesstrom](https://discourse.nodered.org/u/Naesstrom)\
**Replies:** 18\
**Last updated:** [19 December 2018 19:17 UTC](https://discourse.nodered.org/t/specific-time-format/5945 "2018-12-19T19:17:18Z")

</div>

So I'm trying to follow the instructions on the MET Office API to upload my weatherdata to their global site and I've joined all my different mqtt flows etc. but having problem with the time format. In their manual they…

---

## [Value from Payload is empty](https://discourse.nodered.org/t/value-from-payload-is-empty/5965)

<div class="topic-metadata">

**Author:** [@Lee](https://discourse.nodered.org/u/Lee)\
**Replies:** 2\
**Last updated:** [19 December 2018 15:24 UTC](https://discourse.nodered.org/t/value-from-payload-is-empty/5965 "2018-12-19T15:24:35Z")

</div>

I am new to red node and trying to set up a flow to insert messages in a MS SQL database. I am having difficulty passing the values from the payload to the query. I can successfully insert into my table as long as a do…

---

## [Flows visibility](https://discourse.nodered.org/t/flows-visibility/5961)

<div class="topic-metadata">

**Author:** [@Lionel](https://discourse.nodered.org/u/Lionel)\
**Replies:** 2\
**Last updated:** [19 December 2018 14:47 UTC](https://discourse.nodered.org/t/flows-visibility/5961 "2018-12-19T14:47:43Z")

</div>

Hi, Our node-red application is intended to be exposed to many partners, and we would like to filter the visible flows for each partner. Is it possible ? Thx

---

## [Send http request using delay node](https://discourse.nodered.org/t/send-http-request-using-delay-node/5950)

<div class="topic-metadata">

**Author:** [@NRIT](https://discourse.nodered.org/u/NRIT)\
**Replies:** 6\
**Last updated:** [19 December 2018 09:51 UTC](https://discourse.nodered.org/t/send-http-request-using-delay-node/5950 "2018-12-19T09:51:25Z")

</div>

Hi all, I'm developing a simple node red IoT project In particular, when a sensor value is over a threshold, an http request is performed against a ticket system and, if doesn't yet exist, a ticket is opened This is o…

---

## [Email HTML Table from core Template Node](https://discourse.nodered.org/t/email-html-table-from-core-template-node/5897)

<div class="topic-metadata">

**Author:** [@wikus](https://discourse.nodered.org/u/wikus)\
**Replies:** 1\
**Last updated:** [19 December 2018 03:56 UTC](https://discourse.nodered.org/t/email-html-table-from-core-template-node/5897 "2018-12-19T03:56:58Z")

</div>

Hi guys, I have an HTTP end point that generates an HTML table for reporting purposes. I want to use this same flow to extract the HTML and send via email. The HTTP Out generates the table perfectly, but when I want to …

---

## [Input type date ng-model](https://discourse.nodered.org/t/input-type-date-ng-model/5941)

<div class="topic-metadata">

**Author:** [@hathemi](https://discourse.nodered.org/u/hathemi)\
**Replies:** 3\
**Last updated:** [19 December 2018 03:02 UTC](https://discourse.nodered.org/t/input-type-date-ng-model/5941 "2018-12-19T03:02:44Z")

</div>

i have affect curent day to the input date to be the default valut. how can i affect this value to ng-model?? also how an i use input type date with ng-model without getting this error in send. \`\`\` Error: \[ngModel:da…

---

## [Modifying the MQTT Node to use periodically changing passwords](https://discourse.nodered.org/t/modifying-the-mqtt-node-to-use-periodically-changing-passwords/5899)

<div class="topic-metadata">

**Author:** [@gk9](https://discourse.nodered.org/u/gk9)\
**Replies:** 10\
**Last updated:** [18 December 2018 17:00 UTC](https://discourse.nodered.org/t/modifying-the-mqtt-node-to-use-periodically-changing-passwords/5899 "2018-12-18T17:00:16Z")

</div>

Hello, I would like to connect to an MQTT Broker that periodically changes its access password. The standard implementation of the Node Red MQTT Node is not able to handle this "dynamic" change of passwords. I am planni…

---

## [Virtual keyboard in any text fields](https://discourse.nodered.org/t/virtual-keyboard-in-any-text-fields/5712)

<div class="topic-metadata">

**Author:** [@hathemi](https://discourse.nodered.org/u/hathemi)\
**Replies:** 25\
**Last updated:** [18 December 2018 16:24 UTC](https://discourse.nodered.org/t/virtual-keyboard-in-any-text-fields/5712 "2018-12-18T16:24:03Z")

</div>

is it possible todisplay a virtual keyboard in any textfields ?

---

## [Error in EXEC node](https://discourse.nodered.org/t/error-in-exec-node/5800)

<div class="topic-metadata">

**Author:** [@Indolec](https://discourse.nodered.org/u/Indolec)\
**Replies:** 6\
**Last updated:** [18 December 2018 15:51 UTC](https://discourse.nodered.org/t/error-in-exec-node/5800 "2018-12-18T15:51:09Z")

</div>

Just discovered NODE-RED and still learning the basics... Hardware is Raspberry Pi. Designed a flow, with a few exec nodes. Works perfectly on Rpi/Raspbian, commands work in Terminal. Now I want to run the flow on an…

---

## [Watch node producing 2 payloads upon file creation](https://discourse.nodered.org/t/watch-node-producing-2-payloads-upon-file-creation/5938)

<div class="topic-metadata">

**Author:** [@ThanosMel](https://discourse.nodered.org/u/ThanosMel)\
**Replies:** 3\
**Last updated:** [18 December 2018 14:28 UTC](https://discourse.nodered.org/t/watch-node-producing-2-payloads-upon-file-creation/5938 "2018-12-18T14:28:45Z")

</div>

I have a simple test flow to demonstrate my problem. This is my flow \[{"id":"d32c1f48.87f48","type":"tab","label":"Test flow","disabled":false,"info":""},{"id":"8c67530a.53a1f","type":"inject","z":"d32c1f48.87f48","nam…

---

## [Suppress Review Changes/Merge warning on editor after add/delete/change flow(s)](https://discourse.nodered.org/t/suppress-review-changes-merge-warning-on-editor-after-add-delete-change-flow-s/5936)

<div class="topic-metadata">

**Author:** [@gbrito](https://discourse.nodered.org/u/gbrito)\
**Replies:** 0\
**Last updated:** [18 December 2018 13:42 UTC](https://discourse.nodered.org/t/suppress-review-changes-merge-warning-on-editor-after-add-delete-change-flow-s/5936 "2018-12-18T13:42:41Z")

</div>

Hi all, Is there any option on NR settings that can make the editor to Automatically Merge after using the Admin API to add / delete /change flows? I've been working with NR for few months now, and when I use some appl…

---

## [Twitter bot using Nod-RED](https://discourse.nodered.org/t/twitter-bot-using-nod-red/5922)

<div class="topic-metadata">

**Author:** [@Rahul\_Mathavan](https://discourse.nodered.org/u/Rahul_Mathavan)\
**Replies:** 15\
**Last updated:** [18 December 2018 10:03 UTC](https://discourse.nodered.org/t/twitter-bot-using-nod-red/5922 "2018-12-18T10:03:08Z")

</div>

Hi , I have created a simple Twitter bot in Node-RED,( with the twitter node updated version),but i'm not able to display messages on twitter. Could you please help me out with this. Thank you.

---

## [PLC configuration](https://discourse.nodered.org/t/plc-configuration/5912)

<div class="topic-metadata">

**Author:** [@manal](https://discourse.nodered.org/u/manal)\
**Replies:** 8\
**Last updated:** [18 December 2018 09:06 UTC](https://discourse.nodered.org/t/plc-configuration/5912 "2018-12-18T09:06:29Z")

</div>

Hi all, I am reading values from PLC (modbus/tcp) which has analog sensor using modbus node red, and I used input anolog register and read one register. it returns values such as \[ 9088\]. and it works switch on/off LE…

---

## [Call service node Data inject msg.payload](https://discourse.nodered.org/t/call-service-node-data-inject-msg-payload/5909)

<div class="topic-metadata">

**Author:** [@AZDane](https://discourse.nodered.org/u/AZDane)\
**Replies:** 1\
**Last updated:** [18 December 2018 06:14 UTC](https://discourse.nodered.org/t/call-service-node-data-inject-msg-payload/5909 "2018-12-18T06:14:17Z")

</div>

I'm using a call service node to call alexa\_tts. I want her to say the string from the msg.payload from the previous node. A working Data field looks like this: {"message":"This is a test"} How do i replace "This is a…

---

## [Re-use/duplicate flows](https://discourse.nodered.org/t/re-use-duplicate-flows/5906)

<div class="topic-metadata">

**Author:** [@m\_elias](https://discourse.nodered.org/u/m_elias)\
**Replies:** 2\
**Last updated:** [17 December 2018 23:38 UTC](https://discourse.nodered.org/t/re-use-duplicate-flows/5906 "2018-12-17T23:38:14Z")

</div>

Hi, I've just started tinkering with Node Red and have a couple decent flows going. I'd like to setup a flow that subscribes to a few MQTT topics (auto mode \[yes:no\], trigger temperature and current temperature) to auto…

---

## [In node red how to get the number of TCP connections or websocket connections count](https://discourse.nodered.org/t/in-node-red-how-to-get-the-number-of-tcp-connections-or-websocket-connections-count/5870)

<div class="topic-metadata">

**Author:** [@Satishpujari](https://discourse.nodered.org/u/Satishpujari)\
**Replies:** 11\
**Last updated:** [17 December 2018 18:47 UTC](https://discourse.nodered.org/t/in-node-red-how-to-get-the-number-of-tcp-connections-or-websocket-connections-count/5870 "2018-12-17T18:47:30Z")

</div>

In node red how to get the number of TCP connections or websocket connections count to create the dashboard.

---

## [INSERT hexadecimal in SQLITE](https://discourse.nodered.org/t/insert-hexadecimal-in-sqlite/5884)

<div class="topic-metadata">

**Author:** [@Andre](https://discourse.nodered.org/u/Andre)\
**Replies:** 6\
**Last updated:** [17 December 2018 17:44 UTC](https://discourse.nodered.org/t/insert-hexadecimal-in-sqlite/5884 "2018-12-17T17:44:56Z")

</div>

I would like to add a hexidecimal key of an RFID tag like 3D433FF4A in SQlite This is my code to create a table in Sqlite: CREATE TABLE userlist\_9(currentdate DATE, rfid TEXT, number INTEGER) This is my code to add …

---

## [How to set websocket header](https://discourse.nodered.org/t/how-to-set-websocket-header/5894)

<div class="topic-metadata">

**Author:** [@stefan0r](https://discourse.nodered.org/u/stefan0r)\
**Replies:** 0\
**Last updated:** [17 December 2018 16:40 UTC](https://discourse.nodered.org/t/how-to-set-websocket-header/5894 "2018-12-17T16:40:44Z")

</div>

Hi all!:smiley: How can I set header on a websocket client? Thank you for yours aid s

---

## [Serial port / raspberry](https://discourse.nodered.org/t/serial-port-raspberry/5868)

<div class="topic-metadata">

**Author:** [@RogierQ](https://discourse.nodered.org/u/RogierQ)\
**Replies:** 4\
**Last updated:** [17 December 2018 15:37 UTC](https://discourse.nodered.org/t/serial-port-raspberry/5868 "2018-12-17T15:37:34Z")

</div>

I have 8 arduino's connected to my pi after a few days randomly a serial port disconnects only way to solve this problem is doing a reboot and then it works again for few days / hours is this a known problem or is the…

---

## [Secure different routes with different user](https://discourse.nodered.org/t/secure-different-routes-with-different-user/5883)

<div class="topic-metadata">

**Author:** [@Georg25](https://discourse.nodered.org/u/Georg25)\
**Replies:** 3\
**Last updated:** [17 December 2018 13:16 UTC](https://discourse.nodered.org/t/secure-different-routes-with-different-user/5883 "2018-12-17T13:16:06Z")

</div>

Hi, is there a way to secure :1880/ui with another user and password as :1880/mui ? Georg

---

## [Thonny code to Node-Red](https://discourse.nodered.org/t/thonny-code-to-node-red/5875)

<div class="topic-metadata">

**Author:** [@IvarMvl](https://discourse.nodered.org/u/IvarMvl)\
**Replies:** 1\
**Last updated:** [17 December 2018 11:19 UTC](https://discourse.nodered.org/t/thonny-code-to-node-red/5875 "2018-12-17T11:19:41Z")

</div>

So im am using the code below in thonny and am now trying to make it in a Node-red flow . I'm not really familiar with coding so I dont know how it all work. thank you in advance. import RPi.GPIO as GPIO GPIO.setmod…

---

## [Some node installs failing](https://discourse.nodered.org/t/some-node-installs-failing/5869)

<div class="topic-metadata">

**Author:** [@scargill](https://discourse.nodered.org/u/scargill)\
**Replies:** 8\
**Last updated:** [17 December 2018 10:49 UTC](https://discourse.nodered.org/t/some-node-installs-failing/5869 "2018-12-17T10:49:18Z")

</div>

I have my working Node-Red setup on RPI3, bang up to date, I just used the pallette manager and updated a few modules. But, feedparser, twitter and RBE are just not having it... so user pi, I even stopped NR, went into …

---

## [Sqlite not shown on Raspberry Pi](https://discourse.nodered.org/t/sqlite-not-shown-on-raspberry-pi/5479)

<div class="topic-metadata">

**Author:** [@Andre](https://discourse.nodered.org/u/Andre)\
**Replies:** 14\
**Last updated:** [17 December 2018 10:24 UTC](https://discourse.nodered.org/t/sqlite-not-shown-on-raspberry-pi/5479 "2018-12-17T10:24:04Z")

</div>

Hey, I have just installed Sqlite in node red on a raspberry via the pallete manager, but in node red it is not in the list? how is this possible? normal sql is is only in the list.

---

## [Save values on a table / multidimensional array](https://discourse.nodered.org/t/save-values-on-a-table-multidimensional-array/5793)

<div class="topic-metadata">

**Author:** [@britzz](https://discourse.nodered.org/u/britzz)\
**Replies:** 11\
**Last updated:** [17 December 2018 10:21 UTC](https://discourse.nodered.org/t/save-values-on-a-table-multidimensional-array/5793 "2018-12-17T10:21:50Z")

</div>

Dear all, First of all, I apologize for this dumb question for most of you, but my programming background relies mostly on embedded C and I am now taking my first steps in Node-red, Json, MQTT, etc. I am working on Das…

---

## [Newbie in need of clarifications](https://discourse.nodered.org/t/newbie-in-need-of-clarifications/5865)

<div class="topic-metadata">

**Author:** [@jaiy](https://discourse.nodered.org/u/jaiy)\
**Replies:** 1\
**Last updated:** [17 December 2018 07:37 UTC](https://discourse.nodered.org/t/newbie-in-need-of-clarifications/5865 "2018-12-17T07:37:15Z")

</div>

According to the tutorial I would be able to capture all 4 messages however as seen in the screenshot I am only able to capture the first 3 and not the fourth one.

---

## [Transfering node-red server to linux](https://discourse.nodered.org/t/transfering-node-red-server-to-linux/5824)

<div class="topic-metadata">

**Author:** [@patrolin](https://discourse.nodered.org/u/patrolin)\
**Replies:** 10\
**Last updated:** [17 December 2018 01:33 UTC](https://discourse.nodered.org/t/transfering-node-red-server-to-linux/5824 "2018-12-17T01:33:04Z")

</div>

hey guys, got node-red on windows running sweet. want to transition it all to my linux box thats setup running rasbian. is there a easy way to transfer my flows and all that?

---

## [How to make a counter incoming\\outgoing on two sensors?](https://discourse.nodered.org/t/how-to-make-a-counter-incoming-outgoing-on-two-sensors/5839)

<div class="topic-metadata">

**Author:** [@Sergii](https://discourse.nodered.org/u/Sergii)\
**Replies:** 5\
**Last updated:** [17 December 2018 01:00 UTC](https://discourse.nodered.org/t/how-to-make-a-counter-incoming-outgoing-on-two-sensors/5839 "2018-12-17T01:00:25Z")

</div>

Hi! Immediately apologize for my "google translate"... System: Raspberry PI 3b, iobroker, Node-RED v0.18.4. I have two sensors E18-D80NK, they react to the passage of man. Sensor signals are displayed in iobroker and a…

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

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