Error parsing data json_v2 due to complex path

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

Welcome to the community!

This works:

[[inputs.file]]
  files = ["weerlive.json"]
  data_format = "json_v2"
  [[inputs.file.json_v2]]
    measurement_name = "weerlive"
    [[inputs.file.json_v2.object]]
      path = "liveweer"
      included_keys = ["verw", "temp", "lv", "luchtd", "d0zon"]
      tags = ["plaats"]
      [inputs.file.json_v2.object.fields]
        verw = "string"
        temp = "float"
        lv = "int"
        luchtd = "float"
        d0zon = "int"
      [inputs.file.json_v2.object.renames]
        plaats = "locatie"
        verw = "verwachting"
  [inputs.file.tagpass]  # if you only want Amsterdam in locatie tag
    locatie = ["Amsterdam"]

[[outputs.file]]  # file output only for debugging
  namepass = ["weerlive"]
  files = ["weerlive.out"]
  influx_sort_fields = true

Franky, many thanks, your advice works fine also with the larger file!