# Getting Json payload to influxDB

**URL:** https://discourse.nodered.org/t/getting-json-payload-to-influxdb/32555
**Category:** General
**Created:** [7 September 2020 16:01 UTC](https://discourse.nodered.org/t/getting-json-payload-to-influxdb/32555 "2020-09-07T16:01:10Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![tazkiller2001](https://avatars.discourse-cdn.com/v4/letter/t/f475e1/32.png) [@tazkiller2001](https://discourse.nodered.org/u/tazkiller2001)
#### Post date: [7 September 2020 16:01 UTC](https://discourse.nodered.org/t/getting-json-payload-to-influxdb/32555/1 "2020-09-07T16:01:10Z")

</div>

Hi

I have tried to get temperature values ​​from a JSON file into INFLUXDB. The connection to InfluxDB works but can not get values ​​out of my JSON file.

Payload debug:

msg.payload : Object

object

compact: object

detailed: array[4]

0: object

\_id: "70:ee:50:2e:cd:88"

station\_name: "FCH-NTMO-1"

date\_setup: 1537339544

last\_setup: 1537339544

type: "NAMain"

last\_status\_store: 1599493344

module\_name: "FCH-NTMO-Indoor-1"

firmware: 178

last\_upgrade: 1537339528

wifi\_status: 42

reachable: true

co2\_calibrating: false

data\_type: array[5]

place: object

dashboard\_data: object

time\_utc: 1599493343

Temperature: 22.3

CO2: 475

Humidity: 42

Noise: 36

Pressure: 1025.5

AbsolutePressure: 1023.9

min\_temp: 21.5

max\_temp: 22.3

date\_max\_temp: 1599486990

date\_min\_temp: 1599450083

temp\_trend: "stable"

pressure\_trend: "up"

 ![Function to INFLUX](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/0/40d0fe703e289e6dcb1c58c0ccf96ba2cc125caa.jpeg)

Right now I'm just trying to get ID and Temperature in, but value does not come out only the text I have written as:  
 ![gem som payload debug](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/e/4e0ca9986a59b418accaef1857bcd076ff4be203.jpeg)

Hope you can help

B.R

MArtin

---

<div class="post-metadata">

### Author: ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)
#### Post date: [7 September 2020 16:16 UTC](https://discourse.nodered.org/t/getting-json-payload-to-influxdb/32555/2 "2020-09-07T16:16:38Z")

</div>

The values in the function node are defined as strings.

instead of

```auto
...
Humidity: 'msg.payload'
...

```

try

```auto
...
Humidity: msg.payload
...

```

---

<div class="post-metadata">

### Author: ![tazkiller2001](https://avatars.discourse-cdn.com/v4/letter/t/f475e1/32.png) [@tazkiller2001](https://discourse.nodered.org/u/tazkiller2001)
#### Post date: [7 September 2020 19:38 UTC](https://discourse.nodered.org/t/getting-json-payload-to-influxdb/32555/3 "2020-09-07T19:38:07Z")

</div>

Thank you! 🙂

Now i have the right value

---

<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: [6 November 2020 19:38 UTC](https://discourse.nodered.org/t/getting-json-payload-to-influxdb/32555/4 "2020-11-06T19:38:10Z")

</div>

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