# Kibana displays JSON field with "?" in front, but its searchable and acts like seperate fields

**URL:** https://discuss.elastic.co/t/kibana-displays-json-field-with-in-front-but-its-searchable-and-acts-like-seperate-fields/187949
**Category:** Kibana
**Created:** [June 27, 2019, 11:39pm UTC](https://discuss.elastic.co/t/kibana-displays-json-field-with-in-front-but-its-searchable-and-acts-like-seperate-fields/187949 "2019-06-27T23:39:23Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![stcdarrell](https://avatars.discourse-cdn.com/v4/letter/s/a183cd/32.png) [@stcdarrell](https://discuss.elastic.co/u/stcdarrell)
#### Post date: [June 27, 2019, 11:39pm UTC](https://discuss.elastic.co/t/kibana-displays-json-field-with-in-front-but-its-searchable-and-acts-like-seperate-fields/187949/1 "2019-06-27T23:39:24Z")

</div>

i hope this makes sense.. and is in the right group..

i'm using logstash to query a REST API which returns a really large JSON.

That JSON is dumped into a field called "CIF\_Source\_Body," it works.. within that JSON is a huge amount of nested fields..  
This is what kibana displays:  
{  
"indicator": "125.64.94.211",  
"reported\_at": "2019-06-27T21:32:20.424476Z",  
"timezone": "asia/shanghai",  
"latitude": 30.6667,  
"peers": [  
{  
"cc": "CN",  
"prefix": "125.64.94.0/24",  
"rir": "apnic",  
"asn": "4134"  
},  
{  
"cc": "CN",  
"prefix": "125.64.94.0/24",  
"rir": "apnic",  
"asn": "4134"  
}  
],  
"created\_at": "2019-06-27T21:32:30.869846",  
"description": "identified as sending recursive dns queries to a remote host",  
"uuid": "80428a27-de37-4330-98f5-8b1d74a018c5",  
"last\_at": "2019-06-27T19:32:28.000000Z",  
"indicator\_ipv4": "125.64.94.211",  
"reference": "[https://dataplane.org/dnsrd.txt](https://dataplane.org/dnsrd.txt)",  
"provider": "[dataplane.org](http://dataplane.org)",  
"itype": "ipv4",  
"longitude": 104.0667,  
"group": "everyone",  
"cc": "cn",  
"probability": 99.21,  
"confidence": 3,  
"count": 1,  
"asn\_desc": "chinanet sichuan telecom internet data center",  
"tags": [  
"dns",  
"scanner"  
],  
"tlp": "white",  
"location": {  
"lon": 104.0667,  
"lat": 30.6667  
},  
"region": "sichuan",  
"asn": 38283  
},  
{  
"indicator": "125.64.94.211",  
"reported\_at": "2019-06-26T13:23:54.626049Z",  
"timezone": "asia/shanghai",  
"latitude": 30.6667,  
"peers": [  
{  
"cc": "CN",  
"prefix": "125.64.94.0/24",  
"rir": "apnic",  
"asn": "4134"  
},  
{  
"cc": "CN",  
"prefix": "125.64.94.0/24",  
"rir": "apnic",  
"asn": "4134"  
}  
],  
"created\_at": "2019-06-26T13:24:05.293597",  
"description": "identified as sending recursive dns queries to a remote host",  
"uuid": "3714c61c-9b11-4693-9e5a-0d166f18afcf",  
"last\_at": "2019-06-26T10:28:20.000000Z",  
"indicator\_ipv4": "125.64.94.211",  
"reference": "[https://dataplane.org/dnsrd.txt](https://dataplane.org/dnsrd.txt)",  
"provider": "[dataplane.org](http://dataplane.org)",  
"itype": "ipv4",  
"longitude": 104.0667,  
"group": "everyone",  
"cc": "cn",  
"probability": 99.03,  
"confidence": 3,  
"count": 1,  
"asn\_desc": "chinanet sichuan telecom internet data center",  
"tags": [  
"dns",  
"scanner"  
],  
"tlp": "white",  
"location": {  
"lon": 104.0667,  
"lat": 30.6667  
},  
"region": "sichuan",  
"asn": 38283  
},  
{  
"indicator": "125.64.94.211",  
"reported\_at": "2019-06-24T10:02:06.470660Z",  
"timezone": "asia/shanghai",  
"latitude": 30.6667,  
"peers": [  
{  
"cc": "CN",  
"prefix": "125.64.94.0/24",  
"rir": "apnic",  
"asn": "4134"  
},  
{  
"cc": "CN",  
"prefix": "125.64.94.0/24",  
"rir": "apnic",  
"asn": "4134"  
}  
],  
"created\_at": "2019-06-24T10:02:38.556516",  
"description": "identified as sending recursive dns queries to a remote host",  
"uuid": "d90a79be-ea1f-481c-9b83-7861723ee107",  
"last\_at": "2019-06-24T08:13:35.000000Z",  
"indicator\_ipv4": "125.64.94.211",  
"reference": "[https://dataplane.org/sipquery.txt](https://dataplane.org/sipquery.txt)",  
"provider": "[dataplane.org](http://dataplane.org)",  
"itype": "ipv4",  
"longitude": 104.0667,  
"group": "everyone",  
"cc": "cn",  
"probability": 99.05,  
"confidence": 3,  
"count": 1,  
"asn\_desc": "chinanet sichuan telecom internet data center",  
"tags": [  
"dns",  
"scanner"  
],  
"tlp": "white",  
"location": {  
"lon": 104.0667,  
"lat": 30.6667  
},  
"region": "sichuan",  
"asn": 38283  
}

.. i can search and do visualizations on the fields within this field.. just as i should be able to do in a nested group.. its just not displayed as a nested group..

 ![56%20PM](https://us1.discourse-cdn.com/elastic/original/3X/a/2/a2569daab91a24c1b6721dd6b5dec9d2da2c921f.jpeg)

.. any suggestions on why it isnt displaying within kibana correctly?

thanks

---

<div class="post-metadata">

### Author: ![stcdarrell](https://avatars.discourse-cdn.com/v4/letter/s/a183cd/32.png) [@stcdarrell](https://discuss.elastic.co/u/stcdarrell)
#### Post date: [June 28, 2019, 1:53pm UTC](https://discuss.elastic.co/t/kibana-displays-json-field-with-in-front-but-its-searchable-and-acts-like-seperate-fields/187949/2 "2019-06-28T13:53:31Z")

</div>

i got it.. not really a kibana issue, more a data issue..  
it was an array of jsons.. never seen that before.. a logstash split filter fixes things

i got it.. the results are a JSON array.. so you have to split it up using logstash

```
 filter {
        if [cif_source_body] {
                split { field => "cif_source_body"}
                split { field => "[cif_source_body][peers]"}
        }

        if [cif_destination_body] {
                split { field => "cif_destination_body"}
                split { field => "[cif_destination_body][peers]"}
        }
}
```

---

<div class="post-metadata">

### Author: ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)
#### Post date: [June 28, 2019, 7:15pm UTC](https://discuss.elastic.co/t/kibana-displays-json-field-with-in-front-but-its-searchable-and-acts-like-seperate-fields/187949/3 "2019-06-28T19:15:17Z")

</div>

Cool thanks for posting your solution.

Cheers  
Rashmi

---

<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: [July 26, 2019, 7:15pm UTC](https://discuss.elastic.co/t/kibana-displays-json-field-with-in-front-but-its-searchable-and-acts-like-seperate-fields/187949/4 "2019-07-26T19:15:21Z")

</div>

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