English
Summary
A pack of 3 activities which can handle any nested and complex Json / JArray and converts it into XML, CSV files and Data Table.
Overview
- Json to CSV: To view the data in tabular format, output CSV file can be opened using Excel. The first row in Excel will be the headers, generated from all the tag names in JSON file. In case of multi-level nested JSON, it retains the complete path of each element, separated by slash '/'. (as explained in image Explanation 1.)
- Json To XML: This activity converts Json/Array in XML format without any data loss. In case of JArray, element tags are added for each array element and in case of non-array objects Json keys are converted to XML tags and Json values are converted to XML inner text. Output of this activity should be .xml file. (as explained in image Explanation 3)
- Json To DataTable: It converts input Json/JArray to Datatable and provides the flexibility of directly applying all Data Table functions like filtering the JSON Data. In case of JArray, each Data row is converted to Excel Row Item and in case of non JArray structure, all the tags generate headers and in case of multi-level nested JSON, it retains the complete path of each element, separated by slash '/' so as to prevent any data loss. (as explained in image Explanation 2)
Benefits
Published: 11 Jun 2019 | Updated: 18 Dec 2020
License
By clicking download you agree to the following license.
Code Language
Visual Basic
Runtime
.NET Framework
Tags
Compatibility
It is compatible with all previous and current versions of UiPath Studio
Dependencies
Newtonsoft.Json [10.0.3]
Support
UiPath Community SupportSimilar Listings
XML Conversion Activities
A package of 3 custom activities which accepts any complex XML as input and converts it into Data Table, JSON and CSV files.
4 reviews
5.9k
Bronze Certified
JSON Utilities
The Custom Activity package can perform the tasks related to JSON operations, which can be readily used to perform actions like converting JSON to XML, JSON to CSV, etc
2.9k
Bronze Certified
ADROSONIC - Custom Audit Logs
Creating a Custom Audit Log in XML/JSON format and store it at a user specified location
1 reviews
1
Supported by Publisher
PDF.co - Activities for PDF Documents
UiPath Activities from PDF.co. Easily edit PDF documents, extract text and unstructured data from PDF with OCR support. Split and merge PDF pages, convert to formats such as Text, CSV, JSON or XML.
1 reviews
1.1k
Gold Certified
