Data Operations

Converts or transforms a value between formats — including JSON, XML, Base64, URL encoding, dates, numbers, and HTML — and stores the result in a named output variable.

Purpose

Use Data Operations whenever a workflow needs to change the shape or encoding of a value without writing custom logic. Typical scenarios include serialising an object to JSON before sending it in a web request, decoding a Base64 payload received from an API, reformatting a date string to match a downstream system's expected format, or converting an XML response to an object the workflow can navigate.

Inputs

Field	Type	Required	Description
Operation	Dropdown	Yes	The conversion to perform. See the Operations table below.
Input Array	Text	No	The array of strings to join. Visible when Operation is JoinStringArray.
Delimiter	Text	No	The separator character used when joining or splitting. Visible when Operation is JoinStringArray or SplitString.
Input String	Text	No	The text value to encode, decode, split, or convert. Visible when Operation is SplitString, Base64Encode, Base64Decode, UrlEncode, UrlDecode, StringToDate, StringToNumber, HtmlEncode, or HtmlDecode.
Input JSON	Text	No	The JSON string to deserialise or convert. Visible when Operation is JsonToObject, JsonToXml, or JsonToDynamic.
Input XML	Text	No	The XML string to convert. Visible when Operation is XmlToJson.
Input Object	Text	No	A variable reference to the object to serialise. Visible when Operation is ObjectToJson.
Input Date	Date / Time	No	The date value to format as a string. Visible when Operation is DateToString.
Date Format	Text	No	A .NET date format string (e.g. yyyy-MM-dd, o). Visible when Operation is DateToString or StringToDate.
Input Number	Text	No	The numeric value to convert. Visible when Operation is NumberToString.
Target Type	Text	No	The .NET type name to deserialise into (e.g. Dictionary<string,object>). Visible when Operation is JsonToObject.
Output Variable Name	Text	Yes	The name of the workflow variable that will hold the result.

Visibility Rules

Input Array and Delimiter are visible when Operation is JoinStringArray. Delimiter is also visible when Operation is SplitString. Input String is visible when Operation is SplitString, Base64Encode, Base64Decode, UrlEncode, UrlDecode, StringToDate, StringToNumber, HtmlEncode, or HtmlDecode. Input JSON is visible when Operation is JsonToObject, JsonToXml, or JsonToDynamic. Input XML is visible when Operation is XmlToJson. Input Object is visible when Operation is ObjectToJson. Input Date is visible when Operation is DateToString. Date Format is visible when Operation is DateToString or StringToDate. Input Number is visible when Operation is NumberToString. Target Type is visible when Operation is JsonToObject.

Operations

Operation	Description
JoinStringArray	Joins an array of strings into a single string using the specified delimiter.
SplitString	Splits a string by the specified delimiter into an array of strings.
ObjectToJson	Serialises an object into its JSON representation.
JsonToObject	Deserialises a JSON string into an object. Optionally accepts a Target Type for strongly typed deserialisation.
JsonToDynamic	Deserialises a JSON string into a native dictionary or list structure without requiring a target type.
Base64Encode	Encodes a UTF-8 string to Base64.
Base64Decode	Decodes a Base64 string back to UTF-8 text.
UrlEncode	Applies percent-encoding to a string for safe use in a URL.
UrlDecode	Decodes a percent-encoded URL string.
XmlToJson	Parses an XML string and converts it to a JSON-compatible object.
JsonToXml	Converts a JSON string to an XML document string.
DateToString	Formats a DateTime value using the specified Date Format string.
StringToDate	Parses a string into a DateTime using the specified Date Format string.
NumberToString	Converts a numeric value to its string representation.
StringToNumber	Parses a numeric string into a number.
HtmlEncode	Encodes special characters in a string as HTML entities.
HtmlDecode	Decodes HTML entities in a string back to their literal characters.

Outputs

The result is stored under the name provided in Output Variable Name. The type of the stored value depends on the operation: a string for encoding/decoding operations, an object or dictionary for JSON/XML conversions, an array for SplitString and JoinStringArray, a number for StringToNumber, and a DateTime for StringToDate.

Examples

Join an array into a delimited string

Field	Value
Operation	JoinStringArray
Input Array	StringOps1
Delimiter	,
Output Variable Name	JoinedNames
Result	alice, bob, carol

Encode a string to Base64

Field	Value
Operation	Base64Encode
Input String	Hello
Output Variable Name	EncodedValue
Result	SGVsbG8=

Format a date for display

Field	Value
Operation	DateToString
Input Date	2025-06-02T15:04:05Z
Date Format	yyyy-MM-dd HH:mm:ss
Output Variable Name	FormattedDate
Result	2025-06-02 15:04:05