Create your first automation in just a few minutes.Try Studio Web →
by Internal Labs
4
Activity
11.2k
Summary
Summary
A package of 3 custom activities that accept any complex XML file as input and converts it into DataTable, JSON and CSV files.
Overview
Overview
The package contains 3 custom activities for converting XML files to other data formats:
1. XML to DataTable
2. XML to JSON
3. XML to CSV
These activities can handle all types of complex and nested XMLs either in a text file (specified in the input property InputXmlFilePath) with valid XML in it, or accept XML strings directly (specified in the input property InputXmlString). The output will be a CSV or JSON file, at user's designated path (specified in the input property OutputCSV/JSONFilepath), or a DataTable from the input XML.
The time required for this conversion is proportional to the level of nested data structure of the XML (between milliseconds to a few seconds).
Input Properties
Output Properties
Output DataTable – It generates a DataTable from the input XML and provides an option of saving it in a DataTable type of variable.
Notes
Among InputXmlFilepath and InputXlString properties, only 1 input is allowed to be passed for all these activities and it is a mandatory input property. Output XmlFilePath and Output DataTable are mandatory output fields.
Features
Features
This activity caters to the need of converting XML data into tabular form by converting it to a CSV file or directly to data table as well. It provides flexibility of directly filtering XML data according to business rules, by converting it to CSV file or DataTable directly. In case of complex and nested XML, it also retains the whole path of each element in the headers, so as to prevent any data loss. The user will no longer have to write any complex logic for viewing XML data into an Excel sheet and converts XML to JSON format without any kind of data loss. User can simply provide the path of text file with XML in it or provide XML string directly and get the desired output as a CSV file, JSON file or DataTable.
Additional Information
Additional Information
Dependencies
Newtonsoft.Json [10.0.3]
Code Language
C#, Visual Basic
Runtime
Windows Legacy (.Net Framework 4.6.1)
Technical
Version
1.0.1Updated
June 4, 2023Works with
Studio: 21.10 - 22.10
Certification
Silver Certified
Tags
Support
UiPath Community Support