Unexpected non-whitespace character after JSON at position 123

6

frustrating!

i seem to recall that parseJson does NOT like the outermost element to be an array (ie […] ) but instead wants the outermost element to be an object (ie {“o”:[…]} ).

so i think you need to wrap the json like this

parseJson( '{"o":[' + jsonColumn.toText().join(',') + ']}'

and then extract the “o” object to get the array