Ciphix - Data Processing

This component contains a package with custom activities concerning data processing.

The package contains the following activities:

Convert HTML to text: Converts HTML text to plain text using the HTMLAgilityPackage.

The activity outputs extracted text as string.

Convert value to integer: Converts a non-decimal string number to an integer. 

The activity takes in a string value which it tries to convert to an integer. If the string contains anything other than a non-decimal number.

Datatable To JSON: Converts a variable of type DataTable to a String in JSON format.

By taking a DataTable as input, the activity converts this to a string using a build-in .NET function. The activity only creates a string if the input datatable contains data. If the input datatable only contains the headers of the datatable the output string will be: "[]".

JSON to Datatable: An activity that allows the user to convert a JSON Datatable(a datatable converted to JSON format) back to the original datatable.

The DataTable To Json activity Converts a DataTable to a string in JSON format, ready for adding to queue. The JSON To DataTable activity does the opposite. It converts a JSON string to a Datatable after retrieval from the queue.

String is null or empty: An activity that checks whether a string is null or empty and returns TRUE when this is the case.

The String Is Null Or Empty activity checks whether a string is null or empty. If this is the case it returns TRUE.

String is null or whitespace: An activity that checks whether a string is null or contains whitespaces and returns TRUE when this is the case.

The String Is Null Or Whitespace activity checks whether a string is null or contains whitespace. If this is the case it returns TRUE.

Convert value to integer: No need for code syntax to convert string to integer. Datatable to JSON: Easy adding entire datatables as a QueueItem to the Queue and storing datatables in a simpler text format. JSON to datatable: Easy to convert a DataTable into a string in Json format without having to use extra code. This Json string can be added and retrieved from the queue without any problems. Afterwards the Json to Datatable activity can convert it back to the original DataTable. The DataTable to Json and the Json to DataTable activities therefore allow for the addition of entire datatables to the queue. String is null or empty: This activity makes it easy for users to check whether a string is null or empty without having to use extra code. String is null or whitespace: This activity makes it easy for users to check whether a string is null or contains a whitespace without having to use extra code.