Parsing Json object array

[jolaniya]

Hi,
I have trouble with a xml file.
I have applied xml filter on that and after that i am getting 2 outputs.

1. message.GeneralInfo
2. message.ReportNode

I guess these are json outputs but json filter is not working on that.
example of message.GeneralInfo:

message.GeneralInfo: { "ToolVersion": [ "0" ], "ToolVersionStringLiteral": [ "15.0.2" ], "RunStartTime": [ "2021-01-20 06:40:19" ], "ToolName": [ "Micro Focus Unified Functional Testing" ], "ResultName": [ "workspace1_4" ], "Timezone": [ "+05:30:00" ] }
`
I want output like this,

ToolVersion = "0" ToolVersionStringLiteral = "15.0.2" RunStartTime = "2021-01-20 06:40:19" ToolName = "Micro Focus Unified Functional Testing" ResultName = "workspace1_4" Timezone = "+05:30:00"
all inside elements would become separeted field in my kibana
Please help..
Thanks

[Badger]

@jolaniya

json filter is not working on that

What exactly do you mean by that?

[jolaniya]

Hi thanks for the reply Badger.
I mean, I have applied.
filter { json { source => "message" } } This, But it shows
_jsonparsefailure this error.

[jolaniya]

Hi, have you checked that?

[Badger]

@jolaniya

filter { json { source => "message" } }

Shouldn't that be filter { json { source => "message.GeneralInfo" } }?

[jolaniya]

@Badger

filter { json { source => "message.GeneralInfo" } } ?

Yes, I have used that too. But it is also not working.

[jolaniya]

Hey Badger can you please help, I'm still looking for the solution.