What are the querying capabilities and syntax for JSON query in an Azure workbook?

Question

In Azure workbook edit mode, I clicked Add query and set Data source to JSON.

I could not find any documentation what is the syntax I can use. I looked for it in the official doc articles like:
- Workbooks how-to
- Workbooks for VMs

I managed to get the query to display a set of rows once I wrote {StackTrace}, which was a reference to a variable containing dynamic json array from previous Kusto query. But I do not know what else I can do.

Answer 1

The JSON source allows you to add static data to a workbook and visualize it like you would any other data source.

Image of a workbook with JSON data

It does not allow you to transform the data or query for parts of the data.

You can however reference the JSON data in another query control with a Merge source to bring together data from different sources.

Also, comprehensive workbook docs can be found at this Github repo