0

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.

enter image description here

John Gardner
  • 24,225
  • 5
  • 58
  • 76
Konrad Jamrozik
  • 3,254
  • 5
  • 29
  • 59
  • you don't know how to set parameter "StackTrace", which is getting from a query? – Ivan Glasenberg Jul 23 '19 at 09:48
  • I know how to do this. My question is: is there is anything else I can do with the JSON query beyond just pasting a parameter value? It is called "JSON query", so I expect there should be some querying capabilities available. For example, I tried `{stackTrace}.rows[0]` but it didn't work. – Konrad Jamrozik Jul 23 '19 at 18:49
  • technically, it isn't called json query, it's a json data source. its a "query" that gets its data from static json (though that json content can also contain parameter markers, so it isn't *entirely* static). I'm thinking about renaming the data source to "Static data" and having json just be one of the possible options. – John Gardner Aug 11 '20 at 18:03

1 Answers1

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

Arun Abraham
  • 26
  • 1