Variable

Aktiviteler

Collection Add Columns

This activity is used to add new columns to a Collection-type variable. It expands the existing data structure by inserting additional fields, allowing future steps in the workflow to use these new columns. It is especially useful in dynamic data-processing scenarios where table structures must be extended with new columns.

Usage Scenarios

Expanding a collection structure with additional fields before data processing
Preparing a table format that will later be filled with new values
Adding placeholder columns required for calculations or conditional logic
Structuring incoming raw data into a more organized table format

Parameters

Input Collection: The collection variable to which new columns will be added
Column Names: Name or names of the columns to be added (multiple names separated by “;”)
Output: The resulting collection with added columns (often reassigned to the same variable)

Notes

Column names must follow the correct naming structure and should not duplicate existing column names
Multiple columns can be added at once using “;” as a separator
The output must be saved into a collection-type variable to be used in later steps

Collection Add Row

This activity is used to add one or more rows to a Collection-type variable. It is a fundamental step in workflows where data is recorded in table format. If this is the first time data is being added, the collection can be initialized directly by defining only column names and values. If a collection already exists, new rows are appended to the existing structure.

Usage Scenarios

Building a table structure step-by-step by adding rows dynamically
Storing transaction or form data as individual records in a collection
Recording multiple outputs (orders, user entries, log data) into a structured list
Initializing a new collection with column headers and the first row of data

Parameters

Input Collection: The name of the collection variable where the new row will be added (leave empty if creating a new collection)
Columns: Column names of the row to be added (multiple values separated by “;”)
Values: Values corresponding to each column (must follow the same order as Columns; optional)
Output: The resulting collection with the new row added (often reassigned to the same variable)

Notes

When initializing a collection for the first time, only Columns and Values need to be provided
The number and order of Values must match the Columns
Multiple rows can be added by repeating the activity in a loop

Collection Column Copy

This activity copies only the selected columns from a source collection into a new (or existing) target collection. It is designed to extract essential fields from large datasets, making data processing more efficient and streamlined.

Usage Scenarios

Reducing large datasets to only the required fields
Creating simplified datasets for reporting or exporting
Preparing filtered data for API calls or validation steps
Separating columns like contact information, IDs, or status fields
Improving performance by reducing unnecessary data in workflows

Parameters

Input Collection: The source collection from which columns will be selected
Output Collection: The target collection where selected columns will be copied
Column Names: Names of the columns to copy (separate multiple names with “;”)

Notes

Column names must match exactly between the source and target structures
Order of column names determines the structure of the output collection
Useful before loops, filtering, or exporting to external systems

Collection Column Sort

This activity sorts the rows in a collection based on a selected column or columns. Sorting can be done in ascending (A–Z) or descending (Z–A) order. It is commonly used to prepare data for reporting, comparison, or structured analysis.

Usage Scenarios

Organizing datasets before exporting or reporting
Sorting customer, product, or transaction lists
Preparing ordered data for loops or conditional logic
Aligning records for comparison or validation steps
Cleaning and structuring mixed or unsorted data

Parameters

Collection: The collection variable that contains the data to be sorted
Sort By Column: The column name(s) to sort by (separate multiple names with “;”)
Sort Descending: true to sort in descending order, false for ascending order
Output: The sorted collection (commonly written back to the same variable)

Notes

When multiple columns are used, sorting follows the order in the input list
Column names must match exactly with the existing collection structure
Sorting does not modify the column structure, only the row order

Collection Column Type Change

This activity is used to convert the data type of one or more columns within a collection. By transforming values stored as text—such as numbers or dates—into appropriate data types, sorting, filtering, and calculation operations can be performed correctly and without errors.

Usage Scenarios

Converting number-like text values into numeric format for accurate calculations
Transforming date strings into real date or datetime types
Ensuring correct sorting for numeric and date columns
Standardizing data imported from external systems
Preparing collection data for mathematical or logical operations

Parameters

Input Collection: The collection whose column types will be converted
Column Name: The name(s) of the column(s) to convert
Column Types: Target data type (Text, Number, Date, Boolean, etc.)
Output: The updated collection with converted column types

Supported Data Types

Datetime: Values containing both date and time
Date: Values containing only date information
Int: Integer numbers (for example 30, 40, 100)
Decimal: Decimal numbers (for example 10.5, 40.75)
String: Text values (for example “Name”, “Status”)

