JSON and XML
This section provides a complete list of the JSON and XML properties you can configure in the connection settings for this provider.
| Property | Description |
| XPath | The XPath of an element that repeats at the same height within the XML/JSON document (used to split the document into multiple rows). |
| DataModel | Specifies the data model to use when parsing XML/JSON documents and generating the database metadata. |
| JSONFormat | Specifies the format of the JSON document. Only has an effect when Format is set to JSON. |
| XMLFormat | Specifies the format of the XML document. |
| FlattenArrays | By default, nested arrays are returned as strings of XML/JSON. The FlattenArrays property can be used to flatten the elements of nested arrays into columns of their own. Set FlattenArrays to the number of elements you want to return from nested arrays. |
| FlattenObjects | Set FlattenObjects to true to flatten object properties into columns of their own. Otherwise, objects nested in arrays are returned as strings of XML/JSON. |
| BackwardsCompatibilityMode | Set BackwardsCompatibilityMode to true to use the XML/JSON functionality and features available in the 2017 version. |
| QualifyColumns | Controls whether the provider will use relative column names. |
| URISeparator | A delimiter used to separate different values in the URI property. |