# How to extract nested json objects in to new fields in kibana
**URL:** https://discuss.elastic.co/t/how-to-extract-nested-json-objects-in-to-new-fields-in-kibana/282626
**Category:** Kibana
**Created:** [August 27, 2021, 4:47am UTC](https://discuss.elastic.co/t/how-to-extract-nested-json-objects-in-to-new-fields-in-kibana/282626 "2021-08-27T04:47:27Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@sandhya1](https://discuss.elastic.co/u/sandhya1)
#### Post date: [August 27, 2021, 4:47am UTC](https://discuss.elastic.co/t/how-to-extract-nested-json-objects-in-to-new-fields-in-kibana/282626/1 "2021-08-27T04:47:27Z")
Hi,
I have one field which is having nested j son object format, i need to extract into new fields. The field is mapped to the "text" data type and from the below format i need the count of unique first name and need to retrieve all the first name.
{Names:[{“first name”: ”A”,”id”:[{‘first id’:””,”Second id”:}],
{“first name”:”B”,”id”:[{‘first id’:””,”Second id”:}]}],
Status:”ABC”}
Please help me out ,how can i able to get the count from nested j son object.
Thanks in Advance,
Sandhya
---
### Author:  [@tsullivan](https://discuss.elastic.co/u/tsullivan)
#### Post date: [August 30, 2021, 8:42pm UTC](https://discuss.elastic.co/t/how-to-extract-nested-json-objects-in-to-new-fields-in-kibana/282626/2 "2021-08-30T20:42:50Z")
Hi, if the data is mapped as text in Elasticsearch, then Kibana will only be able to do text-based operations on it. It sounds like the data should be indexed as data, not text.
Also, the data sample you gave is not parseable as JSON, so it's super hard to make a mental picture of what you are dealing with. I recommend using the formatting tools to format the data snippets into code and provide a structure that is actually parseable JSON or formatted in a way that makes the structure clear.
---
### Author:  [@ghudgins](https://discuss.elastic.co/u/ghudgins)
#### Post date: [August 30, 2021, 9:08pm UTC](https://discuss.elastic.co/t/how-to-extract-nested-json-objects-in-to-new-fields-in-kibana/282626/3 "2021-08-30T21:08:29Z")
you could maybe try a runtime field for this (if you're in 7.13+ the "add field" button is in the field list in lens & discover)
here's an example that extracts price
```auto
// Flatten a nested field
// Document looks like:
// {
// "products": [ <-- nested field
// { "title": "Kibana", "price": 42.02 },
// { "title": "Elasticsearch", "price": 22.10 }
// ]
// }
for (def product : params._source.products) {
emit(product.price);
}
```
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 27, 2021, 9:08pm UTC](https://discuss.elastic.co/t/how-to-extract-nested-json-objects-in-to-new-fields-in-kibana/282626/4 "2021-09-27T21:08:59Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.