JSON and XML
This section provides a complete list of the JSON and XML properties you can configure in the connection string for this provider.
| Property | Description |
| XPath | Specifies the XPath of an element that has the same name as other elements at that same height within the XML/JSON document. This XPath is used to split the document into multiple rows. |
| DataModel | Specifies the data model configuration to use when parsing XML/JSON documents and generating the database metadata. The value supplied here controls how the driver models nested object arrays into tables. |
| JSONFormat | Specifies the format of the JSON document. Requires Format to be set to JSON. |
| XMLFormat | Specifies the format of the XML document. |
| FlattenArrays | Specifies the number of elements you want to return from nested arrays, as columns of their own. Only recommended for arrays that are expected to be short. |
| FlattenObjects | Specifies that object properties should be flattened into columns of their own. Otherwise, objects nested in arrays are returned as XML/JSON strings. |
| BackwardsCompatibilityMode | Optional property that, when set to True, specifies that XML/JSON functionality should match the functionality and features of the 2017 version. To access the most recent XML/JSON flattening features, leave this blank. |
| QualifyColumns | Specifies whether the provider will use relative column names. |
| URISeparator | A delimiter used to separate different values in the URI property. |