How to create a column that the value is an array

[dxu73]

Does this tool support generating JSON document in which a field value is an array.

For example, how to generate a document like the following. Note: The 'Hobbies' field value is an array:

{ 'Name' : 'Jane', 'Address' : '123 Main Street', 'Hobbies' : [ 'Ski', 'Read', 'Jogging']}

[benkeen]

Hi dxu,

Interesting! But no, this isn't really possible right now. Technically I could definitely tweak the JSON Export Type to generate an array of values for the Custom List Data Type, instead of a comma-delimited list, but then it wouldn't be consistent with the other Export Types.

I think to do this, you'd probably need to create a new, custom Export Type that generates it exactly as you need.

Sorry about that!

• Ben

[soundstep]

I second that, an array format is definitely missing, that's the first thing I was looking for.

[gbordelgit]

hey,
would be good to support array items ['1','2','3']as a sql column for postgresql ..