English
Summary
This Custom Activity provides the ability to convert DataTable to HTML table, convert to JSON, find Min,Max and Average of a column, find column names and rename column in a DataTable
Overview
This custom activity provides seven custom functionalities around DataTable object in UiPath:
1. Convert To HTML - This activity converts the DataTable to HTML table. This is useful to output DataTable in HTML table format for email or for web pages.
2. Convert To JSON - This activity converts DataTable to JSON object. This is particularly useful when calling any external REST API that requires data in JSON format.
3. Get Average Value - This activity returns the average of a given column in a DataTable.
4. Get Min Value - This activity returns the minimum value of a given column in a DataTable.
5. Get Max Value - This activity returns the maximum value of a given column in a DataTable.
6. Get Columns - This activity returns the list of string with DataTable's column names. This is useful when you need to check if a column exists in a DataTable before performing any operation.
7. Rename Column - This activity renames the existing column in a DataTable to a new name and returns the DataTable object with updated column name.
Benefits
Published: 15 Apr 2020 | Updated: 18 Dec 2020
License
MIT
Code Language
Visual Basic
Runtime
.NET Framework
Tags
custom-activity
datatable
[hackathon]
Compatibility
Tested on UiPath 2019.10.4 but should be able to run on older versions.
Dependencies
Newtonsoft.JSON version 12.0.3 or higher
Support
UiPath Community SupportSimilar Listings
