[Bug] UQL parser returning a JSON object is not being rendered

[fatshark-pca]

Describe the bug

The UQL parser does not render/return a value that is visualized correctly. Other parsers work as expected.

Steps to reproduce

Given inline JSON source:

{
  "foo": 1,
  "bar": 2
}

when selecting UQL as parser, with query:
(the query can even be omitted)

parse-json

the resulting table output will be:

result
{ "foo": 1, "bar": 2 }

However, I am expecting the output to be:

foo	bar
1	2

This works fine for Default and Backend parsers.

Sample Data

• Grafana Play - Default
• Grafana Play - Backend
• Grafana Play - UQL

[zhabi]

seems the plugin is not able to handle the single json object.

and another scenario, when there is some filtering to the array and leave one object, the plugin will handle it as a single json object instead of an array with 1 parameter, and then the problem also occurs.

[yesoreyeram]

Can you try?

parse-json
| project kv()

[fatshark-pca]

Hi Sriram, thanks for looking at this. Your suggested solution produces:

key	value
foo	1
bar	2

which does not match the expected output mentioned in my original post (or how the other parsers return). It would be nice to have UQL be able to parse JSON objects similarly as how the other parsers behave, without having to add additional conversions. Thanks!