The number of rows to scan when dynamically determining columns for the table.

Syntax

Connect-XML -RowScanDepth string

Data Type

cstr

Default Value

"100"

Remarks

The number of rows (objects) to scan when dynamically determining columns for the table -- the row scan follows nested objects, counting 1 object array as 1 row. Columns are dynamically determined when a schema (RSD) file is not available for the table, such as when using GenerateSchemaFiles.

Higher values will result in a longer request, but will be more accurate.

Setting this value to 0 (zero) will parse the entire XML document.

See Also

• DataModel: Set this property to model the detected rows into tables.
• Parsing Hierarchical Data: Shows how to query data using each of the DataModel configurations.
• XPath: Use this property to explicitly specify the tables by their XPaths.
• Automatic Schema Discovery: Shows how to configure column discovery using RowScanDepth, FlattenObjects, and FlattenArrays.
• Modeling XML Data: Provides a map to the different data modeling strategies.