Notes

Data type mismatches may lead to incorrect results during sorting, filtering, or calculations. Converting data to the correct type before processing is strongly recommended.

Collection Filter

This activity is used to filter data in a Collection based on specific column values. It selects only the records that match the given criteria and outputs them as a new Collection. This is especially useful when working with large datasets where only certain rows are needed for further processing.

Usage Scenarios

Extracting records that match specific conditions
Filtering customer lists, order tables, or log data
Preparing narrowed-down datasets for reporting or validation
Applying multi-column filter logic with AND/OR rules

Parameters

Input Collection: Dataset to be filtered
Column Name: Column name(s) to apply the filter to (use “;” for multiple)
Column Value: Value(s) to search for in each column (must match order of Column Name)
And/Or: Logical operator to combine multiple conditions (AND / OR). Leave blank if filtering by a single column.
Output: New collection variable containing the filtered results

Notes

Column names and values must match exactly for successful filtering.
When multiple columns are used, the number of values must match the number of column names.
AND requires all conditions to be true; OR requires at least one condition to be true.

Collection Find Value

Using the Collection Find Value activity, you can search for a value in a column while performing operations on the collection and transfer information about the location of that value to a different variable through output. As the output of the activity, the Cell Addresses output contains the Column and Row Number columns. If you want to use the location information you receive in the scenario, you can use it in the following format:

Example: ßVariable 1| Row Number|0ß

Note: If you want to search for the value you have written in the Search Value line in more than one column, there should be a semicolon (;) between the column names you will write in the Column Names line.

Example: “Currency Code; Currency Type”

With the Collection Find Value activity, you can search for a value in the column while operating on the collection and transfer the information about the location of this value to a different variable via output. As the output of the activity, there are Column and Row Number columns in the Cell Addresses output. If you want to use the location information you receive in the scenario, you can use it in the format below:

Example: ßVariable 1| Row Number|0ß

Note: If you want to search for the value you entered in the Search Value line in more than one column, there should be a semicolon (;) between the column names you will write in the Column Names line.

Example: “Currency Code; Currency Type”

Collection Get Value

Using the Collection Get Value activity, you can assign the number of columns and rows in variables of the Collection type to a different variable.

Collection Remove Row

Using the Collection Remove Row activity, you can delete the rows you have added to the variables of the Collection type created.

In the Input Collection line of the activity, write the name of the variable you created in collection type, the index number of the line you want to delete in the Remove Index field, and the relevant collection type variable should be selected on the outputs tab.

Collection To Html Table

Using the Collection To Html Table activity, you can convert your tables from Collection format to HTML table by using Font Size, Cell Padding, Cell Spacing, Border Size parameters, and you can use your tables converted to HTML format in different fields (mail etc.) as per your flow.

Font Size: Using this parameter, you can determine the size of your html table. For example, you can use data such as medium, xx-small, x-small, small, large, x-large, xx-large, smaller, larger, length, initial, inherit, 15px, and 150%.

Cell Padding: You can specify the amount of space between the border and the contents of cells.

Cell Spacing: You can specify the spacing in pixels between cells.

Border Size: You can use it to add borders around objects.

Collection Look Up Value

Using the Collection Look Up Value activity, you can perform the Vlookup operation between variables of the Collection type. The new output after the operation should be transferred to a variable of type Collection.

Collection Remove Columns

Using the Collection Remove Columns activity, you can delete the desired columns of the Variables of type Collection.

To delete more than one column, it is necessary to use the sign “;” between the values entered in the “Column Names” row.

Thanks to the “Deleted Collection” line in the “Outputs” tab, you can move the deleted columns to a different Collection type table.

Collection Remove Duplicate Rows

Using the Collection Remove Duplicate Rows activity, you can delete the duplicate records in the desired columns of the Variables of the Collection type.

If it is desired to delete duplicate records by only looking at the desired column, this column name should be written in the “Duplicate Column” line. In cases where more than one column name is required, the sign “;” must be entered between the column names.

If the “All Columns Duplicate” option is checked, row deletion is performed by looking at the duplicate records in all columns.

Date Diff

This activity calculates the difference between two dates in years, months, days, hours, and minutes. It is used in time-based operations such as duration calculations, delay analysis, deadline checks, and date comparisons. The calculated result can be assigned to a variable and used in later steps of the workflow.

