Specifies that object properties should be flattened into columns of their own. Otherwise, objects nested in arrays are returned as XML/JSON strings.

Data Type

bool

Default Value

true

Remarks

By default, nested objects are returned as XML/JSON strings. To flatten object properties into columns of their own, set FlattenObjects to true. The add-in generates the column name by concatenating the property name onto the object name with a dot.

For example, you can flatten the nested objects below at connection time:

[
     { "grade": "A", "score": 2 },
     { "grade": "A", "score": 6 },
     { "grade": "A", "score": 10 },
     { "grade": "A", "score": 9 },
     { "grade": "B", "score": 14 }
]

When FlattenObjects is set to true and FlattenArrays is set to 1, the preceding array is flattened into the following table:

Column Name	Column Value
grades.0.grade	A
grades.0.score	2