XPath

Specifies the XPath of an element that repeats at the same height within the XML document, which the provider uses to to split the document into multiple rows.

Data Type

string

Default Value

Remarks

The value of this option depends on the current XMLFormat. By default, connector automatically finds the object arrays in the document and models them as rows. This parameter allows you to explicitly define the object arrays using XPaths.

Multiple paths can be specified using a semicolon-separated list. The DataModel property governs how the nested object arrays are modeled as tables.

When using the XMLTable XMLFormat, this option uses a special format so that both column and row paths may be provided. Refer to the XMLFormat documentation for more details.

Automatically Detecting Object Arrays

When XPath is left empty, the connector determines the XPaths by parsing the XML document and identifying the object arrays. The DataModel and RowScanDepth properties configure the row scan; see Automatic Schema Discovery for more information.

This property is used to generate the schema definition when a schema file is not present (see Customizing Schemas).

XPath Examples

For the people example in Raw Data, an example XPath is $.people.vehicles.maintenance

A wildcard XPath can also be used and is helpful in the case that the XPaths are all at the same height but contain different names: