UiPath Flashcards
What are the 4 ways to create DataTables?
- Build Data Table
- Read Range - gets content of worksheet and store data in data table
- Read CSV
- Data Scraping
BRRD (Big bird picking up data table and flying away)
What does the Lookup Data Table function do?
- Search for value -> returns row index
- Give coordinates of cell -> returns value
SerGeant Lookup
What does Output DataTable function do?
Writes data table to string using csv format
List 3 business scenarios where Join Data function is useful?
- Combine 2 databases of employees extracted from 2 applications
- Check which clients (DB1) have been contacted in a marketing campaign (DB2)
- Check which of the suppliers of a company (internal DB) have applied for public aid (public DB).
What are the differences between the two input methods: “Send Windows Messages” and “Simulate”?
Both work in the background (default does not)
Send Windows Messages: Replays the window messages that the target application receives when the mouse/keyboard is used. Slower, but less compatability issues.
Simulate: Uses the technology of the target application (API level). Faster, but some compatability issues.
What is the default input method when interacting with User Interfaces? Strengths/weaknesses?
Actually clicks the mouse and uses the keyboard to enter input.
Can’t touch computer while it’s working.
Slower, but has 100% compatability.
What is an input action as it relates to User Interfaces and what are the 4 types?
It’s any time we insert data into an application, or we send a command to a system to produce a change (or a continuation)
Types: Click, Type Into, Send Hotkey, Hover
What is IMAP?
Internet Message Access Protocol
Used to receive e-mail from mail server
Name 3 characteristics that make a process more suitable for RPA automation?
- Repetitive
- Rule-based
- Stable
Name 3 factors that increase the complexity of a potential automation?
- Number of decision points in business logic
- Legacy Applications
- Inputs that cannot be standardized
What value will the following expression return?
String.Format(“{1} is {0}”, “home”, “John”, “far away”, 0, 1)
“John is home”
What are the 6 steps of RPA implementations?
Prepare RPA, Solution Design, Build RPA, Test RPA, Stailized RPA, Constant improvement
Consider a dictionary variable (birthDates), of type String, String, that contains name and birth date pairs. They key values are the names. You want to add a new key / value pair using an Assign Activity (John Doe, Apr/20/1980).
What expressions would you enter in the To and Value fields of the Assign activity?
To: birthDates(“John Doe”) Value:”Apr/20/1980”
What activity can you use to create a data table from unstructured data?
Generate Data Table. This allows you to use files that may be separated by pipes, spaces, etc…
Can Excel related activities run on a machine that does not have the Excel application installed?
Yes, but only for XLSX files
The last X (xlsX for xls) means that it follows the XML standards
XLSX files is smaller than XLS
What 2 activities can you use if you want to add data to an existing XLSX document without overwriting existing data?
- Excel Append Range
2. Workbook Append Range
What happens if you use a Write Range activity and try to write data in an XLSX file that does not exist?
It will create that file and write the data to it.
What happens when a Find Element activity does not find the desired element within the set Timeout property?
The activity throws an exception and stops the execution.
List 4 uses of RegEx?
Data Scraping
Input Validation
String Manipulation
String Parsing
What are the 4 types of workflows in UiPath
Sequence - best for simple linear work
Flowcharts - better for decisions, workarounds, etc…
State Machine
Global Exception Handler
What are output methods used for in UiPath? What are the 3 types?
They are used to extract data from UI elements.
FullText
Native
OCR
Describe the FULLTEXT Output method
- Fastest of the three
- Extracts hidden text (options in dropdown list)
- Doesn’t support virtual env
- Doesn’t capture text position and formatting
Describe the NATIVE Output method
- Compatible with apps that support Graphics Design Interface
- Extracts text position and formatting
- Can’t extract hidden text or work in the background
- Doesn’t support virtual env
What is GDI
Graphics Design Interface: the Microsoft API used for representing graphical objects.
Describe the OCR Output Method
Optical Character Recognition
- Works with virtual env and reading text from images
- Captures Text position
- Cannot work in the background
- Slowest of the 3
How does data scraping work?
- Indicate multiple elements of the same thing (i.e. titles from a search result).
- This creates a pattern that UiPath recognizes and generalizes to the entire page[s].
- Can do this for multiple elements (i.e. title, publish date, etc…)
- This is then stored in a data table and can be written to a file).
How do you get the number of files in a given directory (as well as other info about the files)
FileInfo = Directory.GetFiles(“FilePathInStringFormat”)
-You would then do: FileInfo.Count.ToString (if you wanted it to be a string that is).
How do you get e-mails in UiPath
- Assign the e-mail address to a variable
- Use get password to store password variable
- Use Get IMAP Mail Messages activity (specify folder, port #, server (imap.gmail.com), email and password)
- In the Output section of IMAP activity properties, use the variable (GetMailMessages) to store the Messages.
How would you get a specific e-mail subject line?
- Store the messages in an email object (variable could be GetMailMessages for example).
- Use GetMailMessages.MessageInstance.Subject
Outilne a workflow to fill an online form from data in a csv file.
- Read CSV into a data table
- Open browser to the form url
- Loop through CSV File
- Use a Type Into activity specifying the selector (i.e. name, address, etc…), and the Record from the CSV/DataTable (Datatable.SpecificRecord.FullName)
What are the steps to publish a library and how would you import to use?
-From studio click publish tab at the top.
-Publish to orchestrator or a custom file location
-Click “publish” to finish
to import…
-Click Manage Packages tab
-Go to Settings
-Locate Source File and click “Add”
-You can now install the package
Describe how to do a google search if you’re interacting on a VM
- Use If Image exists to check for the google search button.
- If true then:
- Use Native Citrix recorder to detect and click where you need to.
When should you use a full selector vs a partial selector?
- Full selectors are best when switching between windows.
- Partial selectors are best for multiple actions in the same window
How do you use wildcards in selectors?
- replaces multiple characters
? replaces a single character.
What is a business rule exception?
An exception caused by the data and a business rule handled by REFramework.
Ex: if a value is too high or low, then skip the next step.
What is an application exception?
An exception caused by an application that is handled by REFramework. Example: An application fails to start, so the framework closes that application and retries.
In REFramework, what is the main advantage of using a dispatcher pattern?
You can split the processing of items between multiple robots
How do the performer and dispatcher work in REFramework?
Dispatcher gets data and puts it in the orchestrator queue. The performer than takes from that queue and performs the necessary actions.
