JSON_KEYS

Owned by Charles Bishop (Deactivated)
Jan 30, 2018

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"]