User Tools

Site Tools


transformations:parsexml

PARSE XML

Category: Transform / Web


Description

Parse XML data into a tabular format.


Use cases

  • Enterprise data parsing from enterprise systems (e.g., transactions, messages).
  • Parse data from Web APIs that return XML.


Action settings

Settings Description
Column Select the column containing the source XML to be parsed.
Decimal separator Select the decimal separator in numeric values. Options: Comma or Dot.
Thousand separator Select the thousands separator in numeric values. Options: Default, Comma, Point or Space.
DTD processing Options: Prohibit, Ignore, or Parse DTD.
Value types Options: Auto (automatically recognize numeric values and convert them into numbers) or
All text (treat all values as text).
Root XML path* The path to the XML node from which parsing starts.
Column names Select the method used to name columns in the result dataset. Options: Element name,
Relative XML path, or Full XML path.
Don't delete original column When checked, the source column with JSON(s) will be kept in the result dataset.
Parse paths Select the XML paths to parse. One path corresponds to one column in the result dataset.
Options: Parse all paths or Parse selected paths (and select the paths from the list).

* Setting can be specified using a parameter.


Examples

Example #1

Parse the submitted XML-formatted data in the "Customer List" column.

Before (source table)

<data>
<person><id>1</id><name>John Doe</name><age>30</age></person>
<person><id>2</id><name>Jane Smith</name><age>25</age></person>
<person><id>3</id><name>Michael Johnson</name><age>40</age></person>
</data>

After (result table)

id name age
1John Doe 30
2Jane Smith 25
3Michael Johnson 40

Action parameters

Column: Customer List
Root XML path: data
Column names: Element name
Parse paths: Parse selected paths
Selected paths: person/age, person/id, person/name


See also

transformations/parsexml.txt · Last modified: 2025/02/01 14:36 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki