FormulaSpy 1.19.1

New

• Added new function 'JsonQuery(json, query, returnStyle)' to query JSON data.

Improved

• Usability & UI improvements to Formula Explorer.
• Formula Explorer remembers your selected view style.
• Improved installer.

Fixed

• Bug fixes.

JsonQuery function

The new JsonQuery is used to run queries on JSON data, in a referenced cell or as a text argument.

Parameters

• json: The JSON to query. This can be a reference to a cell that contains JSON data, or it can be supplied as text.
• query: This is the query to run. It follows the JmesPath query syntax. Examples are here.
• returnStyle (optional. Default value is 1: ArrayAsCsv): This defines how array results should be returned. It can have a value of 1 to 4:

1. ArrayAsCsv: Returns "aaa", "bbb", "ccc"
2. ArrayAsJson: {["aaa", "bbb", "ccc"]}
3. ArrayAsHorizontalRange: Adds the results as new cells, horizontally.
4. ArrayAsVerticalRange: Adds the results as new cells, vertically.