/

JSONTOLIST

JSONTOLIST

Owned by Juliane Wetzel

Last updated: May 10, 2023 by Konsta Danyliuk (Deactivated)

Syntax

JSONTOLIST(<string containing a JSON array>)

Description

Converts the selected JSON data type column into a List data type column.

Examples

Column1	JSONTOLIST returns
["red","blue","yellow"]	[red, blue, yellow]
[red, blue, yellow]	[red, blue, yellow]
[red, blue, "yellow"]	[red, blue, yellow]
["1","44","21","4"]	[1, 44, 21, 4]
[1, 44, 21, 4]	[1, 44, 21, 4]
[1, 44, "21", 4]	[1, 44, 21, 4]
[{"ID1":"1"},{ID2:2},{ID3:"3"}]	[{"ID1":"1"}, {"ID2":2}, {"ID3":"3"}]

Further Documentation

Find more documentation on working with JSON here.

Related content

JSONTOLIST

More like this

JSONTOLIST

More like this

TOJSON

More like this

TOJSON

More like this

TOJSON

More like this

JSON_KEYS

More like this