User Guide

10.5.0
- 10.5.3
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1
- 10.2

Back Next

Read XML Task

The Read XML task can read data from

XML

files and load that data into a RowSet variable. That variable can then be used to import the data into a database or translated to another file type such as Excel, fixed-width, or

CSV

XML files by nature can contain multiple levels of elements and various data throughout them. Therefore you can add multiple RowSet elements to the Read XML Task by adding them through the

Add

button in the sub-menu. For example, you could have an XML file that contains customer information along with a list of the products they ordered. The customer information can be parsed into one RowSet and the list of products into another RowSet. Those variables can then be used to load two separate database tables.

The path to an XML element or attribute is case sensitive. If the path is not typed correctly or if the case is wrong, an error will not be generated.

If validating an XML file using an external Schema, type the path to the Schema file in the Schema URL box on the Advanced tab of the Read XML Task page. The URL syntax is: file://path/file.xsd

Excel Pattern Syntax

Example 1: Read XML File

Example 2: Using Nested Shared Values to Correct XML Parsing

Nested Shared Values

Read XML Task

Add a RowSet Field Definitions

Column

Download Guide

Watch

Comments

Communities

Knowledge Base