# Table Panel: Convert JSON Text to Table

**URL:** <https://community.grafana.com/t/table-panel-convert-json-text-to-table/14616>\
**Category:** Grafana\
**Created:** [February 20, 2019, 12:40am UTC](https://community.grafana.com/t/table-panel-convert-json-text-to-table/14616 "2019-02-20T00:40:31Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![ouronlyhope](https://avatars.discourse-cdn.com/v4/letter/o/b9bd4f/32.png) [@ouronlyhope](https://community.grafana.com/u/ouronlyhope)\
**Post date:** [February 20, 2019, 12:40am UTC](https://community.grafana.com/t/table-panel-convert-json-text-to-table/14616/1 "2019-02-20T00:40:31Z")

</div>

I have a Zabbix Item that is just list of queues and their respective jobs, and is (hopefully) JSON formatted. I’m trying to figure out how to take that JSON Text and have it show up in a Table Panel. I have tried this:

1. Create a New Table Panel
2. Set the Query Mode to text
3. Options -\> Data-\>Table Transform set to JSON

Nothing happens, I’m unable to select any columns below and the query displays just the JSON output (as if I didn’t change it from Table to JSON

I beginning to think I don’t fully understand what I’m doing here, the documentation shows that the Table Transform to JSON just magically happens.

I’m also wondering if maybe my JSON is just not formatted correctly, but if anybody has any other ideas on how to get JSON to show up as a table I’d really appreciate it!

Thanks!

```
Here's my JSON output
{
    "Data": [
                 {
                     "Queue": "Ready",
                     "Jobs": "10"
                 },
                 {
                     "Queue": "Started",
                     "Jobs": "12"
                 },
                 {
                     "Queue": "Finished",
                     "Jobs": "25"
                 }
             ]
}
```

---

<div class="post-metadata">

**Author:** ![ouronlyhope](https://avatars.discourse-cdn.com/v4/letter/o/b9bd4f/32.png) [@ouronlyhope](https://community.grafana.com/u/ouronlyhope)\
**Post date:** [February 23, 2019, 12:41am UTC](https://community.grafana.com/t/table-panel-convert-json-text-to-table/14616/2 "2019-02-23T00:41:52Z")

</div>

I’ve adjusted my output to look like the JSON below, still the Table just shows the text.

```
[
   {
      "type":"table",
      "columns":[
         {"text":"Queue","type":"string"},
         {"text":"Jobs","type":"number"}
      ],
      "rows":[
         ["Ready","10"],
         ["Started","12"],
         ["Finished","25"]
      ]
   }
]
```

---

<div class="post-metadata">

**Author:** ![tupacsoul](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/tupacsoul/32/9734_2.png) [@tupacsoul](https://community.grafana.com/u/tupacsoul)\
**Post date:** [February 24, 2020, 9:15pm UTC](https://community.grafana.com/t/table-panel-convert-json-text-to-table/14616/4 "2020-02-24T21:15:29Z")

</div>

Hi, did you get the resolution? I’m having this same problem.

---

<div class="post-metadata">

**Author:** ![decouxb](https://avatars.discourse-cdn.com/v4/letter/d/6de8d8/32.png) [@decouxb](https://community.grafana.com/u/decouxb)\
**Post date:** [March 3, 2021, 12:05am UTC](https://community.grafana.com/t/table-panel-convert-json-text-to-table/14616/5 "2021-03-03T00:05:15Z")

</div>

bumping this topic because we are facing a similar issue. Has anyone been able to figure out how to take JSON data from zabbix data (JSON is in the value field of the zabbix data) and convert that into a table output in grafana?

---

<div class="post-metadata">

**Author:** ![venijamin](https://avatars.discourse-cdn.com/v4/letter/v/a9a28c/32.png) [@venijamin](https://community.grafana.com/u/venijamin)\
**Post date:** [November 15, 2024, 12:53pm UTC](https://community.grafana.com/t/table-panel-convert-json-text-to-table/14616/6 "2024-11-15T12:53:35Z")

</div>

I know it’s an old post but if someone else is looking for this,  
I did this using a transformation of type “Extract fields”

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/c/7/c71aba817c1d27f1c8ebdd114ff442f24958316c.png)

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [November 15, 2024, 3:14pm UTC](https://community.grafana.com/t/table-panel-convert-json-text-to-table/14616/7 "2024-11-15T15:14:28Z")

</div>