Parse following Json

Hello community.

Please, can you help me parsing the following json, I’ve tried different config without success.

Please, help to this newbie.

JSON:

[
{“tag”:“PLC4S151_EntAmb”,“Instalacion”:“04807”,“Equipo”:“S151”,“TipoDeValor”:“SetPoint”,“v”:10.800000190734863,“q”:192,“time”:1703094813444},{“tag”:“PLC4S151_Status”,“Instalacion”:“04807”,“Equipo”:“S151”,“TipoDeValor”:“Status”,“v”:10.800000190734863,“q”:192,“time”:1703094813444}
]

v is the value and should be a field.

Instalacion, Equipo and TipoDeValor should be tag’s

time should be the influx datatime.

I’m getting this data from Mqtt broker.

Thank you.

So far is working with:

name_override = “vnode”
data_format = “json_v2”

[[inputs.mqtt_consumer.json_v2]]
[[inputs.mqtt_consumer.json_v2.object]]
path = “@this
tags = [“Instalacion”,“TipoDeValor”,“Equipo”]
[inputs.mqtt_consumer.json_v2.object.fields]
v = “float” # is this a float value?

1 Like

Thanks for following up with what worked!