How to parse JSON array and show it in a Table?

Grafana
1

Sample log line

other logs values=‘[{“company_id”:“id1”, “company_name”: “name1”},{“company_id”:“id2”, “company_name”: “name2”}]’

I want to be able to extract the json array from values and show it in a Table (columns, company_id and company_name and so on)

I’ve tried

| pattern `<_> values=‘’, | json values

and that doesn’t work when I go to Transform the table.

Why is it so difficult to do this? Can someone help please

2

image
image1060×322 31.5 KB

image
image653×595 7.83 KB

i am trying but still can’t extract the values
i use extract filed transformation
line format{{.company_name}}
but still can’t achive if you find the way then post it here…
thanks

3

resolved this by printing the individual objects within the array as as part of the logs