# Adding temp and humidity to influxdb

**URL:** <https://discourse.nodered.org/t/adding-temp-and-humidity-to-influxdb/38677>\
**Category:** General\
**Created:** [6 January 2021 19:23 UTC](https://discourse.nodered.org/t/adding-temp-and-humidity-to-influxdb/38677 "2021-01-06T19:23:20Z")\
**Posts on this page:** 4\
**Page:** 2

<div class="post-metadata">

**Author:** ![jfabernathy](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/jfabernathy/32/34883_2.png) [@jfabernathy](https://discourse.nodered.org/u/jfabernathy)\
**Post date:** [8 January 2021 14:16 UTC](https://discourse.nodered.org/t/adding-temp-and-humidity-to-influxdb/38677/21 "2021-01-08T14:16:30Z")

</div>

To close this out, what I got to work was a Nodered MQTT in node connected to topic reading a parsed JSON object:

`[{"Temperature":57.4, "Humidity": 45.6},{"Location:" "RV"}]`

It passed that msg payload to an Influxdb out node which received it as an array of 2 objects:

```auto
environmentTopic : msg.payload : array[2]
array[2]
0: object
Temperature: 60.7
Humidity: 40.6
1: object
Location: "RV"

```

My data in the database still looks basically the same, but if I show tags in the database I see:

```auto
 show tag keys
name: environment
tagKey
------
Location
> show tag keys
name: environment
tagKey
------
Location
> 

```

So I think I have it right??

---

<div class="post-metadata">

**Author:** ![jfabernathy](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/jfabernathy/32/34883_2.png) [@jfabernathy](https://discourse.nodered.org/u/jfabernathy)\
**Post date:** [8 January 2021 14:43 UTC](https://discourse.nodered.org/t/adding-temp-and-humidity-to-influxdb/38677/22 "2021-01-08T14:43:23Z")

</div>

I think this is my confirmation. The output from the select shows before Location was tag and after:

```auto
 select * from environment group by Location limit 3
name: environment
tags: Location=
time Humidity Location Temperature
---- -------- -------- -----------
1610056066283658222 46.6 RV 57.7
1610056126445212027 46.6 RV 57.7
1610056186564122372 46.7 RV 57.7

name: environment
tags: Location=RV
time Humidity Location Temperature
---- -------- -------- -----------
1610113254370362806 45.6 57.4
1610113314536607421 44.9 57.7
1610113374705172706 44.3 58.1
> 

```

---

<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:** [8 January 2021 14:52 UTC](https://discourse.nodered.org/t/adding-temp-and-humidity-to-influxdb/38677/23 "2021-01-08T14:52:55Z")

</div>

Yep, that looks good.  
If you use Grafana for drawing charts note that there is a mechanism in there for defining a chart and providing a list of rooms, it will then auto-generate a set of charts, one for each room.

---

<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:** [9 March 2021 14:52 UTC](https://discourse.nodered.org/t/adding-temp-and-humidity-to-influxdb/38677/24 "2021-03-09T14:52:55Z")

</div>

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

[Previous page](https://discourse.nodered.org/t/adding-temp-and-humidity-to-influxdb/38677.md?page=1)