ToJson(#table)

The ToJson() takes a reference to a table and converts it to a JSON string. It is similar to ToXml(), but expects a different structure.

The image below shows an example for the details of the expected structure:

• Dictionary keys end with a ":"
• Adjacent keys in the same column belong to the same dictionary
• A "-" marks the beginning of an array. Array entries are marked by an empty cell in the same column as the initial "-". Any other value marks the end of the array
• A horizontal sequence of values is interpreted as an array

ToJson() returns the parsed data in a compact JSON string ready to be used with API calls and other purposes.