Usage Scenarios

Calculating how many days remain until a deadline
Measuring the duration between two process timestamps
Checking delays or overdue statuses
Comparing user input dates with system dates
Determining age, waiting time, or processing time

Parameters

Start Date: The initial date from which the calculation begins
End Date: The date to be compared with the Start Date

Notes

Both dates must be in valid date format
The result can be used for numeric comparisons or displayed in logs
Negative differences may occur if End Date is earlier than Start Date

Decrement Variable

This activity decreases the numerical value stored in a specified variable by a defined amount. It is commonly used in counter operations, countdown scenarios, or to track how many times a task remains to be executed.

Usage Scenarios

Countdown operations
Reducing a remaining attempt or retry count
Loop control where a value must decrease per iteration
Tracking how many items or steps are left

Parameters

Input: The variable that contains the numeric value to be decreased
Decrement Value: The amount by which the value will be reduced (e.g., “1”)
Variable: The variable in which the updated value will be stored

Notes

The variable must contain a numeric value before the operation
Negative values may occur if not controlled in the workflow

Generate Variable

Generate Variable Activity; With this activity, you can generate passwords, numbers and guids in detail as you wish. You can assign different variables for Password, Number and Guid at once. You can create a structure as desired by specifying the number range and password length. Character variety: uppercase characters/letters, lowercase characters/letters, numbers, symbols and ambiguous characters.

