JSON functions
JSON functions parse, create, modify, and format data in JSON format. See Working with the JSON functions.
|
Function |
Purpose |
|
Deletes a JSON data element specified by an object name, an array index, or a path. |
|
|
Formats elements in JSON data to make them easier to read. |
|
|
Queries JSON data for an element specified by an object name, an array index, or a path. |
|
|
Validates and returns the JSON data type for an element specified by an object name, an array index, or a path. |
|
|
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. |
|
|
Lists the values in JSON data for an element specified by an object name, an array index, or a path. |
|
|
Converts a list of separated values into a JSON array of the specified type. |
|
|
Parses text as JSON data and keeps the parsed JSON representation in memory for you to reuse with other JSON functions. |
|
|
Returns 0 if JSON is not parsed, -1 if parsed but invalid, or a positive number representing the JSON type if parsed and valid. |
|
|
Adds or modifies an element in JSON data specified by an object name, an array index, or a path. |