Node-RED

Function to write Netatmo measurement in Influx DB

General
#1

Hi,

The Netatmo "Get Measurements" node reads the days minimum termperature from my Netatmo outdoor module and when I fill in

msg.payload.devices[0].modules[2].dashboard_data.min_temp

in the debugger the correct measurement (degrees minimum temperature value like 15.3) is shown in the debug frame. Now I intend to save this value in an Influx DB and I suppose I need a function before saving the value in the database. After reading many instructions I did not succeed, can someone help me writing this function?

Regards, Hans.

#2

You can use a change node to setup the message for influx.

#3

Thanks Colin, just tried the Change node but no succes. Not even after reading the node help, can you be more specific how to use it in my flow?

#4

Post what you see in a debug node before the change node and another after and show us the change node config. Tell us what you want to see on the output.

#5

Also check that you have configured the influxdb node with the correct details of your database.

#6

When this:

payload.devices[0].modules[2].dashboard_data.min_temp

is in my debug node then output in the debugger shows the correct min-temp:

15-7-2019 11:50:04node: 42184b89.07c674msg.payload.devices[0].modules[2].dashboard_data.min_temp : number
15

So I think I need a function or change to save the min-temp (15) in the database.

The relevant part from the complete message object coming from the Netatmo "get stations data" node is shown in the graphic below.

NR
NR.png393×1632 42.4 KB

#7

I am using an influxdb-batch node (with telegraf) and send all netatmo data to it like this:

m = msg.payload.devices[0].dashboard_data


msg.payload = [
    {
        measurement:"netatmo",
        fields: m,
        tags:{
            weather:"internal"
        },
        timestamp: new Date()
    }];

return msg
#8

Thanks Bakman2, works like a charm and the data is saved in the DB. Now struggling how to save only the min_temp from the outdoor module, any help would be appreciated.

#9

But if you have it in the database, it is already saved no ?

#10

The indoor module data is saved, not the outdoor module data. I think msg.payload.devices[0].dashboard_data refers to the indoor module.

influx
influx.JPG2269×161 84.7 KB

#11

Sorry, you can use:

m = msg.payload.devices[0].modules[0].dashboard_data

and for min-temp only:

m = msg.payload.devices[0].modules[0].dashboard_data.min_temp
1 Like
#12

Thanks again for helping! Although the line m = msg.payload.devices[0].modules[0].dashboard_data writes to the DB but unfortunattely only the values for Rain, sum_rain_1, sum_rain_24 and time_utc

And the line m = msg.payload.devices[0].modules[0].dashboard_data.min_temp generates an error:

Error: A 400 Bad Request error occurred: {"error":"unable to parse 'tuin': missing fields"}

#13

You have multiple modules.

Connect the netatmo node to a debug node and determine in which module the min_temp is located.

#14

Solved, thanks for helping!

#15

Just wondered why you were adding a timestamp. I thought Influx added it automatically anyway....

#16

You are correct, it is a historical leftover, good moment to clean it up!

1 Like