Reference > Functions reference > JSON functions
 

JSON functions

JSON functions parse, create, modify, and format data in JSON format. See Working with the JSON functions.

 

This function

Returns

JSONDeleteElement

Deletes a JSON data element specified by an object name, an array index, or a path.

JSONFormatElements

Formats elements in JSON data to make them easier to read.

JSONGetElement

Queries JSON data for an element specified by an object name, an array index, or a path.

JSONListKeys

Lists the object names (keys) or array indexes in JSON data for an element specified by an object name, an array index, or a path.

JSONListValues

Lists the values in JSON data for an element specified by an object name, an array index, or a path.

JSONSetElement

Adds or modifies an element in JSON data specified by an object name, an array index, or a path.

Related topics 

About functions

About formulas