Data Operations

Use the Data Operations node to perform a variety of data transformations—string joining/splitting, JSON/XML serialization and deserialization, encoding/decoding, date and number conversions, and HTML encoding/decoding—directly in your workflow.

Configuration

When you add the Data Operations node, a modal dialog will prompt you for the following fields:

Field	Type	Visible When	Description	Default
Operation	Picklist	always	Choose which operation to perform.	JoinStringArray
Input Array	Text	JoinStringArray	Array of strings to join (e.g. ["a","b","c"]).	["a","b","c"]
Delimiter	Text	JoinStringArray, SplitString	Delimiter to use when joining or splitting strings.	,
Input String	Text	SplitString, Base64Encode, Base64Decode, UrlEncode, UrlDecode, StringToDate, StringToNumber, HtmlEncode, HtmlDecode	The string to encode/decode or split into parts.	empty
Input JSON	Text	JsonToObject, JsonToXml	JSON string to deserialize into an object or convert to XML.	{ "key": "value" }
Input XML	Text	XmlToJson	XML string to convert into JSON.	<root></root>
Input Object	Text	ObjectToJson	The object (variable reference) to serialize into JSON.	empty
Input Date	DateTime	DateToString	The date value to format as a string.	2025-06-02T00:00:00Z
Date Format	Text	DateToString, StringToDate	.NET date format string (e.g. o for round-trip).	o
Input Number	Text	NumberToString	The numerical value to convert to a string.	0
Target Type	Text	JsonToObject	Fully qualified .NET type name to deserialize JSON into. [Uncertain: verify if assembly-qualified name is required]	empty
Output Variable Name	Text	all operations	Name of the workflow variable that will receive the result of the operation.	none

Note: The labels in the UI must exactly match the above (including casing). In some cases the code refers to "Input Json" rather than "Input JSON"—if you encounter mapping errors, please verify the field label in the modal form. [Uncertain: confirm exact field-label mapping]

Supported Operations

• JoinStringArray
  Joins an array of strings into one string using the specified Delimiter.

  • Validates that Input Array is an array of strings.
  • Example result stored in your Output Variable Name.

• SplitString
  Splits a single string by Delimiter into a string array.

• ObjectToJson
  Serializes a .NET object (from Input Object) into its JSON representation.

• JsonToObject
  Deserializes a JSON string (Input JSON) into a .NET object of type Target Type.

• Base64Encode / Base64Decode
  Encodes or decodes a UTF-8 string to/from Base64.

• UrlEncode / UrlDecode
  Applies URL percent-encoding or decoding.

• XmlToJson
  Parses an XML string (Input XML) into a JSON string.

• JsonToXml
  Converts a JSON string (Input JSON) into an XML document (wrapped in a <Root> element).

• DateToString / StringToDate
  Formats a DateTime (Input Date) to string or parses a string back to DateTime using Date Format.

• NumberToString / StringToNumber
  Converts between numeric types and their string representations.

• HtmlEncode / HtmlDecode
  Encodes or decodes HTML entities in a string.

Output

After successful execution, the node writes the result of the chosen operation into the workflow context under the name you provide in Output Variable Name. All input fields (Operation, Input Array, etc.) are then cleared from the context.

Examples

# Example node configuration in UI
Operation:        JoinStringArray
Input Array:      ["apple","banana","cherry"]
Delimiter:        ";"
Output Variable Name: fruitsCsv

Result: fruitsCsv = "apple;banana;cherry"

Operation:         StringToDate
Input String:      "2025-06-18"
Date Format:       "yyyy-MM-dd"
Output Variable Name: parsedDate

Result: parsedDate = 2025-06-18T00:00:00Z

Implementation Notes

TaskType: DataOperations

API Class: [TaskName("DataOperations")] public class DataOperations : BaseTask

Internally uses a switch on the Operation field; unrecognized operations will cause the node to fail with “Unsupported operation.”