# Cannot display json data from elastic search **URL:** \ **Category:** Elasticsearch\ **Created:** [May 29, 2017, 5:52am UTC](https://community.grafana.com/t/cannot-display-json-data-from-elastic-search/1128 "2017-05-29T05:52:12Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![saurabhkulkarni](https://avatars.discourse-cdn.com/v4/letter/s/e47774/32.png) [@saurabhkulkarni](https://community.grafana.com/u/saurabhkulkarni)\ **Post date:** [May 29, 2017, 5:52am UTC](https://community.grafana.com/t/cannot-display-json-data-from-elastic-search/1128/1 "2017-05-29T05:52:12Z")
I have used httpbeat, logstash, elasticsearch and grafana. The flow is as follows: SpringBoot metric endpoint=\> httpbeat =\> logstash =\> elasticsearch =\> grafana Now the problem here is, I am not able to figure out the query to be fired to display the statistics like count of number of hits to a particular endpoint in spring boot which gets captured in the metrics. I am able to get the field in elastic search but am not able to figure out how to get it in grafana using the queries and display on the dashboard. Can anyone please help me with the steps to display a particular field in this json on the dashboard(For example: com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getAllTopics\_count: 0). This is the data that I am pulling from ElasticSearch. { "\_index": “httpbeat-2017.05.25”, "\_type": “httpbeat”, "\_id": “AVw\_Jy-REkmdVqjghygS”, "\_score": 1, "\_source": { “request”: { “headers”: { “Accept”: “application/json” }, “method”: “get”, “url”: “[http://localhost:8080/metrics](http://localhost:8080/metrics)” }, "@timestamp": “2017-05-25T10:27:56.000Z”, “response”: { “headers”: { “X-Application-Context”: “application”, “Date”: “Thu, 25 May 2017 10:27:56 GMT”, “Content-Type”: “application/json;charset=UTF-8” }, “jsonBody”: { “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_updateTopic\_snapshot\_min”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getTopic\_snapshot\_75thPercentile”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_deleteTopic\_snapshot\_min”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getTopic\_count”: 0, “processors”: 2, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_addTopic\_snapshot\_95thPercentile”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_updateTopic\_snapshot\_95thPercentile”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_updateTopic\_snapshot\_999thPercentile”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getTopic\_snapshot\_999thPercentile”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_updateTopic\_snapshot\_max”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getAllTopics\_count”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_addTopic\_snapshot\_999thPercentile”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_deleteTopic\_snapshot\_max”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_deleteTopic\_fifteenMinuteRate”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getAllTopics\_fiveMinuteRate”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getAllTopics\_snapshot\_75thPercentile”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_deleteTopic\_snapshot\_75thPercentile”: 0, “nonheap\_init”: 2496, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getAllTopics\_meanRate”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_addTopic\_snapshot\_98thPercentile”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_updateTopic\_snapshot\_98thPercentile”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_addTopic\_snapshot\_99thPercentile”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_updateTopic\_snapshot\_99thPercentile”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_deleteTopic\_oneMinuteRate”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_deleteTopic\_snapshot\_mean”: 0, “heap\_used”: 169576, “gc\_ps\_scavenge\_time”: 183, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getTopic\_fiveMinuteRate”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getAllTopics\_snapshot\_mean”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_updateTopic\_fifteenMinuteRate”: 0, “heap\_committed”: 331776, “gauge\_response\_metrics”: 7, “classes\_unloaded”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getTopic\_snapshot\_max”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getAllTopics\_snapshot\_stdDev”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getTopic\_oneMinuteRate”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_addTopic\_oneMinuteRate”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_updateTopic\_meanRate”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getTopic\_snapshot\_min”: 0, “instance\_uptime”: 3113663, “gc\_ps\_scavenge\_count”: 9, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_updateTopic\_oneMinuteRate”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getTopic\_snapshot\_98thPercentile”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getTopic\_snapshot\_99thPercentile”: 0, “nonheap\_used”: 81115, “classes\_loaded”: 10391, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getTopic\_fifteenMinuteRate”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_updateTopic\_snapshot\_75thPercentile”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_addTopic\_snapshot\_max”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_deleteTopic\_snapshot\_999thPercentile”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_addTopic\_snapshot\_median”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getTopic\_snapshot\_95thPercentile”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getAllTopics\_fifteenMinuteRate”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getAllTopics\_snapshot\_99thPercentile”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_deleteTopic\_snapshot\_99thPercentile”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getAllTopics\_snapshot\_98thPercentile”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_addTopic\_snapshot\_min”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_updateTopic\_count”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_updateTopic\_snapshot\_median”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getAllTopics\_snapshot\_median”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_updateTopic\_snapshot\_stdDev”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_addTopic\_snapshot\_stdDev”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_deleteTopic\_snapshot\_95thPercentile”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_deleteTopic\_snapshot\_98thPercentile”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getAllTopics\_snapshot\_max”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getAllTopics\_snapshot\_95thPercentile”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getTopic\_snapshot\_median”: 0, “nonheap”: 0, “mem\_free”: 162199, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_addTopic\_snapshot\_75thPercentile”: 0, “threads\_totalStarted”: 31, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_addTopic\_meanRate”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getAllTopics\_snapshot\_min”: 0, “threads\_daemon”: 24, “threads\_peak”: 26, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_deleteTopic\_count”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_addTopic\_fiveMinuteRate”: 0, “datasource\_primary\_usage”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getTopic\_snapshot\_stdDev”: 0, “classes”: 10391, “httpsessions\_active”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_updateTopic\_fiveMinuteRate”: 0, “mem”: 412890, “systemload\_average”: -1, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getAllTopics\_oneMinuteRate”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_deleteTopic\_fiveMinuteRate”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getAllTopics\_snapshot\_999thPercentile”: 0, “heap”: 466432, “gc\_ps\_marksweep\_time”: 199, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_deleteTopic\_meanRate”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_addTopic\_snapshot\_mean”: 0, “httpsessions\_max”: -1, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_addTopic\_count”: 0, “heap\_init”: 262144, “counter\_status\_200\_metrics”: 95, “datasource\_primary\_active”: 0, “threads”: 26, “uptime”: 3155041, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_deleteTopic\_snapshot\_median”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_updateTopic\_snapshot\_mean”: 0, “gc\_ps\_marksweep\_count”: 2, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getTopic\_meanRate”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_getTopic\_snapshot\_mean”: 0, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_deleteTopic\_snapshot\_stdDev”: 0, “nonheap\_committed”: 82496, “com\_mydemoapplication\_springdataapplication\_mydataapplication\_TopicController\_addTopic\_fifteenMinuteRate”: 0 }, “statusCode”: 200 }, “beat”: { “hostname”: “BDSPIND70182685”, “name”: “BDSPIND70182685”, “version”: “4.0.0” }, "@version": “1”, “host”: “BDSPIND70182685”, “type”: “httpbeat”, “tags”: [ “beats\_input\_raw\_event” ] } } ] } } ---
**Author:** ![torkel](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/torkel/32/20_2.png) [@torkel](https://community.grafana.com/u/torkel)\ **Post date:** [May 29, 2017, 7:38am UTC](https://community.grafana.com/t/cannot-display-json-data-from-elastic-search/1128/2 "2017-05-29T07:38:00Z")
What do you want to show? A graph over time, a table? Have you tried adding a panel and using the ES query editor? ---
**Author:** ![saurabhkulkarni](https://avatars.discourse-cdn.com/v4/letter/s/e47774/32.png) [@saurabhkulkarni](https://community.grafana.com/u/saurabhkulkarni)\ **Post date:** [May 29, 2017, 8:25am UTC](https://community.grafana.com/t/cannot-display-json-data-from-elastic-search/1128/3 "2017-05-29T08:25:23Z")
Thank you for the quick reply. Actually I want to show the count field which I am getting in this json for every function, as it will always increase every time it is accessed. I am not able to display that value which is changing as per time. I have tried setting the particular field but cannot get which metric should I use to get it displayed in the graph. ---
**Author:** ![anon80964540](https://avatars.discourse-cdn.com/v4/letter/a/bbe5ce/32.png) [@anon80964540](https://community.grafana.com/u/anon80964540)\ **Post date:** [January 13, 2021, 4:02pm UTC](https://community.grafana.com/t/cannot-display-json-data-from-elastic-search/1128/4 "2021-01-13T16:02:40Z")