# General

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

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

**Page:** 818

---

## [Object export from Messages](https://discourse.nodered.org/t/object-export-from-messages/19024)

<div class="topic-metadata">

**Author:** [@verdammt](https://discourse.nodered.org/u/verdammt)\
**Replies:** 4\
**Last updated:** [12 December 2019 18:49 UTC](https://discourse.nodered.org/t/object-export-from-messages/19024 "2019-12-12T18:49:02Z")

</div>

Hello and good day, I'm still at the beginning with NodeRed. I would like to extract all values ​​from an Object, then I would like to write these values ​​into a Influx Database. Which node can or must use for the extr…

---

## [Html drag & drop - template node - feedback](https://discourse.nodered.org/t/html-drag-drop-template-node-feedback/19043)

<div class="topic-metadata">

**Author:** [@RogierQ](https://discourse.nodered.org/u/RogierQ)\
**Replies:** 3\
**Last updated:** [12 December 2019 17:53 UTC](https://discourse.nodered.org/t/html-drag-drop-template-node-feedback/19043 "2019-12-12T17:53:13Z")

</div>

with the html example with the template node like below a have a drag and drop screen to sort steps. it works :wink: but nice that i can drag and drop data nut i really have no idea were to start to get data out of it …

---

## [Context from localfilesystem: flow.get synchronous error](https://discourse.nodered.org/t/context-from-localfilesystem-flow-get-synchronous-error/19079)

<div class="topic-metadata">

**Author:** [@gbrito](https://discourse.nodered.org/u/gbrito)\
**Replies:** 3\
**Last updated:** [12 December 2019 17:31 UTC](https://discourse.nodered.org/t/context-from-localfilesystem-flow-get-synchronous-error/19079 "2019-12-12T17:31:56Z")

</div>

Hi everyone, Using node-red v1.0.3 with nodejs v10. I've started to use the context from localFileSystem, for persistence. I managed to use it and store items with global.set(...) and flow.set(...) inside function nod…

---

## [Speed of sensors and node-red platform](https://discourse.nodered.org/t/speed-of-sensors-and-node-red-platform/18559)

<div class="topic-metadata">

**Author:** [@bmeester](https://discourse.nodered.org/u/bmeester)\
**Replies:** 22\
**Last updated:** [12 December 2019 15:51 UTC](https://discourse.nodered.org/t/speed-of-sensors-and-node-red-platform/18559 "2019-12-12T15:51:02Z")

</div>

Is it possible to get a payload from a sensor 10 times per second? I try to do this with my ultrasonic range finder but it seems it's can measure maybe once or twice per second.

---

## [Mqtt paho client to subscribe to thingboard topic](https://discourse.nodered.org/t/mqtt-paho-client-to-subscribe-to-thingboard-topic/19066)

<div class="topic-metadata">

**Author:** [@ahsan5109](https://discourse.nodered.org/u/ahsan5109)\
**Replies:** 2\
**Last updated:** [12 December 2019 11:02 UTC](https://discourse.nodered.org/t/mqtt-paho-client-to-subscribe-to-thingboard-topic/19066 "2019-12-12T11:02:43Z")

</div>

I want to connect the nodered mqtt client with thingsboard server....

---

## [Not able to connect mssql](https://discourse.nodered.org/t/not-able-to-connect-mssql/6111)

<div class="topic-metadata">

**Author:** [@akhilendharreddy](https://discourse.nodered.org/u/akhilendharreddy)\
**Replies:** 7\
**Last updated:** [11 December 2019 23:05 UTC](https://discourse.nodered.org/t/not-able-to-connect-mssql/6111 "2019-12-11T23:05:53Z")

</div>

my host: 10.0..\\SQLEXPRESS, not able to connect to this db via mssql node

---

## [Use injector topic in the url http request node](https://discourse.nodered.org/t/use-injector-topic-in-the-url-http-request-node/19015)

<div class="topic-metadata">

**Author:** [@pvanklink](https://discourse.nodered.org/u/pvanklink)\
**Replies:** 9\
**Last updated:** [11 December 2019 22:09 UTC](https://discourse.nodered.org/t/use-injector-topic-in-the-url-http-request-node/19015 "2019-12-11T22:09:33Z")

</div>

How can i use the injector topic in the url http request node ? this topic containts the id(example 1002) i use in the url http://192.168.20.35:82/json.htm?type=devices&rid=1002

---

## [Telldus API - async](https://discourse.nodered.org/t/telldus-api-async/19037)

<div class="topic-metadata">

**Author:** [@Ncedia](https://discourse.nodered.org/u/Ncedia)\
**Replies:** 1\
**Last updated:** [11 December 2019 19:12 UTC](https://discourse.nodered.org/t/telldus-api-async/19037 "2019-12-11T19:12:52Z")

</div>

Hi! I'm using https://github.com/mifi/telldus-api to control my Nexa/Telldus units with Node Red. Now I would like to read sensor data with the same library but are struggling with getting the data from a async functio…

---

## [Node-red can't connect to SQL server](https://discourse.nodered.org/t/node-red-cant-connect-to-sql-server/6129)

<div class="topic-metadata">

**Author:** [@gaara7271](https://discourse.nodered.org/u/gaara7271)\
**Replies:** 7\
**Last updated:** [11 December 2019 18:48 UTC](https://discourse.nodered.org/t/node-red-cant-connect-to-sql-server/6129 "2019-12-11T18:48:50Z")

</div>

i can't connect node red to sql server, i use node-red-contrib-mssql, i try node-red-contrib-mssql-plus, aslo too. i configure firewall. what should i do? Can you help me?

---

## [Convert ANSi (Win 1252) to UTF8 node-red-contrib-iconv](https://discourse.nodered.org/t/convert-ansi-win-1252-to-utf8-node-red-contrib-iconv/19038)

<div class="topic-metadata">

**Author:** [@gadziokos](https://discourse.nodered.org/u/gadziokos)\
**Replies:** 0\
**Last updated:** [11 December 2019 18:38 UTC](https://discourse.nodered.org/t/convert-ansi-win-1252-to-utf8-node-red-contrib-iconv/19038 "2019-12-11T18:38:49Z")

</div>

I have file on sftp server coded in ANSi (Win 1252, have letters like ą, ć ę etc.) I use SFTP node to connect. After that I use function and take data like this (msg.payload = Buffer.from(msg.payload.filedata, 'binary').…

---

## [How to change the theme for node-red](https://discourse.nodered.org/t/how-to-change-the-theme-for-node-red/7144)

<div class="topic-metadata">

**Author:** [@VIKRAMAS](https://discourse.nodered.org/u/VIKRAMAS)\
**Replies:** 4\
**Last updated:** [11 December 2019 18:12 UTC](https://discourse.nodered.org/t/how-to-change-the-theme-for-node-red/7144 "2019-12-11T18:12:54Z")

</div>

In node-red how to change the name of the editor and the theme. And create a installer for that modified project. I am new to node-red(new to node.js also). Is it possible to create a multi-tenant architecture in node-…

---

## [Function: convert Messages to array](https://discourse.nodered.org/t/function-convert-messages-to-array/18872)

<div class="topic-metadata">

**Author:** [@EL\_tech](https://discourse.nodered.org/u/EL_tech)\
**Replies:** 10\
**Last updated:** [11 December 2019 17:26 UTC](https://discourse.nodered.org/t/function-convert-messages-to-array/18872 "2019-12-11T17:26:07Z")

</div>

Hello guys, I want to create as output from a function an array from incoming datas like this example; example "Phone". My code, modified from this example: var m\_out = \[\]; for (int i=0; i\<=3; i++) { var newmsg = {pay…

---

## [Serial-port nodes failing to receive and transmit within the same flow](https://discourse.nodered.org/t/serial-port-nodes-failing-to-receive-and-transmit-within-the-same-flow/18956)

<div class="topic-metadata">

**Author:** [@123](https://discourse.nodered.org/u/123)\
**Replies:** 12\
**Last updated:** [11 December 2019 16:15 UTC](https://discourse.nodered.org/t/serial-port-nodes-failing-to-receive-and-transmit-within-the-same-flow/18956 "2019-12-11T16:15:57Z")

</div>

I require assistance to debug a problem I've encountered when using the serial port nodes. My ultimate goal is to create a UPB to MQTT converter (Universal Powerline Bus; a lighting-control protocol). However, it's earl…

---

## [Calculate rainfall per 24h](https://discourse.nodered.org/t/calculate-rainfall-per-24h/4167)

<div class="topic-metadata">

**Author:** [@Florian](https://discourse.nodered.org/u/Florian)\
**Replies:** 43\
**Last updated:** [11 December 2019 16:15 UTC](https://discourse.nodered.org/t/calculate-rainfall-per-24h/4167 "2019-12-11T16:15:11Z")

</div>

(english below) Hallo, ich empfange von einer Wetterstation das Payload (payload.rainfall.total.value) für die aktuelle Regenmenge. Leider besteht keine Möglichkeit, die Regenmenge für einen Tag (24h) zu erfassen und d…

---

## [How to use other js files](https://discourse.nodered.org/t/how-to-use-other-js-files/18999)

<div class="topic-metadata">

**Author:** [@john88](https://discourse.nodered.org/u/john88)\
**Replies:** 7\
**Last updated:** [11 December 2019 13:24 UTC](https://discourse.nodered.org/t/how-to-use-other-js-files/18999 "2019-12-11T13:24:24Z")

</div>

Hi I want to use other js file in a function node. How can I use it? ex\> my.js file function AAA () { var result = "hi"; return result; } How can I use the AAA functions in my.js file inside a function node? th…

---

## [Access SQLite DB directly from the Function node](https://discourse.nodered.org/t/access-sqlite-db-directly-from-the-function-node/19002)

<div class="topic-metadata">

**Author:** [@Spraga](https://discourse.nodered.org/u/Spraga)\
**Replies:** 1\
**Last updated:** [10 December 2019 18:09 UTC](https://discourse.nodered.org/t/access-sqlite-db-directly-from-the-function-node/19002 "2019-12-10T18:09:52Z")

</div>

Does anybody know if it's possible to access a SQLite db file and execute queries directly from code in the Function node?

---

## [How to avoid spikes](https://discourse.nodered.org/t/how-to-avoid-spikes/18992)

<div class="topic-metadata">

**Author:** [@jaeti01](https://discourse.nodered.org/u/jaeti01)\
**Replies:** 1\
**Last updated:** [10 December 2019 14:08 UTC](https://discourse.nodered.org/t/how-to-avoid-spikes/18992 "2019-12-10T14:08:47Z")

</div>

Hi, i am fairly green with node-red and need some quick advise please. I have a message coming in on an http input node (iBeacon URL call) and some activity pending upon it. Now i have the problem thsat sometimes I ha…

---

## [Join node and Table ui problem](https://discourse.nodered.org/t/join-node-and-table-ui-problem/18993)

<div class="topic-metadata">

**Author:** [@nikza5566](https://discourse.nodered.org/u/nikza5566)\
**Replies:** 0\
**Last updated:** [10 December 2019 13:07 UTC](https://discourse.nodered.org/t/join-node-and-table-ui-problem/18993 "2019-12-10T13:07:42Z")

</div>

I had a problem when I use a join node to make an array JSON form. I have 5 function node that write payload to a table msg.payload = { "Load": "Lamp", "Usage": true, "Up-Time": "00:00" }; ^This i…

---

## ["Refresh on selection change" - context stuff. Help](https://discourse.nodered.org/t/refresh-on-selection-change-context-stuff-help/18970)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 4\
**Last updated:** [10 December 2019 10:38 UTC](https://discourse.nodered.org/t/refresh-on-selection-change-context-stuff-help/18970 "2019-12-10T10:38:20Z")

</div>

NR 1.0.3. In the context menu I can see node, flow and global context variables. There is this nice box (un-ticked by default) for all three. Though the node one is of interest to me at this point. I tick it and it …

---

## [Raspberry Pi - Hall Effect Sensor](https://discourse.nodered.org/t/raspberry-pi-hall-effect-sensor/18968)

<div class="topic-metadata">

**Author:** [@nakiabrewer](https://discourse.nodered.org/u/nakiabrewer)\
**Replies:** 5\
**Last updated:** [10 December 2019 10:06 UTC](https://discourse.nodered.org/t/raspberry-pi-hall-effect-sensor/18968 "2019-12-10T10:06:56Z")

</div>

Hi Everyone, Tried searching on this topic but didn't turn up anything that really guided me to solution mode. Looking for some advice on how I might interface this sensor: https://core-electronics.com.au/g1-4-water-fl…

---

## [Store and Push Node-red flow](https://discourse.nodered.org/t/store-and-push-node-red-flow/18977)

<div class="topic-metadata">

**Author:** [@dhavalm24](https://discourse.nodered.org/u/dhavalm24)\
**Replies:** 0\
**Last updated:** [10 December 2019 09:00 UTC](https://discourse.nodered.org/t/store-and-push-node-red-flow/18977 "2019-12-10T09:00:57Z")

</div>

Hello, Our requirement is to create store and Push node-red flow for Outdoor Multitech gateways as they would not have constant network access, the data should be pushed when there is network access. Do let us know the…

---

## [I am getting error please help me](https://discourse.nodered.org/t/i-am-getting-error-please-help-me/18906)

<div class="topic-metadata">

**Author:** [@sandeepanj](https://discourse.nodered.org/u/sandeepanj)\
**Replies:** 5\
**Last updated:** [10 December 2019 05:15 UTC](https://discourse.nodered.org/t/i-am-getting-error-please-help-me/18906 "2019-12-10T05:15:25Z")

</div>

8 Dec 16:04:56 - \[info\] Waiting for missing types to be registered: 8 Dec 16:04:56 - \[info\] - server 8 Dec 16:04:56 - \[info\] - profile i dont know what is server and profile node. i am unable to deploy my node. it i…

---

## [Email Node In - Search for String](https://discourse.nodered.org/t/email-node-in-search-for-string/18955)

<div class="topic-metadata">

**Author:** [@Gc5lear](https://discourse.nodered.org/u/Gc5lear)\
**Replies:** 5\
**Last updated:** [9 December 2019 22:05 UTC](https://discourse.nodered.org/t/email-node-in-search-for-string/18955 "2019-12-09T22:05:50Z")

</div>

Hi all, I’ve installed Hassio and Node Red today and what I want to do seems simple enough in theory but can’t find an obvious answer anywhere online. I managed to create an email in and out node and the work just fine,…

---

## [Need help - Syntax MSSQL Insert Statement from a msg.payload](https://discourse.nodered.org/t/need-help-syntax-mssql-insert-statement-from-a-msg-payload/18941)

<div class="topic-metadata">

**Author:** [@joachimmm](https://discourse.nodered.org/u/joachimmm)\
**Replies:** 3\
**Last updated:** [9 December 2019 20:17 UTC](https://discourse.nodered.org/t/need-help-syntax-mssql-insert-statement-from-a-msg-payload/18941 "2019-12-09T20:17:06Z")

</div>

Hello, what ist the generell Syntax fo executing a MSSQL insert statement from a msg.payload? I've installed the mssql node. with a fixed value works I have success.. Thank you jo

---

## [Avoid "node" as a variable name in functions](https://discourse.nodered.org/t/avoid-node-as-a-variable-name-in-functions/18924)

<div class="topic-metadata">

**Author:** [@drmibell](https://discourse.nodered.org/u/drmibell)\
**Replies:** 7\
**Last updated:** [9 December 2019 17:20 UTC](https://discourse.nodered.org/t/avoid-node-as-a-variable-name-in-functions/18924 "2019-12-09T17:20:40Z")

</div>

It took me a few minutes to sort this one out. The code in my (demo) function node is: node.warn('hello world'); var node = 'hello world'; node.warn('hello world'); return msg; The third line throws an error, "TypeErro…

---

## [Flow variable changes when it shouldn't](https://discourse.nodered.org/t/flow-variable-changes-when-it-shouldnt/18952)

<div class="topic-metadata">

**Author:** [@Miniu](https://discourse.nodered.org/u/Miniu)\
**Replies:** 2\
**Last updated:** [9 December 2019 15:07 UTC](https://discourse.nodered.org/t/flow-variable-changes-when-it-shouldnt/18952 "2019-12-09T15:07:18Z")

</div>

Hi Developers, As you'll notice in the code below, I'm only using the flow.get method, I'm not using the set method anywhere. Unfortunately, despite entering anything into the text node, my flow variable in memory also…

---

## [Access object value using position not name](https://discourse.nodered.org/t/access-object-value-using-position-not-name/18945)

<div class="topic-metadata">

**Author:** [@cymplecy](https://discourse.nodered.org/u/cymplecy)\
**Replies:** 7\
**Last updated:** [9 December 2019 14:10 UTC](https://discourse.nodered.org/t/access-object-value-using-position-not-name/18945 "2019-12-09T14:10:20Z")

</div>

My JSON/JSONata-fu has gone missing :frowning: If I've got a msg.payload object { "uuid":"fd8916521157", "characteristics": { "notification":true, "e95d9250251d470aa062fa1922dfa9a8":23 } } Can …

---

## [UI Display not showing full graph after reset](https://discourse.nodered.org/t/ui-display-not-showing-full-graph-after-reset/18944)

<div class="topic-metadata">

**Author:** [@Pac8](https://discourse.nodered.org/u/Pac8)\
**Replies:** 4\
**Last updated:** [9 December 2019 13:31 UTC](https://discourse.nodered.org/t/ui-display-not-showing-full-graph-after-reset/18944 "2019-12-09T13:31:48Z")

</div>

This may be a pretty juvenile question but I am having trouble with my UI where it will not display in full after a reset. I move about nodes and do full and modified deploys but it will work again after a bit of messing…

---

## [Timestamp + additonal value in function node](https://discourse.nodered.org/t/timestamp-additonal-value-in-function-node/18946)

<div class="topic-metadata">

**Author:** [@maku12](https://discourse.nodered.org/u/maku12)\
**Replies:** 1\
**Last updated:** [9 December 2019 13:12 UTC](https://discourse.nodered.org/t/timestamp-additonal-value-in-function-node/18946 "2019-12-09T13:12:30Z")

</div>

Hi, how can I add some additional info in a timestamp and function node. For example: Klick on Inject: the current timestamp+variables or text from a functions node should be displayed. output should be: 157589271296…

---

## [Simple question for you guys/girls; brain twister for me](https://discourse.nodered.org/t/simple-question-for-you-guys-girls-brain-twister-for-me/18752)

<div class="topic-metadata">

**Author:** [@zuchi238](https://discourse.nodered.org/u/zuchi238)\
**Replies:** 34\
**Last updated:** [9 December 2019 08:37 UTC](https://discourse.nodered.org/t/simple-question-for-you-guys-girls-brain-twister-for-me/18752 "2019-12-09T08:37:32Z")

</div>

(Intro: I'm new to NR; am planning to use Node Red on my sailing boat; Have raspi with Openplotter; and now I need to know my fuel en de weather). Here we go Have Arduino with simple sketch with digital barometer (BMP2…

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

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