UiPath Flashcards

1
Q

What are the 4 ways to create DataTables?

A
  • 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)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What does the Lookup Data Table function do?

A
  1. Search for value -> returns row index
  2. Give coordinates of cell -> returns value

SerGeant Lookup

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What does Output DataTable function do?

A

Writes data table to string using csv format

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

List 3 business scenarios where Join Data function is useful?

A
  1. Combine 2 databases of employees extracted from 2 applications
  2. Check which clients (DB1) have been contacted in a marketing campaign (DB2)
  3. Check which of the suppliers of a company (internal DB) have applied for public aid (public DB).
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What are the differences between the two input methods: “Send Windows Messages” and “Simulate”?

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is the default input method when interacting with User Interfaces? Strengths/weaknesses?

A

Actually clicks the mouse and uses the keyboard to enter input.

Can’t touch computer while it’s working.

Slower, but has 100% compatability.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is an input action as it relates to User Interfaces and what are the 4 types?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is IMAP?

A

Internet Message Access Protocol

Used to receive e-mail from mail server

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Name 3 characteristics that make a process more suitable for RPA automation?

A
  1. Repetitive
  2. Rule-based
  3. Stable
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Name 3 factors that increase the complexity of a potential automation?

A
  1. Number of decision points in business logic
  2. Legacy Applications
  3. Inputs that cannot be standardized
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What value will the following expression return?

String.Format(“{1} is {0}”, “home”, “John”, “far away”, 0, 1)

A

“John is home”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What are the 6 steps of RPA implementations?

A

Prepare RPA, Solution Design, Build RPA, Test RPA, Stailized RPA, Constant improvement

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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?

A

To: birthDates(“John Doe”) Value:”Apr/20/1980”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What activity can you use to create a data table from unstructured data?

A

Generate Data Table. This allows you to use files that may be separated by pipes, spaces, etc…

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Can Excel related activities run on a machine that does not have the Excel application installed?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What 2 activities can you use if you want to add data to an existing XLSX document without overwriting existing data?

A
  1. Excel Append Range

2. Workbook Append Range

17
Q

What happens if you use a Write Range activity and try to write data in an XLSX file that does not exist?

A

It will create that file and write the data to it.

18
Q

What happens when a Find Element activity does not find the desired element within the set Timeout property?

A

The activity throws an exception and stops the execution.

19
Q

List 4 uses of RegEx?

A

Data Scraping
Input Validation
String Manipulation
String Parsing

20
Q

What are the 4 types of workflows in UiPath

A

Sequence - best for simple linear work
Flowcharts - better for decisions, workarounds, etc…
State Machine
Global Exception Handler

21
Q

What are output methods used for in UiPath? What are the 3 types?

A

They are used to extract data from UI elements.

FullText
Native
OCR

22
Q

Describe the FULLTEXT Output method

A
  • Fastest of the three
  • Extracts hidden text (options in dropdown list)
  • Doesn’t support virtual env
  • Doesn’t capture text position and formatting
23
Q

Describe the NATIVE Output method

A
  • 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
24
Q

What is GDI

A

Graphics Design Interface: the Microsoft API used for representing graphical objects.

25
Q

Describe the OCR Output Method

A

Optical Character Recognition

  • Works with virtual env and reading text from images
  • Captures Text position
  • Cannot work in the background
  • Slowest of the 3
26
Q

How does data scraping work?

A
  • 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).
27
Q

How do you get the number of files in a given directory (as well as other info about the files)

A

FileInfo = Directory.GetFiles(“FilePathInStringFormat”)

-You would then do: FileInfo.Count.ToString (if you wanted it to be a string that is).

28
Q

How do you get e-mails in UiPath

A
  • 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.
29
Q

How would you get a specific e-mail subject line?

A
  • Store the messages in an email object (variable could be GetMailMessages for example).
  • Use GetMailMessages.MessageInstance.Subject
30
Q

Outilne a workflow to fill an online form from data in a csv file.

A
  • 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)
31
Q

What are the steps to publish a library and how would you import to use?

A

-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

32
Q

Describe how to do a google search if you’re interacting on a VM

A
  • 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.
33
Q

When should you use a full selector vs a partial selector?

A
  • Full selectors are best when switching between windows.

- Partial selectors are best for multiple actions in the same window

34
Q

How do you use wildcards in selectors?

A
  • replaces multiple characters

? replaces a single character.

35
Q

What is a business rule exception?

A

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.

36
Q

What is an application exception?

A

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.

37
Q

In REFramework, what is the main advantage of using a dispatcher pattern?

A

You can split the processing of items between multiple robots

38
Q

How do the performer and dispatcher work in REFramework?

A

Dispatcher gets data and puts it in the orchestrator queue. The performer than takes from that queue and performs the necessary actions.