CSV to JSON adding brackets and backslashes

[markfree]

I've created a discovery rule that collects a list of files.
The list goes something like this:

$ zabbix_get -s PXW1CEADG016 -k system.run["powershell.exe -File C:\zabbix\scripts\mailing_file_stats.ps1"]
name
C:\FTP\import\bkp
C:\FTP\import\20220709013444_cacs10_v83.txt
C:\FTP\import\20220709013444_cacs10_v83.txt.log
C:\FTP\import\20220709013444_cacs11_v83.txt
C:\FTP\import\20220709013444_cacs11_v83.txt.log
C:\FTP\import\20220709013445_cakauto4.txt
C:\FTP\import\20220709013445_cakauto4.txt.log
C:\FTP\import\20220709_Cacs3_v83_PXW1CEADG018.txt
C:\FTP\import\20220709_Cacs9_v83_PXW1CEADG021.txt

Then, I added the preprocessing "CSV to JSON".
For that discovery, there's a macro, {#MAILING.NAME} -> $..name

For testing, I've created an item prototype to get the file size.

vfs.file.size[{#MAILING.NAME}]

After that, Zabbix created an item for each file with the wrong file path.
It added literal brackets and backslashes to the file path, therefore, making the item unsupported.
vfs.file.size["["C:\\FTP\\import\\20220709_Cacs3_v83_Processad o_no _servidor_PXW1CEADG018.txt"]"]

Any idea of how to correct that?

[Markku]

For me it looks like your jsonpath ($..name) is somehow incorrect as it returns the value as list (array), not as plain string. How about $..name.first() or $.name?

Markku

[Markku]

For me it looks like your jsonpath ($..name) is somehow incorrect as it returns the value as list (array), not as plain string. How about $..name.first() or $.name?

Markku

[markfree]

That's it!
If I change JSONPath to $.name, the discovery rule finds all files correctly.

I was testing JSONPath with an online evaluator and its result had no matches when using 1 dots.
I guess that was misleading.

[Markku]

I was testing JSONPath with an online evaluator and its result had no matches when using 1 dots.
I guess that was misleading.

My feeling exactly: I haven't found a practical way to test the Zabbix JSONPath expressions outside of Zabbix as those that I've tried haven't quite worked like Zabbix.

Markku