Storing values in the database

So we simply have to use the MQTT topic we saw in the previous subpage (

Connecting espore server to the TTN using Node-red⁠

) and parse it to the required format for the influxDB node (which you will need to install previously, check link below)

⁠

Loading flows.nodered.org⁠

⁠

The flow will look as follows:

⁠

where the content of “function” is:

var msgOut1 = {};

msgOut1.payload = [msg.payload.uplink_message.decoded_payload,

{

devEUI: msg.payload.end_device_ids.dev_eui

}];

msgOut1.measurement = "data";

var msgOut2 = {};

msgOut2.payload = [{

rssi: msg.payload.uplink_message.rx_metadata[0].rssi,

snr: msg.payload.uplink_message.rx_metadata[0].snr,

{

gw_eui: msg.payload.uplink_message.rx_metadata[0].gateway_ids.eui,

devEUI: msg.payload.end_device_ids.dev_eui

}];

msgOut2.measurement = "metadata";

return [msgOut1, msgOut2];

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.