# How to use msg.payload in INFLUXDB V2.4 query

**URL:** <https://discourse.nodered.org/t/how-to-use-msg-payload-in-influxdb-v2-4-query/68803>\
**Category:** General\
**Created:** [10 October 2022 12:35 UTC](https://discourse.nodered.org/t/how-to-use-msg-payload-in-influxdb-v2-4-query/68803 "2022-10-10T12:35:33Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![HomeByKasbah](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/homebykasbah/32/68944_2.png) [@HomeByKasbah](https://discourse.nodered.org/u/HomeByKasbah)\
**Post date:** [10 October 2022 12:35 UTC](https://discourse.nodered.org/t/how-to-use-msg-payload-in-influxdb-v2-4-query/68803/1 "2022-10-10T12:35:33Z")

</div>

Hello,  
How to introduce the msg.payload variable in an influxDB V2.4 query. I want to put it in range(start: ).  
\</  
msg.query=['from(bucket: "Temp")',  
' |\> range(start:"msg.payload")',  
' |\> filter(fn: (r) =\> r["\_measurement"] == "Temperature 1")',  
].join('\n');  
return message;  
/\>

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [10 October 2022 12:55 UTC](https://discourse.nodered.org/t/how-to-use-msg-payload-in-influxdb-v2-4-query/68803/2 "2022-10-10T12:55:20Z")

</div>

You can use a Template node (not ui\_template) to create the query with the payload value embedded.

**[Edit]** Note that the query does not need to be on multiple lines, it can all be in one simple string.

---

<div class="post-metadata">

**Author:** ![HomeByKasbah](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/homebykasbah/32/68944_2.png) [@HomeByKasbah](https://discourse.nodered.org/u/HomeByKasbah)\
**Post date:** [10 October 2022 13:11 UTC](https://discourse.nodered.org/t/how-to-use-msg-payload-in-influxdb-v2-4-query/68803/3 "2022-10-10T13:11:08Z")

</div>

Thank you Colin,  
Have you an exemple please.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [10 October 2022 13:20 UTC](https://discourse.nodered.org/t/how-to-use-msg-payload-in-influxdb-v2-4-query/68803/4 "2022-10-10T13:20:17Z")

</div>

An example of what?  
Did you read the help text for the Template node?

---

<div class="post-metadata">

**Author:** ![HomeByKasbah](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/homebykasbah/32/68944_2.png) [@HomeByKasbah](https://discourse.nodered.org/u/HomeByKasbah)\
**Post date:** [10 October 2022 14:01 UTC](https://discourse.nodered.org/t/how-to-use-msg-payload-in-influxdb-v2-4-query/68803/5 "2022-10-10T14:01:01Z")

</div>

here is how i made the query, what i want is to use msg.payload as variable.

```auto
[{"id":"f77dfd0998d3cc46","type":"function","z":"1abeef9a268f3612","name":"","func":"//var var01=msg.payload;\nmsg.query='from(bucket: \"Temp\") |> range(start:-5h) |> filter(fn: (r) => r[\"_measurement\"] == \"Temperature 1\")';\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":260,"y":120,"wires":[["652b68907d4f05fb","a6332a1590c698ff"]]}]

```

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [10 October 2022 14:10 UTC](https://discourse.nodered.org/t/how-to-use-msg-payload-in-influxdb-v2-4-query/68803/6 "2022-10-10T14:10:33Z")

</div>

It is much easier using a Template node as I suggested.

---

<div class="post-metadata">

**Author:** ![HomeByKasbah](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/homebykasbah/32/68944_2.png) [@HomeByKasbah](https://discourse.nodered.org/u/HomeByKasbah)\
**Post date:** [10 October 2022 17:28 UTC](https://discourse.nodered.org/t/how-to-use-msg-payload-in-influxdb-v2-4-query/68803/7 "2022-10-10T17:28:40Z")

</div>

Thank you i try it

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [10 October 2022 20:56 UTC](https://discourse.nodered.org/t/how-to-use-msg-payload-in-influxdb-v2-4-query/68803/8 "2022-10-10T20:56:07Z")

</div>

Just for completeness, if you ever do need to do stuff like this in a function node then the neatest way is to use the [template literal](https://www.w3schools.com/js/js_string_templates.asp) syntax. So something like

```auto
msg.query = `from(bucket: "Temp") |> range(start:${msg.payload}) |> filter(fn: (r) => r["_measurement"] == "Temperature 1")`
return msg;

```

---

<div class="post-metadata">

**Author:** ![HomeByKasbah](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/homebykasbah/32/68944_2.png) [@HomeByKasbah](https://discourse.nodered.org/u/HomeByKasbah)\
**Post date:** [11 October 2022 08:47 UTC](https://discourse.nodered.org/t/how-to-use-msg-payload-in-influxdb-v2-4-query/68803/9 "2022-10-11T08:47:01Z")

</div>

I tried that and it works.

```auto
var var01=msg.payload;
msg.query='from(bucket: "Temp")'+
' |> range(start:-'+var01+')'+
' |> filter(fn: (r) => r["_measurement"] == "Temperature 1")';

return msg;

```

Thank you for help

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [11 October 2022 09:12 UTC](https://discourse.nodered.org/t/how-to-use-msg-payload-in-influxdb-v2-4-query/68803/10 "2022-10-11T09:12:27Z")

</div>

That is not what I suggested, and it would have been even easier in a Template node containing:  
`from(bucket: "Temp") |> range(start: {{payload}}) |> filter(fn: (r) => r["_measurement"] == "Temperature 1")`  
That is exactly what the Template node is for.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [10 December 2022 09:13 UTC](https://discourse.nodered.org/t/how-to-use-msg-payload-in-influxdb-v2-4-query/68803/11 "2022-12-10T09:13:10Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.