Get column name from parameter list in json data format

,
1

Am sending data in json format using telegraf. But the column headers in the measurements are shown as Parameter_0_datatype,Parameter_0_value, etc. The json string does contain the parameter names but it’s not taking them. How can I solve this?

Following is my input_plugin in the conf file

[[processors.converter]]
[processors.converter.tags]
measurement = [“topic”]

Read metrics from MQTT topic(s)

[[inputs.mqtt_consumer]]
servers = [“localhost:1883”]

servers = [“10.255.201.118:1883”]

MQTT QoS, must be 0, 1, or 2

qos = 0

Topics to subscribe to

topics = [
“Lenze”,
“LACC”,
“DIAG”
]

if true, messages that can’t be delivered while the subscriber is offline

will be delivered when it comes back (such as on service restart).

NOTE: if true, client_id MUST be set

persistent_session = false

If empty, a random client ID will be generated.

client_id = “”

username and password to connect MQTT server.

username = “telegraf”

password = “pwd”

data_format = “json”

2

Hello @Aritra666B,
Can you please share your json?
Also have you seen this?

You might find that useful. You’ll want to specify your tags and timestamps.

3

json format
json format766×590 16.3 KB

4

You’ll need something like:
json_time_key = “Parameters_InitTime”
json_time_format = “2006-01-02T15:04:05Z07:00”
json_name_key = “Topic”
tag_keys = [
$yourtagkeys
]

I’m not sure what you want to make tags or timestamp etc. Does this help? I’m just following the documentation sent above.