How to extract value from JSON and display in separate rows or in the comma separated format

Grafana InfluxDB
1

From InfluxDB in one column I have JSON

[
   {
      "dtcId":"31798",
      "ecuId":"99",
      "status":"ACTIVE"
   },
   {
      "dtcId":"801A55",
      "ecuId":"86",
      "status":"ACTIVE"
   }, ....

But I would like to convert it to such format that in Table panel I will get something like this:

dtcId | ecuID
31798 | 99
801A55 | 86

or at least:

dtcID list
31798, 801A55

I tried to use Transformation and without problem this:
dtcReadout.dtcs[0].dtcId
extracts value from JSON array but how to extract all dtcsId from all array items :frowning:

2

Welcome @mich20061 to the Grafana forum.

Are you using Flux? If yes, have you explored Experimental json.parse() function | Flux Documentation ?

A few potentially helpful threads here and here.