Parsing Json object array

Elastic Stack Logstash
1

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

2

What exactly do you mean by that?

3

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

4

Hi, have you checked that?

5

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

6

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

7

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

8

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