Work with JSON 🗄️

Refer to the TODO: add back in json link JSON page in the Explanation section of the documentation to understand what JSON is and why/when it needs to be used with ArupCompute.

The ArupCompute Excel plugin provides a range of functions for creating, manipulating, and unpacking JSON.

Example

The below example makes use of the 'working with lists of data' example calculation. The code for this calculation is here and the custom data type used as an input is here.

Using the additional Excel functions that are provided by the ArupCompute Excel plugin, the required input JSON is straightforwardly constructed.

The above example Excel file is here.