XML File Data Parsing

Application Scenario

You may want to parse an offline XML file into a two-dimensional table and store it in a database.

Implementation Method

Upload the XML file to the FTP server or place the file in the webroot folder of the FineDataLink project.

Use the API Input function to access the XML file, parse the file using the XML Parsing operator, and store the data in the database.

You can download the sample file XML_sample.zip.

Placing the XML File

Upload the XML file to the FTP server or place the file in the \webapps\webroot path in the FineDataLink installation directory.

The XML file in this example is placed in the /linux_EN/webapps/webroot path in the FineDataLink installation directory, as shown in the following figure.

Note:

 You can also create other folders in the webroot folder and adjust the access path accordingly in subsequent steps.

Access the XML file in the browser using https://FineDataLink IP address:Port number/webroot/XML file name.

Reading File Data using the API Input Operator

Create a scheduled task, add the Data Transformation node, click the added Data Transformation node to enter the editing page, add the API Input operator, and fill in the address of the uploaded XML file for data fetching, as shown in the following figure.

Click Data Preview to view the fetched XML file data, as shown in the following figure.

Parsing the XML File

Use the XML Parsing operator to parse the XML data, and specify a namespace for the fetched XML data, as shown in the following figure.

Click Select XML Node to select the fields to be parsed, as shown in the following figure.

Click Data Preview to view the tabular data after parsing, as shown in the following figure.

Outputting Data to a Database Table

Use the DB Table Output operator to store the parsed upstream data in the database, as shown in the following figure.

Effect Display

After you save and run the task, the XML file data is stored in the target database, as shown in the following figure.