Trying to bring data over from tasmota blerry
mqtt-value
{
"via_device": "esp_mini32_blerry_01",
"Battery_Voltage": 2.513,
"RSSI": -89,
"Battery": 31,
"Humidity": 62,
"Temperature": 22,
"Time": "2022-02-06 03:45:51",
"DewPoint": 14.38,
"mac": "A4C138F07A87",
"alias": "mkg"
}
with configuration :
[[inputs.mqtt_consumer]]
servers = ["tcp://10.10.1.7:1883"]
topics = [
"tele/tasmota_blerry/+"
]
data_format = "json_v2"
[[inputs.mqtt_consumer.json_v2]]
measurement_name_path = "alias"
timestamp_path = "Time"
timestamp_format = "2006-01-02T15:04:05"
timestamp_timezone = "America/New_York"
keeps tossing errors :
2022-02-06T03:44:14Z E! [inputs.mqtt_consumer] Error in plugin: parsing time "\"2022-02-06T04:44:14\"" as "2006-01-02T15:04:05": cannot parse "\"2022-02-06T04:44:14\"" as "2006"
The timestamp_format
does not match with the Time
field format.
Furthermore, you also have to define your tags and fields.
Try this config as an example, this should work:
[[inputs.mqtt_consumer]]
servers = ["tcp://10.10.1.7:1883"]
topics = [
"tele/tasmota_blerry/+"
]
data_format = "json_v2"
[[inputs.mqtt_consumer.json_v2]]
measurement_name_path = "alias"
timestamp_path = "Time"
timestamp_format = "2006-01-02 15:04:05"
timestamp_timezone = "America/New_York"
[[inputs.mqtt_consumer.json_v2.tag]]
path = "via_device"
rename = "device"
[[inputs.mqtt_consumer.json_v2.tag]]
path = "mac"
[[inputs.mqtt_consumer.json_v2.field]]
path = "Battery_Voltage"
type = "float"
rename = "Voltage"
[[inputs.mqtt_consumer.json_v2.field]]
path = "RSSI"
type = "int"
[[inputs.mqtt_consumer.json_v2.field]]
path = "Battery"
type = "int"
[[inputs.mqtt_consumer.json_v2.field]]
path = "Humidity"
type = "int"
[[inputs.mqtt_consumer.json_v2.field]]
path = "Temperature"
type = "int"
[[inputs.mqtt_consumer.json_v2.field]]
path = "DewPoint"
type = "float"