Connect to XML | Wyn Documentation

Wyn Enterprise User Guide

Wyn Enterprise: Connect to XML

To create a XML data source in Wyn Enterprise, follow these steps.

On the Resource Portal, navigate to Create (+) > Create Data Source.
Select Xml in the data source list on the left or in the icon view on the right.
Fill in the database configuration information for the selected data source.

Field	Description
Name*	The name for the data source that you want to specify.
SourceType	Select from the list that displays the following options - Local, Web, and Embed.
Data Source*	When the source type is Local, click Select File to select the local source file. When the source type is Web, you need to enter the source address of the source, which is usually a URL. When the source type is Embed, you need to enter or paste the content of the XML file.
XPath*	Use a path expression to navigate to the XML document. For details, please refer to https://www.w3schools.com/xml/xpath_syntax.asp
Use Table/Field Name Mapping	If you check this option, you can either import a CSV file or manually enter the display names for the required tables or fields in the Mapping dialog. For more information on mapping table and column names, visit this topic.

* Required fields

Click Create after the successful connection.

You can view the added data source in the Categories tab of the Resource Portal.

Note:
Since the data is imported into the system, if you want to refresh the data of the data source, you need to manually edit the data source and import the data again.
If garbled characters appear in a local XML file, save the file in the UTF-8 encoding and upload it again.
Also, if a column with the same name is detected, only the column that appears first is retained, whereas the data from the column with the same name is discarded.