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. |
|
|
Adds or modifies an element in JSON data specified by an object name, an array index, or a path. |