Hello,
I am having difficulties to select specific data in a json file.
I want to use a criterion in the path to select an entry in an array:
path = “@this.liveweer.#(plaats=“Amsterdam”)”
(This query is GJSON compliant according the GJSON Playground)
This gives a [telegraf] error:
Error running agent : Error loading config file http://…: Error parsing data: Line 191: invalid TOML symntax
Alternativelive I replaced the path by:
path = “@this.liveweer.0”
This works fine, so the remainder of the telegraf configuration is OK.
The relevant section in the telegraf file is:
[[inputs.file]]
files = ["/home/janlinux/tmp/input_weerlive.json"]
data_format = “json_v2”
[[inputs.file.json_v2]]
measurement_name = “weerlive”
[[inputs.file.json_v2.field]]
path = “liveweer.#.plaats”
rename = “locatie”
[[inputs.file.json_v2.field]]
path = “liveweer.#.verw”
rename = “verwachting”
[[inputs.file.json_v2.object]]
path = “@this.liveweer.#(plaats=“Amsterdam”)”
included_keys = [“temp”, “lv”, “luchtd”, “d0zon”]
tags = [“plaats”]
The input file reads (This file contains only “Amsterdam”, but I want to select from a larger file with multiple “plaats” entries):
{ “liveweer”: [{“plaats”: “Amsterdam”, “temp”: “-0.3”, “gtemp”: “-6.3”, “samenv”: “Licht bewolkt”, “lv”: “53”, “windr”: “Oost”, “windrgr”: “90”, “windms”: “7”, “winds”: “4”, “windk”: “13.6”, “windkmh”: “25.2”, “luchtd”: “1010.1”, “ldmmhg”: “758”, “dauwp”: “-8”, “zicht”: “45”, “verw”: “Zonnig en koud, in het zuiden eerst bewolkt. Morgen regen, mogelijk IJZEL”, “sup”: “08:47”, “sunder”: “16:34”, “image”: “lichtbewolkt”, “d0weer”: “halfbewolkt”, “d0tmax”: “2”, “d0tmin”: “-2”, “d0windk”: “3”, “d0windknp”: “10”, “d0windms”: “5”, “d0windkmh”: “19”, “d0windr”: “O”, “d0windrgr”: “90”, “d0neerslag”: “0”, “d0zon”: “55”, “d1weer”: “regen”, “d1tmax”: “0”, “d1tmin”: “-7”, “d1windk”: “3”, “d1windknp”: “8”, “d1windms”: “4”, “d1windkmh”: “15”, “d1windr”: “O”, “d1windrgr”: “90”, “d1neerslag”: “90”, “d1zon”: “20”, “d2weer”: “halfbewolkt”, “d2tmax”: “7”, “d2tmin”: “2”, “d2windk”: “2”, “d2windknp”: “6”, “d2windms”: “3”, “d2windkmh”: “11”, “d2windr”: “Z”, “d2windrgr”: “180”, “d2neerslag”: “60”, “d2zon”: “10”, “alarm”: “0”}]}
Thanks in advance,
Jan