Working with XML Files
Extensible Markup Language (XML) is a markup language that defines a set of rules for encoding documents in a format that is both human-readable and machine-readable.
XML file support in Guzzle provides extensive features to specify file format details and many other properties which make it easier to work with our Data. This article outlines how to work with XML files for source and target in Ingestion activity.
XML File Properties in Guzzle#
| Property | Description | Default Value | Available in Source Section | Available in Target Section |
|---|---|---|---|---|
| Character Set | It refers to the Set of Characters used to Read/Write test files. Allowed Values include: UTF-8, UTF-16 etc. | UTF-8 | ✔ | ✔ |
| XML Row Tag | The row tag of your XML files to treat as a row. For example, in this XML <books> <books></books> ...</books>, the appropriate value would be book. | Row | ✔ | ✔ |
| XML Root Tag | The Root tag of your XML files to treat as a root. It encloses all the other elements and is therefore the sole parent element to all the other elements. For example, in the XML <books> <books> <books> ...</books>, the appropriate value would be books. | Rows | ✔ | ✔ |
| Configure processed path | The Configure Processed Paths feature allows the user to specify the directory and Guzzle moves the Data into that directory. When creating a processed file path Guzzle creates 3 subfolders: processed, rejected and partial. For more information click here. | NULL | ✔ | X |
| Configure control file settings | The Configure Control File feature cross check whether a file is valid or not. It compares the number of records in the original file and the control file extension. Guzzle provides the Configure Control File feature for all local file formats including Delimited, JSON, XML, Excel and Fixed Length Files. For more information click here. | NULL | ✔ | ✔ |
| Partial Load | Specify partial loading of files. | False | ✔ | X |
The Interface for XML in Guzzle is :#
