Syntax
JSON_KEYS(<JSON array as string>)
Description
Returns all keys of a JSON object (key:value pairs of the JSON) as a list.
Examples
Column1 | JSON_KEYS returns |
|---|---|
{"George":10, "Wins":[1,2,3]} | ["George", "Wins"] |
{"First":"Joni", "Last":"Smith", "Age":10} | ["First", "Last", "Age"] |
{"key1":25, "key2":75} | ["key1", "key2"] |
{"Ultimate":4, "Answer":2} | ["Ultimate", "Answer"] |
Further Documentation
Find more documentation on working with JSON here.