# Nested Objects in a json Response displayed in Kibnana

**URL:** <https://discuss.elastic.co/t/nested-objects-in-a-json-response-displayed-in-kibnana/97565>\
**Category:** Logstash\
**Created:** [August 18, 2017, 10:53am UTC](https://discuss.elastic.co/t/nested-objects-in-a-json-response-displayed-in-kibnana/97565 "2017-08-18T10:53:47Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![giridharan78](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/giridharan78/32/22100_2.png) [@giridharan78](https://discuss.elastic.co/u/giridharan78)\
**Post date:** [August 18, 2017, 10:53am UTC](https://discuss.elastic.co/t/nested-objects-in-a-json-response-displayed-in-kibnana/97565/1 "2017-08-18T10:53:47Z")

</div>

Continuing the discussion from [I would like to access nested data from an array](https://discuss.elastic.co/t/i-would-like-to-access-nested-data-from-an-array/71432/6):

The data inside the array are not getting indexed and hence not displayed on the kibana dashboard. What is the best way to process the data from Logstash \> elastic search \> kibana. I wanted to get the data in the results and get them displayed in kibana. Sample of my data below. Presently the data is displayed as single object on kibana (discover)  
Any suggestions would be very much appreciated.

{  
"meta":{  
"paginationTotalResults": 3,  
"response\_in\_sec": 0.08  
},  
"results":[  
{  
"pageTitle": "Breast cancer | Cancer Research UK",  
"url": "[http://www.cancerresearchuk.org/about-cancer/type/breast-cancer/](http://www.cancerresearchuk.org/about-cancer/type/breast-cancer/)",  
"browserUri": "browsers/ff",  
"dataStartDuration": 0.067,  
"renderStart": 3.071  
}  
{  
{  
"pageTitle": "Breast cancer | Cancer Research UK",  
"url": "[http://www.cancerresearchuk.org/about-cancer/type/breast-cancer/](http://www.cancerresearchuk.org/about-cancer/type/breast-cancer/)",  
"browserUri": "browsers/ff",  
"dataStartDuration": 0.094,  
"renderStart": 2.266  
}  
]  
}

Config file used in logstash  
input {  
http\_poller{  
urls =\> {  
test1 =\> {  
method =\> get  
url =\> "[https://xxxxxxxx.com/pa/1/testRuns?jobTemplate=jobTemplates/76045](https://xxxxxxxx.com/pa/1/testRuns?jobTemplate=jobTemplates/76045)"  
headers =\> {  
Authorization =\> "Bearer c59e764ccad6ffc0a5ca28eb50255ae910b126190baa5e020e9da5403660"  
Realm =\> "626367"  
}  
}  
}

request\_timeout =\> 1200  
interval =\> 1200  
codec =\> json  
# A hash of request metadata info (timing, response headers, etc.) will be sent here  
#metadata\_target =\> "http\_poller\_metadata"  
}  
}  
filter{

}  
output {  
#stdout { codec =\> ruby\_debug }  
elasticsearch {  
hosts =\> "[http://localhost:9200](http://localhost:9200)"  
index =\> "api-index"  
}  
}

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [August 18, 2017, 11:09am UTC](https://discuss.elastic.co/t/nested-objects-in-a-json-response-displayed-in-kibnana/97565/2 "2017-08-18T11:09:29Z")

</div>

Kibana doesn't fully support arrays of objects.

> The data inside the array are not getting indexed and hence not displayed on the kibana dashboard.

What, exactly, do you mean by this? ES has no problem indexing documents with arrays of objects.

---

<div class="post-metadata">

**Author:** ![giridharan78](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/giridharan78/32/22100_2.png) [@giridharan78](https://discuss.elastic.co/u/giridharan78)\
**Post date:** [August 18, 2017, 11:28am UTC](https://discuss.elastic.co/t/nested-objects-in-a-json-response-displayed-in-kibnana/97565/3 "2017-08-18T11:28:58Z")

</div>

Sorry, my understanding might be wrong. I thought if all the objects inside the array are indexed then there would be no problem getting them displayed on kibana. The main problem is getting the data displayed on Kibana. Followed all the process mentioned in [https://www.elastic.co/guide/en/elasticsearch/reference/current/nested.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/nested.html).

Could you please advise what would be the best way to display the nested objects on kibana.

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [August 18, 2017, 1:21pm UTC](https://discuss.elastic.co/t/nested-objects-in-a-json-response-displayed-in-kibnana/97565/4 "2017-08-18T13:21:36Z")

</div>

I suggest you ask in the Kibana category, but as I said Kibana's handling of arrays of objects is a known limitation.

---

<div class="post-metadata">

**Author:** ![giridharan78](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/giridharan78/32/22100_2.png) [@giridharan78](https://discuss.elastic.co/u/giridharan78)\
**Post date:** [August 24, 2017, 11:11am UTC](https://discuss.elastic.co/t/nested-objects-in-a-json-response-displayed-in-kibnana/97565/5 "2017-08-24T11:11:00Z")

</div>

Found a solution. Split filter has worked.

Reference: [https://www.elastic.co/guide/en/logstash/current/plugins-filters-split.html](https://www.elastic.co/guide/en/logstash/current/plugins-filters-split.html)

---

<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:** [September 21, 2017, 11:11am UTC](https://discuss.elastic.co/t/nested-objects-in-a-json-response-displayed-in-kibnana/97565/6 "2017-09-21T11:11:28Z")

</div>

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