JSON functions

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

Function

Purpose

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.

JSONGetElementType

Validates and returns the JSON data type 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.

JSONMakeArray

Converts a list of separated values into a JSON array of the specified type.

JSONSetElement

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