JSONTOLIST

May 10, 2023

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

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.