JSON - Arrays of objects made from sheet rows
Closed this issue · 2 comments
Having a hard time getting my sheet to export. Granted I'm using a bunch of the advanced features. I have each row as an object that has three properites and two sets of nested arrays of properties.
{ Name: XXX,
Prop1: XXX,
Prop2: XXX,
Array1: [ 1,2,3],
Array2: [1,2,3]
}
It will export one (row) of these but wont export the whole sheet as an array of these objects. Every time I use the Export Contents as Array or Export Sheet Arrays option, I just get a blank array with no content.
[]
Am I doing something wrong?
The most common thing that causes this issue is the column keys not being properly formatted to support both arrays and nested elements. (which looks like the case from your screenshot) The Nested array prefix option should handle this automatically for you. See the wiki section on Exporting Nested Elements and Sheet Arrays at the Same Time for some more detailed information.
Thank you so much! That totally fixed the issue.