RowScanDepth
Specifies the number of rows the provider scans when dynamically determining table columns.
Data Type
string
Default Value
"100"
Remarks
When this property is set, the add-in scans the specified number of rows (objects) in the XML document to detect columns and datatypes. The scans follow nested objects, counting each object array as a single row.
If no schema (RSD) is available for the table, columns are determined dynamically using this scan. The behavior applies when using GenerateSchemaFiles or when a schema file is not present.
Higher values improve detection accuracy but may increase request time. Setting this property to 0 causes the add-in to parse the entire XML document.
This property is useful for controlling the trade-off between schema detection accuracy and query performance when parsing XML data.
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.