# Nested Json fields

**URL:** https://discuss.elastic.co/t/nested-json-fields/127669
**Category:** Elasticsearch
**Created:** [April 11, 2018, 3:49pm UTC](https://discuss.elastic.co/t/nested-json-fields/127669 "2018-04-11T15:49:23Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![chrigui94](https://avatars.discourse-cdn.com/v4/letter/c/a8b319/32.png) [@chrigui94](https://discuss.elastic.co/u/chrigui94)
#### Post date: [April 11, 2018, 3:49pm UTC](https://discuss.elastic.co/t/nested-json-fields/127669/1 "2018-04-11T15:49:23Z")

</div>

I have a json that looks like this

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

**This is my problem:**

I need to get positions of gateways (antennaLongitude, antennaLatitude) as a geo\_point type  
and make a kibana map that contains the posititions of gateways. But the field gateways is nested and contains many gateways[0..n] how can I get these geopoints in elasticsearch!? I did split() in logstash but split will multiply the hole document n times (n is number of gateways ) which is not correct for my case.

Can I index these positions as an array of geo\_points ? and how ?

---

<div class="post-metadata">

### Author: ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [April 11, 2018, 4:00pm UTC](https://discuss.elastic.co/t/nested-json-fields/127669/2 "2018-04-11T16:00:46Z")

</div>

Could you provide a full recreation script as described in [About the Elasticsearch category](https://discuss.elastic.co/t/about-the-elasticsearch-category/21). It will help to better understand what you are doing. Please, try to keep the example as simple as possible.

A full reproduction script will help readers to understand, reproduce and if needed fix your problem. It will also most likely help to get a faster answer.

---

<div class="post-metadata">

### Author: ![chrigui94](https://avatars.discourse-cdn.com/v4/letter/c/a8b319/32.png) [@chrigui94](https://discuss.elastic.co/u/chrigui94)
#### Post date: [April 12, 2018, 8:04am UTC](https://discuss.elastic.co/t/nested-json-fields/127669/3 "2018-04-12T08:04:40Z")

</div>

I explained more my problem: I need how to index this nested json document how can I do it ?

---

<div class="post-metadata">

### Author: ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [April 12, 2018, 8:17am UTC](https://discuss.elastic.co/t/nested-json-fields/127669/4 "2018-04-12T08:17:51Z")

</div>

I can't help without an example to start with I'm afraid.

---

<div class="post-metadata">

### Author: ![vasireddyajay](https://avatars.discourse-cdn.com/v4/letter/v/e9a140/32.png) [@vasireddyajay](https://discuss.elastic.co/u/vasireddyajay)
#### Post date: [April 12, 2018, 9:41am UTC](https://discuss.elastic.co/t/nested-json-fields/127669/5 "2018-04-12T09:41:27Z")

</div>

Hi, I have the same question as @chrigui94 . For example, I have this json file and would like to use filebeat to parse and send to kibana.

**JSON File**  
{  
"payload": [  
{  
"measurement": "addition",  
"fields": {  
"eia": 487.86  
},  
"tags": {  
"device": "xyz",  
"catchall": "catchAll1",  
"technology": "java",  
"mbusprimary": 1  
},  
"timestamp": 1523446306000000000  
}  
],  
"\_msgid": "9600a72.8d0d458"  
}

**FileBeat.yml**

- type: log

Please guide me how to parse this json payload and use in Kibana

---

<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: [May 10, 2018, 9:41am UTC](https://discuss.elastic.co/t/nested-json-fields/127669/6 "2018-05-10T09:41:59Z")

</div>

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