Optional property that, when set to True, specifies that XML/JSON functionality should match the functionality and features of the 2017 version. To access the most recent XML/JSON flattening features, leave this blank.

Data Type

bool

Default Value

false

Remarks

Flattening eliminates nested hierarchies and puts all values into a single level, resulting in clean columns and rows. The ability to flatten or unflatten complex JSON objects makes nested JSON, arrays, or tables linked by foreign keys, more usable for analytics, reporting, or machine learning.

Available flattening features include DataModel, FlattenArrays, FlattenObjects, and the ability to flatten tables and columns dynamically via a SQL query.