Syntax
JSON_VALUE<string>;<string containing json key>)
Description
Returns a value for a given key from a JSON object.
Examples
| Column1 | Key | JSON_VALUE returns |
|---|---|---|
{"myBoolean":true,"myList":["a","b"],"myMap":{"c":"d","a":"b"},"myObject":"myClass","myJsonObject":{"myString":"myStringValue"}} | myBoolean | TRUE |
{"myBoolean":true,"myList":["a","b"],"myMap":{"c":"d","a":"b"},"myObject":"myClass","myJsonObject":{"myString":"myStringValue"}} | myObject | myClass |
{"myBoolean":true,"myList":["a","b"],"myMap":{"c":"d","a":"b"},"myObject":"myClass","myJsonObject":{"myString":"myStringValue"}} | myList | \["a","b"\] |
{"myBoolean":true,"myList":["a","b"],"myMap":{"c":"d","a":"b"},"myObject":"myClass","myJsonObject":{"myString":"myStringValue"}} | myMap | \{"c":"d","a":"b"\} |
{"myBoolean":true,"myList":["a","b"],"myMap":{"c":"d","a":"b"},"myObject":"myClass","myJsonObject":{"myString":"myStringValue"}} | myJsonObject | {"myString":"myStringValue"} |
Further Documentation
Find more documentation on working with JSON here.