# How to display array of object as JSON respose in kibana

**URL:** <https://discuss.elastic.co/t/how-to-display-array-of-object-as-json-respose-in-kibana/140734>\
**Category:** Kibana\
**Created:** [July 19, 2018, 1:10pm UTC](https://discuss.elastic.co/t/how-to-display-array-of-object-as-json-respose-in-kibana/140734 "2018-07-19T13:10:01Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Maheswar\_Murmu](https://avatars.discourse-cdn.com/v4/letter/m/a88e57/32.png) [@Maheswar\_Murmu](https://discuss.elastic.co/u/Maheswar_Murmu)\
**Post date:** [July 19, 2018, 1:10pm UTC](https://discuss.elastic.co/t/how-to-display-array-of-object-as-json-respose-in-kibana/140734/1 "2018-07-19T13:10:01Z")

</div>

![kibana](https://us1.discourse-cdn.com/elastic/original/3X/3/c/3c8f494472340791333881ca0ef2a828050df94d.PNG)

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.

---

<div class="post-metadata">

**Author:** ![jbudz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jbudz/32/45922_2.png) [@jbudz](https://discuss.elastic.co/u/jbudz)\
**Post date:** [July 19, 2018, 8:54pm UTC](https://discuss.elastic.co/t/how-to-display-array-of-object-as-json-respose-in-kibana/140734/2 "2018-07-19T20:54:52Z")

</div>

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](https://www.elastic.co/guide/en/logstash/current/plugins-filters-grok.html) and [json filter](https://www.elastic.co/guide/en/logstash/current/plugins-filters-json.html)

---

<div class="post-metadata">

**Author:** ![Maheswar\_Murmu](https://avatars.discourse-cdn.com/v4/letter/m/a88e57/32.png) [@Maheswar\_Murmu](https://discuss.elastic.co/u/Maheswar_Murmu)\
**Post date:** [July 20, 2018, 11:08am UTC](https://discuss.elastic.co/t/how-to-display-array-of-object-as-json-respose-in-kibana/140734/3 "2018-07-20T11:08:46Z")

</div>

![logstashConfigFile](https://us1.discourse-cdn.com/elastic/original/3X/c/3/c3c75fcf604f97519ea7470cadae6514d9e13ea1.PNG)

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.

---

<div class="post-metadata">

**Author:** ![jbudz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jbudz/32/45922_2.png) [@jbudz](https://discuss.elastic.co/u/jbudz)\
**Post date:** [July 20, 2018, 8:43pm UTC](https://discuss.elastic.co/t/how-to-display-array-of-object-as-json-respose-in-kibana/140734/4 "2018-07-20T20:43:08Z")

</div>

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:

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

```

---

<div class="post-metadata">

**Author:** ![Maheswar\_Murmu](https://avatars.discourse-cdn.com/v4/letter/m/a88e57/32.png) [@Maheswar\_Murmu](https://discuss.elastic.co/u/Maheswar_Murmu)\
**Post date:** [July 22, 2018, 4:35am UTC](https://discuss.elastic.co/t/how-to-display-array-of-object-as-json-respose-in-kibana/140734/5 "2018-07-22T04:35:08Z")

</div>

![logstashConfFile](https://us1.discourse-cdn.com/elastic/original/3X/e/e/eeb348f54527a49ba5215a74c4a7008990917b77.PNG)  
 ![kibana](https://us1.discourse-cdn.com/elastic/original/3X/9/6/963f022593c91c7eac6370f4d297c5def5cfbf27.PNG) ![kibanaJSON](https://us1.discourse-cdn.com/elastic/original/3X/3/2/321eea47e7671ab49dc5c278d6485601b82f55b9.PNG)

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.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [August 19, 2018, 4:35am UTC](https://discuss.elastic.co/t/how-to-display-array-of-object-as-json-respose-in-kibana/140734/6 "2018-08-19T04:35:10Z")

</div>

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