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 connector 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 connector 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.