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

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

Further Documentation

Find more documentation on working with JSON here.