How to make this json array as csv data

Elastic Stack Logstash
1

Hi All

I have json data like this

[{
		"jsondata": ["123456", "description1", "notes1", "information1", 9]
	}, {
		"jsondata": ["44555", "description2", "notes2", "information2", 8]
	}
]

I need the output in csv format like this

123456,description1,notes1,information1,9
44555,description2,notes2,information2,8

I have tried this in filters

split{field => "message"}
mutate{gsub => [ "jsondata", "[ ]",""]
csv{
source => "jsondata"
columns => ["header1", "header2","header3", "header4","header5"]
separator => ","
}

Please let me know how to solve this

Thanks

2

Fixed it by my own. By adding rename to the array.

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.