How to display an array of JSON objects as JSON

Grafana Dashboards
1

I’m on version 11.1.3

The data source is MongoDB. I have a field that is an array of JSON objects. It shows as an array of maps in a Table. I tried to set the Cell Type to JSON View but it doesnt help.

This is an example of a source record in mongodb.

{ "a" : 100, 
  "b" : "hello",
  "events": [ { "event_dt" : "2024-10-01",  "event_server" : "10,3,40.123"},
                   { "event_dt" : "2024-10-02",  "event_server" : "10.1.50.212"}
                 ]
}

The events fields displays as an array of maps like this in the Table in Grafana :
[map[ event_dt : 2024-10-01 event_server: 10.3.40.123] map[ event_dt : 2024-10-02 event_server: 10.1.50.212 ] ]

How do i get it to display as in JSON format ?

TIA !!

2

what visualization will you be using to display your data

3

A Table.

4

maybe use business text plugin

image
image1090×748 54 KB

5

Hi @yosiasz
I don’t want it flattened. I want the whole Events field to be rendered as a JSON value. Flattening it will create noise as there can be a lot of fields of occasional value to users.

1 Like
6

image
image613×144 5.53 KB

like this?

or using the Business Table plugin - @mikhailvolkov

image
image1292×728 51.5 KB

1 Like
7

This looks like it will do it. But how do I use a Business Table plug in. Sorry, I have only basic knowledge of Grafana.

Thanks.

8

@yosiasz Can you tell me how you did it in the first screenshot above ?
Thats what im looking for.
Thanks

9

it’s pretty self explanatory. read the Business text plugin, try it out based on your data and when stuck post back and would be happy to help you.