JDBC Driver for XML

Build 22.0.8462

XPath

The XPath of an element that repeats at the same height within the XML document (used 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 driver 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

If XPath is left empty, the driver will determine 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 will be used to generate the schema definition when a schema file is not present (see Customizing Schemas).

XPath Examples

Example XPath for the people example in Raw Data: $.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:

<rsb:set  attr="XPath" value="/feed/*" />

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462