The XML file provider is a
read-only provider where you specify the data schema via XPath expressions.
Below is a sample XML file you can read with this provider there are a few things to note.
product is a child element of
id of the
product is an xml attribute value of
<products> <product id="1"> <name>product1</name> <price>123.45</price> </product> <product id="2"> <name>product2</name> <price>456.78</price> </product> </products>
The XPath to the product child nodes is either
The XPath to the product id is
@id and the XPath to name and price are
price as they are elements of the product (current) node.
These XPath expressions then translate the XML document into a Table structure for Data Sync to use.
XPath documentation on MSDN https://msdn.microsoft.com/en-us/library/ms256471(v=vs.110).aspx
The file path or Web Url to the XML file to load.
Windows Wildcards are supported in the filename i.e. *.xml.
The XPath expression to the node item collection.
If you need to register XML Namespaces for your document you can add XML Namespaces and prefixes in this collection.
Add to the Columns collection specifying the DataType, Name and the XPath Expression. XML XPath expressions are
When using Wildcard filenames this specifies whether the search will include subfolders.
This is a special column that is injected into your schema and will return the filename of the XML document. This is especially useful when using wildcard filenames.