- Release Notes
- Getting Started
- Setup and Configuration
- Automation Projects
- Dependencies
- Types of Workflows
- File Comparison
- Automation Best Practices
- Source Control Integration
- Debugging
- The Diagnostic Tool
- Variables
- Managing Variables
- The Variables Panel
- Types of Variables
- UiPath Proprietary Variables
- Arguments
- Imported Namespaces
- Trigger-based Attended Automation
- Recording
- UI Elements
- Control Flow
- Selectors
- Object Repository
- Data Scraping
- Image and Text Automation
- Automating Citrix Technologies
- RDP Automation
- Salesforce Automation
- SAP Automation
- VMware Horizon Automation
- Logging
- The ScreenScrapeJavaSupport Tool
- The WebDriver Protocol
- Test Suite - Studio
- Extensions
- Troubleshooting
- About troubleshooting
- Microsoft App-V support and limitations
- Internet Explorer X64 troubleshooting
- Microsoft Office issues
- Identifying UI elements in PDF with Accessibility options
- Repairing Active Accessibility support
- Automating Applications Running Under a Different Windows User
- Validation of large Windows-legacy projects takes longer than expected
UiPath Proprietary Variables
The GenericValue variable is a type of variable that can store any kind of data, including text, numbers, dates, and arrays, and is particular to Studio.
GenericValue variables are automatically converted to other types, in order to perform certain actions. However, it is important to use these types of variables carefully, as their conversion may not always be the correct one for your project.
UiPath Studio has an automatic conversion mechanism of GenericValue variables, which you can guide towards the desired outcome by carefully defining their expressions. Take into account that the first element in your expression is used as a guideline for what operation Studio performs. For example, when you try to add two GenericValue variables, if the first one in the expression is defined as a String, the result is the concatenation of the two. If it is defined as an Integer, the result is their sum.
Name/Syntax |
Description |
---|---|
CompareTo
| |
Contains
|
Used to check whether a string variable contains a certain substring or not. For example, if you want to check if a sentence
contains a specific word, the expression should be
[SentenceVariable].Contains("term") , where [SentenceVariable] is the GenericValue variable containing the sentence and "term" is the word to be searched for.
Note: When using this method with a GenericValue variable of data type Int, Float or Boolean, the data is automatically converted
to String and handled accordingly.
|
Equals
| |
GetHashCode
| |
GetType
| |
GetTypeCode
| |
IndexOf
|
Used to return the index of a substring contained inside a string variable. For example, if you want to find the index of
the word "locate" inside the sentence "Find 'locate' in this sentence", the expression should be
[SentenceVariable].IndexOf("locate") , where [SentenceVariable] is the GenericValue variable containing the sentence and "locate" is the term to be searched for.
Note: When using this method with a GenericValue variable of data type Int, Float or Boolean, the data is automatically converted
to String and handled accordingly.
|
Length
|
Used to return the number of characters in a string variable. For example, if you want to find out how many letters a word
has, the expression should be
[WordVariable].Length , where [WordVariable] is the GenericValue variable containing the word.
Note: When using this method with a GenericValue variable of data type Int, Float or Boolean, the data is automatically converted
to String and handled accordingly.
|
Replace
|
Used to replace data contained inside a string variable. For example, if you want to change a local file path
C:\ExampleFolder\Main.xaml into the corresponding server file path C:/ExampleFolder/Main.xaml , the expression should be [PathVariable].Replace("\","/") where [PathVariable] is the GenericValue variable containing the file path, "\" is the character to be replaced and "/" is the character used as replacement.
Note: When using this method with a GenericValue variable of data type Int, Float or Boolean, the data is automatically converted
to String and handled accordingly.
|
Split
|
Used to return individual components from a string variable. For example, if you want to extract the year from a MM.DD.YYYY
date format, the expression should be
[DateVariable].Split(".".ToCharArray)(2) , where [DateVariable] is the GenericValue variable containing the date, "." is the character used as a separator, .ToCharArray is a method that creates an array with the elements delimited by the separator and (2) represents the index of the element to be returned, in our case, the year.
Note: When using this method with a GenericValue variable of data type Int, Float or Boolean, the data is automatically converted
to String and handled accordingly.
|
Substring
|
Used to return a substring contained in a string variable. For example, if you want to extract a word from the "There are
100 machines available" sentence, the expression should be
[SentenceVariable].Substring(10,3) , where [SentenceVariable] is the GenericValue variable containing the sentence, 10 is the index of the first character to be returned, and 3 is the
length of the substring starting from the first character. In this example, the resulted substring would be "100".
Note: When using this method with a GenericValue variable of data type Int, Float or Boolean, the data is automatically converted
to String and handled accordingly.
|
ToBoolean
| |
ToByte
| |
ToChar
| |
ToDecimal
| |
ToDouble
| |
ToInt
|
Used to convert a specified value to a nullable integer. Note: When using this method with a GenericValue variable of data type Boolean, the "True" and "False" values are converted to
1 and 0, respectively.
|
ToInt16
|
Note: When using this method with a GenericValue variable of data type Boolean, the "True" and "False" values are converted to
1 and 0, respectively.
|
ToInt32
|
Note: When using this method with a GenericValue variable of data type Boolean, the "True" and "False" values are converted to
1 and 0, respectively.
|
ToInt64
|
Note: When using this method with a GenericValue variable of data type Boolean, the "True" and "False" values are converted to
1 and 0, respectively.
|
ToLower
|
Note: When using this method with a GenericValue variable of data type Int, Float or Boolean, the data is automatically converted
to String and handled accordingly.
|
ToLowerInvariant
|
Note: When using this method with a GenericValue variable of data type Int, Float or Boolean, the data is automatically converted
to String and handled accordingly.
|
ToSByte
| |
ToSingle
| |
ToString
| |
ToType
| |
ToUInt16
|
Note: When using this method with a GenericValue variable of data type Boolean, the "True" and "False" values are converted to
1 and 0, respectively.
|
ToUInt32
|
Note: When using this method with a GenericValue variable of data type Boolean, the "True" and "False" values are converted to
1 and 0, respectively.
|
ToUInt64
|
Note: When using this method with a GenericValue variable of data type Boolean, the "True" and "False" values are converted to
1 and 0, respectively.
|
ToUpper
|
Note: When using this method with a GenericValue variable of data type Int, Float or Boolean, the data is automatically converted
to String and handled accordingly.
|
ToUpperInvariant
|
Note: When using this method with a GenericValue variable of data type Int, Float or Boolean, the data is automatically converted
to String and handled accordingly.
|
Trim
|
Note: When using this method with a GenericValue variable of data type Int, Float or Boolean, the data is automatically converted
to String and handled accordingly.
|
TrimEnd
|
Note: When using this method with a GenericValue variable of data type Int, Float or Boolean, the data is automatically converted
to String and handled accordingly.
|
TrimStart
|
Note: When using this method with a GenericValue variable of data type Int, Float or Boolean, the data is automatically converted
to String and handled accordingly.
|
When using Ctrl + K, Ctrl + M, or Ctrl + Shift + M directly in the Format Value activity body, the created variable or argument is of type GenericValue. For other activities, the created type is the same as the required type of the activity.
To demonstrate how a GenericValue variable works, let us create an automation that performs different operations whose results depend on the way we define their expressions. We create two GenericValue variables of different data types and display the results in the Output panel.
- Create a new blank project.
- Create three GenericValue variables:
Int
,Str
, andResult
. -
In the Default column for the
Int
variable, type 12, and for theStr
variable, type "34". The first variable is interpreted as an integer, while the second one is interpreted as a string. - Add an Assign activity to the Designer panel and connect it to the Start node.
- In the Properties panel, in the To field, enter the
Result
variable. - In the Value field, type
Int
+Str
. - Add a Write Line activity and connect it to the Assign one.
-
Double click the activity card and in the Text field, enter the
Result
variable.The project should look as in the following screenshot.
-
Press F5 to execute your automation. Note that, in the Output panel, the sum of the two numbers is displayed.
-
Go back to the previously added Assign activity and change the Value field to
Str
+Int
, to reverse the order of the variables. The project should look as in the following screenshot. -
Press F5 to execute your automation. Note that, in the Output panel, the concatenation of the two numbers is displayed.
This means that UiPath Studio takes the first element defined in your expression as a guideline for what operation to perform. If the first element in your expression is an integer or a GenericValue variable filled in as integer, UiPath Studio will perform the sum of the elements.
If the first element in your expression is a string or a GenericValue variable filled in as string, UiPath Studio will perform the concatenation of the elements.
We recommend that you read the About Queues and Transactions page, for an overview on queues and transactions, before further proceeding to the QueueItem variable.
Before getting into an in-depth detailing of the subject, make sure you understand the distinction between queue items (items stored in a queue in Orchestrator) and QueueItem variables (variables used in Studio to process queue items). We refer to them exactly like that: “QueueItem variables” and “queue items”.
Broadly, as the name says, the QueueItem variable stores an item which has been extracted from a container of items, a queue. This extraction is generally made with the purpose of further using the queue items in various scenarios. Let’s say you represent a banking institution and you have a deposits’ report of 50 clients. You want to process the data of each client who had previously deposited an On-Us Check smaller than $5000, using a third-party financial application. In this regard, you can make a workflow in which the QueueItem variable stores, by turn, the information of each client. Each entry read by the QueueItem variable is stored in a queue item and added to the designated queue in Orchestrator. The result of this whole process is a queue which contains the clients' information, each in the corresponding queue item.
To further process the data which meets the condition, you must create another workflow which extracts from the previously created queue, the items with a corresponding On-Us Check value smaller than $5000. A step-by-step procedure on how to create such a project is provided at the end of this topic.
Name/Syntax |
Description |
---|---|
Equals
| |
GetHashCode
| |
GetType
| |
ToString
|
Name/Syntax |
Description |
---|---|
AssignedTo
| |
DueDate
|
The latest date and time at which the item should be processed. If empty, the item can be processed at any given time. |
DeferDate
|
The earliest date and time at which the item is available for processing. If empty, the item can be processed as soon as possible. |
Id
| |
ItemKey
|
The unique identifier of the item. For example,
1bf829e1-cd6b-4275-a364-19db3cfe09c7 .
|
Priority
|
The priority of the queue item as defined in Studio in the Priority field on the Properties panel. |
ProcessingException
|
The processing exception of a failed item. |
Progress
|
Custom progress information about a queue item whose status is InProgress. |
QueueDefinitionId
|
The unique identifier of the queue under which a queue item/transaction has been created. |
QueueName
|
The name of the queue containing the processed items. |
Reference
|
A user-specified value for easier queue item identification. |
RetryNo
|
The number of times the item has been retried. |
ReviewStatus
|
The revision status of the queue item as retrieved from Orchestrator. |
RowVersion
|
An internal field used for version stamping. It gets updated whenever a property of the current transaction is changed. |
SpecificContent
|
A collection of key value pairs containing custom data associated with the current transaction, as configured in the Add Queue Item activity. |
StartTransactionTime
|
The time and date the transaction processing began. |
Status
|
The status of the queue item as retrieved from Orchestrator. |
Due to the nature of this example, we have split this section in two parts, each representing one of the two main workflows to be used when working with queues and queue items:
Uploading Items Into a Queue
.xlsx
file. Let’s say you represent a banking
institution and you have a deposits’ report of 50 clients. You want to process the data
of each client that previously deposited an On-Us Check smaller than $5000, using a
third-party financial application. The report contains the name of the client, the On-Us
Check value, and two other additional values, let’s say Cash In and Not On-Us Check. We
create a workflow in which the QueueItem variable stores, by turn, the information of
each client. Each entry read by the QueueItem variable is then stored in a queue item
and added to the designated queue in Orchestrator. The result of this whole process is a
queue which contains each clients’ specific information. Before proceeding to the actual
workflow, you might want to take a look at the clients’ report here. We are going to
work with the "July Reports" sheet.
Without further ado:
- Create a new sequence.
- Add an Excel Process Scope activity inside the sequence.
- Add a Use Excel File activity and define the location of the workbook in the Excel file field of the activity.
- Add a Read Range activity to read the desired range of values from the report and store them in a DataTable variable.
- On the right side of the Range field, select Plus > Excel > Indicate in Excel and select a range of cells (for example, A1:D51).
-
In the Save to field, press Ctrl + K to create a new DataTable variable which stores the previously read data range. Name it
dt_DataTable1
or similar. The Variables pane should also display the newly created variable as follows:
-
Next, add a For Each Row in Data Table activity to the Designer panel and fill in the blank fields with “row” and the name of the DataTable variable,
dt_DataTable1
, respectively. This activity performs the action defined within it for each row in the data table. The sequence should look similar to the following screenshot so far:
- Add an Add Queue Item activity in the For Each Row in Data Table activity. This adds an item to a queue (defined below at steps 8 and 12), for each row in the spreadsheet.
- In the Queue name field, type
the name of the queue you want your items to be stored in, let's say
ReportQueue
. -
Click the field under Item information to open the Dictionary Builder window. Create 4 arguments, each corresponding to a column from the report. Define them as follows:
Name
, keeping the default values for Direction and Type, and with Value set torow(0).ToString
. This retrieves the value from the column with the counter 0 for each row in the workbook, in our case the name of the client.CashIn
, keeping the default values for Direction and Type, and with Value set torow(1).ToString
. This retrieves the value from the column with the counter 1 for each row in the workbook, in our case the Cash In value.OnUsCheck
, keeping the default values for Direction and Type, and with Value set torow(2).ToString
. This retrieves the value from the column with the counter 2 for each row in the workbook, in our case the On-Us Check value.NotOnUsCheck
, keeping the default values for Direction and Type, and with Value set torow(3).ToString
. This retrieves the value from the column with the counter 3 for each row in the workbook, in our case the Not On-Us Check value.
-
The Dictionary Builder window should look similar to the following screenshot:
- Connect Studio’s Robot to Orchestrator. For details on how to do it, click here.
- Navigate to https://cloud.uipath.com, log in using your credentials, and then create a queue, ReportQueue, to store the items. Make sure that, whatever name you used above (step 8), you use the same here.
- Go back to Studio. At this point your workflow should be error-free and functional, so the next step is to make it available to Orchestrator. In this regard click Design > Publish.
-
To run the process, click Design > Run.
Note: Take into account that, after being processed, queue items become transactions, and are further handled as such. - Navigate to https://cloud.uipath.com again and display the transactions.
Processing the Transactions From a Queue
To demonstrate how to further process transactions from a queue, we are going to create a second workflow which retrieves from the appropriate queue, the transactions with an On-Us Check value smaller than $5000. For each transaction that meets the condition, the values are collected and introduced into a third-party dummy application. The other ones are labeled as business exceptions.
- Go to Design > New > Flowchart to create a new file in the project initiated above.
- Add an Use Application/Browser activity to open the third-party dummy application. Connect it to the Start node.
- Fill in the required details
(Display Name, File path, Selector) on the
Properties panel, and configure the activity to log in with the
corresponding credentials. Use
admin
for the Username field, andpassword
for the Password field. - In the File path field, fill in the path of the application.
- In the Selector field, using Selector Editor, define a selector for UIDemo.
- Add a Should Stop activity to the Designer panel and connect it to the Open Application activity.
-
Add a Flow Decision activity to the Designer panel and connect it to the Should Stop activity. These last two activities check if you stopped the job while it was still running. This gives you the possibility to further configure the workflow to perform various safety routines after the stop is triggered. See below an example of such a routine:
- Add a Log Message activity and connect it to the True branch of the previously added flow decision.
- In the Properties panel, in the Message field, type “Stop process required” or something similar to be displayed if the stop is triggered.
- Add a Close Application activity and connect it to the Log Message activity previously added.
- In the Properties
panel, in the DisplayName field, after Close application, type
UIDemo.exe UIDemo
.
- Add a Get Transaction Item activity to the False branch of the flow decision added previously (step 7). This activity retrieves the transaction items from the queue and stores them, by turn, with each iteration of the loop, in a QueueItem variable.
- In the Properties pane, in the QueueName field, type the name of the queue which stores your items. In our case, as defined in the Uploading Items into a Queue section, the name is "ReportQueue".
- In the TransactionItem field, press Ctrl+K to create the QueueItem variable which stores each transaction item. Name it "TransItem" or similar.
- Add a Flow Decision activity to the Designer panel and connect it to the Get Transaction Item activity.
- In the Properties pane, in the
Condition field, type
TransItem isNot Nothing
. This activity checks the value of each item to determine if the end of the queue has been reached. - Connect the False branch of the flow decision to the Log Message activity created in step 7. This ensures the job stops when the end of the queue is reached.
- Add another Flow Decision activity to the Designer panel and connect it to the True branch of the flow decision created in step 11.
-
In the Properties pane, in the Condition field, type
cint(TransItem.SpecificContent("OnUSCheck").ToString) < 5000
, where:cint
converts a variable of type string to one of type integer.TransItem
is the QueueItem variable (step 18) used to store the items.SpecificContent("OnUSCheck")
retrieves the content of the On US Check argument in each item..ToString
converts the content of the QueueItem variable into a variable of type string.-
< 5000
is the condition to be checked against.The above expression converts the OnUSCheck value in each QueueItem variable into a string variable, which is then further converted into an integer. The value thus obtained is checked for compliance with the condition.
- Add a Set Transaction Status activity to the Designer panel, and connect it to the False branch of the previous flow decision (step 13).
- In the Properties pane, make sure the Status field is set to Failed, and ErrorType to Business. This way, if the value of On US Check is bigger or equal to 5000, the transaction is marked as failed with a business exception.
- In the TransactionItem field
add the
TransItem
variable. - In the Reason field, type "OnUSCheck amount is bigger than 5000" or similar, to display for a failed transaction.
- Connect the Set Transaction Status activity to the Should Stop activity (step 6), to create a loop and process the next transaction in the queue.
- Add a Sequence activity to the Designer panel, and connect it to the True branch of the previous flow decision (step 13). Inside the sequence, add a Try Catch activity and configure it such that any potential errors are correctly labeled as application errors when processing the items.
- Open the UIDemo application, and log
in with the username
admin
and the passwordpassword
. -
Perform the following series of activities for each of the Cash In, On Us Check and Not On Us Check fields in the UIDemo application:
- Into the previous Try Catch activity, add an Use Application/Browser activity to open the application.
- Add a Type Into activity.
- Click Indicate target on screen and select from the UIDemo interface the blank field corresponding to Cash In.
- In the Type this
field, type
transItem.SpecificContent("CashIn").ToString
. Each term in the expression is explained above (step 15). This expression converts the value in each QueueItem variable into a string variable.
- Add a Get Text activity after the previous Type Into activities and select "Indicate target on screen" from the options menu.
- Point at the transaction number in the UIDemo application and click Confirm.
- Set the Text field to a new
variable, say
TransNumber
. This retrieves the transaction number for each queue item that meets the initial condition. - Add a Set transaction status activity after the Get Text activity.
- Make sure the Status field is set to Successful and the ErrorType is set to Application. This way, if the set of values is successfully introduced in the application, the status of the transaction is set to Successful, or else labeled as an application exception.
- In the Output window, define a
new argument and add the previously created variable,
TransNumber
(step 25) as value. - In the Transaction item field,
add the
TransItem
variable. - Add a Click activity after the Set transaction status activity.
- Click Indicate target on screen and select the Accept button from the UIDemo interface.
-
The Try Catch activity should look similar to the following screenshot:
- Return to the flowchart and connect the previous Sequence activity (step 21) to the Should Stop activity (step 6) to create a loop and process the next transaction in the queue.
-
The flowchart should look similar to the following screenshot:
- To run the process, click Design > Run.
- After the execution has ended, you may navigate to https://cloud.uipath.com and display the processed transactions with the corresponding processing details:
-
Successful Transaction
-
Failed Transaction