JSONTOLIST

Owned by Charles Bishop (Deactivated)
Jan 30, 2018
1 min read

Syntax

JSONTOLIST(<string containing a JSON array>)

Description

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

Examples

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