jsonimport(
JSON
)

The jsonimport( function converts JSON into a Panorama dictionary or data array.


Parameters

This function has one parameter:

json – The JSON text to be imported.


Description

This function converts JSON into a Panorama dictionary or data array. (JSON is a data interchange format that is used by many web API’s. See [http://json.org][] for more information.)

For example, this formula creates a Panorama dictionary.

jsonimport(||| {"Name" : "Jack", "Color" : "Blue", "Size" : 38} |||)

The example above is exactly equivalent to this formula that uses the initializedictionary( function.

initializedictionary("Name","Jack","Color","Blue","Size",38)

This example creates a Panorama data array.

jsonimport(|||["Orange", "Teal", "Yellow"]|||)

The example above is exactly equivalent to this formula that uses the dataarray( function.

dataarray("Orange", "Teal", "Yellow")

Complex JSON text can include arrays nested within dictionaries, or vice versa. The jsonimport( function will create the equivalent nested structure using Panorama dictionaries and data arrays.


See Also


History

VersionStatusNotes
10.0NewNew in this version.