How to display array of object as JSON respose in kibana


(Maheswar Murmu) #1

Hi,

I am using FileBeat to collect logs , the logs are sent to logstash and I am visualization it on kibana and i have given a one log entries below;

2018-07-19 17:51:06 INFO DayBookController:304 - [{"id":2,"firstName":"Vishallly","lastName":"kumar","friendlyName":"Vishalllyk","phoneNumber":"1123456789"}]

But this all field i am not able to get it as message fields are visible in the UTF format.

I will be pleased if anyone help me to resolve this issue.


(Jon Budzenski) #2

We'll need to get this formatted properly before ingesting into elasticsearch, so likely something in our logstash config.

Can you share which filters you're using with logstash? You should be able to do this with a combo of a grok filter and json filter


(Maheswar Murmu) #3

Hii Jon,

How do i filter it with a combo of grok filter and json filter.If you could have a look to my configuration and give me the feedback.


(Jon Budzenski) #4

It looks like we have a grok filter ready so we can add in the JSON filter under it. The JSON is assigned to the line field. Under the grok filter we would add:

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

(Maheswar Murmu) #5


I have added the json filter but i am n't able to get as fields and value.As you can see in the log file i have configured Log level as INfO and then the message column.But still the same I guess issue is only with json response.


(system) #6

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