Number: Sayı seçeneği
Number Range: Sayı aralığı
Guid Text:
Password: Şifre bilgisi
Character Size: Karakter uzunluğu
İnclude Upper Case: Büyük harfleri dahil etme
Include Lower Case: Küçük harfleri dahil etme
Include Numbers: Rakamları dahil etme
Include Symbols: Sembolleri dahil etme – (!’^+%&/=?_-*$#é)
Include Ambiguous Characters: Belirsiz karakterleri dahil etme (()<>|{}[].:,;`)

Get Length

This activity calculates the total number of characters in a text or variable content. It is useful for validations, length-based checks, and text analysis. The resulting length value is assigned to a variable for use in later steps.

Usage Scenarios

Validating whether a text meets minimum or maximum length rules
Performing format checks on inputs (ID, phone number, code, etc.)
Measuring text size before splitting or trimming
Using character count in conditional flows

Parameters

Input: The text or variable whose character length will be calculated
Variable: The variable that will store the calculated character count

Notes

Spaces, punctuation, and all visible/invisible characters are included in the count
Useful before substring, comparison, or validation operations

Html Table To Collection

This activity converts table data in HTML format into a Collection variable so it can be used within an RPA workflow. It is especially useful when processing tables extracted from email content or web pages.

Usage Scenarios

Transforming HTML tables retrieved from emails (e.g., via IMAP Get Mail) into structured data
Converting tables obtained from Get Source Code or Get Attribute activities
Preparing HTML-based table data for further processing, filtering, or exporting
Using web-extracted table content in reporting or decision-making steps

Parameters

Html Table Text: The HTML table content as text or a variable containing HTML data
Collection Variable: The name of the Collection variable to store the converted table

Notes

The HTML must contain a valid <table> structure
Output collection can be directly used with filtering, looping, or Excel write activities

The data contained in the collection variable must be written in the correct format in order to use it in the activity.

ßVariable| Column Name|0ß

Variable: The name of the collection variable

Column Name: The name of the column from which to import data

0: Row number to import data from

You can use this format if you want to loop down to the bottom rows in the table imported in Collection format.

ßVariable| Column Name|æcountæß

Variable: The name of the collection variable

Column Name: The name of the column from which to import data

count: The variable name of the row number to import data from

Note: You can create an “æ” symbol using AltGr + A.

You can create an “ß” symbol using AltGr + S.

You can create a “|” symbol using the AltGr + Solid line keys.

Increment Variable

This activity increases the numerical value inside a specified variable by a defined amount. It is commonly used for counters, generating sequence numbers, or incrementing indexes during workflow execution.

Usage Scenarios

Increasing a loop counter value
Generating sequential numbers (e.g., row numbers, IDs)
Tracking the number of processed items
Updating index values in iterative operations

Parameters

Input: The variable that contains the numeric value to be incremented
Increment Value: The amount by which the value will be increased (e.g., enter “1” to increment by one)
Variable: The variable that will store the incremented value (configured in the Outputs section)

Notes

The Input value must be numeric
Commonly used inside loops or repeated steps

JSON Add Value

This activity adds a new key and its corresponding value to existing JSON data. It enables dynamic expansion of the JSON structure during workflow execution. It is useful when additional fields must be included in API request payloads or when process-generated information needs to be embedded into JSON.

Usage Scenarios

Adding new fields to a JSON payload before sending it to an API
Enriching JSON data with additional information generated during the workflow
Dynamically building JSON structures step by step
Preparing extended request bodies for integrations

Parameters

Data: The existing JSON content to be updated
New Key: The name of the key to be added
New Value: The value to be assigned to the new key
Delay Time: Optional wait time before execution (milliseconds)
Variable: The variable to store the updated JSON containing the newly added key-value pair

Notes

The new key must not conflict with an existing key unless overwriting is intended
Useful for workflows that construct JSON progressively based on conditions

JSON Delete Value

This activity removes a specific key and its corresponding value from JSON-formatted data. It is typically used when simplifying JSON structures, eliminating unnecessary fields, or performing data cleanup based on rule-based conditions.

Usage Scenarios

Removing unused or irrelevant fields from a JSON response
Simplifying JSON before sending it to another system
Cleaning up data by deleting fields such as “extraInfo”, “tempData”, or similar
Preparing a minimal JSON payload for API requests

Parameters

Data: The JSON content in which the deletion will be performed
Key: The name of the key to be removed from the JSON structure

Notes

The output contains the updated JSON after the specified key has been removed
Only the first matching key is removed if duplicate keys exist
Useful for keeping JSON structures lightweight and manageable

JSON Deserialize To Collection

This activity converts JSON-formatted data into a Collection structure. After deserialization, the JSON content becomes a table-like row-and-column format, making it suitable for looping, filtering, and detailed processing. It is especially useful for handling API responses or external system data provided in JSON format.

Usage Scenarios

Processing API responses by converting JSON arrays into collection rows
Analyzing structured JSON data in a tabular format
Looping through customer, order, or product lists returned in JSON
Preparing JSON data for reporting or Excel export

Parameters

JSON: The JSON-formatted input data to be converted
Collection: The resulting collection containing the deserialized JSON content

Notes

The output collection reflects the hierarchical structure of the JSON
Ideal for scenarios requiring row-based processing
The variable assigned to Collection must be of type Collection

JSON Get Value

This activity reads the value of a specific key in a JSON structure and assigns it to a variable. It is useful when extracting a single piece of information or validating specific fields within JSON data.

Usage Scenarios

Retrieving a status field from a service response
Extracting user information such as name, email, or ID
Using JSON values in decision-making steps
Logging specific JSON fields for audit or tracking

Parameters

Data: JSON content from which the value will be retrieved
Key: Name of the key whose value will be extracted
Variable: Variable that will store the extracted value

Notes

The output is the value corresponding to the specified key
If the key appears multiple times, the first match is returned
Data must be valid JSON format

JSON Serialize From Collection

This activity converts data stored in a Collection into JSON format. It is especially useful when tabular data must be transferred to external systems or sent to APIs.

Usage Scenarios

Converting table-like data into JSON before making an API call
Preparing structured data for external system integration
Archiving Collection data in JSON format
Transforming multi-row records into a machine-readable JSON structure

Parameters

Collection: Name of the collection variable to be converted to JSON
Variable: Name of the variable that will store the generated JSON content

Notes

The output contains the JSON representation of the collection data
Column names in the collection become JSON keys
Suitable for sending bulk data to web services

JSON Set Value

This activity is used to update the value of a specific key in JSON-formatted data. It is preferred when an existing JSON structure needs to be modified or when new information must be assigned to a field during the workflow.

Usage Scenarios

Updating a status field in JSON data (e.g., “pending” → “approved”)
Modifying values returned from an API response
Injecting new information into an existing JSON structure
Preparing JSON content before sending it back to another system

Parameters

Data: JSON content to be updated
Key: Name of the field whose value will be changed
New Value: New value to assign to the specified key
Variable: Name of the variable that will store the updated JSON

Notes

The output is the JSON content where the specified key has been updated
Key names must match the JSON structure exactly
If the key does not exist, some systems may create it automatically while others may return an error

JSON and XML Variable Type

Varible JSON Variable

You can keep your values in JSON format in your Variable variable.

Varible XML Variable You can keep your values in XML format in your Variable variable.

New Variable

This activity is used to create a new variable within the scenario. The variable can then be used to store, carry, or process data throughout different steps of the workflow. The variable name, data type, and description can be customized as needed.

Usage Scenarios

Creating a variable to store user input (e.g., username, ID, date)
Holding temporary data between steps
Storing calculation results
Managing flags, counters, or status information in the workflow

Parameters

Variable Name: Name of the variable to be created
Data Type: Type of data the variable will store (e.g., Text, Number, Boolean, Collection)
Initial Value: Starting value of the variable
Description: Optional explanation of the variable’s purpose

Notes

A variable created in the scenario can be referenced using the format: ßVariableNameß
If the variable will be filled later, the Initial Value can be left empty
Variables should be named clearly and meaningfully to avoid confusion in complex workflows

Normalize Text

This activity removes Turkish-specific characters from the input text. It is used to simplify and standardize text, especially in system operations or data comparison processes where special characters may cause issues.

Parameters

Input: Text that may contain Turkish characters

Outputs

Text with all Turkish characters normalized and replaced with standard Latin equivalents

QR Read

This activity is used to read a QR code and extract its content into a variable. It enables retrieving the data inside digital QR codes without requiring a physical barcode scanner.

Usage Scenario
A QR code on a document may contain a customer number. By reading this QR code, the extracted number can be saved into a variable and used in the automation process.

Parameters

Image Path: Full file path of the image containing the QR code

Outputs

The decoded content extracted from the QR code

QR Write

With the Qr Write activity, you can create a Qr code using bmp, tiff, jpeg, gif, png or wmf formats and save it in any directory.

Note: The Height line represents the height dimension and the Width line represents the width dimension. If left blank, the height is saved as 200 pixels and the width as 100 pixels.

Replace

This activity is used to replace a specific expression within a text with another expression. The modified text is returned as output and can be assigned to a variable. It is commonly used in text processing and auto-correction scenarios.

Usage Scenario
To change the word “Deneme” to “Test” in the text “Deneme123”, set Replace Text to “Deneme” and Replace Value to “Test”. The result will be “Test123”, which can then be used in subsequent steps.

Parameters

Input: The text to be modified
Replace Text: The expression to be replaced
Replace Value: The new expression that replaces the old one

Outputs

Updated text

Reset Variable

This activity clears the content of defined variables or restores them to their original initial values. It is used in loop operations or after conditional flows where variables must be reset to maintain process stability.

Usage Scenario
If variables such as Result, Total, or Status are used across multiple steps and need to be reused, the Reset Variable activity can reset these variables, removing previous values to ensure a clean workflow.

Parameters

Input: The variable(s) to be reset. If multiple variables are used, they must be separated with semicolons (;).
First Initial:
- True: Restores the variable to its originally defined Initial Value.
- False: Completely clears the variable, including its initial value.

Search Text And Get Value

This activity extracts the value located between two specified expressions within a text and assigns it to a variable. It is particularly useful for retrieving information from structured or tagged text content.

Usage Scenario
Given the text “Turkcell Global Bilgi”, if only “Global” is needed:
Set Start Text to “Turkcell” and End Text to “Bilgi”.
The activity captures the text between these two expressions (“Global”) and outputs it.

Parameters

Input: The text to be searched
Start Text: The expression located before the desired value
End Text: The expression located after the desired value

Outputs

The captured value between the Start Text and End Text

Set Variable

This activity assigns a value—either a manually entered input or the content of an existing variable—to another variable. It is used for organizing data, performing format adjustments, storing calculation results, or creating temporary and dynamic values during workflow execution.

Usage Scenarios

Retrieving a value from a specific cell in a collection and assigning it to another variable
Storing the result of a calculation in a new variable
Assigning constant values such as text, date, or time
Saving system date-time information into a variable
Holding dynamically generated data in temporary variables
Structuring form input data for later steps

Parameters

Input: The value to be assigned (manual text or existing variable)
Output Variable: The variable that will store the assigned value

In order to be able to use the data in the Collection variable in the activity, it must be written in the correct format.

ßVariable| Column Name|0ß

Variable: The name of the collection variable

Column Name: The name of the column from which to import data

0: Row number to import data from

You can use this format if you want to loop down to the bottom rows in the table imported in Collection format.

ßVariable| Column Name|æcountæß

Variable: The name of the collection variable

Column Name: The name of the column from which to import data

count: The variable name of the row number to import data from

Note: You can create an “æ” symbol using AltGr + A.

You can create an “ß” symbol using AltGr + S.

You can create a “|” symbol using the AltGr + Solid line keys.

In addition, using the Set Variable activity, you can get the system date and time by typing the correct strings and use this information in the flow.

Finding the last day of the month

new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(1).AddDays(-1).ToString(“dd.MM.yyyy”)

Finding the first day of the month

new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(1).ToString(“dd.MM.yyyy”)

Find out what week of year in which we are in

(DateTime.Now.DayOfYear / 7) + 1

Adding 5 minutes to the system clock

DateTime.Now.AddMinutes(5).ToString(“dd MMMM yyyy HH:mm:ss”)

Changing the date format

Convert.ToDateTime(“24 jan 2021”).ToString(“yyyy-MM-dd”)

Note: If errors are received in the formats used, you can try to delete the quotes and write them again.

Split Text And Set Count

This activity splits the input text using a specified separator and returns the total number of resulting parts as a numeric value. It is typically used to determine item counts in structured text or to provide loop counters.

Usage Scenarios

Determining how many items a delimited text contains
Preparing loop limits based on the number of split segments
Counting fields in CSV-like structures
Validating whether expected segment counts are present in incoming text

Parameters

Input: Text or variable containing the text to be split
Separator: Character or string used to split the text (e.g., ,, ;, |)

Outputs

Total number of segments produced after splitting the text

Split Text And Set Value By Index

This activity splits the input text using a specified separator and returns the part located at the given index. It is commonly used to extract structured information from delimited text.

Usage Scenarios

Extracting specific fields from delimited data
Parsing text received from external systems (e.g., “A/B/C” format)
Separating name–surname, code–value, or path-like structures
Quickly isolating a specific item without performing complex text operations

Parameters

Input: Text or variable containing the text to be split
Separator: Character or string used to split the text (e.g., / , , |)
Index: Zero-based position of the desired part

Outputs

The text segment located at the specified index

If the text you want to split goes down to the bottom lines and you want to get the text on the second line, just type “\n” in the Separator line and “1” in the index line.

\n = New Line
\r = Carriage return

Substring

This activity extracts a specific portion of a text. The text can be provided directly in the Input field or taken from a variable. The starting position is defined by Start Index, and the number of characters to extract is defined by Length. The result is returned as a new text value.

Usage Scenarios

Extracting a keyword, code, or identifier from a larger text
Isolating a specific section of structured text (e.g., date, name, prefix)
Cleaning or transforming text before validation or storage
Taking only a meaningful section from user inputs or system outputs

Parameters

Input: Text or variable containing the source string
Start Index: Zero-based position where extraction begins
Length: Optional. Number of characters to extract; if left empty, extraction continues to the end of the text

Outputs

Extracted substring

Text To Lower

This activity converts the input text entirely into lowercase letters. It is commonly used to ensure consistency in text comparisons, data standardization, and uniform processing of user inputs or external data.

Usage Scenarios

Preparing text for case-insensitive comparisons
Standardizing names, cities, or codes before validation
Normalizing user input for search or matching operations
Cleaning mixed-case data before storing or processing

Parameters

Input: Text or variable containing the value to be converted to lowercase

Outputs

Lowercase-formatted text

Text To Slug

This activity converts input text into a clean and safe slug format suitable for system fields such as URLs or file names. It removes special characters and replaces spaces with hyphens (-), producing a normalized and system-friendly output.

Usage Scenarios

Creating URL-friendly strings from titles or names
Generating clean file names by removing special characters
Normalizing text for system matching or database keys
Producing consistent identifiers for content management systems

Parameters

Input: Raw text to be converted
Lenght: Maximum character length of the slug. If empty or 0, no limit is applied. Output is trimmed if it exceeds this length.

Outputs

Slug-formatted text with cleaned characters and hyphen-separated words

Text To Upper

This activity converts the given text entirely into uppercase characters. It is used for data standardization, visual consistency, and processes that require uppercase formatting.

Usage Scenarios

Converting names, cities, and country values into a consistent uppercase format
Preparing text for systems that only accept uppercase input
Standardizing user input before database or comparison operations
Ensuring uniform presentation in reports or documents

Parameters

Input: Text or variable to be converted to uppercase

Outputs

Uppercase version of the provided text

Trim

This activity removes unnecessary leading and trailing spaces from text values to ensure data consistency. It is commonly used before validation, comparison, filtering, or database operations to prevent mismatches caused by unwanted whitespace.

Usage Scenarios

Cleaning user input before comparison
Preparing external data (API, file, form, OCR output) for processing
Ensuring accurate matching in decision or validation steps
Standardizing text data before saving to Excel or databases

Parameters

Input: Text or variable containing leading and/or trailing spaces

Outputs

Cleaned text with removed whitespace

XML Deserialize To Collection

This activity converts XML-formatted data into a collection variable. The XML content may be entered directly or provided through a variable. After conversion, each XML node is represented as a row in tabular (collection) structure, enabling easy processing of hierarchical XML data.

Usage Scenarios

Converting XML responses from web services into a table-like structure
Filtering, transforming, or reporting XML content using collection operations
Preparing XML data for Excel, database, or API processing
Simplifying complex XML structures into row–column format for automation steps

Parameters

Input: XML-formatted data or a variable containing XML content

Outputs

Converted collection variable (table-structured data)

XML Get Element

This activity retrieves the content of a specific element from XML-formatted data. When multiple elements share the same name, the Index parameter allows selecting which one to extract. The extracted element value is returned as output and can be used in further steps of the automation.

Usage Scenarios

Extracting repeated XML fields such as feedback notes, comments, addresses, or descriptions
Reading structured data from XML returned by external systems or APIs
Selecting a specific element when multiple identical tag names exist
Retrieving the latest or specific entry from XML-based logs or datasets

Parameters

Data: XML content or a variable containing XML data
Key: Name of the XML element to retrieve
Index: Indicates which element to extract when multiple exist (0-based)

Outputs

Extracted element value

XML Get Value

This activity retrieves the value of a specific key (element name) from XML-formatted data. If multiple elements share the same key, the activity can return a specific one using an index value. It is commonly used when reading structured XML responses from external systems and extracting required fields.

Usage Scenarios

Extracting specific fields (name, phone number, date, ID, etc.) from XML responses
Reading customer or order information stored in XML format
Retrieving repeated XML elements by index (e.g., second phone number, third address)
Processing structured data returned by APIs, integrations, or file-based XML results

Parameters

Data: XML content or a variable containing XML data
Key: Name of the XML element whose value will be extracted
Index: Specifies which matching element to return when multiple elements share the same key (0-based)

Outputs

Extracted value

XML Serialize From Collection

This activity converts data stored in a Collection variable into XML format. It is useful for data exchange, integration, archiving, or sending structured information to systems that require XML input. By serializing collection-based table data, the activity provides a standardized text output that can be transferred across different platforms.

Usage Scenarios

Exporting collection data to external systems in XML format
Preparing structured XML output for APIs requiring XML requests
Archiving tabular data in a portable and readable format
Converting customer, order, or transaction records into XML for integration workflows

Parameters

Input: The collection dataset to be converted into XML
Generated text output in XML format

Notes

The activity serializes the entire collection, including all rows and columns
The resulting XML can be saved, sent via email, or used as part of a web service call

Variable

Variable

Aktiviteler

Collection Add Columns

Collection Add Row

Collection Column Copy

Collection Column Sort

Collection Column Type Change

Collection Filter

Collection Find Value

Collection Get Value

Collection Remove Row

Collection To Html Table

Collection Look Up Value

Collection Remove Columns

Collection Remove Duplicate Rows

Date Diff

Decrement Variable

Generate Variable

Get Length

Html Table To Collection

Increment Variable

JSON Add Value

JSON Delete Value

JSON Deserialize To Collection

JSON Get Value

JSON Serialize From Collection

JSON Set Value

JSON and XML Variable Type

New Variable

Normalize Text

QR Read

QR Write

Replace

Reset Variable

Search Text And Get Value

Set Variable

Split Text And Set Count

Split Text And Set Value By Index

Substring

Text To Lower

Text To Slug

Text To Upper

Trim

XML Deserialize To Collection

XML Get Element

XML Get Value

XML Serialize From Collection

Do you want to have Digital Employees?