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