Split a csv fied into nested array

Elastic Stack Logstash
1

hello,I use logstash to import csv to elasticsearch, my question is that one of the fields contains the string formatted as [{"level1":aa,"level2":bb},{"level1":aaa,"level2",bbb},...],The field, is array.and i need to parse this and put into elasticsearch like this eg:
levels:[
{ "level1":"aa",
"level2":"bb"
},
{ "level1":"aaa",
"level2":"bbb"
}]
. what are possible solutions for this?Thank you!

2

Provided the string is valid JSON (e.g. all the string values are in double quotes) a simple JSON filter will parse that

json { source => "someColumn" target => "someField" }
3

Ok,I will try it,thank you!

4

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