Table of Contents

Search

  1. Preface
  2. Introduction
  3. Dashboard
  4. Resources
  5. Workflows
  6. Task Reference
  7. Services Overview
  8. Users
  9. Logs and Reports
  10. Encryption
  11. System
  12. Appendix
  13. Glossary Terms

Read XML Task

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

0 COMMENTS

We’d like to hear from you!