Document toolboxDocument toolbox

getJsonFields

Owned by Anthony Shevlin (Deactivated)
Last updated: Dec 01, 2023
1 min read
[ 1 Usage details ] [ 2 Example ]

Extract field names from a JSON object. Returns a concatenated comma-separated field list ordered in ascending order.

Usage details

LQL Command

select getJsonFields(fieldname) from table

Example

Input
table

json_data

json_data

{"a": "v", "b": "c"}

{"a": {"b": "c"}}

LQL Command

select *, getJsonFields(json_data) as a jsonFields from table

Output

json_data

jsonFields

json_data

jsonFields

{"a": "v", "b": "c"}

a , b

{"a": {"b": "c"}}

a