Documentation 2023.12

Feature	Minimum System Requirement	Recommended System Requirement
Processor	64 Bit – 4 Core	64 Bit – 4 Core or more
RAM	16 GB	32 GB or above
Storage Space	256 GB	256 GB or above
Operating System	Windows Server 2016 or above
Operating System Language	English
Administrator Privileges	Local Admin
Ports	9080, 8443
AutoLogon	Enabled (Not required)
Internet Connection	Required for downloading installation files and web automation
Database²	PostgreSQL or access connection to the database to be installed (JDBC support required)

Feature	Minimum System Requirement	Recommended System Requirement
Processor	64 Bit – 4 Core	64 Bit – 4 Core or more
RAM⁴	16 GB	16 GB or above
Storage Space	128 GB	128 GB or above
Operating System	Windows Server 2016 or Windows 10 or newer
Operating System Language	English
Administrator Privileges	Local Admin
Ports	9080, 8443
AutoLogon	Enabled (Not required)
Lock Screen	Disabled
Screen Resolution	1920X1080 – %100
Automatic Restart	Disabled
Windows Developer Mode	Enabled
Internet Connection	Required for downloading installation files and web automation

Diagram

The business processes are mapped graphically using the Modeler (Design Studio). For modeling the processes, end user or process developer uses BPMN-Diagram.

BPMN-Diagram

In BPMN, the processes are described using diagrams with a series of graphic elements. Such a visual presentation makes it easy for users to understand the logic of a process. BPMN has been primarily developed to design and read both simple and complex diagrams of business processes. For that, the BPMN standard classifies the graphic elements by categories: as a result, the elements are easily recognized by the users who work with business process diagrams.

Start Events

Start Events define where a Process or Sub-Process starts and to start a process, it must include one start event.

Id	The unique identifier of the element within the process model.
Name	Displayed name of the element in the canvas.
Documentation	It is a description and additional information about the item.
Execution listeners	Listener of activity. Listeners are created at the start and end of activity.

Start event

Start event activity, also called Untyped start event or the None start event, defines where a process starts. Start event activity is the most common type of event. Processes that start with such an event are created without any pre-conditions. It is common to use this event when a human starts a process through a graphical user interface.

Initiator	Initiator of the process.
Form key	Form key that provides a reference to a form.
Form reference	A specific form name.
Validate form fields	Validate the form fields. If you check the fields, set true in this field, otherwise set false.
Form properties	Definition of the form with a list of form properties.

Start timer event

Start timer event activity creates process instance on cyclic timer events, at points in time, after time spans or after timeouts.

Time cycle (e.g. R3/PT10H):	Define the recurring time interval to start process at certain intervals or send multiple reminders for behind schedule user task.
Time Date in ISO-8601	Define the timer with an ISO-8601 date definition.
Time Duration (e.g. PT5M)	Define the timer with an ISO-8601 duration.

Start signal event

Start signal event activity starts process instance based on signaling across different processes. A single thrown signal can be caught multiple times by different catching signal events.

Signal reference	The part of execution in which a signal is thrown and caught by intermediate events.
Interrupting	Specify whether or not all parent executions are terminated.

Start message event

Start message event activity starts process instance on receipt of a message.

Message reference	Execution in which one start event and one intermediate catching event state two message event.
Interrupting	Specify whether or not all parent executions are terminated.

Start error event

Start error event activity is used for catching named errors. This activity is only used inside of an event sub-process.

Error reference	Reference name of error.
Interrupting	Specify whether or not all parent executions are terminated.

Start escalation event

Start escalation event activity triggers an event sub-process to start.

Escalation reference	Reference name of escalation.
Interrupting	Specify whether or not all parent executions are terminated.

Start condition event

Start condition event activity checks if a condition is true and triggers event. It can be used as start event of an event sub process, as intermediate event and boundary event. The start and boundary event can be interrupting and non interrupting.

Condition express	Define a condition expression for the conditional event.
Interrupting	Specify whether or not all parent executions are terminated.

Activities

Activities are the elements that actually do something in a process. The activities are defined as a Task.

Task: The smallest unit of work in a process, for instance, the prompt to fill out a form or a call to an external web service. Tasks are the most common type of activity. In essence, tasks are the elements that do something in a process.

User task

Usert task activity is a typical “workflow” Task where a human performer performs the Task with the assistance of a software application and is scheduled through a task list manager of some sort.

Exclusive	When it receives a special job from a specific process example, it makes jobs run in order.
Execution listeners	Listeners for an activity, process, sequence flow, start and end event.
Multi-instance type	Determines if multiple instances of this activity are created.
Cardinality (Multi-instance)	An expression or numeric value (integer) that determines how many instances are created.
Collection (Multi-instance)	The number of instances is determined by the elements of a collection. For each element in the collection, a new instance is created.
Element Variable (Multi-instance)	The variable under which each element is available to the newly created instance.
Completion Condition (Multi-instance)	An expression that, if it evaluated to `true`, stops the creation of new instances.
Is for compensation	A flag that identifies whether this activity is intended for the purposes of compensation.
Assignments	Defines the assignee of a task. The assignee is the person who is responsible for the completion of a task. By default, the assignee is set to `$INITIATOR` which is a special variable that is set to the user who started the process. It is possible to set the assignee directly or through an expression. In both cases, the expected value is the User ID of the assignee.
Form key	Form key that provides a reference to a form.
Form reference	The form associated with the User Task. Once a user opens the task, he or she is presented with the referenced form. It is possible to create a new form, reference an existing one or delete the current reference.
Validate form fields	If the form is submitted and validate form fields expression evaluates to true, form fields are validated on the back send according to the form model restrictions.
Due date	The due date of the task.
Priority	An integer number denoting the priority of the task.
Form properties	Sets the form properties.
Task listeners	Sets Task Listeners for this task

You can use the Execution listeners as shown in the examples.

Start

End

Take

You can use the Multi-instance type as shown in the examples.

Default, only one instance is created:

None

Activities are created in parallel. This is a good practice for User tasks activity:

Parallel

Activities are created sequentially. This is a good practice for Service tasks activity:

Sequential

You can use the Cardinality (Multi-instance) as shown in the examples.

${number}

2

You can use the Collection (Multi-instance) as shown in the example.

2

You can use the Element variable (Multi-instance) as shown in the example.

elementvar

You can use the Completion Condition (Multi-instance) as shown in the example.

true

${variable==True}

You can use the Expression as shown in the examples.

${firstName}

${clientService.createNewClient(firstName, lastName, email)}

You can use the Result variable name as shown in the example.

resultvar

You can use the Skip expression as shown in the example.

${firstName}

You can use the Task listeners as shown in the examples.

Occurs when the task has been created and all task properties are set:

create

Occurs when the task is assigned to somebody. Please note that the Assignment event is fired before the Create event:

assignment

Occurs when the task is completed and just before the task is deleted from the runtime data:

complete

Occurs just before the task is going to be deleted or completed:

delete

Service task

Service task activity uses some sort of service, which could be a Web service or an automated application.

Exclusive	When it receives a special job from a specific process example, it makes jobs run in order.
Set service task to be triggerable	Sets service tasks to be triggerable. This makes it possible that an external trigger determines when to continue the execution of the process once the Service Task was executed.
Execution listeners	Listeners for an activity, process, sequence flow, start and end event.
Multi-instance type	Determines if multiple instances of this activity are created.
Cardinality (Multi-instance)	An expression or numeric value (integer) that determines how many instances are created.
Collection (Multi-instance)	The number of instances is determined by the elements of a collection. For each element in the collection, a new instance is created.
Element Variable (Multi-instance)	The variable under which each element is available to the newly created instance.
Completion Condition (Multi-instance)	An expression that, if it evaluated to `true`, stops the creation of new instances.
Is for compensation	A flag that identifies whether this activity is intended for the purposes of compensation.
Class	Class that implements the service task logic.
Expression	An expression which is resolved once the task is executed.
Delegate expression	Service task logic defined with a delegate expression.
Class fields	Class fields make it possible to inject field values into your delegated class.
Result variable name	The name of the variable in which the result of the Service Task’s execution is stored.
Use local scope for result variables	Indicates whether to store the result variable as a local variable.
Skip expression	Defines an expression which is evaluated before executing the task.

You can use the Execution listeners as shown in the examples.

Start

End

Take

You can use the Multi-instance type as shown in the examples.

Default, only one instance is created:

None

Activities are created in parallel. This is a good practice for User tasks activity:

Parallel

Activities are created sequentially. This is a good practice for Service tasks activity:

Sequential

You can use the Cardinality (Multi-instance) as shown in the examples.

${number}

2

You can use the Collection (Multi-instance) as shown in the example.

2

You can use the Element variable (Multi-instance) as shown in the example.

elementvar

You can use the Completion Condition (Multi-instance) as shown in the example.

true

${variable==True}

You can use the Expression as shown in the examples.

${firstName}

${clientService.createNewClient(firstName, lastName, email)}

You can use the Result variable name as shown in the example.

resultvar

You can use the Skip expression as shown in the example.

${firstName}

Script task

Script task activity executes processes that modeler or implementer defines a script in a language that the engine can interpret.

Script format	Script format of the script task that will be selected from combobox.
Script	Script text of the script task.
Exclusive	When it receives a special job from a specific process example, it makes jobs run in order.
Execution listeners	Listeners for an activity, process, sequence flow, start and end event.
Multi-instance type	Determines if multiple instances of this activity are created.
Cardinality (Multi-instance)	An expression or numeric value (integer) that determines how many instances are created.
Collection (Multi-instance)	The number of instances is determined by the elements of a collection. For each element in the collection, a new instance is created.
Element Variable (Multi-instance)	The variable under which each element is available to the newly created instance.
Completion Condition (Multi-instance)	An expression that, if it evaluated to `true`, stops the creation of new instances.
Is for compensation	A flag that identifies whether this activity is intended for the purposes of compensation.
Auto store variables	Automatically stores any variable defined in the script on the execution. Please note that some languages such as JavaScript do not support this feature.

You can use the Script format as shown in the examples.

Groovy

JavaScript

You can use the Script as shown in the example.

var today = new Date(); 
var a = new Date(today.getFullYear(), today.getMonth()+1, 0); 
var b = a.toString();  
execution.setVariable("tarih",b);

You can use the Execution listeners as shown in the examples.

Start

End

Take

You can use the Multi-instance type as shown in the examples.

Default, only one instance is created:

None

Activities are created in parallel. This is a good practice for User tasks activity:

Parallel

Activities are created sequentially. This is a good practice for Service tasks activity:

Sequential

You can use the Cardinality (Multi-instance) as shown in the examples.

${number}

2

You can use the Collection (Multi-instance) as shown in the example.

2

You can use the Element variable (Multi-instance) as shown in the example.

elementvar

You can use the Completion Condition (Multi-instance) as shown in the example.

true

${variable==True}

To create a script;
- Fill in the Script name, Script description, and the script content to be added using the “Script – Add New Custom Script” button.
- Click on the “Save” button to save the script.
- Access the added script from “Scripting Helper – JS Custom Scripts”.
To edit a script;
- Select the created script from “Scripting Helper – JS Custom Scripts” and click on the “Edit” button.
To delete a script;
- Select the created script from “Scripting Helper – JS Custom Scripts” and click on the “Remove” button.

Mail task

Mail task activity is used for sending mails to receiver in another process or Swimlanes. It is necessary to set up an email server via configuration since there is no mail server.

Exclusive	When it receives a special job from a specific process example, it makes jobs run in order.
Execution listeners	Listeners for an activity, process, sequence flow, start and end event.
Multi-instance type	Determines if multiple instances of this activity are created.
Cardinality (Multi-instance)	An expression or numeric value determines how many instances are created.
Collection (Multi-instance)	The number of instances is determined by the elements of a collection. For each element in the collection, a new instance is created.
Element Variable (Multi-instance)	The variable under which each element is available to the newly created instance.
Completion Condition (Multi-instance)	An expression that, if it evaluated to `true`, stops the creation of new instances.
Is for compensation	A flag that identifies whether this activity is intended for the purposes of compensation.
Headers	Line separated mail headers.
To	The recipients of the email. Multiple recipients can be defined in a comma-separated list.
From	The sender email address. If not provided, the default configured “from address” is used.
Subject	The subject of the email.
Cc	The CC (Carbon Copy) recipients of the email. Multiple recipients can be defined in a comma-separated list.
Bcc	The BCC (Blind Carbon Copy) recipients of the email. Multiple recipients can be defined in a comma-separated list.
Text	Text of the email in clear text. If HTML is not supported on the receiver’s end, the text version of the email is displayed.
Html	Content of the email in the HTML format. This allows for the creation of rich formatting and the usage of images.
Charset	Character set to be used in the email.

You can use the Execution listeners as shown in the examples.

Start

End

Take

You can use the Multi-instance type as shown in the examples.

Default, only one instance is created:

None

Activities are created in parallel. This is a good practice for User tasks activity:

Parallel

Activities are created sequentially. This is a good practice for Service tasks activity:

Sequential

You can use the Cardinality (Multi-instance) as shown in the examples.

${number}

2

You can use the Collection (Multi-instance) as shown in the example.

2

You can use the Element variable (Multi-instance) as shown in the example.

elementvar

You can use the Completion Condition (Multi-instance) as shown in the example.

true

${variable==True}

Http task

Http task activity allows submitting and storing the results of a HTTP call.

Exclusive	When it receives a special job from a specific process example, it makes jobs run in order.
Execution listeners	Listeners for an activity, process, sequence flow, start and end event.
Multi-instance type	Determines if multiple instances of this activity are created.
Cardinality (Multi-instance)	An expression or numeric value determines how many instances are created.
Collection (Multi-instance)	The number of instances is determined by the elements of a collection. For each element in the collection, a new instance is created.
Element Variable (Multi-instance)	The variable under which each element is available to the newly created instance.
Completion Condition (Multi-instance)	An expression that, if it evaluated to `true`, stops the creation of new instances.
Is for compensation	A flag that identifies whether this activity is intended for the purposes of compensation.
Request method	Request URL of the HTTP call.
Request URL	Request method to be used in the HTTP.
Request headers	Line-separated HTTP request headers.
Request body	Request body to be sent, e.g., a JSON file.
Request body encoding	Encoding of the request body.
Request timeout	Request timeout in milliseconds.
Disallow redirects	Determines whether HTTP redirects can be redirected.
Fail status codes	List of Http response status codes to fail the request and throw a FlowableException.
Handle status codes	List of status codes for which the task throws BpmnError which can be caught by a boundary error event.
Ignore exception	Determines whether exceptions are ignored and stored in the variable indicated in the response variable.
Response variable name	The variable name in which the HTTP response is stored.
Save request variables	Determines whether all request variables are stored. By default, only response related variables are stored as variables.
Save response status, headers	Determines whether response variables including HTTP status, headers etc. are stored. By default, only the response body is stored as a variable.
Result variable preﬁx	A prefix that is put in front of the variable name of the result variables for easier grouping.
Save response as a transient variable	Determines whether the response variables should be stored as transient.
Save response as JSON	Determines whether the response variable is stored as a JSON variable instead of a String.

You can use the Execution listeners as shown in the examples.

Start

End

Take

You can use the Multi-instance type as shown in the examples.

Default, only one instance is created:

None

Activities are created in parallel. This is a good practice for User tasks activity:

Parallel

Activities are created sequentially. This is a good practice for Service tasks activity:

Sequential

You can use the Cardinality (Multi-instance) as shown in the examples.

${number}

2

You can use the Collection (Multi-instance) as shown in the example.

2

You can use the Element variable (Multi-instance) as shown in the example.

elementvar

You can use the Completion Condition (Multi-instance) as shown in the example.

true

${variable==True}

You can use the Request URL as shown in the example.

http://your-system.example.com/your-endpoint/${someVariable}

You can use the Request method as shown in the examples.

GET

POST

PUT

DELETE

You can use the Request method as shown in the example.

{‘clientId’: ${clientId}, ‘name’: ${name}}

You can use the Request timeout as shown in the example.

25

You can use the Fail status code as shown in the examples.

400

404

5XX

Status codes in handleStatusCodes override those in failStatusCodes when they are both set.

You can use the Response variable name as shown in the example.

responseVar

You can use the Result variable prefix as shown in the examples.

responseProtocol

responseReason

responseStatusCode

responseHeaders

responseBody

errorMessage

Decision task

Decision task activity executes Business rules encoded in DMN tables.

Execution listeners	Listeners for an activity, process, sequence flow, start and end event.
Multi-instance type	Determines if multiple instances of this activity are created.
Cardinality (Multi-instance)	An expression or numeric value (integer) that determines how many instances are created.
Collection (Multi-instance)	The number of instances is determined by the elements of a collection. For each element in the collection, a new instance is created.
Element Variable (Multi-instance)	The variable under which each element is available to the newly created instance.
Completion Condition (Multi-instance)	An expression that, if it evaluated to `true`, stops the creation of new instances.
Is for compensation	A flag that identifies whether this activity is intended for the purposes of compensation.
Decision table reference	Reference to the DMN table that will be executed.
Throw error if no rules were hit	Specify whether an error should be thrown if no rules of the decision table were hit and consequently no result was found.
Fallback to default tenant	Find decision definition without tenant when previous attempts to find it with tenant field.

You can use the Execution listeners as shown in the examples.

Start

End

Take

You can use the Multi-instance type as shown in the examples.

Default, only one instance is created:

None

Activities are created in parallel. This is a good practice for User tasks activity:

Parallel

Activities are created sequentially. This is a good practice for Service tasks activity:

Sequential

You can use the Cardinality (Multi-instance) as shown in the examples.

${number}

2

You can use the Collection (Multi-instance) as shown in the example.

2

You can use the Element variable (Multi-instance) as shown in the example.

elementvar

You can use the Completion Condition (Multi-instance) as shown in the example.

true

${variable==True}

You only have to indicate a Decision Table Reference; the mapping of the variable is configured in the Decision Table.

Shell task

The Shell task allows you to run shell scripts and commands.

Command	Shell command to execute.
Argument 1	Arguments that are passed to the shell command.
Argument 2	Arguments that are passed to the shell command.
Argument 3	Arguments that are passed to the shell command.
Argument 4	Arguments that are passed to the shell command.
Argument 5	Arguments that are passed to the shell command.
Wait	Wait, if necessary, until the shell process has terminated.
Output Variables	Variable to store shell command output.
Error Code Variable	Variable to store shell command error code.
Redirect Error	Indicates whether the standard error is combined with the standard output.
Clean Env	Indicates whether the shell process inherits the current environment.
Directory	Default directory of shell process.
Exclusive	When it receives a special job from a specific process example, it makes jobs run in order.
Execution listeners	Listeners for an activity, process, sequence flow, start and end event.
Multi-instance type	Determines if multiple instances of this activity are created.
Cardinality (Multi-instance)	An expression or numeric value determines how many instances are created.
Collection (Multi-instance)	The number of instances is determined by the elements of a collection. For each element in the collection, a new instance is created.
Element Variable (Multi-instance)	The variable under which each element is available to the newly created instance.
Completion Condition (Multi-instance)	An expression that, if it evaluated to `true`, stops the creation of new instances.
Is for compensation	A flag that identifies whether this activity is intended for the purposes of compensation.

You can use the Execution listeners as shown in the examples.

Start

End

Take

You can use the Multi-instance type as shown in the examples.

Default, only one instance is created:

None

Activities are created in parallel. This is a good practice for User tasks activity:

Parallel

Activities are created sequentially. This is a good practice for Service tasks activity:

Sequential

You can use the Cardinality (Multi-instance) as shown in the examples.

${number}

2

You can use the Collection (Multi-instance) as shown in the example.

2

You can use the Element variable (Multi-instance) as shown in the example.

elementvar

You can use the Completion Condition (Multi-instance) as shown in the example.

true

${variable==True}

Structural

Structural is used for designing processes within processes and accessing the existing processes.

Id	The unique identifier of the element within the process model.
Name	Displayed name of the element in the canvas.
Documentation	It is a description and additional information about the item.
Asynchronous	Indicates the synchronous or asynchronous operating status of the item.

Sub process

Sub process activity is a graphical object within a process that contains activities, gateways, events and sequence flows. It can also contain sub processes.

Exclusive	When it receives a special job from a specific process example, it makes jobs run in order.
Data objects	Defines the Data Objects of the process or sub process. Each data object is initialized as a process variable under the defined name.
Execution listeners	Listener of activity. Listeners are created at the start and end of activity.
Multi-instance type	Determines if multiple instances of this activity are created.
Cardinality (Multi-instance)	An expression or numeric value (integer) that determines how many instances are created.
Collection (Multi-instance)	The number of instances is determined by the elements of a collection. For each element in the collection, a new instance is created.
Element Variable (Multi-instance)	The variable under which each element is available to the newly created instance.
Completion Condition (Multi-instance)	An expression that, if it evaluated to `true`, stops the creation of new instances.
Is a transaction sub process	Identifies whether this sub process is type of transaction. A BPMN transaction is a set of activities that logically belongs together. Transactions can be canceled through the Cancel End Event and handled through the Cancel Intermediate Boundary Event.
Element index variable	Variable name of multi instance characteristic’s counter.

You can use the Execution listeners as shown in the examples.

The “Start” property indicates the moment when a process is initiated. When a workflow process starts, this property can trigger an execution listener. It can be used to perform specific actions at the beginning of the workflow process.

Start

The “End” property signifies the moment when a process is completed. When a workflow process finishes, this property can trigger an execution listener. It can be used to perform specific actions at the end of the workflow process.

End

The “Take” property denotes the moment when a flow transitions from one task or activity to another. Thus, when a step in the workflow moves to another step, this property can trigger an execution listener. It can be used to manage data transitions or conditional operations between tasks.

Take

You can use the Multi-instance type as shown in the examples.

Default, only one instance is created:

None

Activities are created in parallel. This is a good practice for User tasks activity:

Parallel

Activities are created sequentially. This is a good practice for Service tasks activity:

Sequential

You can use the Cardinality (Multi-instance) as shown in the examples.

${number}

2

You can use the Collection (Multi-instance) as shown in the example.

2

You can use the Element variable (Multi-instance) as shown in the example.

elementvar

You can use the Completion Condition (Multi-instance) as shown in the example.

true

${variable==True}

${dataCount==0}, ${dataExists==”true”}

You can use the Element index variable as shown in the example.

Counter1[/dire

A Sub-Process can only have one none start event; no other start event types are allowed. A Sub-Process must at least have one end event.

Collapsed sub process

Collapsed sub process activity hierarchial modeling for a high-level, end-to-end overview of the business process by enabling Sub-processes to be collapsed, resulting in hiding all details.

Exclusive	When it receives a special job from a specific process example, it makes jobs run in order.
Data objects	Defines the Data Objects of the process or sub process. Each data object is initialized as a process variable under the defined name.
Execution listeners	Listener of activity. Listeners are created at the start and end of activity.
Multi-instance type	Determines if multiple instances of this activity are created.
Cardinality (Multi-instance)	An expression or numeric value (integer) that determines how many instances are created.
Collection (Multi-instance)	The number of instances is determined by the elements of a collection. For each element in the collection, a new instance is created.
Element Variable (Multi-instance)	The variable under which each element is available to the newly created instance.
Completion Condition (Multi-instance)	An expression that, if it evaluated to `true`, stops the creation of new instances.
Is a transaction sub process	Identifies whether this sub process is type of transaction.

You can use the Execution listeners as shown in the examples.

The “Start” property indicates the moment when a process is initiated. When a workflow process starts, this property can trigger an execution listener. It can be used to perform specific actions at the beginning of the workflow process.

Start

The “End” property signifies the moment when a process is completed. When a workflow process finishes, this property can trigger an execution listener. It can be used to perform specific actions at the end of the workflow process.

End

The “Take” property denotes the moment when a flow transitions from one task or activity to another. Thus, when a step in the workflow moves to another step, this property can trigger an execution listener. It can be used to manage data transitions or conditional operations between tasks.

Take

You can use the Multi-instance type as shown in the examples.

Default, only one instance is created:

None

Activities are created in parallel. This is a good practice for User tasks activity:

Parallel

Activities are created sequentially. This is a good practice for Service tasks activity:

Sequential

You can use the Cardinality (Multi-instance) as shown in the examples.

${number}

2

You can use the Collection (Multi-instance) as shown in the example.

2

You can use the Element variable (Multi-instance) as shown in the example.

elementvar

You can use the Completion Condition (Multi-instance) as shown in the example.

true

${variable==True}

${dataCount==0}, ${dataExists==”true”}

Event sub process

Event sub process activity is triggered by an event and can be added at the process level or at any sub process level. Event sub process activity might be triggered using events like message events, error events, signal events, timer events, or compensation events. The subscription to the start event is created when the scope (process instance or sub process) hosting the event sub process is created. The subscription is removed when the scope is ended.

Exclusive	When it receives a special job from a specific process example, it makes jobs run in order.
Execution listeners	Listener of activity. Listeners are created at the start and end of activity.

You can use the Execution listeners as shown in the examples.

The “Start” property indicates the moment when a process is initiated. When a workflow process starts, this property can trigger an execution listener. It can be used to perform specific actions at the beginning of the workflow process.

Start

The “End” property signifies the moment when a process is completed. When a workflow process finishes, this property can trigger an execution listener. It can be used to perform specific actions at the end of the workflow process.

End

The “Take” property denotes the moment when a flow transitions from one task or activity to another. Thus, when a step in the workflow moves to another step, this property can trigger an execution listener. It can be used to manage data transitions or conditional operations between tasks.

Take

Call activity

A Call activity identifies a point in the Process where a global Process or a Global Task is used. The Call activity acts as a ‘wrapper’ for the invocation of a global Process or Global Task within the execution. The activation of a call activity results in the transfer of control to the called global Process or Global Task.

Exclusive	When it receives a special job from a specific process example, it makes jobs run in order.
Complete asynchronously	Executes the completion of the call activity in an exclusive asynchronous job. This is for example useful in combination with parallel multi-instance.
Execution listeners	Listener of activity. Listeners are created at the start and end of activity.
Called element	Reference of a process.
Called element type	Sub process type is an attribute that defines whether the sub-process details are embedded within the higher level process or refers (`Reference`) to another, re-usable process.
Input parameters	An optional input parameter map. Allows the mapping of parameters and variables which are then available in the newly created process.
Output parameters	An optional output parameter map. Allows the mapping of parameters and variables onto the original Case Work Item as the Human task’s Work Item completes.
Inherit variables in sub process	Inherit parent process variables in the newly created process.
Start the referenced process from the same deployment	Choose true if process that is started is in the same process. Choose false if the newest process definition will always be used. Default value is true.
Fallback to default tenant	Look for the definition by key in the default tenant when current tenant search fails.
Process instance name	The name of process that will be created. Note: When this field is left blank, the default value is “ProcessName_call_activity_Date” .
Inherit business key	Inherit the business key from the parent process.
Business key expression	Business key of the newly created process instance. Can be an expression.
Use local scope for out parameters	Use local variable scope for out parameters.
Multi-instance type	Determines if multiple instances of this activity are created.
Cardinality (Multi-instance)	An expression or numeric value (integer) that determines how many instances are created.
Collection (Multi-instance)	The number of instances is determined by the elements of a collection. For each element in the collection, a new instance is created.
Element variable (Multi-instance)	The variable under which each element is available to the newly created instance.
Completion condition (Multi-instance)	An expression that, if it evaluated to `true`, stops the creation of new instances.
Is a transaction sub process	Identifies whether this sub process is type of transaction.

You can use the Execution listeners as shown in the examples.

The “Start” property indicates the moment when a process is initiated. When a workflow process starts, this property can trigger an execution listener. It can be used to perform specific actions at the beginning of the workflow process.

Start

The “End” property signifies the moment when a process is completed. When a workflow process finishes, this property can trigger an execution listener. It can be used to perform specific actions at the end of the workflow process.

End

The “Take” property denotes the moment when a flow transitions from one task or activity to another. Thus, when a step in the workflow moves to another step, this property can trigger an execution listener. It can be used to manage data transitions or conditional operations between tasks.

Take

Default, creates only one instance:

key

Creates in parallel:

End

You can use the Input parameters as shown in the examples.

Source: variablex

Source Expression: variablex is using for …. (any description)

Target: variablex

Target Expression: variablex is receiving from main process. (any description)

You can use the Output parameters as shown in the examples.

Source: variablex

Source Expression: variablex is using for …. (any description)

Target: variablex

Target Expression: Sending variablex to main process. (any description)

You can use the Multi-instance type as shown in the examples.

Default, only one instance is created:

None

Activities are created in parallel. This is a good practice for User tasks activity:

Parallel

Activities are created sequentially. This is a good practice for Service tasks activity:

Sequential

You can use the Cardinality (Multi-instance) as shown in the examples.

${number}

2

You can use the Collection (Multi-instance) as shown in the example.

2

You can use the Element variable (Multi-instance) as shown in the example.

elementvar

You can use the Completion Condition (Multi-instance) as shown in the example.

true

${variable==True}

${dataCount==0}, ${dataExists==”true”}

Adhoc sub process

Adhoc sub process activity is a task group that exists to complete a part of process.

Completion condition	An expression that, if it evaluated to `true`, stops the creation of new instances.
Ordering	If the Embedded Sub-Process is Ad Hoc (the Ad hoc attribute is True), then the Ad hoc Ordering attribute must be included.
Cancel remaining instances	Cancel the remaining instances for the adhoc sub process.

You can use the Completion condition as shown in the examples.

${variable==True}

${dataCount==0}, ${dataExists==”true”}

You can use the Ordering as shown in the examples.

Parallel

Sequential

Gateways

Gateways are used for controlling how the Process flows through Sequence Flows as they converge and diverge within a Process. If the flow does not need to be controlled, then a Gateway is not needed.

Id	The unique identifier of the element within the process model.
Name	Displayed name of the element in the canvas.
Documentation	It is a description and additional information about the item.
Asynchronous	Indicates the synchronous or asynchronous operating status of the item.

Exclusive gateway

Exclusive gateway is used for creating alternative paths within a process flow.

Exclusive	When it receives a special job from a specific process example, it makes jobs run in order.
Flow order	The order in which the outgoing flows are evaluated and stored in the XML representation of the process. The order of the outgoing flows is managed by clicking on the up and down arrows icon.

After using this activity, the desired conditions are entered into the flow condition field in the arrow.

${existResult==true}

${countResult==3}

${existResult==true && countResult==3}

${timecontrol.contains(“h”) || timecontrol.contains(“s”) || timecontrol.contains(“m”)}

To decide which route the process follows, the conditions on the outgoing Sequence Flows are checked. The conditions are modeled as an expression and must always evaluate to a boolean value of true or false. It is important to understand that the conditions of an exclusive gateway are not modeled on the gateway itself but rather on the outgoing sequence flows.

If more than one condition evaluates to true, the path that was defined first is chosen. This should obviously never happen. If no condition evaluates to true, the process is stuck.

There is the possibility to mark a Sequence Flow as Default Flow. If you do so, the flow follows this route if no condition matches.

Parallel gateway

Parallel gateway activity is used for synchronizing flows within a process flow and creating parallel flows at the same time. Contrary to Exclusive gateway activity, all conditions are calculated.

Exclusive	When it receives a special job from a specific process example, it makes jobs run in order.
Flow order	The order in which the outgoing flows are evaluated and stored in the XML representation of the process. The order of the outgoing flows is managed by clicking on the up and down arrows icon.

Parallel gateways are used to model situations where more than one path is executed in parallel. These gateways do not have any conditions since all paths are always executed. To join parallel branches, use another parallel gateway. The execution only continues once all paths have been completed.

Inclusive gateway

Inclusive gateway activity create alternative but parallel paths within a process flow. Contrary to Exclusive gateway activity, all conditions are calculated.

Exclusive	When it receives a special job from a specific process example, it makes jobs run in order.
Flow order	The order in which the outgoing flows are evaluated and stored in the XML representation of the process. The order of the outgoing flows is managed by clicking on the up and down arrows icon.

To decide which route(s) the process follows, the conditions on the outgoing Sequence Flows are checked. The condition is modeled as an expression and must always evaluate to a boolean value of true or false. It is important to understand that the conditions of an inclusive gateway are not modeled on the gateway itself but rather on the outgoing sequence flows.

Every time a condition evaluates to true or if a Sequence Flow has no condition, the process branches at that position. If no condition evaluates to true or if there is no Sequence Flow without a condition, the process is stuck.

To join inclusive branches, use another inclusive gateway. The execution only continues once all paths have been completed.

Event gateway

Event gateway activity represents a branching point in the Process where the alternative paths that follow the Gateway are based on Events that occur, rather than the evaluation of Expressions using Process data (as with an Exclusive or Inclusive Gateway).

Exclusive	When it receives a special job from a specific process example, it makes jobs run in order.
Flow order	The order in which the outgoing flows are evaluated and stored in the XML representation of the process. The order of the outgoing flows is managed by clicking on the up and down arrows icon.

Event Gateways are used to model branches which are depending on the occurrence of two or more events. The process execution stops at the gateway and resumes once one of the events connected via Sequence Flow occur.

Boundary Events

Boundary event is used to keep track of activities. In other words, boundary event actively follow the activities whether there’s a some triggering event that can change the direction of the diagram. If the event occurs, the execution route of the process follows the outgoing sequence based on the boundary event. Boundary event activities can be attached tasks, sub-process or call activities

Id	The unique identifier of the element within the process model.
Name	Displayed name of the element in the canvas.
Documentation	It is a description and additional information about the item.

Throw error

Throw error activity is used for throwing errors.

Asynchronous	Indicates the synchronous or asynchronous operating status of the item.
*Error message	Error message that will be shown.

_{Note: * Fields selected with are required, others are optional.}

Boundary error event

Boundary error event activity catches error event and when it does, it destroys activity that error event is attached to and also destroys ongoing processes. Process follows the sequence flow of boundary error event activity.

Error reference	Reference name of error reference.
Error message contains	Allows the continuation of the desired flow depending on the content of the error message in an activity

Boundary escalation event

Boundary escalation event activity directs process to another flow by throwing and escalation and can be only attached to an embedded sub-process or a call activity, since an escalation can only be thrown by an escalation intermediate throw event or an escalation end event. When boundary escalation event acitivity is triggered by an escalation event from a call activity, then the defined output variables of the call activity are passed to the scope of the boundary event.

Escalation reference

Reference name of escalation.

Boundary timer event

Boundary timer event acts as a stopwatch and as an alarm clock. When it’s time to execute the activity to which the boundary event is attached, a timer is started. When the timer fires (e.g., after a specified interval), the activity is interrupted and the sequence flow going out of the timer boundary event is followed.

Execution listeners	Listeners for an activity, process, sequence flow, start and end event.
Time cycle (e.g. R3/PT10H)	Define the timer with the ISO-8601 cycle.
Time date in ISO-8601	Define the timer with ISO-8601 date definition.
Time duration (e.g. PT5M)	Define the timer with ISO-8601 duration.
Time End Date in ISO-8601	Define the timer with ISO-8601 date definition.
Cancel activity	Provides the activity cancelling.

Boundary signal event

Boundary signal event activity delays process execution until a particular signal is received. Signaling can happen across different processes.

Signal reference	Reference name of signal.
Cancel activity	Provides the activity cancelling.

Boundary message event

Boundary message event activity catches message on the boundary of activity or catches messages that are defined in message reference.

Message reference	Reference name of message.
Cancel activity	Provides the activity cancelling.

Boundary cancel event

Boundary cancel event activity is triggered when a transaction is canceled and interrupts all active executions in the current scope.

Boundary conditional event

Boundary conditional event activity is triggered if a specific condition is met.

Condition expression

Define the condition expression for the conditional event.

Boundary compensation event

Boundary compensation event activity is used for partially failed operations. This event needs to be attached to the boundary of an activity.

Intermediate Catching Events

Intermediate Catching Events indicate that some triggering event happens that is triggered based on certain conditions during a process. Catching events activity waits for any triggering events to occur from the beginning, therefore, every start event activity is a catching event.

Id	The unique identifier of the element within the process model.
Name	Displayed name of the element in the canvas.
Documentation	It is a description and additional information about the item.

Intermediate timer catching event

Intermediate timer catching event activity delays process execution until a certain point in time is reached or a particular duration is over.

Execution listeners	Listeners for an activity, process, sequence flow, start and end event.
Time cycle (e.g. R3/PT10H)	Define the timer with ISO-8601 cycle.
Time date in ISO-8601	Define the timer with ISO-8601 date definition.
Time duration (e.g. PT5M)	Define the timer with ISO-8061 duration.

Intermediate signal catching event

Process execution is delayed until a particular signal is received. Signaling can happen across different processes.

Execution listeners	Listeners for an activity, process, sequence flow and start and end event.
Signal reference	Reference name of signal.

Intermediate message catching event

Intermediate message catching event activity reacts upon the arrival of a message.

Execution listeners	Listeners for an activity, a process, a sequence flow, start and end event.
Message reference	Reference name of message.

Intermediate conditional catching event

Intermediate conditional catching event activity starts process according to some conditions.

Execution listeners	Listeners for an activity, a process, a sequence flow, start and end event.
Condition expression	Define a condition expression for the conditional event.

Intermediate throwing events

Intermediate throwing events indicate something that happens during a process. Throwing event allows another part of your process (Or a new process) to proceed or start. Therefore, every end event activity is a throwing event.

Id	The unique identifier of the element within the process model.
Name	Displayed name of the element in the canvas.
Documentation	It is a description and additional information about the item.

Intermediate none throwing event

Intermediate none throwing event activity marks the occurrence of a particular event. Process execution is not delayed. In combination with execution listeners, this type of event can, for instance, serve as points to capture KPIs or other metrics.

Execution listeners

Listeners for an activity, a process, a sequence flow, start and end event.

Intermediate signal throwing error

Intermediate signal throwing error activity event fires a signal. Afterwards it continues the process execution. Signals can be thrown either from the back end or using the Signal throwing intermediate event. One single thrown signal can be caught multiple times by different catching signal events.

Execution listeners	Listeners for an activity, process, sequence flow and start and end event.
Signal reference	Reference name of signal.
Asynchronous	Indicates the synchronous or asynchronous operating status of the item.

Intermediate escalation throwing event

Intermediate escalation throwing event activity throws a named escalation. This escalation can be caught by a boundary escalation event activity or an event sub-process with an start escalation event that has the same or none escalation code.

End Events

End Events indicate where a path of a process ends and must be added to the end of process to terminate.

End event

End event activity indicates the end of a process.

Execution listeners

Listeners for an activity, a process, a sequence flow, start and end event.

End error event

End error event activity ends process in sub process in particular error state. If you want to catch this particular error you should use boundary error event in the boundary of sub process. “Error reference” must be the same in boundary error event and end error event.

Execution listeners	Listeners for an activity, a process, a sequence flow, start and end event.
Error reference	Reference name of error.

End escalation event

End escalation event activity ends the current path of execution and a named escalation is thrown.

Execution listeners	Listeners for an activity, a process, a sequence flow, start and end event.
Escalation reference	Reference name of escalation.

End cancel event

End cancel event activity triggers the cancellation of a transaction.

Execution listeners

Listeners for an activity, a process, a sequence flow, start and end event.

End terminate event

End terminate event activity triggers the immediate termination of a process instance. All steps still executing in parallel branches are terminated.

Execution listeners	Listeners for an activity, a process, a sequence flow, start and end event.
Terminate all	Enable to terminate the process instance.

Swimlanes

Processes in BPMN models are often wrapped in a so-called pool which is further divided into lanes.

Id	The unique identifier of the element within the process model.
Name	Displayed name of the element in the canvas.
Documentation	It is a description and additional information about the item.

Pool

Pool, which uses a lane metaphor, places processes of a particular employee, workgroup or section on horizontal or vertical axis and provides clarity and accountability. This indicates the connections, communications and transition between lanes.

Process identiﬁer	Unique identifier of the process definition.
Is executable	Determines whether or not the process is executable. There can only ever be one executable business process per process model.

A Pool is the graphical representation of a participant in a collaboration. A participant can be a specific PartnerEntity (e.g., a company) or can be a more general PartnerRole (e.g., a buyer, seller, or manufacturer). A pool may or may not reference a process. A pool is not required to contain a Process, i.e., it can be a “black box.”

Lane

A Lane is a sub-partition within a process (often within a pool) and will extend the entire length of the process level, either vertically or horizontally. Lanes are a good way to organize responsibilities in a process. Often, a pool defines a process or an organization and the lanes represent departments. BPMN elements such as Tasks, Gateways etc. are then modeled within the pool that most matches that organizational unit. While this has no effect on most tasks, User Tasks can benefit from it.

Artifacts

Artifacts provide additional information that modelers add to bring a necessary level of detail to the diagram. Artifacts do not directly add any runtime behavior but serve to make the model clearer.

Text annotation

Text annotations are a mechanism for a modeler to provide additional information for the reader of a process.

Id	The unique identifier of the element within the process model.
Name	Displayed name of the element in the canvas.
Documentation	It is a description and additional information about the item.
Text	The text of the text annotation.

Chatbot

A chatbot is an automated program that can interact with humans using natural language. Chatbots can be used as standalone services or software tools, as well as integrated into Robotic Process Automation (RPA) projects to be used in RPA processes. In RPA, Chatbot activity is a structure that allows direct interaction with users in an automation process. Chatbot activity enables businesses to manage their data and processes to quickly and efficiently respond to user needs. With a chatbot, not only can users receive answers to their questions, but document requests, information inquiries, and data entries can also be automated.

Wait Answer

The “Wait answer” activity allows the bot to wait after responding to a question or message from a user. In other words, after sending a response, the bot waits for a certain period for the user to make another input.

Exclusive	When it receives a special job from a specific process example, it makes jobs run in order.
Execution listeners	Listeners for an activity, process, sequence flow, start and end event.
Multi-instance type	Determines if multiple instances of this activity are created.
Cardinality (Multi-instance)	An expression or numeric value (integer) that determines how many instances are created.
Collection (Multi-instance)	The number of instances is determined by the elements of a collection. For each element in the collection, a new instance is created.
Element Variable (Multi-instance)	The variable under which each element is available to the newly created instance.
Completion Condition (Multi-instance)	An expression that, if it evaluated to `true`, stops the creation of new instances.
Is for compensation	A flag that identifies whether this activity is intended for the purposes of compensation.
Assignments	Defines the assignee of a task. The assignee is the person who is responsible for the completion of a task. By default, the assignee is set to `$INITIATOR` which is a special variable that is set to the user who started the process. It is possible to set the assignee directly or through an expression. In both cases, the expected value is the User ID of the assignee.
Form key	Form key that provides a reference to a form.
Form reference	The form associated with the User Task. Once a user opens the task, he or she is presented with the referenced form. It is possible to create a new form, reference an existing one or delete the current reference.
Validate form fields	If the form is submitted and validate form fields expression evaluates to true, form fields are validated on the back send according to the form model restrictions.
Due date	The due date of the task.
Priority	An integer number denoting the priority of the task.
Form properties	Sets the form properties.
Task listeners	Sets Task Listeners for this task
Skip expression	Skip an expression execution associated with task or association or not
Category	Category of the BPMN element

You can use the Execution listeners as shown in the examples.

Start

End

Take

You can use the Multi-instance type as shown in the examples.

Default, only one instance is created:

None

Activities are created in parallel. This is a good practice for User tasks activity:

Parallel

Activities are created sequentially. This is a good practice for Service tasks activity:

Sequential

You can use the Cardinality (Multi-instance) as shown in the examples.

${number}

2

You can use the Collection (Multi-instance) as shown in the example.

2

You can use the Element variable (Multi-instance) as shown in the example.

elementvar

You can use the Completion Condition (Multi-instance) as shown in the example.

true

${variable==True}

You can use the Expression as shown in the examples.

${firstName}

${clientService.createNewClient(firstName, lastName, email)}

You can use the Result variable name as shown in the example.

resultvar

You can use the Skip expression as shown in the example.

${firstName}

You can use the Task listeners as shown in the examples.

Occurs when the task has been created and all task properties are set:

create

Occurs when the task is assigned to somebody. Please note that the Assignment event is fired before the Create event:

assignment

Occurs when the task is completed and just before the task is deleted from the runtime data:

complete

Occurs just before the task is going to be deleted or completed:

delete

Send Message

Send Message activity allows the bot to send a message, which may contain information, a response, or guidance for the user. It is used for scenarios where the bot needs to send a response or information to the user. For example, when a user asks a question or performs a specific action, the bot responds appropriately. The “Send Message” activity enables the bot to interact with the user and is used to control the flow of the conversation.

Query	The query intended to be sent is entered into this field.
Reset	Reset intent.
Entity	Variable in the process

You can use the Query as shown in the examples.

Enter your mail address

Enter your user name

You can use the Entity as shown in the examples.

mail

username

Prompt and Close

Prompt and Close activity involves the bot asking a user a question to initiate a conversation or complete a specific scenario. The bot asks a question to obtain specific information, provide options, or prompt the user to take a particular action. Based on the user’s response, the bot applies a set of logical rules and completes a specific scenario. After performing a certain task, the “Prompt and Close” activity concludes the conversation or transitions to another activity.

Query

The query intended to be sent is entered into this field.

You can use the Query as shown in the examples.

Enter your mail address

Enter your user name

Whatsapp

Whatsapp activities allow Whatsapp operations to be performed. In order to perform the operaitons, it is necessary to use the Whatsapp business API and the phone number must be registered in that service.

Send text message

Send text message activity is used for sending message to anyone.

*Gsm no	Gsm that the message will be sent is written in this field.
*Text message	Text message to send is written in this field.

_{Note: * Fields selected with are required, others are optional.}

You can use the Gsm no as shown in the example.

01111111111

901111111111

You can use the Text message as shown in the example.

Hello, I will send the file.

Send attachment

Send attachment activity is used for sending attachment to anyone.

*Gsm no	Gsm that the message will be sent is written in this field.
*File name	Name of the file to send.
*Base64	Base64 string of image file.
File name as	To change the name of the submitted file.
Image caption	Image caption, only valid for image file.

_{Note: * Fields selected with are required, others are optional.}

You can use the Gsm no as shown in the example.

01111111111

901111111111

You can use the File name as shown in the example.

C:RobustaTempQR.png

You can use the File name as as shown in the example.

C:RobustaTempQR1.png

You can use the Image caption as as shown in the example.

This is the image I mentioned.

Applications

Applications activities refer to the automation of the interactions of desktop, Java, SAP and web applications with elements of graphical user interfaces. All interactions with the user interface can be represented as input (sending or adding something to the application) and output (receiving something from the application). Examples of these actions are clicking a button and typing text in a text box or retrieving text from a browser page.

You can reach a how-to guide on Web Applications by clicking here.

Open

Open activity enables the opening or to be attached of various applications such as a web browser, Windows, JAVA, and SAP.

*Application name	The reference name is given to the application which is desired to open in this field.
*Type	Select type of application which will be opened or attached.
Application reference	Reference id of application which is already running.
*Url	Url address of webpage for web applications or window title information for some applications such as Windows and Java applications.
Wait until load	If this checkbox is checked, it is waited until loading all elements of webpages or Windows.
Download directory	The default download path which is desired is written.
Timeout (sec)	Sets timeout period for checking visible or enable property of the element. Default value is 15.
Profile directory	The path of the profile folder is written. Chrome, Firefox or Opera profile allows you to maintain all of your browser details as apps, extensions, settings, browsing history, bookmarks, saved passwords, themes and open tabs.
Maximize	If it is checked, the application window will be open maximised.
Arguments	Arguments, browser item reference.

_{Note: * Fields selected with are required, others are optional.}

You can use the Applications as shown in the example.

robustaWebpage

You can use the Type as shown in the examples.

CHROME

INTERNETEXPLORER

WINDOWS

FIREFOX

OPERA

OPERAATTACH

CHROMEATTACH

SAP

JAVA

JAVA_JAB

MSWINDOWS

MICROSOFT_EDGE

You can use the Url for Browser as shown in the example.

https://www.robusta.ai/

You can use the Url for Windows as shown in the example.

Untitled – Notepad

You can use the Url for SAP as shown in the example.

UAT-Robusta-SAP

You can use the Download directory as shown in the example.

C:Robusta

You can use the Download directory for SAP as shown in the example.

9080

You can use the Download directory as shown in the example.

C:Profile1

You can use the Timeout (sec) as shown in the example.

5

Mouse actions

Mouse actions activity allows mouse actions to be performed at the specified location on the application.

*Application name	The reference name of applications which has already been opened or attached is chosen in the dropdown.
Button	Click type is chosen.
*Field	It is the field where the location (XPath) of the area is written.
Double click	It allows double-clicking on the desired area.
Wait until visible	If this checkbox is checked, it is waited until visible all elements of webpages or Windows.
Wait until load	If this checkbox is checked, it is waited until loading all elements of webpages or Windows.
Hover	The cursor is positioned on the relevant field.
X-coordinate	It clicks to the right or left of the XPath which is written in the Field as much as the given pixel value. Positive and negative values can be entered. Clicks to the right of XPath when using positive values, and negative values to the left.
Y-coordinate	It clicks to below or above of the XPath which is written in the Field as much as the pixel value given. Positive and negative values can be entered. Clicks on negative values below XPath when positive values are used.

_{Note: * Fields selected with are required, others are optional.}

You can use the Applications name as shown in the example.

${robustaWebpage}

You can use the Button as shown in the examples.

LEFT

RIGHT

NONE

You can use the Field for Browser as shown in the example.

(//input[@title=”Arama”])[1]

You can use the Field for Windows as shown in the example.

//Pane[@ClassName=Scintilla”]

You can use the X-Coordinate as shown in the example.

150

You can use the Y-Coordinate as shown in the example.

150

The above example use will do Left Double Click after the page and element is loaded to press the button whose location is given in the Field field .

Set methods

Set methods activity enables data writing to desired fields (Textbox, Combobox etc.) via browser or application.

*Application name	The reference name of applications which has already been opened or attached is chosen in the dropdown.
*Field	It is the field where the location (XPath) of the area is written.
Clear	If it is necessary, it enables clearing the field before setting.
*Type	The type of setting is chosen.
*Text	For the set operation, it is generally used over the Text. (When Type=attribute, the text field is not required)
Attribute name	If “Attribute” is selected as an action in the Type property, the attribute name of the element to be used must be written. In the process of setting a title, the Title to be changed should be entered in this field.
Wait until visible	If this checkbox is checked, it is waited until visible all elements of webpages or Windows.

_{Note: * Fields selected with are required, others are optional.}

You can use the Applications name as shown in the example.

${robustaWebpage}

You can use the Field as shown in the example.

(//input[@title=”Arama”])[1]

You can use the Type as shown in the examples.

Value and Attribute options can be used if the area to be printed text is a combobox and the desired text cannot be printed with the text method. Because on some websites and applications, it allows changing the values in the combobox only with attribute options. For this reason, setting up with the Text method does not work.

Title option should only be used if you want to change the title information of the site.

It can also be used as an alternative to the Text method in Keystroke.

Text is used to write text into the given content:

Text

It is used to change the value in the Html code for the entered location (Xpath) value:

Value

It is used to change the Attribute value in the Html code by specifying which Attribute value is desired for the entered location (Xpath) value:

Attribute

Used to change the title of the page that opens:

Title

It is a keyboard gesture. If the KeyStroke action is selected, the action desired to be performed on the keyboard is written in the text section:

Keystroke

You can use the Text as shown in the examples.

Coronavirus news

Coronavirus news for ${days}

${days}

You can use the Attribute name as shown in the examples.

Value

option

Home – Robusta

The value to be set in the text field can be both written with a variable and entered directly as text. If it is to be entered as text, it can be entered as robusta. But the value is to be sent by means of the variable, the name of variable must be between brackets ({}) and start with $. Let’s assume that robusta is assigned to companyname variable and we will call a variable to obtain the value of that variable, the variable name must be typed as ${companyname}.

Get methods

Get methods activity is used for getting data from the desired fields through the browser or application.

*Application name	The reference name of applications which has already been opened or attached is chosen in the dropdown.
*Field	It is the field where the location (XPath) of the area is written.
*Type	To get data, the appropriate action should be selected.
Attribute name	If “Attribute” is selected as an action in the Type property, the attribute name to be fetched must be written.
*Result variable name	The variable name is defined in this property to store the data received from the application in a variable and use it in the next process step.

_{Note: * Fields selected with are required, others are optional.}

You can use the Applications name as shown in the example.

${robustaWebpage}

You can use the Field as shown in the example.

(//input[@title=”Arama”])[1]

You can use the Type as shown in the examples.

It returns the given content as text:

Text

It returns the “attribute” value in the location (Xpath) information entered:

Value

It returns the value of this attribute by entering the desired attribute information in the entered location (Xpath) information:

Attribute

When the application is opened, it brings up the page title:

Title

It brings up the link when the application is opened:

URL

You can use the Attribute name as shown in the examples.

Attribute Name is not required for Title and Url option in actions.

Attribute Name is not required for Text option in Actions

value

name

You can use the Result variable name as shown in the example.

getResult

Wait actions

Wait actions activity allows the desired element to wait until it becomes clickable or visible through the browser or application. In this way, clicking or setting etc. Processes are delayed according to the loading state of the element, not a fixed waiting period.

*Application name	The reference name of applications which has already been opened or attached is chosen in the dropdown application which will be opened.
*Field	It is the field where the location (Xpath) of the area is to be waited for on the application.
*Wait for	It provides the selection of the wait action to be performed.
Timeout (sec)	The sets timeout period for checking visible or enable property of the element. Default value is 15.

_{Note: * Fields selected with are required, others are optional.}

You can use the Applications name as shown in the example.

${robustaWebpage}

You can use the Field as shown in the example.

(//input[@title=”Arama”])[1]

It waits until the field in the given XPath location becomes visible:

Visible

It waits until the field in the given XPath location becomes invisible:

invisible

It waits until the field in the given XPath location becomes clickable:

Enable

You can use the Timeout (sec) as shown in the example.

5

In the example above, until the element whose location is given in the Field field is visible, the next action will not be carried out and the element will be expected to be visible.

Switch actions

Switch actions activity allows switching between desired windows or frames through the browser or application.

*Application name	The reference name of applications which has already been opened or attached is chosen in the dropdown application which will be opened.
*Switch to	The option of the field that wanted to switch in the application or page is chosen in the dropdown.
*Field	If the area to be transferred to is a frame, any field (XPath) in the frame must be written. Note: If the “Switch to” property is selected as a “default window” or “default content”, the “Field” property can be left blank.
*Title	If the “Switch to” action is selected as “Window”, the “Match” action should be chosen appropriately. The window title should be written “Title” field. If the full window title is written “Title” field, the equals option should choose in the “Match” field. If the starting of the window title is written “Title” field, the starts option should choose in the “Match” field. If the ending of the window title is written “Title” field, the ends option should choose in the “Match” field. If any part of the window title is written “Title” field, the contains option should choose in the “Match” field.
Match	The desired option can be chosen when searching by title.
Retry Count	The number of attempts until the operation occurs is written, which can be any numeric value. Default value is 1.

_{Note: * The required fields may change according to the selected features.}

You can use the Application name as shown in the example.

${robustaWebpage}

You can use the Switch to as shown in the example.

It allows switching between pages that are open more than one in the application:

Window

It allows to switch to frame within the opened application:

Frame

It provides the transition to the default main window:

Default Window

It is used to return to the previous content after switching to a Frame. In addition, although the elements to be accessed in some websites and applications cannot be in a separate window or frame, they still require access with the switch method. In these cases, the desired action can be performed by switching the content containing the element:

Default Content

You can use the Field as shown in the examples.

Since Xpath information is not required for Window, Default Content and Default Window options, the field can be filled with (*) character.

//*[@id=”google_ads_iframe”]

//*[@id=”Content-Language”]

You can use the Title name as shown in the examples.

Home – Robusta

You can use the Match as shown in the examples.

It is the structure used when searching by title.

The title name of the window to be switched must be written exactly the same:

Equals

It is sufficient to write a certain part from the beginning of the title name of the window to be switched:

Starts

It is sufficient to write a certain part from the end of the title name of the window to be switched:

Ends

It is sufficient to write a word that is in the title name of the window you want to switch to and is not found in other windows:

Contains

If the window you want to switch to does not have the title name, it should be selected:

Notitle

It enables transition to the next window that opens. When this actions is selected, it is not necessary to fill the title field:

7

If a title is not written in the window to be switched, the “Match” property can be selected as “Notitle” or “Next”.

Next option switches to the window that opens immediately after the existing window.

Scroll

Scroll activity is used for moving the page up/down or right/left on the browser or application.

*Application name	The reference name of applications which has already been opened or attached is chosen in the dropdown application which will be opened.
X-coordinate	Specifies how many units the page movement will move along the X-axis.
Y-coordinate	Specifies how many units the page movement will move along the Y-axis.
*Scroll	These options are used for moving the page in any direction on the browser or application that is opened.

_{Note: * Fields selected with are required, others are optional.}

You can use the Application name as shown in the example.

robustaWebpage

You can use the X-coordinate as shown in the example.

300

You can use the Y-coordinate as shown in the example.

0

Scrolls the screen downwards:

Down

Scrolls the screen upwards:

Up

Scrolls the screen to the left:

Left

Scrolls the screen to the right:

Right

Page movement is not used in two directions at the same time. The process must be done separately for each movement.

If you want to move the page up or down only, the Y-coordinate field should be left blank.

If you want to move the page to the right or left only, the X-coordinate field should be left blank.

Scrape data

Scrape data activity allows receiving data in bulk via a browser or application.

You can find the information how to use scrape function using winspy, please follow the link.

*Application name	The reference name of applications which has already been opened or attached is chosen in the dropdown application which will be opened.
*Scraper name	It is the name of the dataset where the retrieved data will be stored. Note: The data brought by the scrap method is actually kept in a dataset.
*Table	The location (Xpath) of the table is written in this field is written.
Header	The header part of XPath is written in this field. Note: If there is no header for the Table, this field should be left blank.
First record header	If you want to point out the first record to be scraped as a title, the Checkbox should be selected.
*Row	The row part of Xpath is written in this field. Note: This XPath should represent all the rows in the table.
*Column	The smallest part of XPath which includes the desired data is written in this field. Note: This XPath should represent all the cells or repetitive data in the table.
Advertisement	The location (XPath) information of the advertisement button or pop-up (If any) seen on the page is written.
Wait (ms)	The time required to wait during the scrap is specified in milliseconds.
Next page	The location (Xpath) information of the next button of the table (If any) to be scraped is written. The provided XPath should not be found on the last page.
Initial popup click	Initial pop click locator Xpath.
Popup	If there is a pop-up on the page, the location (Xpath) information of the close button is written.
Max count	The maximum count of data to be scrapped is written.
Hover	If set to True, it scrolls the page down each time the data is scraped.

Note: * Fields selected with are required, others are optional.

You can use the Application as shown in the example.

robustaWebpage

You can use the Scraper as shown in the example.

scrapeTable

You can use the Table as shown in the example.

(//table[@class=”unitTable”])[1]

You can use the Header as shown in the example.

thead//tr//th

You can use the Row as shown in the example.

tbody//tr

You can use the Column as shown in the example.

td

You can use the Advertisement as shown in the example.

//*[@value=”Adv”]/[text()]

You can use the Wait (ms) as shown in the example.

3000

You can use the Next page as shown in the example.

//*[@value=”Next”]/[text()]

You can use the Initial popup click as shown in the example.

@class=’siebui-popup-button’]/*[@title=’Pick Address:New’]

You can use the Popup as shown in the example.

@class=’siebui-popup-button’]/*[@title=’Pick Address:New’]

You can use the Max count as shown in the example.

10

Alert actions

Alert actions activity provides the management of the browser’s own pop-ups on the browser. In other words, it is for the management of the pop-ups belonging to the browser, not any pop-up that appears on any site.

*Application name	The reference name of applications which has already been opened or attached is chosen in the dropdown application which will be opened.
*Action	Depending on the request, appropriate actions are provided for closing or accepting pop-ups that are opened on the screen of the browser or application. Note: The activity uses in cases if there is no XPath information available.

_{Note: * Fields selected with are required, others are optional.}

You can use the Applications name as shown in the example.

${robustaWebpage}

You can use the Action as shown in the example.

When a notification comes to the application screen, it accepts it and makes the notification screen close:

Accept

When a notification comes to the application screen, it makes it close without accepting this warning:

Dismiss

Download file

Download file activity is used for downloading files with the help of the link address (URL) of the file to be downloaded in cases where there is no download button on any web page.

*Application name	The reference name of applications which has already been opened or attached is chosen in the dropdown application which will be opened.
*Url	Since the files do not have a download button, there is a link address in the HTML code section. It can be downloaded files using this link.
*Directory	This is the field where the directory to download the file to be downloaded is specified.
*File name	The name of the file to be downloaded is written.

_{Note: * Fields selected with are required, others are optional.}

You can use the Applications name as shown in the example.

${robustaWebpage}

You can use the Url as shown in the example.

https://s0.shbdn.com/projeler/media/photos/Project/2017/05.png

You can use the Directory as shown in the example.

C:TempDownloadedFiles

You can use the Directory as shown in the example.

test.jpeg

Take capture

Take capture activity is the structure that allows taking image through the browser or application.

*Application name	The reference name of applications which has already been opened or attached is chosen in the dropdown application which will be opened.
*Field	It is the field where the location (Xpath) of the area to be taken captured on the application to be worked is specified.
*Directory	For saving the image, the directory is written in this field.
File name	The file name which will be created is written in this field.

_{Note: * Fields selected with are required, others are optional.}

You can use the Applications name as shown in the example.

${robustaWebpage}

You can use the Field as shown in the example.

//img[@id=”capthcaimage”

You can use the Directory as shown in the example.

C:RobustaProjects

You can use the File name as shown in the example.

robusta.jpeg

Screenshot files are image files. For this reason, it should be named a suitable lay down (JPG, jpeg etc.).

Functions

Functions activity finds the occurrence number of a desired element on the browser or windows application (This element can be an image, a button or a text), checking whether the item whose location is given exists on the current screen. Also, it allows the refresh of the page (Refresh) within a certain field or entire page on the browser or windows application.

*Application name	The reference name of applications which has already been opened or attached is chosen in the dropdown application which will be opened.
*Field	The location (Xpath) of the area where the action is desired is entered.
*Result variable name	The variable name which stores the data obtained by the Functions activity is written.
*Action	The desired action is chosen in the dropdown.
Retry Count	The number of attempts until the operation occurs is written. Note: It can be any numeric value. Default value is 1.

_{Note: * Fields selected with are required, others are optional.}

You can use the Applications name as shown in the example.

${robustaWebpage}

You can use the Field as shown in the example.

(//input[@title=”Arama”])[1]

You can use the Result variable name as shown in the examples.

countResult

existResult

You can use the Action as shown in the examples.

It returns the number of elements of the given content. It is possible to have more than one element with the same XPath on the page. For example, it can be used in cases where the number of rows in the table is found:

Element Count

It is used for refreshing a certain area or the entire page:

Refresh

It checks whether the element whose location (Xpath) information is given exists on the current screen and according to the result, the result is true if there is an element, otherwise, it is false It is used for refreshing a certain area or the entire page:

Exist

You can use the Retry Count as shown in the examples.

7

Exists operation returns true or false only.

The result of the Element Count operation is returned only as a digit (in string format). (Eg: Such as 5, 3)

Run Script

This activity enables the execution of JavaScript code in the web interface.

*Application name	The reference name of applications which has already been opened or attached is chosen in the dropdown application which will be opened.
*Script	Script to be executed, must be JavaScript
*Result variable name	The variable name which stores the data obtained by the Run Script activity is written.

_{Note: * Fields selected with are required, others are optional.}

You can use the Applications name as shown in the example.

${robustaWebpage}

You can use the Result variable name as shown in the examples.

countResult

existResult

Browser navigate

Browser navigate activity is used to redirect the tab opened in the process to another site.

*Application name	The reference name of applications which has already been opened or attached is chosen in the dropdown application which will be opened.
Navigate url	URL of the site to be navigated
Navigate to	Navigation direction is selected “forward” or “backward”

_{Note: * Fields selected with are required, others are optional.}
One of the “Navigate to” or “Navigate url” features must be entered.

You can use the Applications name as shown in the example.

${navigateOpen}

You can use the Navigate url as shown in the example.

https://www.robusta.ai/

You can use the Navigate to as shown in the example.

forward

back

Close

Close activity, closes the browser or application in the given name to be closed.

*Application name

The reference name of applications which has already been opened or attached is chosen in the dropdown application which will be opened.

_{Note: * Fields selected with are required, others are optional.}

You can use the Applications name as shown in the example.

${robustaWebpage}

Keyboard & Mouse

Keyboard & Mouse activities offer that simulate keyboard or mouse input that a human will use. There are also events that can set the focus to a specific window, minimize or maximize the screen or perform any action on it. These activities are necessary to create an automation that simulates human behavior.

While ending remote desktop connections, make sure that Capslock is turned off. Otherwise, on the next connection, Capslock will be turned on.

Mouse

Mouse activity is used for sending Mouse actions to the currently open screen, regardless of the browser or application.

*Action	Specifies the mouse click type.
X-Position	The location on the X-axis where the process will take place is entered. It can also be entered as a variable. Note: The variables are used in ${} in Robusta RPA.
Y-Position	The location on the Y-axis where the process will take place is entered. It can also be entered as a variable. Note: The variables are used in ${} in Robusta RPA.

_{Note: * Fields selected with are required, others are optional.}

You can use the Action as shown in the examples.

LEFT_CLICK

RIGHT_CLICK

DOUBLE_CLICK

MOVE

You can use the X-Position as shown in the examples.

425

${xPos}

You can use the Y-Position as shown in the examples.

125

${yPos}

Drag drop

Drag drop activity allows you to click and drag a given coordinate area on the currently open screen to drop it into another coordinate field.

*Drag x	The location of the X-axis where the drag operation will be performed is entered.
*Drag y	The location of the Y-axis where the drag operation will be performed is entered.
*Drop x	The location of the X-axis where the drop operation will be performed is entered.
*Drop y	The location of the Y-axis where the drop operation will be performed is entered.

_{Note: * Fields selected with are required, others are optional.}

You can use the Drag x as shown in the example.

236

You can use the Drag y as shown in the example.

123

You can use the Drop x as shown in the example.

125

You can use the Drop y as shown in the example.

639

Keyboard

Keyboard activity is used for writing text to the application active on the screen via the keyboard to the desired area.

*Text	The text to be written in the desired field in the active application is written here. It can also be entered as a variable. Note: The variables are used in ${} in Robusta RPA.
Press key after typing	It is chosen which key will be pressed after typing.
Wait after typing (ms)	After typing, the information about how long to wait is entered.

_{Note: * Fields selected with are required, others are optional.}

You can use the Text as shown in the example.

Hello world ${result}

You can use the Press key after typing x as shown in the example.

NONE TAB ENTER

You can use the Wait after typing (ms) as shown in the example.

500

Hotkey

Hotkey activity is used for sending shortcut commands (CTRL + S, ENTER etc.) to the application that is active on the screen.

*Hotkey

The command information to be sent with the keyboard is written in this field. The command can also be entered as a variable.
Note: The variables are used in ${} in Robusta RPA.

_{Note: * Fields selected with are required, others are optional.}

You can use the Hotkey as shown in the example.

CTRL+S , CTRL+SHIFT+ENTER

Commands can be sent in binary or triple combination. While writing commands, the phrase “+” should be written between two commands.

BACK_SPACE	ALT	3	L or l	NUMPAD2	F10	}
TAB	PAUSE	4	M or m	NUMPAD3	F11	MINUS
UNDEFINED	CAPS_LOCK	5	N or n	NUMPAD4	F12	QUOTE
ACCEPT	ESCAPE	6	O or o	NUMPAD5	WINDOWS	KP_UP
HELP	SPACE	7	Ö or ö	NUMPAD6	SUBTRACT	KP_DOWN
ALPHANUMERIC	PAGE_UP	8	P or p	NUMPAD7	ADD	KP_LEFT
@	PAGE_DOWN	9	Q or q	NUMPAD8	DELETE	KP_RIGHT
:	END	;	R or r	NUMPAD9	DEL	ALT_GRAPH
^	HOME	=	S or s	‘	NUM_LOCK	ALT_GR
!	LEFT	A or a	Ş or ş	+	SCROLL_LOCK	ALT-GR
(	UP	B or b	T or t	SEPARATER	&	STOP
#	RIGHT	C or c	U or u	%	*	AGAIN
+	DOWN	Ç or ç	Ü or ü	DECIMAL	QUOTEDBL	PROPS
)	,	D or d	V or v	DIVIDE	<	UNDO
–		E or e	W or w	F1	PRINTSCREEN	COPY
$	.	F or f	X or x	F2	INSERT	PASTE
€	/	G or g	Y or y	F3	HELP	FIND
~	¨	Ğ or ğ	Z or z	F4	META	CUT
CANCEL	\|	H or h	[	F5	>	SEPARATOR
CLEAR	é	I or ı		F6	{	ENTER
SHIFT	0	İ or i	]	F7	n	?
CONTROL	1	J or j	NUMPAD0	F8	_	PLUS
CTRL	2	K or k	NUMPAD1	F9	t

Key hold

Key hold activity allows holding down the ALT-SHIFT-CTRL keys on the keyboard and keying the characters that need to be typed with a shortcut on the keyboard.

*Key	The key to being kept pressed or released is chosen in the dropdown.
*Event	If KEY_DOWN is selected, the key is kept pressed, if the KEY_UP command is selected, the key is released.

_{Note: * Fields selected with are required, others are optional.}

You can use the Key as shown in the examples.

ALT

SHIFT

CTRL

You can use the Event as shown in the examples.

KEY_DOWN

KEY_UP

A key that is made KEY_DOWN should be released later with the KEY_UP command.

Clipboard

Clipboard activities are used to retrieve specific text from the clipboard or insert it into the clipboard.

Get from clipboard

Get from clipboard activity is used for retrieving specific text from the clipboard or inserting it into the clipboard.

*Result text name

The Variable’s name to assign the data read from the clipboard is written.

Note: * Fields selected with are required, others are optional.

You can use the Result text name as shown in the examples.

getVar

${Varname}

The data saved in the clipboard after any operation is taken into the process from the clipboard by giving a variable name. If the variable is already defined, the variable name is used as ${}:

${getVar}

Set to clipboard

Set to clipboard activity is used for writing text on the clipboard.

Text

It is the desired value to be written to the clipboard.

Note: * Fields selected with are required, others are optional.

You can use the Text as shown in the examples.

Hello World

${getVar}

Clipboard to dataset

Clipboard to dataset activity is used for converting the text read from the clipboard into a dataset.

*New dataset name	The reference name is given to the dataset which will create in this field.
*Has header	It indicates whether the first line of the text document to be opened is a title or not. If the feature is selected, it means there is a title, if it is not, it means no title.
Delimeter	The separator character in the text document to be opened is specified.
*Type	Indicates the data type. Data types differ in structure and separators.

^{Note: * Fields selected with are required, others are optional.}

You can use the New dataset name as shown in the examples.

clipDS

After exiting the data in the dashboard, it can be written to another field such as excel, csv with the name given to the data set.

You can use the Type as shown in the examples.

CSV_Default

CSV_Excel

CSV_InformixUnload

CSV_MySQL

CSV_Oracle

CSV_PostgreSQLCsv

CSV_PostgreSQLText

CSV_RFC4180

CSV_TDF

text

You can use the Delimeter as shown in the examples.

name; surname; age;

Data is written according to the separator of the data received in the set. Separators such as commas can be used.

Dataset to clipboard

Dataset to clipboard activity is used for writing the dataset to the clipboard.

*Dataset name	The reference name of the dataset which has already been created is chosen in the dropdown.
*Has header	It is indicated whether the first line of the text document to be opened is a title or not. If the feature is selected, it means there is a title, if it is not, it means no title.

^{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the examples.

clipDS

Copy file to clipboard

Copy file to clipboard activity enables file content to be copied to the clipboard.

*File name

The file path is written.

^{Note: * Fields selected with are required, others are optional.}

You can use the File name as shown in the examples.

C:RobustaData.txt

Clear clipboard

Get from clipboard activity enables to clear content of the clipboard.

Excel

Excel activities provide methods for creating, extracting, and adding data to Excel workbooks and worksheets.

You can reach a how-to guide on Excel by clicking here.

Open Excel

Open activity is used for opening an existing Excel file.

*Excel name	The reference name is given to the excel file which will open in this field.
*Excel file name	The file path is written.
File password	The password is entered to open or modify the encrypted file.

Note: * Fields selected with are required, others are optional.

You can use the Excel name as shown in the example.

exampleExcel

You can use the Excel file name as shown in the example.

C:RobustaExample.xlsx

You can use the File password as shown in the example.

1234

Create

Create activity is used for creating an Excel file that did not exist before. Create process creates Excel and at the same time does the process of opening Excel.

*Excel name	The reference name is given to the excel file which will create in this field.
*Excel file name	The file path is written.
Overwrite	This checkbox enables overwriting if there is a file or folder with the same name.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

newExcel

You can use the Excel file name as shown in the example.

C:RobustaNew_Excel.xlsx

If the “Overwrite” checkbox status is:

True: If there is no file/folder with the same name in the relevant directory, it is not necessary to mark this field. If there is a file/folder with the same name in the relevant directory, the name is changed by overwriting the old file/folder.

False: If there is a file/folder with the same name in the relevant directory, the name is not changed. The function gets an error with the message “There is folder already in the directory.

Save and close

Save and close activity is used for saving or closing Excel after the operations are performed in the Excel file.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
*Action	The desired operation is selected. There are three options, Save, Close and Save and Close.
Excel file name	The file path is written. Note: If an excel file is desired to save as, write the name and path of the word file.

Note: * Fields selected with are required, others are optional.

You can use the Excel name as shown in the example.

newExcel

You can use the action as shown in the example.

SAVE

CLOSE

SAVE_AND_CLOSE

You can use the Excel file name as shown in the example.

C:New_Excel.xlsx

If you want to save Excel as a different excel, the Excel file path field must be filled.

If you want to perform both Save and Close operations, component should be used twice.

Copy

Copy activity is used for copying data in a specified range from an Excel file.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet index	Index of the sheet to work in Excel. If not added, it takes the first sheet by default.
Destination	It can be determined from which cell the copied data will be written in excel.
Source excel	The excel reference name from which the data will be received is chosen in the dropdown.
Source sheet	The Excel sheet name which will be retrieved data is written.
Range	The range of cells to be copied is given.
*Shift	Specifies how to copy the dataset to the Excel file.
Copy as value	It is the choice of copying the data to be copied with its values (without formulas). Note: This checkbox will be important if there is a formula in Excel. If you want to hold the values you can copy the results as a value. If you do not check this box, you can lose the values.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name as shown in the example.

Sheet1

You can use the Sheet index as shown in the example.

5

You can use the Destination as shown in the example.

D1

You can use the Source excel as shown in the example.

${newExcel}

You can use the Range as shown in the example.

A1:B5

You can use the Shift as shown in the example.

Copies the data to the current location that is already data:

NONE

Copies your data to a valid location by shifting the current data to the right:

RIGHT

Copies your data to the current location by moving the existing data down:

DOWN

Sheet name fields do not have to be filled if the first page of the excel files will be copied. Otherwise, it must be filled.

If there are two separate excels and if there is a copy operation between these two excels, the Sheet name, Source sheet and Excel name fields must be filled.

Remove

Remove activity is used for deleting the inside of a column or a cell in an Excel file.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet index	Index of the sheet to work in Excel. If not added, it takes the first sheet by default.
Rows	The row index is written.
Column	Column name or index is written. If it is wanted to delete more than one column, it is named a column number, column letter, or column heading by separating it with a comma.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

newExcel

You can use the Sheet name as shown in the example.

Sheet1

You can use the Sheet index as shown in the example.

5

You can use the Rows as shown in the example.

1

To select multiple rows, use “:”

1:5

You can use the Column as shown in the example.

1

A

A, B

Sheet name field can be left blank if it is desired to operate on the first page of the Excel file. Otherwise, it has to be filled.

In Excel, rows begin with 1, columns begin with 0.

If you want to delete only a row in Excel, the column is left blank.

If you want to delete only a column in Excel, the row is left blank.

Remove duplicates

Remove duplicates activity enables to delete duplicate rows in any columns.

*Excel name	The reference name of the excel file which has already opened or created is chosen in the dropdown.
Sheet name	The name of the sheet to work in excel can be added. If not added, it is accepted as the first sheet by default.
Sheet index	Index of the sheet to work in Excel. If not added, it takes the first sheet by default.
Row	Indicates on which line the remove duplicate operation will be performed.
Column	Indicates on which column the remove duplicate operation will be performed.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

newExcel

You can use the Sheet name as shown in the example.

Sheet1

You can use the Sheet index as shown in the example.

5

You can use the Row as shown in the example.

1

You can use the Column as shown in the example.

1

A

Sheet name field can be left blank if it is desired to operate on the first page of the Excel file. Otherwise, it has to be filled.

In Excel, rows begin with 1, columns begin with 0.

If you want to delete only a row in Excel, the column is left blank.

If you want to delete only a column in Excel, the row is left blank.

Format

Format activity is used for converting the specified column in an Excel file to the desired format.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Range	Excel sheet range from which to fetch data is written.
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet index	Index of the sheet to work in Excel. If not added, it takes the first sheet by default.
*Format	The cells are formatted for dates, text, currency, and time using desired formats.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${formatExcel}

You can use the Range as shown in the example.

A1:C5

You can use the Sheet name as shown in the example.

Sheet1

You can use the Sheet index as shown in the example.

5

You can use the Format as shown in the example.

For date:

dd.MM.yyyy

For TC:

00000000000

For text:

@

For currency:

₺ #, ## 0; -₺ #, ## 0

For hours:

hh.mm: nn

These examples can be increased on demand or by using ready-made formats in excel.

Read excel to dataset

Read excel to dataset activity is used for converting the desired Excel file will be processed into dataset.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
*New dataset name	The reference name is given to the dataset which will create in this field.
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet index	Index of the sheet to work in Excel. If not added, it takes the first sheet by default.
Range	Excel sheet range from which to received data is written.
Has header	If the dataset has column headings, true is selected.
Include Formatted Text	If it is desired to include formatted text in a new column, true is selected.
Set to null	This checkbox provides the set cell values that are empty string to null.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the New dataset name as shown in the example.

newDataset

You can use the Sheet name as shown in the example.

Sheet1

You can use the Sheet index as shown in the example.

5

You can use the Range as shown in the example.

A1:C5

Sheet name field can be left blank if it is desired to operate on the first page of the Excel file. Otherwise, it has to be filled.
If the Range field is not filled, all of the data in the excel file constitutes the dataset range.
If no Destination is given, it is copied to cell A1.

Write dataset to excel

Write excel to dataset activity allows the changes to be written to the relevant excel file after the dataset processes are completed.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
*Dataset name	The reference name of the dataset which has already been created is chosen in the dropdown.
Sheet name	The name of the sheet to work in excel can be added. If not added, it is accepted as the first sheet by default.
Sheet index	Index of the sheet to work in Excel. If not added, it takes the first sheet by default.
Destination	It can be determined from which cell the dataset will be written in excel. If the Destination field is not filled, the dataset will be written its range directly into Excel. Note: If the target range/area (Destination) is given and there is already data in the given area, that data will be written to the side of the dataset range.
*Shift	Specifies how to write the dataset to the excel file.
Include header	If there are column header in the resulting dataset, true is selected.
Row	Rows that will be written to the Excel.
Column	Columns that will be written to the Excel.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Dataset name as shown in the example.

${newDataset}

You can use the Sheet name as shown in the example.

Sheet1

You can use the Sheet index as shown in the example.

5

You can use the Destination as shown in the example.

A1

You can use the Shift as shown in the example.

Copies the data to the current location that is already data:

NONE

Copies your data to a valid location by shifting the current data to the right:

RIGHT

Copies your data to the current location by moving the existing data down:

DOWN

You can use the Row as shown in the example.

1:5

You can use the Column as shown in the example.

1:5

The sheet name field can be left blank if it is desired to operate on the first page of the Excel file. Otherwise, it has to be filled.

If the Destination field is not filled, the dataset prints its range directly into Excel. If the destination is given and if there is data in excel in the field where it is given, that data moves next to the dataset range.

Copy/Remove sheet

Copy/Remove sheet activity is used for copying data in a specified range from an Excel file.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default. Note: When the “Action” property is selected as “Remove”, the “Sheet Name” field must be filled.
Sheet index	Index of the sheet to work in Excel. If not added, it takes the first sheet by default.
*Action	The desired action is selected.
Source excel	The excel reference name from which the data will be received is chosen in the dropdown.
New sheet name	The name of new sheet to create in Excel is written.
Copy as value	If the checkbox is selected, formulas in Excel will be copied as a value.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name as shown in the example.

Sheet1

You can use the Sheet index as shown in the example.

5

You can use the Action as shown in the example.

COPY

REMOVE

You can use the Source excel as shown in the example.

${copyExcel}

You can use the New sheet as shown in the example.

NewSheet

The sheet name field can be left blank if it is desired to operate on the first page of the Excel file. Otherwise, it has to be filled.

If Copy operation will be done in the same excel file, new sheet name and sheet name fields should be filled.

Source excel, new sheet name and sheet name fields must be filled in if copy operation will be done in different excel files.

Create sheet

Create sheet activity is used for creating sheets in an Excel file and it appends the newly created sheet to the end.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet name	The name of the page to be created in the excel file is given.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name as shown in the example.

NewSheet

Rename sheet

Rename sheet activity is used for changing name of sheet in Excel.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet index	Index of the sheet to work in Excel. If not added, it takes the first sheet by default.
*New sheet name	The new name of the sheet is written.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name as shown in the example.

Sheet1

You can use the Sheet index as shown in the example.

5

You can use the New sheet name as shown in the example.

newSheet

List sheets

List sheets activity allows transferring the worksheets in the Excel file to the dataset.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
*New dataset name	The reference name of the dataset that will be created is given.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the New dataset file name as shown in the example.

listDataset

If the dataset is written to the excel file, it will appear as below.

Save sheet as pdf

Save sheet as pdf activity allows the pages in an Excel file to be saved as PDF.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
*Pdf name	The pdf file name is written.
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet index	Index of the sheet to work in Excel. If not added, it takes the first sheet by default.
All sheets	If all worksheets in Excel will be saved as pdf, this field is selected.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Pdf name file name as shown in the example.

C:RobustanewExcel_to_PDF.pdf

You can use the Sheet name file name as shown in the example

Sheet1

You can use the Sheet index as shown in the example.

5

Clear sheet

Clear sheet activity performs the process of deleting a page in an Excel file or the desired area in the page.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet name	Name of the sheet to work in Excel, if not added it takes the first sheet by default.
Sheet index	Index of the sheet to work in Excel. If not added, it takes the first sheet by default.
Range	Excel sheet range from which to clear data is written.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name file name as shown in the example.

Sheet1

You can use the Sheet index as shown in the example.

5

You can use the Range name as shown in the example

A1:C5

If it is desired to delete a certain range in the page rather than a page in the Excel file, the range is given. If the range is not given, the entire sheet is deleted.

If the first page of the excel files will be processed, the sheet name fields do not have to be filled. Otherwise, it must be filled.

Pivot

Pivot activity is used for pivot operations that will be done in an Excel file.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Source sheet	The Excel sheet name which includes data for the pivot is written.
Range	The information for the range to be pivoted is given.
Sheet name	The name of that sheet is given to show the result of the Pivot operation on a blank Excel sheet or a newly created Excel sheet.
Sheet index	Index of the sheet to work in Excel. If not added, it takes the first sheet by default.
Destination	It can be determined from which cell the pivoted data will be written in excel. Note: If no destination is given, the copy is made to cell A1.
Columns	It gives which columns will consist of in the pivot operation.
Rows	It gives which rows will consist of in the pivot operation.
Values	The desired action is written.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${pivotExcel}

You can use the Source sheet as shown in the example.

Sheet1

You can use the Range as shown in the example.

A1:B3

A:A

A:H

You can use the Sheet name as shown in the example.

Pivot

You can use the Sheet index as shown in the example.

5

You can use the Destination as shown in the example.

A1

You can use the Columns as shown in the examples.

A

A,B

You can use the Rows as shown in the example.

B

You can use the Values as shown in the examples.

SUM(C)

COUNT(C),AVERAGE(C)

Supported functions:

AVERAGE

COUNT

COUNT_NUMS

MAX

MIN

PRODUCT

STD_DEV

STD_DEVP

SUM

VAR

VARP

If the first page of the excel files will be pivoted, the source sheet field does not have to be filled. Otherwise, it must be filled.
If no Destination is given, it is copied to cell A1.
If Range is not given, the entire range in the Excel file is taken.
If there is more than one table or different data in the sheet, the “Range” field should be filled.
Excel file that contains different columns with the same name, errors can occur during pivot operations. In this case, the column names should be changed.

Get row as json

Get row as json activity allows to create a variable in JSON format of a row in the excel.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet index	Index of the sheet to work in Excel. If not added, it takes the first sheet by default.
Row	Row index.
*Result variable name	Variable name of the return value.

*_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name as shown in the example.

Sheet1

You can use the Sheet index as shown in the example.

5

You can use the Row as shown in the example.

0

You can use the Result variable name as shown in the example.

getJSON

Hide or show

Hide or show activity is used for hiding or showing a column or a row in an Excel file.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet index	Index of the sheet to work in Excel. If not added, it takes the first sheet by default.
Action	Hide and show action is chosen rows or columns.
Rows	It is written which row will be shown or hidden.
Colums	It is written which columns will be shown or hidden.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name file name as shown in the example.

Sheet1

You can use the Sheet index as shown in the example.

5

You can use the Action as shown in the example.

HIDE

SHOW

You can use the Rows as shown in the example.

1

1:5

You can use the Rows as shown in the example.

1

1:4

If the Row field is left blank, it will perform the operation for the whole column.

Set cell style

Set cell style activity is used for formatting the cell styles of the desired ranges in the worksheet of an Excel file.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet index	Index of the sheet to work in Excel. If not added, it takes the first sheet by default.
Range	The range of cells to be changed data is given.
Fill color	The background color of the cell is written as RGB values or the name of the color.
Font color	The text color is written as RGB values or the name of the color.
Bold	This checkbox provides changing the font thickness.
Italic	This checkbox provides italicization.
Underline	This checkbox provides underlining.
Font size	The font size is adjusted. The desired font number is written in this area.
Font name	The font type is written.
Wrap text?	Wrap text is the automatic adjustment of text to fit within a confined space, such as a cell or text box, by breaking the text into multiple lines
Has border?	Whether borders (Frame) will be present or not is selected.
Border style	The border style that will be applied is selected.
Border position?	The position of the border that will be applied is selected.
Border color	The border color of the cells is is written as RGB values or the name of the color.
Vertical alignment	Vertical alignment of the cells.
Horizontal alignment	Horizontal alignment of the cells.
Is hyperlink?	This checkbox provides converting text to hyperlink.
Url	This textbox provides url value to be converted to hyperlink.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name file name as shown in the example.

Sheet1

You can use the Sheet index as shown in the example.

5

You can use the Range as shown in the example.

A1

A1:B5

You can use the Font color file name as shown in the example.

255,0,0 (Red)

255,255,0 (Yellow)

You can use the Font size as shown in the example.

9

You can use the Font name as shown in the example.

Arial

You can use the Border style as shown in the examples.

NONE

THIN

MEDIUM

DASHED

DOTTED

THICK

DOUBLE

You can use the Border position as shown in the examples.

ALL

NONE

TOP

BOTTOM

LEFT

RIGHT

You can use the Border color as shown in the examples.

yellow

255,56,180

You can use the Vertical alignment as shown in the examples.

NONE

TOP

CENTER

BOTTOM

JUSTIFY

DISTRIBUTED

You can use the Horizontal alignment as shown in the examples.

NONE

GENERAL

LEFT

CENTER

RIGHT

FILL

JUSTIFY

CENTER_SELECTION

DISTRIBUTED

Remove cell style

Remove cell style activity is used for removing style of cell in Excel.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet index	Index of the sheet to work in Excel. If not added, it takes the first sheet by default.
Range	The range of cells to be removing style is given.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name as shown in the example.

Sheet1

You can use the Sheet index as shown in the example.

5

You can use the Range as shown in the example.

A1:D7

The sheet name field can be left blank if it is desired to operate on the first page of the Excel file. Otherwise, it has to be filled.
If the Range field is not filled, all of the data in the excel file constitutes the dataset range.

Set formula

Set formula activity is used for replacing formulas in a specified cell or range in an Excel file. If there is no formula in the cell, it cannot be used for new formula assignment.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Range	The range of cells to be received is given.
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet index	Index of the sheet to work in Excel. If not added, it takes the first sheet by default.
Formula	Excel formula is written without ‘=’ at the beginning.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Range as shown in the example.

A1

A1:C5

You can use the Sheet name file name as shown in the example.

Sheet1

You can use the Sheet index as shown in the example.

5

You can use the Formula as shown in the example.

SUM(A1:B1)

Find and replace

“Find and replace” activity is used to find a specific word or phrase within an Excel file, text, or file and then replace it with a desired word or phrase.

*Excel name	The reference name of the Excel file which has already been opened or created is chosen in the dropdown.
*New dataset name	Reference name of dataset which will be created
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
Range	Excel sheet range from which to fetch data is written.
*Find what	String that is searched for and will be replaced.
*Replace with	New string that will be replaced with.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${formatExcel}

You can use the New dataset name as shown in the example.

TestDataset

You can use the Sheet name as shown in the example.

Sheet1

You can use the Range as shown in the example.

A1:C5

You can use the Find what as shown in the example.

RPA

You can use the Replace with as shown in the example.

RobustaRPA

Autofit rows/columns

Autofit rows/columns activity is used to fit the entries in rows and columns automatically.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet index	Index of the sheet to work in Excel. If not added, it takes the first sheet by default.
Rows	The row index is written (Starts from 1).
Columns	The column name or index is written (Starts from 1).

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name as shown in the example.

Sheet1

You can use the Sheet index as shown in the example.

5

You can use the Rows as shown in the example.

1

1:5

You can use the Columns as shown in the example.

A1

A1:B5

1

1:5

Merge/unmerge cells

Merge/unmerge cells activity is used for merging and unmerging cells in Excel.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet index	Index of the sheet to work in Excel. If not added, it takes the first sheet by default.
Range	The Excel sheet range for the merge or unmerge is written.
Merge cells?	If it is desired to merge, this checkbox is selected. If it is desired to unmerge, this checkbox is not selected.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name as shown in the example.

Sheet1

You can use the Sheet index as shown in the example.

5

You can use the Range as shown in the example.

A1:D7

Sheet name field can be left blank if it is desired to operate on the first page of the Excel file. Otherwise, it has to be filled.
If the Range field is not filled, all of the data in the excel file constitutes the dataset range.

MS Excel

MS Excel activities provide methods for creating, extracting, and adding data to excel workbooks and worksheets in MS Excel.

Open

Open activity is used for opening an existing Excel file.

*Excel name	The reference name is given to the excel file which will open in this field.
*Excel file name	The file path is written.
Visible	Offers the option of whether the excel file is visible or not. Possible Values: `true`: The Excel application window will be visible, active, and maximized on the screen. `false`: The Excel application will run in the background, and the window will not be displayed to the user.

Note: * Fields selected with are required, others are optional.

You can use the Excel name as shown in the example.

exampleExcel

You can use the Excel file name as shown in the example.

C:RobustaExample.xlsx

Create

Create activity is used for creating a new Excel file. It creates Excel file and at the same time does the process of opening Excel.

*Excel name	The reference name is given to the excel file which will create in this field.
*Excel file name	The file path is written.
Overwrite	This checkbox enables overwriting if there is a file or folder with the same name.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

newExcel

You can use the Excel file name as shown in the example.

C:RobustaNew_Excel.xlsx

If the “Overwrite” field’s checkbox status is:

True: If there is no file/folder with the same name in the relevant directory, a name change is made. If there is a file/folder with the same name in the relevant directory, the name is changed by overwriting the old file/folder.

False: If there is no file/folder with the same name in the relevant directory, a name change is made. If there is a file/folder with the same name in the relevant directory, the name is not changed. The function gets an error with the message There is folder already in the directory.

Close

Close activity is used for closing Excel after the operations are performed in the Excel file.

*Excel name

The reference name of the excel file which has already been opened or created is chosen in the dropdown.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

newExcel

Save

Save activity is used for “save”, “save as” or “save as and close” and “save and close” Excel after the operations are performed in the Excel file.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
*Action	The desired operation is selected. There are three options, Save, Save as, Save as and Close and Save and Close.
Excel file name	The file path is written. Note: If an excel file is desired to save as, write the name and path of the word file.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

newExcel

You can use the action as shown in the example.

SAVE

SAVE AS

SAVE_AS_AND_CLOSE

SAVE_AND_CLOSE

You can use the Excel file name as shown in the example.

C:New_Excel.xlsx

Copy

Copy activity is used for copying data in a specified range from an Excel file.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
Destination	It can be determined from which cell the copied data will be written in excel.
Source sheet	The Excel sheet name which will be retrieved data is written.
Range	The range of cells to be copied is given.
*Shift	Specifies how to copy the dataset to the Excel file.
Copy as value	It is the choice of copying the data to be copied with its values (without formulas). Note: This checkbox will be important if there is a formula in Excel. If you want to hold the values you can copy the results as a value. If you do not check this box, you can lose the values.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name as shown in the example.

Sheet1

You can use the Destination as shown in the example.

D1

You can use the Source excel as shown in the example.

Sheet2

You can use the Range as shown in the example.

A1:B5

You can use the Shift as shown in the examples.

Copies the data to current location that has already data:

NONE

Copies your data to current place by moving the existing data to the right:

RIGHT

Copies your data to current location by moving the existing data down:

DOWN

Sheet name fields do not have to be filled if the first page of the excel files will be copied. Otherwise it must be filled.

Remove duplicates

Remove duplicates activity enables to delete duplicate rows in any columns.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet name	The name of the sheet to work in excel can be added. If not added, it is accepted as the first sheet by default.
Row	Indicates on which line the remove duplicate operation will be performed.
Column	Indicates on which column the remove duplicate operation will be performed.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

newExcel

You can use the Sheet name as shown in the example.

Sheet1

You can use the Row as shown in the example.

1

You can use the Column as shown in the example.

1

A

Sheet name field can be left blank if it is desired to operate on the first page of the Excel file. Otherwise, it has to be filled.

In Excel, rows 1, columns begin with 0.

If you want to delete only the column in Excel, the row is left blank.

Read excel to dataset

Read excel to dataset activity is used for converting the desired Excel file will be processed into dataset.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
*New dataset name	The reference name is given to the dataset which will create in this field.
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
Range	Excel sheet range from which to received data is written.
Has header	If the dataset has column headings, true is selected.
Include Formatted Text	If it is desired to include formatted text in a new column, true is selected.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the New dataset name as shown in the example.

newDataset

You can use the Sheet name as shown in the example.

Sheet1

You can use the Range as shown in the example.

A1:C5

Write dataset to excel

Write dataset to excel activity allows the changes to be written to the relevant Excel file after the dataset processes are completed.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
*Dataset name	The reference name of the dataset which has already been created is chosen in the dropdown.
Sheet name	The name of the sheet to work in excel can be added. If not added, it is accepted as the first sheet by default.
Destination	It can be determined from which cell the dataset will be written in excel. If the Destination field is not filled, the dataset will be written its range directly into Excel. Note: If the target range/area (Destination) is given and there is already data in the given area, that data will be written to the side of the dataset range.
*Shift	Specifies how to write the dataset to the excel file.
Include header	If there are column header in the resulting dataset, true is selected.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Dataset name as shown in the example.

${newDataset}

You can use the Sheet name as shown in the example.

Sheet1

You can use the Destination as shown in the example.

A1

You can use the Shift as shown in the example.

Copies the data to current location that has already data:

NONE

Copies your data to current place by moving the existing data to the right:

RIGHT

Copies your data to current location by moving the existing data down:

DOWN

Create sheet

Create sheet activity is used for creating sheets in an Excel file.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet name	The name of the page to be created in the excel file is given.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name as shown in the example.

NewSheet

Hide or Show

Hide or show activity is used for hiding or showing a column or a row in an MS Excel file.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet name	The name of the sheet to work in MS Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet index	Index of the sheet to work in MS Excel. If not added, it takes the first sheet by default.
Action	Hide and show action is chosen rows or columns.
Rows	It is written which row will be shown or hidden.
Colums	It is written which columns will be shown or hidden.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name file name as shown in the example.

Sheet1

You can use the Sheet index as shown in the example.

5

You can use the Action as shown in the example.

HIDE

SHOW

You can use the Rows as shown in the example.

1

1:5

You can use the Rows as shown in the example.

1

1:4

If the Row field is left blank, it will perform the operation for the whole column.

Format

Format activity is used for converting the specified column in an Excel file to the desired format.

*Excel name	The reference name of the MS Excel file which has already been opened or created is chosen in the dropdown.
Range	Excel sheet range from which to fetch data is written.
Sheet name	The name of the sheet to work in MS Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet index	Index of the sheet to work in MS Excel. If not added, it takes the first sheet by default.
*Format	The cells are formatted for dates, text, currency, and time using desired formats.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${formatExcel}

You can use the Range as shown in the example.

A1:C5

You can use the Sheet name as shown in the example.

Sheet1

You can use the Sheet index as shown in the example.

5

You can use the Format as shown in the example.

For date:

dd.MM.yyyy

For TC:

00000000000

For text:

@

For currency:

₺ #, ## 0; -₺ #, ## 0

For hours:

hh.mm: nn

These examples can be increased on demand or by using ready-made formats in excel.

Find and replace

“Find and replace” activity is used to find a specific word or phrase within a MS Excel file, text, or file and then replace it with a desired word or phrase.

*Excel name	The reference name of the MS Excel file which has already been opened or created is chosen in the dropdown.
*New dataset name	Reference name of dataset which will be created
Sheet name	The name of the sheet to work in MS Excel can be added. If not added, it is accepted as the first sheet by default.
Range	Excel sheet range from which to fetch data is written.
*Find what	String that is searched for and will be replaced.
*Replace with	New string that will be replaced with.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${formatExcel}

You can use the New dataset name as shown in the example.

TestDataset

You can use the Sheet name as shown in the example.

Sheet1

You can use the Range as shown in the example.

A1:C5

You can use the Find what as shown in the example.

RPA

You can use the Replace with as shown in the example.

RobustaRPA

Set Formula

Set formula activity is used for replacing formulas in a specified cell or range in an MS Excel file. If there is no formula in the cell, it cannot be used for new formula assignment.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Range	The range of cells to be received is given.
Sheet name	The name of the sheet to work in MS Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet index	Index of the sheet to work in MS Excel. If not added, it takes the first sheet by default.
Formula	Excel formula is written without ‘=’ at the beginning.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Range as shown in the example.

A1

A1:C5

You can use the Sheet name file name as shown in the example.

Sheet1

You can use the Sheet index as shown in the example.

5

You can use the Formula as shown in the example.

SUM(A1:B1)

Run macro

Run macro activity is used for running macros.

*Excel name	The name of the Excel file that was opened or created before is selected.
*Macro name	The name of macro that will be run in Excel.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Run macro as shown in the example.

runMacro

Pivot

Pivot activity is used for pivot operations that will be done in an Excel file.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Source sheet	The Excel sheet name which includes data for the pivot is written.
Range	The information for the range to be pivoted is given.
Sheet name	The name of that sheet is given to show the result of the Pivot operation on a blank Excel sheet or a newly created Excel sheet.
Destination	It can be determined from which cell the pivoted data will be written in excel. Note: If no destination is given, the copy is made to cell A1.
Columns	It gives which columns will consist of in the pivot operation.
Rows	It gives which rows will consist of in the pivot operation.
Values	The desired action is written.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${pivotExcel}

You can use the Source sheet as shown in the example.

Sheet1

You can use the Range as shown in the example.

A1:B3

A:A

A:H

You can use the Sheet name as shown in the example.

Pivot

You can use the Destination as shown in the example.

A1

You can use the Columns as shown in the examples.

A

A,B

You can use the Rows as shown in the example.

B

A,B

You can use the Values as shown in the examples.

SUM(C)

COUNT(C),AVERAGE(C)

Supported functions:

AVERAGE

COUNT

COUNT_NUMS,

MAX

MIN

PRODUCT

STD_DEV

STD_DEVP

SUM

VAR

VARP

If the first page of the excel files will be pivoted, the source sheet field does not have to be filled. Otherwise, it must be filled.
If no Destination is given, it is copied to cell A1.
If Range is not given, the entire range in the Excel file is taken.

Refresh pivot table

Refresh pivot table is used for refreshing pivot tables in MS Excel.

*Excel name	Reference name of Excel which will be opened.
Sheet name	Name of the sheet to work in Excel. If not added, it takes the first sheet by default.
*Pivot name	Name of the pivot table that will be refreshed in MS Excel.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name as shown in the example.

Sheet1

You can use the Pivot name as shown in the example.

pivot1

List sheets

List sheets activity allows transferring the worksheets in the Excel file to the dataset.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
*New dataset name	The reference name of the dataset that will be created is given.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the New dataset file name as shown in the example.

listDataset

If the dataset is written to the excel file, it will appear as below.

Save sheet as pdf

Save sheet as pdf activity allows the pages in an Excel file to be saved as PDF.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
*Pdf name	The pdf file name is written.
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
All sheets	If all worksheets in Excel will be saved as pdf, this field is selected.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Pdf name file name as shown in the example.

C:RobustanewExcel_to_PDF.pdf

You can use the Sheet name file name as shown in the example

Sheet1

Clear sheet

Clear sheet activity performs the process of deleting a page in an Excel file or the desired area in the page.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet name	Name of the sheet to work in Excel, if not added it takes the first sheet by default.
Range	Excel sheet range from which to clear data is written.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name file name as shown in the example.

Sheet1

You can use the Range name as shown in the example

A1:C5

If it is desired to delete a certain range in the page rather than a page in the Excel file, the range is given. If the range is not given, the entire inside of the sheet is deleted.

If the first page of the excel files will be processed, the sheet name fields do not have to be filled. Otherwise, it must be filled.

Copy/Remove sheet

Copy/Remove sheet activity is used for copying data in a specified range from an Excel file.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default. Note: When the “Action” property is selected as “Remove”, the “Sheet Name” field must be filled.
*Action	The desired action is selected.
New sheet name	The name of new sheet to create in Excel is written.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name as shown in the example.

Sheet1

You can use the Action as shown in the example.

COPY

REMOVE

You can use the New sheet as shown in the example.

NewSheet

Google Sheet

Open

The “Open” activity is used to open a Google Sheet file.

*Google sheet name	The reference name of the google sheet which has already been opened or created is chosen in the dropdown.
*Google sheet url address	URL address of the page to be accessed.
*Credential file	Pre-authorized user credentials

_{Note: * Fields selected with are required, others are optional.}

You can use the Google Sheet name as shown in the example.

newGoogleSheet

.

Read google sheet to dataset

The “Read google sheet to dataset” activity is used to import the specified Google Sheet file into a dataset.

*Google sheet name	The reference name of the google sheet which has already been opened or created is chosen in the dropdown.
*New dataset name	The reference name is given to the dataset which will create in this field.
Sheet name	A page or tab name within a spreadsheet. If not included, it defaults to the first page.
Range	Cell range, e.g: A1:C2
Has header	If there are column headings in the dataset, check the box.
Include formatted text	The values will be calculated and formatted in the response according to the format of the cell.

_{Note: * Fields selected with are required, others are optional.}

You can use the Google sheet name as shown in the example.

${newGoogleSheet}

You can use the New dataset name as shown in the example.

newDS

List sheets

The “List Sheets” activity retrieves a list of all sheet names within a specified Google Sheets document.

*Google sheet name	The reference name of the google sheet which has already been opened or created is chosen in the dropdown.
*New dataset name	Reference name of dataset which will be created.

_{Note: * Fields selected with are required, others are optional.}

You can use the Google Sheet name as shown in the example.

GoogleSheet

.

Get spreadsheet info

The “Get Spreadsheet Info” activity retrieves metadata and structural information about a specified Google Sheets document.

*Google sheet name	The reference name of the google sheet which has already been opened or created is chosen in the dropdown.
*Result variable name	Result variable name.

_{Note: * Fields selected with are required, others are optional.}

You can use the Google Sheet name as shown in the example.

newGoogleSheet

.

Create sheet

The “Create Sheet” activity adds a new sheet to an existing Google Sheets document. This activity allows you to specify the name of the new sheet and optionally set its position within the document.

*Google sheet name	The reference name of the google sheet which has already been opened or created is chosen in the dropdown.
*Sheet name	Name of the sheet.

_{Note: * Fields selected with are required, others are optional.}

You can use the Google Sheet name as shown in the example.

GoogleSheet

.

Create spreadsheet

The “Create Spreadsheet” activity creates a new Google Sheets document. This activity allows you to specify the title of the new spreadsheet and optionally add initial sheets to it.

*Google sheet name	The reference name of the google sheet which has already been opened or created is chosen in the dropdown.
*Spreadsheet name	Spreadsheet name (it will be created in “My Drive”)
*Credential file	Pre-authorized user credentials

_{Note: * Fields selected with are required, others are optional.}

You can use the Google Sheet name as shown in the example.

newGoogleSheet

.

Copy/Remove Sheet

The “Copy/Remove Sheet” activity provides functionality to either copy or remove a specified sheet within a Google Sheets document. When copying, the activity duplicates the sheet within the same document or to a different document. When removing, the activity deletes the specified sheet from the document. This versatile activity is useful for managing the structure and contents of your Google Sheets documents by allowing both duplication and deletion of sheets.

*Google sheet name	The reference name of the google sheet which has already been opened or created is chosen in the dropdown.
Source Google sheet name	Source Google Sheet Instance Name. e.g:${myGoogleSheet}
Sheet name	A page or tab name within a spreadsheet. If not included, it defaults to the first page.
*Action	Copy or remove sheet.
New sheet name	The name of new sheet to create in excel.

_{Note: * Fields selected with are required, others are optional.}

You can use the Google Sheet name as shown in the example.

GoogleSheet

.

Write dataset to google sheet

The “Write dataset to Google Sheet” activity is used to write changes made in a dataset to the relevant Google Sheet file after the completion of the changes.

*Google sheet name	The reference name of the google sheet which has already been opened or created is chosen in the dropdown.
*Dataset name	The reference name is given to the dataset.
Sheet name	A page or tab name within a spreadsheet. If not included, it defaults to the first page.
Destination	Sets destination cell on which the operation will write the results.
*Shift	Select how to copy the dataset to Google Sheet.
Has header	If there are column headings in the dataset, check the box.
Row	Rows that will be written to the excel. Use “:” to select range of rows. (Starting from index 0)
Column	Columns that will be written to the excel. Use “:” to select range of columns. (Starting from index 0)

_{Note: * Fields selected with are required, others are optional.}

You can use the Google sheet name as shown in the example.

${newGoogleSheet}

You can use the Dataset name as shown in the example.

newDS

You can use the Destination as shown in the example.

A1 C5

You can use the Shift as shown in the example.

NONE

It copy your data to current place which already has data.

RIGHT

It will copy your data to current place by moving the existing data to the right.

DOWN

It will copy your data to current place by moving the existing data to the down.

Set cell style

Set cell style activity is used for formatting the style of a table cell in Google sheet. This activity changes the appearance of the cell so that the text becomes more readable.

*Google sheet name	The reference name of the google sheet which has already been opened or created is chosen in the dropdown.
Sheet name	A page or tab name within a spreadsheet. If not included, it defaults to the first page.
Range	The range of cells to be changed data is given.
Fill color	The background color of the cell is written as RGB values or the name of the color.
Font color	The text color is written as RGB values or the name of the color.
Bold	This checkbox provides changing the font thickness.
Italic	This checkbox provides italicization.
Underline	This checkbox provides underlining.
Font size	The font size is adjusted. The desired font number is written in this area.
Font name	The font type is written.
Wrap text?	Wrap text. Default is false.
Vertical alignment	Vertical alignment of the cells.
Horizontal alignment	Horizontal alignment of the cells.

_{Note: * Fields selected with are required, others are optional.}

You can use the Word name as shown in the example.

${newWord}

You can use the Range as shown in the example.

A1

A1:B5

You can use the Font color file name as shown in the example.

255,0,0 (Red)

255,255,0 (Yellow)

You can use the Font size as shown in the example.

9

You can use the Font name as shown in the example.

Arial

You can use the Vertical alignment as shown in the examples.

NONE

TOP

CENTER

BOTTOM

JUSTIFY

DISTRIBUTED

You can use the Horizontal alignment as shown in the examples.

NONE

GENERAL

LEFT

CENTER

RIGHT

FILL

JUSTIFY

CENTER_SELECTION

DISTRIBUTED

Close

Close activity is used for closing Google sheet after the operations are performed in the Google sheet

*Google sheet name	The reference name of the google sheet which has already been opened or created is chosen in the dropdown.
*Action	Specify the intended action.

_{Note: * Fields selected with are required, others are optional.}

You can use the Google Sheet name as shown in the example.

newGoogleSheet

You can use the Action as shown in the example.

CLOSE

.

Word

Word activities provide methods of retrieving, refreshing and adding data from word workbooks and worksheets.

Open

Open activity is used for opening an existing word file with doc or docx extension.

*Word name	The reference name is given to the word file which will open in this field.
Word file name	The file path is written.
Open Password	The password is entered to open or modify the encrypted file.

_{Note: * Fields selected with are required, others are optional.}

You can use the Word name as shown in the example.

robustaWord

You can use the Word file name as shown in the example.

C:RobustaTempRobusta.docx

You can use the Open Password as shown in the example.

1234

Create

Create activity is used for opening an existing Word file with doc or docx extension.

*Word name	The reference name is given to the word file which will create in this field.
Word file name	The file path is written.
Overwrite	This checkbox enables overwriting if there is a file or folder with the same name.

_{Note: * Fields selected with are required, others are optional.}

You can use the Word name as shown in the example.

robustaWord

You can use the Word file name as shown in the example.

C:RobustaTempRobusta.docx

If the “Overwrite” field’s checkbox status is:

True: If there is no file/folder with the same name in the relevant directory, a name change is made. If there is a file/folder with the same name in the relevant directory, the name is changed by overwriting the old file/folder.

False: If there is no file/folder with the same name in the relevant directory, a name change is made. If there is a file/folder with the same name in the relevant directory, the name is not changed. The function gets an error with the message There is folder already in the directory.

Save and close

Save and close activity is used for saving or closing the word file after the operations in the word file.

*Word name	The reference name of the word file which has already been opened or created is chosen in the dropdown.
*Action	The desired operation is selected. There are three options, Save, Close and Save and Close.
Word file name	The file path is written. Note: If a word file is desired to save as, write the name and path of the word file.

_{Note: * Fields selected with are required, others are optional.}

You can use the Word name as shown in the example.

${newWord}

You can use the Action as shown in the example.

SAVE

CLOSE

SAVE_AND_CLOSE

You can use the Word file name as shown in the example.

C:newWord.docx

If you want to save the word as a different word, the New word file name field must be filled.
If you want to perform both Save and Close operations, activity should be used twice.

Replace

Replace activity is used for replacing a specified text in a Word file with the desired text.

*Word name	The reference name of the word file which has already been opened or created is chosen in the dropdown.
*Old pattern	The old text that will be replaced is written.
*New pattern	The new text that will replace the old text is written.
New line position	It can provide adding a new line before, after, and both before and after the word that needs to be replaced.

_{Note: * Fields selected with are required, others are optional.}

You can use the Word name as shown in the example.

${newWord}

You can use the Old pattern as shown in the example.

Create

If you want to replace the word create in the word file with the new word, write create in this field.

#name#

$adress$

If you want to replace the $adress$ label in the word file with Maltepe/İstanbul, write $adress$ in this field.

You can use the New pattern as shown in the example.

New

If you want to replace the word create in the word file with the new word, write new in this field.

Maltepe/İstanbul

If you want to replace the $adress$ label in the word file with Maltepe/İstanbul, write Maltepe/İstanbul in this field.

You can use the New line position as shown in the example.

None	–
Before	A line is added before the replaced word.
After	A line is added after the replaced word.
Before_And_After	A line is added both before and after the replaced word.

Get text

Get text activity is used for importing all existing text in a Word file.

*Word name	The reference name of the word file which has already been opened or created is chosen in the dropdown.
*Result variable name	Used for assigning all the received data in the Word file to the variable. Note: The variable name to be given must not contain spaces.

_{Note: * Fields selected with are required, others are optional.}

You can use the Word name as shown in the example.

newWord

You can use the Result variable name as shown in the example.

getTextResult

Replace image

Replace image activity is used for replacing a specified image in a Word file with the desired image.

*Word name	The reference name of the word file which has already been opened or created is chosen in the dropdown.
*Source of image	Folder path of image.
Height of image	Height of image in pixels, default value is 450 pixels
Width of image	Width of image in pixels, default value is 450 pixels
Image text	Alt text of the image to be changed in Word document
Image no	The order of the image to be changed in the Word document

_{Note: * Fields selected with are required, others are optional.}

You can use the Word name as shown in the example.

${newWord}

You can use the Source of image as shown in the example.

C:\Temp\picture.jpeg

Read table to dataset

Read table to dataset activity is used for exporting the specified table in a Word file to the data.

*Word name	The reference name of the word file which has already been opened or created is chosen in the dropdown.
*New dataset name	The reference name is given to the dataset which will create in this field.
*Table index	The index of the table which will be read to the dataset is written.
Has header	If the dataset has column headings, true is selected.

_{Note: * Fields selected with are required, others are optional.}

You can use the Word name as shown in the example.

${newWord}

You can use the New dataset name as shown in the example.

newDS

You can use the Table name index as shown in the example.

1

Write dataset to word

Write dataset to word activity is used for writing changes made in dataset to the relevant table in Word file after completion of the changes.

*Word name	The reference name of the word file which has already been opened or created is chosen in the dropdown.
*Dataset name	The reference name of the dataset which has already been created is chosen in the dropdown.
*Table index	The index of the table which will be read to the dataset is written. Note: The index of the first table will be 0 since tables start from 0.
Include header	If there are column header in the resulting dataset, true is selected.

_{Note: * Fields selected with are required, others are optional.}

You can use the Word name as shown in the example.

${newWord}

You can use the New dataset name as shown in the example.

${newDS}

You can use the Table name index as shown in the example.

1

If there is no table in the Word document where the Dataset will be written, the error message “No table found at that index” will be encountered.
Therefore, there must be a table structure in the Word document where the dataset will be transferred.

Append paragraph

Append paragraph activity is used for adding text with a new paragraph into a Word file or adding text to the end or beginning of an existing paragraph.

*Word name	The reference name of the word file which has already been opened or created is chosen in the dropdown.
*Text	The text to be inserted into the paragraph with the position number is written. Note: If the position number is not given, it is added to the end.
Position	The position of the table to which will be added is written. Note: If -1 or null, the table is added to the end of the page, if 0, the table is added to the top of the page, otherwise, it is added after the indexed paragraph.

_{Note: * Fields selected with are required, others are optional.}

You can use the Word name as shown in the example.

${newWord}

You can use the Text as shown in the example.

To add text:

Hello World

To add a text from variable:

personelDataset

You can use the Position as shown in the example.

1

Append table

Append table activity is used for inserting tables in Word.

*Word name	The reference name of the word file which has already been opened or created is chosen in the dropdown.
Table position	The position of the table to which will be added is written. Note: If -1 or null, the table is added to the end of the page, if 0, the table is added to the top of the page, otherwise, it is added after the indexed paragraph.

_{Note: * Fields selected with are required, others are optional.}

You can use the Word name as shown in the example.

newWord

You can use the Position as shown in the example.

1

Merge cells

Merge cells activity is used for merging cells in word.

*Word name	The reference name of the word file which has already been opened or created is chosen in the dropdown.
*Table Index	Index of the table which will be merged cells is written (starts form 1).
*Range	Table cell range to merge is written (from A to Z are column indexes, from 1 to ∞ are row indexes).
With all data	If the checkbox is selected, all data in the merged cells are written to the merged field. Otherwise, only the data in the first cell is written.

_{Note: * Fields selected with are required, others are optional.}

You can use the Word name as shown in the example.

${newWord}

You can use the Table Index as shown in the example.

4 1

You can use the Range as shown in the example.

A1:C5

If the “With all data” checkbox status is:

True: All data in the merged cells is written to the merged field.

False: Only the data in the first cell is written.

Save as pdf

Save as pdf activity is used for saving Word file as PDF.

*Word name	The reference name of the word file which has already been opened or created is chosen in the dropdown.
*Pdf file name	The file path is written.

_{Note: * Fields selected with are required, others are optional.}

You can use the Word name as shown in the example.

newWord

You can use the Pdf file name as shown in the example.

C:Robustanew.pdf

Append image

Append image activity can add different sizes of images to word files.

*Word name	The reference name of the word file which has already been opened or created is chosen in the dropdown.
*Source of image	Folder path of image.
Height of image	Height of image in pixels. Default value is 450 pixels
Width of image	Width of image in pixels. Default value is 450 pixels
Image position	Position of the image to which to be added. If -1 or null, image is added to the end of the page. if zero, image is added to top of the page. Otherwise added after indexed paragraph.

_{Note: * Fields selected with are required, others are optional.}

You can use the Word name as shown in the example.

newWord

You can use the Source of image as shown in the example.

C:Temppicture.jpeg

You can use the Height of image as shown in the example.

600

You can use the Width of image as shown in the example.

400

Set cell style

Set cell style activity is used for formatting the style of a table cell in Microsoft Word. This activity changes the appearance of the cell so that the text becomes more readable.

*Word name	The reference name is given to the word file which will open in this field.
*Table index	Index of the table which will be readed to dataset / written to file or which will be merged (starts from 1)
Range	The range of cells to be changed data is given.
Fill color	The background color of the cell is written as RGB values or the name of the color.
Font color	The text color is written as RGB values or the name of the color.
Bold	This checkbox provides changing the font thickness.
Italic	This checkbox provides italicization.
Underline	This checkbox provides underlining.
Font size	The font size is adjusted. The desired font number is written in this area.
Font name	The font type is written.
Has border?	Whether borders (Frame) will be present or not is selected.
Border style	The border style that will be applied is selected.
Border position?	The position of the border that will be applied is selected.
Border color	The border color of the cells is is written as RGB values or the name of the color.
Vertical alignment	Vertical alignment of the cells.
Horizontal alignment	Horizontal alignment of the cells.
Is hyperlink?	This checkbox provides converting text to hyperlink.
Url	This checkbox provides url value to be converted to hyperlink.

_{Note: * Fields selected with are required, others are optional.}

You can use the Word name as shown in the example.

${newWord}

You can use the Table index as shown in the example.

3

You can use the Range as shown in the example.

A1

A1:B5

You can use the Font color file name as shown in the example.

255,0,0 (Red)

255,255,0 (Yellow)

You can use the Font size as shown in the example.

9

You can use the Font name as shown in the example.

Arial

You can use the Border style as shown in the examples.

NONE

THIN

MEDIUM

DASHED

DOTTED

THICK

DOUBLE

You can use the Border position as shown in the examples.

ALL

NONE

TOP

BOTTOM

LEFT

RIGHT

You can use the Border color as shown in the examples.

yellow

255,56,180

You can use the Vertical alignment as shown in the examples.

NONE

TOP

CENTER

BOTTOM

JUSTIFY

DISTRIBUTED

You can use the Horizontal alignment as shown in the examples.

NONE

GENERAL

LEFT

CENTER

RIGHT

FILL

JUSTIFY

CENTER_SELECTION

DISTRIBUTED

Text File

Text File activities refer to the automation of tasks such as creating, opening, retrieving and writing data to a file.

Open

Open activity is used for opening the existing text file.

*Text name	The reference name is given to the text file file which will open in this field.
*Text file name	The file path is written.
*Has header	It is indicated whether the first line of the text document to be opened is a title or not.
Delimeter	If the type is selected CSV, the separator character in the text document that will be opened is written to split rows into columns.
*Type	The type of text document that will be opened from the dropdown is chosen.
Encoding	The character encoding that can be used is chosen from the dropdown.

_{Note: * Fields selected with are required, others are optional.}

You can use the Text name as shown in the example.

newText

You can use the Text file name as shown in the example.

C:tempnotes.txt

You can use the Delimeter as shown in the example.

name; surname; age; “;”

You can use the Type as shown in the examples.

CSV_Default

CSV_Excel

CSV_InformixUnload

CSV_MySQL

CSV_Oracle

CSV_PostgreSQLCsv

CSV_PostgreSQLText

CSV_RFC4180

CSV_TDF

Text

You can use the Encoding as shown in the examples.

UTF-8

UTF-16

ISO-8859-1

ISO-8859-9

Cp1252

Cp1254

US-ASCII

Create

Create activity is used for creating a new text file.

*Text name	The reference name is given to the text file which will create in this field.
*Text file name	The file path is written.
*Type	The type of text document to be opened from the dropdown is chosen.
*Has header	It is indicated whether the first line of the text document to be opened is a title or not.
Delimeter	The separator character in the text document to be opened is written.
Encoding	The character encoding that can be used is chosen from the dropdown.
Overwrite	This checkbox enables overwriting if there is a file or folder with the same name.

_{Note: * Fields selected with are required, others are optional.}

You can use the Text name as shown in the example.

newText

You can use the Text file name as shown in the example.

C:tempnotes.txt

You can use the Type as shown in the examples.

CSV_Default

CSV_Excel

CSV_InformixUnload

CSV_MySQL

CSV_Oracle

CSV_PostgreSQLCsv

CSV_PostgreSQLText

CSV_RFC4180

CSV_TDF

Text

You can use the Delimeter as shown in the example.

name; surname; age; “;”

You can use the Encoding as shown in the examples.

UTF-8

UTF-16

ISO-8859-1

ISO-8859-9

Cp1252

Cp1254

US-ASCII

ANSI

If the “Overwrite” field’s checkbox status is:

True: If there is no file/folder with the same name in the relevant directory, a name change is made. If there is a file/folder with the same name in the relevant directory, the name is changed by overwriting the old file/folder.

False: If there is no file/folder with the same name in the relevant directory, a name change is made. If there is a file/folder with the same name in the relevant directory, the name is not changed. The function gets an error with the message There is folder already in the directory.

The Create file activity under File Operations can also be used to create files with .txt and .csv extensions.

Save and close

Save and close activity is used for saving or closing the text file after the operations in the text file.

*Text name	The reference name of the text file which has already been opened or created is chosen in the dropdown.
Action	The desired operation is selected. There are three options, Save, Close and Save and Close.
*File name	The file path is written. Note: If a word file is desired to save as, write the name and path of the word file.

_{Note: * Fields selected with are required, others are optional.}

You can use the Text name as shown in the example.

${newText}

You can use the Action as shown in the example.

SAVE

CLOSE

SAVE_AND_CLOSE

You can use the File name as shown in the example.

C:tempnotes.txt

Export text

Export text activity is used for creating columns in the dataset by separating the data in the text file according to the specified range.

*Text name	The reference name of the text file which has already been opened or created is chosen in the dropdown.
Headers	Header names for the dataset is written.
*Value ranges	Value start and end indexes for each column of the dataset are written.
Trim	It provides trimming whitespace characters from the beginning and end of the values.
*New dataset name	The reference name is given to the dataset which will create in this field.

_{Note: * Fields selected with are required, others are optional.}

You can use the Text name as shown in the example.

newText

You can use the Headers as shown in the example.

adı,soyadı

You can use the Value ranges as shown in the example.

0-12,13-25

You can use the New dataset name as shown in the examples.

newDS

Read textfile to dataset

Read text file to dataset activity is used for converting the file to be processed into a dataset.

*Text name	The reference name of the text file which has already been opened or created is chosen in the dropdown.
*New dataset name	The reference name is given to the dataset which will create in this field.

_{Note: * Fields selected with are required, others are optional.}

You can use the Text name as shown in the example.

newText

You can use the New dataset name as shown in the example.

newDS

After the data in the file is read, the name of the data set in which the data is written manually. The name written is the name that will be selected in the “Dataset name” field while using the data set in the next functions.

Write dataset to textfile

Write dataset to textfile activity is used for writing the changes to the relevant file after the operations related to the dataset are completed.

*Text name	The reference name of the text file which has already been opened or created is chosen in the dropdown.
*Dataset name	The reference name of the dataset which has already been created is chosen in the dropdown.
Append	If the append checkbox is checked, data will be appended to the end of the file. If it is not checked and the text file is empty, the data is written to the text file. If the text file includes the data, the old data is deleted to add the new data.

_{Note: * Fields selected with are required, others are optional.}

You can use the Text name as shown in the example.

newText

You can use the New dataset name as shown in the example.

newDS

Write to textfile

Write to textfile activity is used for writing text to textfile.

*Text file name	The file path is written.
*Text	The text to be added is written.
Append	If the append checkbox is checked, data will be appended to the end of the file. If it is not checked and the text file is empty, the data is written to the text file. If the text file includes the data, the old data is deleted to add the new data.

_{Note: * Fields selected with are required, others are optional.}

You can use the Text file name as shown in the example.

C:TempmyFile.txt

You can use the Text as shown in the example.

Hello

Read textfile to variable

Read textfile to dataset activity is used for assigning file to be processed to a variable.

*Text name	The reference name of the text file which has already been opened or created is chosen in the dropdown.
*Result variable name	A variable name that will be created is written.

_{Note: * Fields selected with are required, others are optional.}

You can use the Text name as shown in the example.

newText

You can use the Result variable name as shown in the example.

newVariable

File Operations

File activities refer to the automation of the tasks you perform with the files and folders on your computer, such as creating, copying or renaming files and folders.

Create file

Create file activity is used for creating a new file.

*File name	The file path is written.
Overwrite	This checkbox enables overwriting if there is a file or folder with the same name.

_{Note: * Fields selected with are required, others are optional.}

You can use the file name as shown in the example.

C:Test.txt

C:Deneme.csv

If the “Overwrite” checkbox status is:

True: If there is no file/folder with the same name in the relevant directory, a name change is made. If there is a file/folder with the same name in the relevant directory, the name is changed by overwriting the old file/folder.

False: If there is no file/folder with the same name in the relevant directory, a name change is made. If there is a file/folder with the same name in the relevant directory, the name is not changed. The function gets an error with the message There is folder already in the directory.

The Create text file activity under Text file can also be used to create .txt and .csv files.

Create directory

Create directory is used for creating directory.

*Directory name	The directory name is written
Create all directories	If there is no any intermediate directory in the given file path, it creates it sequentially according to the given path until the last directory. Example: C:\Temp\a\b\c And a not exists, if its true it creates a,b and c directories.

_{Note: * Fields selected with are required, others are optional.}

C:TempDenemeNewDirectory

Copy

Copy activity is used for copying file or folder.

*File name	The file name or the folder name with path.
*Destination path	The destination directory for the copied files or folders is written.
Overwrite	This checkbox enables overwriting if there is a file or folder with the same name.

_{Note: * Fields selected with are required, others are optional.}

You can use the folder path as shown in the example.

C:TempTest

You can use the file path as shown in the example.

Full name for specific file:

C:TempTest.xlsx

Files that start with the initial letter a in the folder and have an extension .txt are processed in batches:

C:Tempa*.txt

All files in the folder with extension .xlsx are processed in batch:

C:Temp*.xlsx

All files in the folder will be processed in batch:

C:Temp*.*

All files/folders in the folder will be processed collectively:

C:Temp*

You can use the Destination path as shown in the example.

If you want to copy the folder with the same name to the “Test” folder only:

C:Test

If you want to change the name to “Trial” while copying the folder under the “Test” folder:

C:TestTrial

If simultaneous Rename will not be done in the copying process, make sure that the directory has “” at the end while giving the “Destination path”.

You can use the Destination path as shown in the example.

If you want to copy the file to the “Test” folder with the same name:

C:Test

If you want to change the name to “newFile.xlsx” while copying the file under “Test” folder:

C:TestnewFile.xlsx

If the destination path ends with a file separator (With a slash), the file or folder is located in that path:

C:TempmyFolder

Otherwise, if the destination path has the file or folder name at the end, action will be taken with renaming support:

C:TempmyFolderfileWithNewName.txt

If you use unzip, add folder name:

C:TempmyFolderfolderName

If the “Overwrite” checkbox status is:

True: If there is no file/folder with the same name in the relevant directory, the copy will be done. If there is a file/folder with the same name in the relevant directory, the old file/folder is overwritten and copied.

False: If there is no file/folder with the same name in the relevant directory, the copy will be done. If there is a file/folder with the same name in the relevant directory, it will not be copied. The function gets an error with the message that there is a file/folder already in the directory.

Delete

Delete activity is used for deleting file or folder. File or folder that Delete activity delete cannot be recovered and cannot be found in the Recycle Bin.

*File name

The file name or the folder name with path.

_{Note: * Fields selected with are required, others are optional.}

You can use the folder path as shown in the example.

C:TempTest

All files/folders in the folder will be processed collectively:

C:Temp*

You can use the file path as shown in the example.

Full name for specific file:

C:TempTest.xlsx

Files that start with the initial letter a in the folder and have an extension .txt are processed in batches:

C:Tempa*.txt

All files in the folder with extension .xlsx are processed in batch:

C:Temp*.xlsx

All files in the folder will be processed in batch:

C:Temp*.*

All files/folders in the folder will be processed collectively:

C:Temp*

Move

Move activity is used for moving files and folders to the desired directory.

*File name	The file name or the folder name with path.
*Destination path	The destination directory for the copied files or folders is written.
Overwrite	This checkbox enables overwriting if there is a file or folder with the same name.

_{Note: * Fields selected with are required, others are optional.}

You can use the folder path as shown in the example.

C:TempTest

You can use the file path as shown in the example.

Full name for specific file:

C:TempTest.xlsx

Files that start with the initial letter a in the folder and have an extension .txt are processed in batches:

C:Tempa*.txt

All files in the folder with extension .xlsx are processed in batch:

C:Temp*.xlsx

All files in the folder will be processed in batch:

C:Temp*.*

All files/folders in the folder will be processed collectively:

C:Temp*

You can use the Destination path as shown in the example.

If you want to copy the folder with the same name to the “Test” folder only:

C:Test

If you want to change the name to “Trial” while copying the folder under the “Test” folder.

C:TestTrial

You can use the Destination path as shown in the example.

If you want to copy the file to the “Test” folder with the same name:

C:Test

If you want to change the name to “newFile.xlsx” while copying the file under “Test” folder:

C:TestnewFile.xlsx

If the destination path ends with a file separator (With a slash), the file or folder is located in that path:

C:TempmyFolder

Otherwise, if the destination path has the file or folder name at the end, action will be taken with renaming support:

C:TempmyFolderfileWithNewName.txt

If you use unzip, add folder name:

C:TempmyFolderfolderName

If the “Overwrite” checkbox status is:

True: If there is no file/folder with the same name in the relevant directory, the move is performed. If there is a file/folder with the same name in the relevant directory, the old file/folder is overwritten and moved.

False: If there is no file/folder with the same name in the relevant directory, the move is performed. If there is a file/folder with the same name in the relevant directory, the move will not be performed. The function gets an error with the message that there is file/folder already in the directory.

Rename

Rename activity is used for changing file or folder name.

*File name	The file name or the folder name with path.
*New file name	The new file name without path is written.
Overwrite	This checkbox enables overwriting if there is a file or folder with the same name.

_{Note: * Fields selected with are required, others are optional.}

You can use the file path as shown in the example.

Full name for specific file C:TempTest.xlsx

You can use the folder path as shown in the example.

C:TempTest

You can use the New file name for file as shown in the example.

newFile.xlsx

You can use the New file name for folder as shown in the example.

NewFile

The extension of the file can also be changed. The file C:test.txt can be done as C:test.csv Changing the name can be done simultaneously while changing the extension.

If the “Overwrite” checkbox status is:

True: If there is no file/folder with the same name in the relevant directory, a name change is made. If there is a file/folder with the same name in the relevant directory, the name is changed by overwriting the old file/folder.

False: If there is no file/folder with the same name in the relevant directory, a name change is made. If there is a file/folder with the same name in the relevant directory, the name is not changed. The function gets an error with the message There is folder already in the directory.

Zip

Zip activity is used to converting file to compressed format.

*File name	The file name or the folder name with path.
*Zip File Name	The zip file name or folder name with path.
Overwrite	This checkbox enables overwriting if there is a file or folder with the same name.
Password	If there is a password for compressed file, its password must be entered here.

_{Note: * Fields selected with are required, others are optional.}

You can use the file path as shown in the example.

Full name for specific file:

C:TempTest.xlsx

Files that start with the initial letter a in the folder and have an extension .txt are processed in batches:

C:Tempa*.txt

All files in the folder with extension .xlsx are processed in batch:

C:Temp*.xlsx

All files in the folder will be processed in batch:

C:Temp*.*

All files/folders in the folder will be processed collectively:

C:Temp*

You can use the Zip file name as shown in the example.

C:Tempdeneme.zip

Accepts all the following characters for encryption.

türkçeğüışçöÇÖİŞĞÜé!’^+#$%&{()=}-_;`~¨´.₺€@+-[]

The name of the compressed file (The name of the file can be changed) and the format as .zip should be written to give the desired full directory.

If the “Overwrite” checkbox status is:

True: If there is no file with the same name in the relevant directory, compression is performed. If there is a file with the same name in the relevant directory, the old file is overwritten and compressed.

False: If there is no file with the same name in the relevant directory, compression is performed. If there is a file with the same name in the relevant directory, decompression is not performed. The function gets an error with the message File already exists in directory.

Unzip

Unzip activity is used for unziping file in compressed format.

*File name	The zip file name or the folder name with path.
*Destination path	Specifies the destination directory of the zip file to be opened.
Overwrite	This checkbox enables overwriting if there is a file or folder with the same name.
Password	If there is a password for compressed file, its password must be entered here.

_{Note: * Fields selected with are required, others are optional.}

You can use the File name as shown in the example.

C:TempTest.zip

You can use the Destination path as shown in the example.

C:TempTest

C:TempTest2

You can use the Password as shown in the example.

password

When the compressed file is being converted to a wide format, a new name cannot be given, it comes to the expanded format with that name, whatever the original name of the file is.

If destination path end with a file separator (with a slash) then the file or folder will be located in that path. Otherwise, if destination path has the file or folder name at the end, action will be taken with renaming support.

If the “Overwrite” checkbox status is:

True: If there is no file with the same name in the relevant directory, it is opened. If there is a file with the same name in the relevant directory, the old file is overwritten and opened.

False: If there is no file with the same name in the relevant directory, it is opened. If there is a file with the same name in the relevant directory, it will not be opened. The function gets an error with the message File already exists in directory.

List files

List files activity is used for listing file/folder names in folder.

*Directory name	The file name or the folder name with path.
*Dataset name	The reference name is given to the dataset which will create in this field.

_{Note: * Fields selected with are required, others are optional.}

You can use the Directory name as shown in the example.

C:TempTest

You can use the Dataset name as shown in the example.

Dataset transferred file and folder names form 5 columns.
Folder/file full directory in column A:

C:Tempdeneme or C:Temptest.xlsx

Folder/file name in column B:

test or text.xlsx

If the folder name is taken in the C column, it is written as “Directory”, if the file name is taken, it is written as “File”.

The resulting dataset appears as follows when excelling Excel. Without excel, the rows of the list in the data set can be taken in the loop.

Get file attributes

Get file attributes are used for assigning a file’s properties such as size, creation date, etc. to a variable.

*File name	The file name or the folder name with path.
Attribute name	Returns the type of information to be retrieved from the file.
*Result variable name	A variable name that will be created is written.

_{Note: * Fields selected with are required, others are optional.}

You can use the File name as shown in the example.

C:Test.txt

You can use the Attribute name as shown in the example.

Date of creation:

CREATION_TIME

Last login date:

LAST_ACCESS_TIME

Last modified time

LAST_MODIFIED_TIME

Size:

SIZE

Whether it is a confidential document:

HIDDEN

Whether the change is on:

READONLY

You can use the Result variable name as shown in the example.

denemeSonuc

Find in textfiles

Find in textfiles is used for searching in all .txt, csv, doc, and docx files or in one file with .txt, csv, doc, and docx extensions. If the files include searched text, the file names are written to the dataset.

*Directory name	The file name or directory name to be searched is written.
*File type	The file type to search in is chosen in the dropdown.
*Search	The text to search is written.
*Dataset name	The reference name is given to the dataset which will create in this field.

_{Note: * Fields selected with are required, others are optional.}

You can use the Directory name as shown in the example

C:Robusta

You can use the File type as shown in the example.

txt

You can use the Search as shown in the example.

Robusta

You can use the Dataset name as shown in the example.

searchResult

File exists

File exists activity is used for giving the information that the file exists or does not exist in the given directory. The result is returned as True or False.

*File name	The file path or directory is written.
*Result variable name:	A variable name that will be created is written.
Retry Count	The number of attempts is written, can be any numeric value. Default value is 1.

_{Note: * Fields selected with are required, others are optional.}

You can use the folder path as shown in the example.

C:TempTest

You can use the file path as shown in the example.

Full name for specific file:

C:TempTest.xlsx

Files that start with the initial letter a in the folder and have an extension .txt are processed in batches:

C:Tempa*.txt

All files in the folder with extension .xlsx are processed in batch:

C:Temp*.xlsx

All files in the folder will be processed in batch:

C:Temp*.*

All files/folders in the folder will be processed collectively:

C:Temp*

You can use the Result variable name as shown in the example.

existResult

You can use the Retry Count as shown in the examples.

7

Export from tiff

Export from tiff activity exports images in tiff extension files containing multiple images.

*Tiff file name	The file path is written.
*Output path	The path to the folder where the output is to be sent is written.
Image type	The type of image to be used is chosen in the dropdown.

_{Note: * Fields selected with are required, others are optional.}

You can use the Tiff file path as shown in the example.

C:TempmyFile.tiff

You can use the Output path as shown in the example.

C:Temp

PNG

JPG

JPEG

TIFF

BMP

GIF

Pdf

Pdf activities include designed to extract data from pdf files and store them in string variables.

Open

Open activity is used to open an existing pdf file.

Pdf name*	The reference name is given to the PDF file which will open in this field.
*Pdf file name	The file path is written.
Password	If there is a password in the PDF file, the password is written. Otherwise, no need to be used.

_{Note: * Fields selected with are required, others are optional.}

You can use the Pdf name as shown in the example.

robustaPdf

You can use the Pdf file name as shown in the example.

C:Robustarobusta.pdf

Export as image

Export as images activity is used for exporting PDF file to files with .png, .jpeg, .tiff, .bmp, .gif extensions.

*Pdf name	The reference name is given to the PDF file which will open in this field.
Start Page	The starting page number of PDF file is written.
End Page	The last page number of PDF file is written.
*Output Path	The directory of the picture that will be created is written. Note: Creates an image file with the same name and specified page number as the PDF.
*DPI	The resolution of the picture is written. The default value of the picture is 144 dpi.
*Image Type	The format of the picture to be transferred is chosen in the dropdown. The default format of the picture is PNG.

_{Note: * Fields selected with are required, others are optional.}

You can use the pdf reference name as shown in the example.

${RobustaPdf}

You can use the start page as shown in the example.

1

You can use the End page as shown in the example.

3

You can use the Output path as shown in the examples.

C:Robusta

The files are named as follows.

robusta_page_1.png

robusta_page_2.png

robusta_page_3.png

You can use the DPI path as shown in the example.

300

You can use the Image type as shown in the examples.

png

jpeg

jpg

tiff

bmp

gif

Export images

Export images activity enables the images contained in PDF file to be exported to a specified directory in .png format.

*Pdf name	The reference name is given to the PDF file which will open in this field.
Start Page	The starting page number of the PDF file is written.
End Page	The last page number of the PDF file is written.
*Output Path	The directory of the picture that will be created is written. Note: Creates an image file with the same name and specified page number as the PDF.

_{Note: * Fields selected with are required, others are optional.}

You can use the pdf reference name as shown in the example.

${RobustaPdf}

You can use the start page as shown in the example.

1

You can use the End page as shown in the example.

3

You can use the Output path as shown in the examples.

C:Robusta

The files are named as follows.

robusta_page_1.png

robusta_page_2.png

Convert tables to HTML

Convert tables to HTML activity allows PDF tables to be converted to HTML format.

*Pdf name	The reference name is given to the PDF file which will open in this field.
*Table Type	The table structure to be converted is chosen in the dropdown.
Start Page	The starting page number of the PDF file is written.
End Page	The last page number of the PDF file is written.
Maximum font size	Maximum font size is written.
Ignore line count	The number of lines that will not be written to the html output, from the beginning of the start page is written.
*Output Path	The directory of the HTML file that will be created is written.

_{Note: * Fields selected with are required, others are optional.}

You can use the pdf reference name as shown in the example.

${RobustaPdf}

You can use the Table type as shown in the example.

BASIC : Used for simple tables.

COMPLEX : Used for different and complex table structures.

STRIPLESS : Used for pdfs with table structure but no table lines.

Note : Strikethrough lines may occur when the “BASIC” feature is selected. If this situation is not desired, the table type should be changed to “COMPLEX”.

You can use the start page as shown in the example.

1

You can use the End page as shown in the example.

1

You can use the Output path as shown in the examples.

C:Robusta

robusta.html

Read text

Read text activity allows all records in the PDF file to be received as text.

*Pdf name	The reference name is given to the PDF file which will open in this field.
Start page	The starting page number of PDF file is written.
End page	The last page number of PDF file is written.
Result variable name*	A variable name that will be created is written.
X-coordinate	The pixel value of the X-coordinate of the area to be read on the pdf is written. Note: If it is desired to limit the area in the PDF file, this field must be used with a Y-coordinate, Height, and Width.
Y-coordinate	The pixel value of the Y-coordinate of the area to be read on the pdf is written. Note: If it is desired to limit the area in the PDF file, this field must be used with a X-coordinate, Height, and Width.
Height	The pixel value of the Height of the area to be read on the pdf is written. Note: If it is desired to limit the area in the PDF file, this field must be used with a X-coordinate, Y-coordinate, and Width.
Width	The pixel value of the Width of the area to be read on the pdf is written. Note: If it is desired to limit the area in the PDF file, this field must be used with a X-coordinate, Y-coordinate, and Height.

_{Note: * Fields selected with are required, others are optional.}

You can use the Pdf name as shown in the example.

${RobustaPdf}

You can use the start page as shown in the example.

1

You can use the End page as shown in the example.

3

You can use the Result text name as shown in the example.

readRobustaPdf

120

250

50

100

Merge pdf

Merge pdf activity allows merging of pdf files.

*Pdf file name	The file path of the first PDF file is written.
Password	It is used if there is a password in the first PDF file to be processed. Otherwise, it is not mandatory to use.
*File name 2	The file path of the second PDF file is written.
Password 2	It is used if there is a password in the second PDF file to be processed. Otherwise, it is not mandatory to use.
*New file name	The new file name is written.

_{Note: * Fields selected with are required, others are optional.}

You can use the Pdf file name as shown in the example.

C:RobustarobustaStarter.pdf

You can use the Password as shown in the example.

123456!

You can use the File name 2 as shown in the example.

C:RobustarobustaConfulence.pdf

You can use the Password 2 as shown in the example.

987654!

You can use the New file name as shown in the example.

C:RobustarobustaMerge.pdf

Extract attachment

Extract attachment activity allows the attachments in a PDF file to be exported to a specified directory.

Pdf File name*	The resource file name is written.
Password	It is used if there is a password in the PDF file to be processed. Otherwise, it is not mandatory to use.
*Attach file path	The output attachment directory is written.

_{Note: * Fields selected with are required, others are optional.}

You can use the Pdf file name as shown in the example.

C:RobustarobustaStarter.pdf

You can use the Password as shown in the example.

123456!

You can use the Attach file path as shown in the example.

C:Robusta

Split pdf

Split pdf activity allows splitting of pdf files.

*Pdf file name	The file path of the first PDF file is written.
Password	It is used if there is a password in the first PDF file to be processed. Otherwise, it is not mandatory to use.
Start page	Start page. Type: Integer
End page	End page. Type: Integer
*New file name	The new file name is written.

_{Note: * Fields selected with are required, others are optional.}

You can use the Pdf file name as shown in the example.

C:RobustarobustaStarter.pdf

You can use the Password as shown in the example.

123456!

You can use the New file name as shown in the example.

C:RobustarobustaMerge.pdf

Dataset

Dataset activities provide methods for creating, extracting, and adding data to a dataset.

Create

Create activity allows creating the new dataset.

*New dataset name

Reference name of dataset which will be created.

_{Note: * Fields selected with are required, others are optional.}

You can use the New dataset name as shown in the example.

newDS

It is not possible to write any data when row and column are not added to a newly created dataset.
This is done with the “Add row” and “Add Column” activities.

Get action

Get action activity allows to retrieve data from a cell in the dataset.

*Dataset name	Reference name of dataset.
*Row	Row index.
*Columns	Column name or column index.
*Result variable name	Variable name of the return value.

_{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the example.

newDS

You can use the Row name as shown in the example.

Row value starts at 0.

0

You can use the Column name as shown in the examples.

Column value starts at 0.

0

Name

You can use the Result variable name as shown in the example.

getNameResult

Set action

Set action activity allows writing data to a cell in the dataset.

*Dataset name	Reference name of dataset.
*Column	Column name or column index.
Row	Row index.
*Value	It refers to the value required to be written to the data set to be processed.
*Type	Type of the value to set.

_{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the example.

newDS

You can use the Column name as shown in the examples.

Column value starts at 0.

0

Name

0:3

You can use the Row name as shown in the examples.

Row value starts at 0.

0

You can use the Value name as shown in the examples.

Robusta

${Name}

You can use the Type as shown in the example.

STRING

INTEGER

DOUBLE

DATE

BOOLEAN

Get size

Get size activity gives the result of the number of rows in a dataset.

*Dataset name	Reference name of dataset.
Size type	The operation to be counted in the dataset is selected.
*Result variable name	Variable name of the return value.

_{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the example.

newDS

You can use the Size type as shown in the examples.

Row

Column

You can use the Result variable name as shown in the example.

sizeResult

Set header

Set header activity allows the column to be changed/added in the dataset to be named as a column header.

*Dataset name	Reference name of dataset.
*Column	Column name or column index.
*New header	New header for the selected column.

_{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the example.

newDS

You can use the Column as shown in the examples.

0

Name

You can use the New header as shown in the example.

Comany Name

Add column

Add column activity is used to add columns within a dataset.

*Dataset name	Reference name of dataset.
*Column name	Name of the column to be added. If null, adds row to the end.
Column index	The order of the column to be added.
Result variable name	Variable name of the return value.

_{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the example.

newDS

You can use the Column name as shown in the examples.

0

Name

Name,Surname

You can use the Column index as shown in the examples.

The column number starts from 0. If left blank, a column is added to the last column in the dataset.

If it is desired to add a column to the last column in the dataset, the new column index field should be left blank.

If a column is wanted to be added to an empty dataset (Dataset), 0 should be given as an index. Otherwise, a new column cannot be created.

If multiple columns are added (comma-separated entry in the ‘Column name’ field), the value corresponding to the number of columns added should be given in this field. Example: If 3 columns are added, “4:6” should be given.

10:12

0

You can use the Result variable name as shown in the example.

resultVariable

Remove column

Remove column activity is used to delete a column from a dataset.

*Dataset name	Reference name of dataset.
*Column	Column name or column index.

_{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the example.

newDS

You can use the Column as shown in the examples.

0

Name

A:C

0:4

Add row

Add row activity is used to add columns within a dataset.

*Dataset name	Reference name of dataset.
Row	Column name or column index.
Result variable name	Variable name of the return name.

_{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the example.

newDS

You can use the Row as shown in the example.

The row number starts from 0. If left blank, a row is added to the last column in the dataset.

0

You can use the Result variable name as shown in the example.

resultVariable

Remove row

Remove row activity is used to delete a row from a dataset.

*Dataset name	Reference name of dataset.
*Row	Row index.
Remove by filter	If the rows will be removed according to a filter expression, then this parameter should be set true.

_{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the example.

newDS

You can use the Row as shown in the example.

0

Get row as json

Get row as json activity allows to create a variable in JSON format of a row in the dataset.

*Dataset name	Reference name of dataset.
*Row	Row index.
Result variable name	Variable name of the return value.

_{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the example.

newDS

You can use the Row as shown in the example.

0

You can use the Result variable name as shown in the example.

getJSON

Get rows as json

Get rows as json activity allows creating a variable in JSON format of a rows in the dataset.

*Dataset name	Reference name of dataset.
*Rows	Rows index.
Result variable name	Variable name of the return value.

_{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the example.

newDS

You can use the Row as shown in the example.

0:3

You can use the Result variable name as shown in the example.

getJSON

Sort

Sort activity is used to sort a dataset.

*Dataset name	Reference name of dataset.
*Sort	Sort expression.

_{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the example.

newDS

You can use the Sort as shown in the examples.

“columnName” asc

“columnName” desc

Filter

Filter activity is used to filter within a dataset.

*Dataset name	Reference name of dataset.
*Filter	Filter expression.
*New dataset name	It is named by creating a new dataset containing filtered data.

_{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the example.

newDS

You can use the Filter as shown in the examples.

$”ad”=”ilhan” and $”Numara”=5

$”ad” begins with “il” or $”Numara”=7

$”ad” contains “han”

$”SIRKET”=”Robusta”

$”${columnName}”=”Robusta”

$”mail”=”${mailAdresi}”

$”A”=”Robusta”

“Important Note: Applicable when ‘has header’ is selected as false in the ‘Read Excel to Dataset’ activity.”

=

!=

<

<=

begins with, ends with, contains, does not contain, and, or

(

)

You can use the New dataset name as shown in the example.

newFilteredDS

Remove blanks

Remove blanks activity creates a new dataset (Dataset) by removing the empty rows in the dataset.

*Dataset name	Reference name of dataset.
*New dataset name	Reference name of the dataset which will be created.

_{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the example.

newDS

You can use the New dataset name as shown in the example.

removeBlanksDS

Remove duplicates

Remove duplicates activity transforms the repetitive data in a dataset into singular.

*Dataset name	Reference name of dataset.
*New dataset name	Reference name of the dataset which will be created.

_{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the example.

newDS

You can use the New dataset name as shown in the example.

removeDupDS

Merge

Merge activity allows combining two datasets. It allows writing the second data set after the first data set. It allows merging of two data sets without having to have the same pattern. In other words, while there are 3 columns in the first data set, while the second data set has 4 columns, it combines these two data sets.

*Dataset name	Reference name of dataset which will be used for operations.
*Dataset name 2	Reference name of the 2nd dataset selected for processing.
Merge type	Combines two datasets in two different ways: Vertical and Horizontal.
*New dataset name	Reference name of dataset which will be created.

_{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the example.

newDS

You can use the Dataset name 2 as shown in the example.

newDS2

You can use the Merge type as shown in the examples.

Vertical

Horizontal

You can use the New dataset name as shown in the example.

mergeDS

Join

Join activity allows two datasets to be joined by referencing the selected columns.

*Dataset name	Name of dataset which will be used for operations.
*Dataset name 2	Name of the 2nd dataset selected for processing.
*Source reference	Source column name reference in which the dataset will be joined.
*Destination reference	Destination column name reference in which the dataset will be joined.
*New dataset name	Name of dataset which will be created.

_{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the example.

dataset1

You can use the Dataset name 2 as shown in the example.

dataset2

You can use the Source reference as shown in the examples.

Id

You can use the Destination reference as shown in the examples.

Plaka

You can use the New dataset name as shown in the example.

newDS

Depending on the size of the datasets and the order in which they are processed, different results will be obtained.

Input
Source Dataset
Source reference : Id

Input
Destination Dataset
Destination reference : Plaka

Input
Source Dataset
Source reference : Plaka

Input
Destination Dataset
Destination reference : Id

Minus

Minus activity gives the difference between the two datasets. It gives the result of data that is in the first dataset and not in the second dataset. Two data sets must be in the same pattern in order to get the correct result. In other words, both datasets must have the same columns. It works by providing control in the second data set for all data included in the first dataset.

*Dataset name	Reference name of dataset which will be used for operations.
*Dataset name 2	Reference name of the 2nd dataset selected for processing.
*New dataset name	Reference name of dataset which will be created.

_{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the example.

${newDS}

You can use the Dataset name 2 as shown in the example.

newDS2

You can use the New dataset name as shown in the example.

minusDS

Union

Union activity allows finding the combination set of two datasets. Unlike the Merge activity, the Union activity takes the data that exists in both combination sets into a combination set as a single data. The two datasets must have the same pattern.

*Dataset name	Reference name of dataset which will be used for operations.
*Dataset name 2	Reference name of the 2nd dataset selected for processing.
*New dataset name	Reference name of dataset which will be created.

_{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the example.

newDS

You can use the Dataset name 2 as shown in the example.

newDS2

You can use the New dataset name as shown in the example.

unionDS

Intersection

Intersection activity allows to find the intersection set of two datasets. The two datasets must be in the same pattern.

*Dataset name	Reference name of dataset which will be used for operations.
*Dataset name 2	Reference name of the 2nd dataset selected for processing.
*New dataset name	Reference name of dataset which will be created.

_{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the example.

newDS

You can use the Dataset name 2 as shown in the example.

newDS2

You can use the New dataset name as shown in the example.

intersectionDS

Save as

Save as activity allows to save a dataset in different formats such as CSV, Excel, Json, Xml, Html, Pdf.

*Dataset name	Reference name of dataset which will be used for operations.
*Text file name	File name with path.
*Type	The dataset; Csv, excel, json, xml, html, pdf formats are selected to be saved.
Include header	First row of selected range is a header.
Delimeter	Specifies with which separator cellular data will be combined when saving in CSV format.
Quote char	It determines the character in which string values will be written when saving in CSV format.

_{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the example.

${datasetname}

You can use the Text file name as shown in the example.

C:RobustaOrnek.csv

You can use the Type as shown in the examples.

CSV

EXCEL

JSON

XML

HTML

PDF

You can use the Delimeter as shown in the example.

It only needs to be filled when the CSV type is selected.

,

;

You can use the Quote char as shown in the examples.

It only needs to be filled when the CSV type is selected.

‘

“

Close

Close activity allows closing a dataset.

*Dataset name

Reference name of dataset which will be used for operations.

_{Note: * Fields selected with are required, others are optional.}

You can use the Dataset name as shown in the example.

${newDS}

Mail

Mail activities are designed to facilitate the automation of mail-related tasks covering various protocols such as IMAP, POP3 or SMTP.

You can reach a how-to guide on Mail component by clicking here.

Exchange connection

Exchange connection activity is the area where the necessary information to establish a connection to the Exchange server is received. In order to be able to receive or send an e-mail, the server connection must be established first. Other mail methods are included in the next step.

Configuration name	It is the name of the opened connection. This name will be chosen in other mail components.
*Connection name	The reference name is given to the mail connection which will open in this field.
Host	The server information of the e-mail address is entered.
Username	Username information of the e-mail address is entered.
Password	Password information of the e-mail address is entered.
Domain	The domain name information of the e-mail address is entered.
Type	The type of Exchange server is chosen in the dropdown.
Test connection	The correctness of the connection can be checked with a button.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

mailConnection

You can use the Host as shown in the example.

https://outlook.com/Exchange.asmx

You can use the Username as shown in the example.

john.doe@outlook.com

You can use the Password as shown in the example.

johndoe123

You can use the Domain as shown in the example.

outlook.com

You can use the Type as shown in the example.

Exchange2007_SP1

Exchange2010

Exchange2010_SP1

Exchange2010_SP2

Imap/Smtp connection

Imap/Smtp connection activity is the area where the necessary information to establish a connection to the Imap/Smtp server is obtained. Incoming mails in IMAP (Internet Message Access Protocol) as a system first come to the server where the user is logged in and then send them to a different e-mail server in the recipient’s mailbox using SMTP (Simple Mail Transfer Protocol). Since the user can read mails, ie download them, SMTP is a one-way (Sending) protocol, IMAP is activated and the mails are downloaded.

Configuration name	It is the name of the opened connection. This name will be chosen in other mail components.
*Connection name	The reference name is given to the mail connection which will open in this field.
Imap host	Imap server information of the mail address is entered.
Imap port	Imap port information of the mail address is entered.
Imap user	Imap username information of the e-mail address is entered.
Imap password	Imap password of the e-mail address is entered.
Imap ssl	Whether there is an Imap Ssl certificate in the mail address is specified with true/false.
Imap tls enabled	Whether the Smtp tls certificate is present in the mail address is specified with true/false.
Imap tls required	True/false indicates whether the Imap tls certificate is required in the mail address.
Smtp host	Smtp server information of the e-mail address is entered.
Smtp port	Smtp port information of the e-mail address is entered.
Smtp user	Smtp username information of the e-mail address is entered.
Smtp password	The Smtp password of the e-mail address is entered.
Smtp ssl	Whether the Smtp Ssl certificate is present in the mail address is specified with true/false.
Smtp tls enabled	Whether the Smtp tls certificate is present in the mail address is specified with true/false.
Smtp tls required	Whether the Smtp tls certificate is required in the mail address is specified with true/false.
Test connection	The correctness of the connection can be checked with a button

_{Note: * Fields selected with are required, others are optional.}
If the “Configuration” field is filled while creating the mail connection, the “IMAP” and “SMTP” fields do not need to be filled.
If the “Configuration” field is not filled while creating the mail connection, at least one of the “IMAP” and “SMTP” fields is expected to be filled.

You can use the Connection name as shown in the example.

mailConnection

You can use the Imap host as shown in the example.

imap.gmail.com

You can use the Imap port as shown in the example.

In order to send mail messages, Microsoft Outlook and Apple Mail etc. Other mail clients require settings specified by the service provider. This field must be entered as 993 for Gmail

993

You can use the Imap user as shown in the example.

john.doe@gmail.com

You can use the Imap password as shown in the example.

In order to receive mail messages, the password of the e-mail address to be linked is entered.

JohnDoe123

You can use the Imap ssl as shown in the example.

In order to receive mail messages, Microsoft Outlook and Apple Mail etc. Other mail clients require settings specified by the service provider. This field must be set to True for Gmail.

You can use the Imap tls enabled as shown in the example.

In order to receive mail messages, Microsoft Outlook and Apple Mail etc. Other mail clients require settings specified by the service provider. For Gmail, this field must be set to False.

You can use the Imap tls required as shown in the example.

In order to receive mail messages, Microsoft Outlook and Apple Mail etc. Other mail clients require settings specified by the service provider. For Gmail, this field must be set to False.

You can use the Smtp host as shown in the example.

smtp.gmail.com

You can use the Smtp port as shown in the example.

In order to send mail messages, Microsoft Outlook and Apple Mail etc. Other mail clients require settings specified by the service provider. For Gmail, this field must be entered 587.

587

You can use the Smtp user as shown in the example.

In order to send mail messages, the e-mail address to be linked is entered.

john.doe@gmail.com

You can use the Smtp password as shown in the example.

In order to send e-mail messages, the password of the e-mail address to be linked is entered.

JohnDoe123

You can use the Smtp ssl as shown in the example.

In order to send mail messages, Microsoft Outlook and Apple Mail etc. Other mail clients require settings specified by the service provider. For Gmail, this field must be set to False.

You can use the Smtp tls enabled as shown in the example.

In order to send mail messages, Microsoft Outlook and Apple Mail etc. Other mail clients require settings specified by the service provider. This field must be set to True for Gmail.

You can use the Smtp tls required as shown in the example.

In order to send mail messages, Microsoft Outlook and Apple Mail etc. Other mail clients require settings specified by the service provider. This field must be set to True for Gmail

Read/Save/Attachment

Read/Save/Attachment activity is used for reading and saving mails in specified folders and for additional files in mails.

*Connection name	The reference name of the mail connection which has already been established is chosen in the dropdown.
*Dataset name	The reference name of the already opened dataset is chosen in the dropdown.
Mail no	If the value of the Mail No field is empty or -1, then selected actions will be applied to all emails. Emails are sorted by oldest first.
Mark as read?	Whether the emails will be marked as read or not after the transaction is specified as True/False is decided.
Mark as unread?	Whether the emails will be marked as unread or not after the transaction is specified as True/False is decided.
Mark as deleted?	It is specified whether the emails will be deleted after the process.
Save attachments?	True/False whether to save mail attachments or not is decided.
Save attachments recursively?	Save all attachments which included in .eml and .msg attachments if it is checked.
Save mail?	Whether the emails will be saved or not after the transaction is specified as True/False is decided.
Save path	The directory where the emails or attachments will be saved is written.
Attachment Dataset name	The reference name is given to the dataset which will create in this field for mail attachments.
Save message body images?	Save inline and external URL images of message. Available only for IMAP/SMTP

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

mailConnection

You can use the Dataset name as shown in the example.

searchDS

You can use the Mail no as shown in the example.

-1

2

You can use the Save path as shown in the example.

C:Temp

Send

Send activity is used for sending mail via Send mail server.

*Connection name	The reference name of the mail connection which has already been established is chosen in the dropdown.
From	An email address that is for the sender is written.
To	An email address that is for the receiver is written. To add multiple addresses, use “,” or “;” to separate them. It may differ depending on the mail service provider.
Subject	If it is desired to be added subject, the subject title is written.
Message	The content of the message is written.
Attachment	The directory of the file/files to be attached to the mail is written. Note: If more than one file is to be entered, directories should be separated by commas (,)
Cc	The e-mail addresses of the people who want to be informed about the content of the mail are entered.
Bcc	The addresses of the people who want to be informed securely are written.
Is HTML?	If the mail is wanted to send in HTML format, this checkbox is checked.
Send delivery receipt	A delivery receipt confirms delivery of your email message to the recipient’s mailbox.
Send read receipt	Read receipt confirms that your message was opened.
Read Timeout Value	The time(in Milliseconds) to read is entered depending on the size of the attached file.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

mailConnection

You can use the From as shown in the example.

albert.baker@gmail.com

You can use the To as shown in the example.

john.doe@outlook.com,adam.tru@outlook.com

You can use the Subject path as shown in the example.

About the Financial Statement

You can use the Subject path as shown in the example.

Hello, This mail has been sent for testing purposes.

You can use the Attachment as shown in the example.

C:Tempattachment.xlsx,C:Masraffile.xlsx

You can use the Cc as shown in the example.

brandenenastanford@gmail.com

You can use the Bcc as shown in the example.

lilymagdalendawson@gmail.com

You can use the Read Timeout Value as shown in the example.

300000

To send a mail, only cc and bcc fields can be used.

Reply

Reply activity is used for replying mail via Reply mail server.

*Connection name	The reference name of the mail connection which has already been established is chosen in the dropdown.
*Dataset name	The reference name of the already opened dataset is chosen in the dropdown.
Mail no	If the value of the Mail No field is empty or -1, then selected actions will be applied to all emails. Emails are sorted by oldest first.
Subject	If it is desired to be added title, the subject title is written.
Message	The content of the message is written.
Attachment	The directory of the file/files to be attached to the mail is written. Note: If more than one file is to be entered, directories should be separated by commas (,)
Cc	The e-mail addresses of the people who want to be informed about the content of the mail are entered.
Is HTML?	If the mail is wanted to send in HTML format, this checkbox is checked.
Reply all?	This checkbox activates or deactivates the reply to all options.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

mailConnection

You can use the Dataset name as shown in the example.

searchDS

You can use the Mail no as shown in the example.

0

1

You can use the Subject path as shown in the example.

About the Financial Statement

You can use the Subject path as shown in the example.

Hello, This mail has been sent for testing purposes.

You can use the Attachment as shown in the example.

C:Tempattachment.xlsx,C:Masraffile.xlsx

You can use the Cc as shown in the example.

brandenenastanford@gmail.com

Forward

Forward activity is used for forwarding mail to other users through Forward mail server.

*Connection name	The reference name of the mail connection which has already been established is chosen in the dropdown.
*Dataset name	The reference name of the already opened dataset is chosen in the dropdown.
*Mail no	If the value of the Mail No field is -1, then selected actions will be applied to all emails. Emails are sorted by oldest first.
From	An email address that is for the sender is written.
*To	An email address that is for the receiver is written. To add multiple addresses, use “,” or “;” to separate them. It may differ depending on the mail service provider.
Subject	If it is desired to be added title, the subject title is written.
Message	The content of the message is written.
Attachment	The directory of the file/files to be attached to the mail is written. Note: If more than one file is to be entered, directories should be separated by commas (,)
Cc	The e-mail addresses of the people who want to be informed about the content of the mail are entered.
Bcc	The addresses of the people who want to be informed securely are written.
Is HTML?	If the mail is wanted to send in HTML format, this checkbox is checked.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

mailConnection

You can use the Dataset name as shown in the example.

searchDS

You can use the Mail no as shown in the example.

0

1

You can use the From as shown in the example.

albert.baker@gmail.com

You can use the To as shown in the example.

john.doe@outlook.com

You can use the Subject path as shown in the example.

About the Financial Statement

You can use the Message as shown in the example.

If “is HTML” is true, you can edit the message part with html code.

Hello, This mail has been sent for testing purposes.

You can use the Attachment as shown in the example.

C:Tempattachment.xlsx,C:Masraffile.xlsx

You can use the Cc as shown in the example.

brandenenastanford@gmail.com

You can use the Cc as shown in the example.

lilymagdalendawson@gmail.com

Search

Search activity is used for searching mail on Search mail server.

*Connection name	The reference name of the mail connection which has already been established is chosen in the dropdown.
*Folder name	The folder name in which emails will be searched is written.
Message id	Message id.
From	If it is desired to search the emails that are received from a particular person, the email address is written. Use “,” to enter multiple e-mails.
Only with attachment?	It is checked or unchecked True/False to indicate that mails with/without attachment files should be searched.
Search limit	The number of mails to be searched is specified in the mailbox.
Max date	The max date for search criteria can be written.
Min date	The min date for search criteria can be written.
Subject	The subject title is specified to search by subject title in the subject section.
Case sensitive	This checkbox provides a case-sensitive search for the inputted subject.
Only Unread?	This checkbox provides to decide whether read or unread emails will be searched.
*New dataset name	The reference name is given to the dataset which will create in this field.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

mailConnection

You can use the Folder name as shown in the example.

By default, INBOX comes, but any folder name can be given. For example, if the e-mails received from the administrator are to be collected in a folder called “MANAGER”, “MANAGER” should be written in this field.

INBOX

You can use the From as shown in the example.

albert.baker@gmail.com

You can use the Search limit as shown in the example.

10

50

You can use the Max date as shown in the example.

15.03.2020

05.01.2023 16:11:08

You can use the Min date path as shown in the example.

01.03.2020

02.01.2023 16:11:08

You can use the Subject as shown in the example.

About the Financial Statement

You can use the New dataset name as shown in the example.

searchDS

Create folder

Create folder activity is used for creating folders via mail server.

*Connection name	The reference name of the mail connection which has already been established is chosen in the dropdown.
*Folder name	The desired folder name is written to create.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

mailConnection

You can use the Folder name as shown in the example.

Moved

Move mail

Move mail activity is used for moving mails to folders via mail server.

*Connection name	The reference name of the mail connection which has already been established is chosen in the dropdown.
*Dataset name	The reference name of the already opened dataset is chosen in the dropdown
*Folder name	The folder name in which mails will be moved is written.
Mail no	If the value of the Mail No field is empty or -1, then selected actions will be applied to all emails. Emails are sorted by oldest first.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

mailConnection

You can use the Dataset name as shown in the example.

searchDS

You can use the Folder name as shown in the example.

Moved

You can use the Mail no as shown in the example.

0

Close connection

Close connection activity is used to close mail connection.

*Connection name

The reference name of the mail connection which has already been established is chosen in the dropdown.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

robustamailconnection

MS Outlook

MS Outlook activities enable to perform Outlook operations.

Send

Send activity opens the logged in Outlook application and sends an e-mail.

To	The receiver’s email address for to field is written. To add multiple addresses, it is used ‘,’ or ‘;’ to separate them.
Cc	The email address for the cc field is written. To add multiple addresses, it is used ‘,’ or ‘;’ to separate them.
Bcc	The email address for the bcc field is written. To add multiple addresses, it is used ‘,’ or ‘;’ to separate them.
Subject	If it is desired to be added subject, the subject title is written.
Message	The content of the message is written.
Attachment	The directory of the file/files to be attached to the mail is written. Note: This feature depends on your Outlook settings. Check Outlook Options > Mail > Send messages
IsHtml?	If the mail is wanted to send in HTML format, this checkbox is checked.
Send delivery receipt	A delivery receipt confirms delivery of your email message to the recipient’s mailbox.
Send read receipt	A read receipt confirms that your message was opened.
High Importance	Allows users to mark an email as high priority when sending it to indicate its importance
Email Address	If you have multiple email addresses, it enables you to send the email with the specified email address
Behalf of name	Displayed named to receiver

_{Note: * Fields selected with are required, others are optional.}

You can use the To as shown in the example.

albert.baker@gmail.com

You can use the Cc as shown in the example.

brandenenastanford@gmail.com

You can use the Bcc as shown in the example.

lilymagdalendawson@gmail.com

You can use the Subject as shown in the example.

About the Financial Statement

You can use the Message as shown in the example.

Hello, This mail has been sent for testing purposes.

You can use the Attachment as shown in the example.

C:Tempattachment.xlsx,C:Masraffile.xlsx

Mark

Mark activity allows the mails to be marked as read or unread.

*Entry id	The entry id of the mail item is written. Entry id is in the first column in the Dataset created in the Search activity.
Mark as	Mark as read or unread is specified.

_{Note: * Fields selected with are required, others are optional.}

You can use the Entry id as shown in the example.

${entryID}

You can use the Mark as shown in the example.

READ

UNEAD

Search

Search activity is used to search mail on Search mail server.

*Folder	The folder name in which emails will be searched is written. To search in a subfolder, it is used ‘/’ to specify the path.
*From	If it is desired to search the emails that are received from a particular person, the email address is written.
Min date	The min date for search criteria can be written.
Has attachment?	It is checked or unchecked True/False to indicate that mails with/without attachment files should be searched.
Max date	The max date for search criteria can be written.
Unread?	This checkbox provides to decide whether read or unread emails will be searched.
Subject	The subject title is specified to search by subject title in the subject section.
Search limit	The number of mails to be searched is specified in the mailbox.
Email Address	If you have multiple email addresses, it searchs in the specified email address.
*New dataset name	The reference name is given to the dataset which will create in this field.

_{Note: * Fields selected with are required, others are optional.}

You can use the Folder as shown in the example.

Inbox/Robusta/RPA

You can use the From as shown in the example.

albert.baker@gmail.com

You can use the Min date path as shown in the example.

02.01.2023 16:11:08

You can use the Max date as shown in the example.

05.01.2023 16:11:08

You can use the Subject as shown in the example.

About the Financial Statement

You can use the Search limit as shown in the example.

10

50

You can use the New dataset name as shown in the example.

searchDS

Download attachments

Download attachment activity allows downloading the files in mail attachment.

*Entry id	The entry id of the mail item is written. Entry id is in the first column in the Dataset created in the Search activity.
*Path	The directory where the attachments will be downloaded is written.

_{Note: * Fields selected with are required, others are optional.}

You can use the Entry id as shown in the example.

${entryID}

You can use the Path as shown in the example.

D:robustafiles

Save

Save activity is used for saving mails in specified folders and for additional files in mails.

*Entry id	The entry id of the mail item is written. Entry id is in the first column in the Dataset created in the Search activity.
*Path	The directory where the email will be saved is written.

_{Note: * Fields selected with are required, others are optional.}

You can use the Entry id as shown in the example.

123

You can use the Path as shown in the example.

C:Robustafiles

Reply/Reply all/Forward

Reply/Reply all/Forward activity is used for replying to and forwarding mail to one or more than one receiver.

*Entry id	The entry id of the mail item is written. Entry id is in the first column in the Dataset created in the Search activity.
Action	The action is selected for the email.
To	The receiver’s email address for to field is written. To add multiple addresses, it is used ‘,’ or ‘;’ to separate them.
Cc	The email address for the cc field is written. To add multiple addresses, it is used ‘,’ or ‘;’ to separate them.
Bcc	The email address for the bcc field is written. To add multiple addresses, it is used ‘,’ or ‘;’ to separate them.
Subject	If it is desired to be added subject, the subject title is written.
Message	The content of the message is written.
Attachment	The directory of the file/files to be attached to the mail is written. Note: If more than one file is to be entered, directories should be separated by commas (,)
is HTML?	If the mail is wanted to send in HTML format, this checkbox is checked.

_{Note: * Fields selected with are required, others are optional.}

You can use the Entry id as shown in the example.

123

You can use the Action as shown in the examples.

REPLY

REPLY_ALL

FORWARD

You can use the To as shown in the example.

albert.baker@gmail.com

You can use the Cc as shown in the example.

brandenenastanford@gmail.com

You can use the Bcc as shown in the example.

lilymagdalendawson@gmail.com

You can use the Subject as shown in the example.

About the Financial Statement

You can use the Message as shown in the example.

Hello, This mail has been sent for testing purposes.

You can use the Attachment as shown in the example.

C:Tempattachment.xlsx,C:Masraffile.xlsx

Move mail

Move mail activity is used for moving mails to folders via mail server.

*Entry Id	The entry id of the mail item is written. Entry id is in the first column in the Dataset created in the Search activity.
*Folder name	The name of the folder where the files will be moved is written.
Email Address	Specify e-mail address to scan (if you have several e-mail addresses on Outlook)

_{Note: * Fields selected with are required, others are optional.}

You can use the Entry id as shown in the example.

${entryId}

You can use the Folder name as shown in the example.

Inbox

To move in a subfolder, use “/” to specify path.

Inbox/Robusta/RPA

Read from file

Read from file activity allows to read a “.msg” file.

*File Name	Msg file name with the path to read is written.
Path	The file path where the emails will be saved is written. where the mails will be saved.
*New Dataset Name	The reference name is given to the dataset which will create in this field.

_{Note: * Fields selected with are required, others are optional.}

You can use the File Name as shown in the example.

D:robustafilesmyMail.msg

You can use the Path as shown in the example.

D:robustafiles

You can use the New Dataset Name as shown in the example.

newDs

Database

Database activities allow the user to connect to the database and query, call a function or procedure, and add/delete/update records.

Open connection

Open connection activity is used for establishing a connection to the desired database server.

*Connection name	A connection name is defined to be used as the database connection variable.
*Database name	The name of the previously defined database on the DB Definitions page in the RPA-Admin module.
*Database user	Database user name information is written.
*Database url	Jdbc URL entry is written in accordance with the database to be connected.
*Database password	Database user password information is written.
*Driver name	The driver suitable for the database to be connected is selected.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

robustaConnection

You can use the Database user shown in the example.

MYSQL

You can use the Database user shown in the example.

root

You can use the Url for Mysql as shown in the example.

jdbc:mysql://localhost:3306/robusta

You can use the Url for Oracle as shown in the example.

jdbc:oracle:thin:@localhost:8080:robusta

You can use the Url for SQL server as shown in the example.

jdbc:sqlserver://localhost:1433;databaseName=robusta

You can use the Url for Apache Impala as shown in the example.

jdbc:impala://[Host]:[Port]

You can use the Url for PostgreSQL as shown in the example.

Connection db = DriverManager.getConnection(url, username, password)

You can use the Url for IBM S400 server as shown in the example.

JDBC URL: jdbc:as400://hostname/default-schema

You can use the Url for Sybase server as shown in the example.

jdbc:sybase:Tds:host:port?ServiceName=database

You can use the Url for Bkz. as shown in the examples.

https://docs.oracle.com/cd/E57185_01/ESTUG/apbs02s04s01.html

You can use the Database password shown in the example.

1234

You can use the Url for Mysql as shown in the example.

com.mysql.jdbc.Driver

You can use the Url for Oracle as shown in the example.

oracle.jdbc.driver.OracleDriver

You can use the Url for SQL server as shown in the example.

com.microsoft.sqlserver.jdbc.SQLServerDriver

Close connection

Close connection activity is used for closing an opened connection.

*Connection
name

The defined connection name before is chosen from the dropdown.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

robustaConnection

Execute query

Execute query activity is used for adding, updating and deleting records in the database.

*Connection name	The defined connection name before is chosen from the dropdown.
Param1	The value to be assigned to the first parameter is written.
Param2	The value to be assigned to the second parameter is written.
Param3	The value to be assigned to the third parameter is written.
Param4	The value to be assigned to the fourth parameter is written.
Param5	The value to be assigned to the fifth parameter is written.
Parameters	If it is desired to put multiple parameters, parameters are written.
*Query sql	The value of sql query is written.
*Result dataset name	The reference name is given to the dataset which will create in this field.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

robustaConnection

You can use the Param1 as shown in the examples.

2314589

${customerID}

You can use the Param2 as shown in the examples.

Company A

${companyName}

You can use the Param3 as shown in the examples.

area

${area}

You can use the Param4 as shown in the examples.

title

${title}

You can use the Param5 as shown in the examples.

robusta

${company}

You can use the Parameters as shown in the example.

[2314589, Company A]

[${customerID}, ${companyName}]

You can use the Query sql as shown in the example.

SELECT * FROM db_test.customer_infos WHERE CustomerID = ‘:1’ AND CompanyName = ‘:2’ ;

You can use the Query sql as shown in the example.

employeesDataset

Call stored procedure

Call stored procedure activity executes a desired stored procedure in the database and returns the result.

Usage examples can be found at this link.

*Connection name	The defined connection name before is chosen from the dropdown.
Param1	The value to be assigned to the first parameter is written.
Param2	The value to be assigned to the second parameter is written.
Param3	The value to be assigned to the third parameter is written.
Param4	The value to be assigned to the fourth parameter is written.
Param5	The value to be assigned to the fifth parameter is written.
Parameters	If it is desired to put multiple parameters, parameters are written.
*Stored procedure name	The stored procedure name is written. The question marks should be added as many as the number of parameters to be used.
*Result dataset name	The reference name is given to the dataset which will create in this field.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

robustaConnection

You can use the Param1 as shown in the example.

[‘1’, ‘STRING’, ‘in’, ‘2314589’]

You can use the Param2 as shown in the example.

[‘2’, ‘STRING’, ‘in’, ‘${companyName}’]

You can use the Param3 as shown in the example.

[‘3’, ‘STRING’, ‘in’, ‘${companyName}’]

You can use the Param4 as shown in the example.

[‘4’, ‘STRING’, ‘in’, ‘${companyName}’]

You can use the Param5 as shown in the example.

[‘5’, ‘STRING’, ‘in’, ‘${companyName}’]

You can use the Parameters as shown in the example.

[[‘1’, ‘STRING’, ‘in’, ‘2314589’], [‘2’, ‘STRING’, ‘in’, ‘${companyName}’]]

You can use the Stored procedure name as shown in the example.

CALL robusta.getCustomerInfo(?,?);

You can use the Query sql as shown in the example.

employeesDataset

Execute update

Execute update activity executes a requested query on the database and returns the query result.

*Connection name	The defined connection name before is chosen from the dropdown.
Param1	The value to be assigned to the first parameter is written.
Param2	The value to be assigned to the second parameter is written.
Param3	The value to be assigned to the third parameter is written.
Param4	The value to be assigned to the fourth parameter is written.
Param5	The value to be assigned to the fifth parameter is written.
Parameters	If it is desired to put multiple parameters, parameters are written.
*Query sql	The value of sql query is written.
*Result dataset name	The reference name is given to the dataset which will create in this field.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

robustaConnection

You can use the Param1 as shown in the example.

[‘1’, ‘STRING’, ‘in’, ‘2314589’]

You can use the Param2 as shown in the example.

[‘2’, ‘STRING’, ‘in’, ‘${companyName}’]

You can use the Param3 as shown in the example.

[‘3’, ‘STRING’, ‘in’, ‘${companyName}’]

You can use the Param4 as shown in the example.

[‘4’, ‘STRING’, ‘in’, ‘${companyName}’]

You can use the Param5 as shown in the example.

[‘5’, ‘STRING’, ‘in’, ‘${companyName}’]

You can use the Parameters as shown in the example.

[[‘1’, ‘STRING’, ‘in’, ‘2314589’], [‘2’, ‘STRING’, ‘in’, ‘${companyName}’]]

You can use the Query sql as shown in the example.

insert into rpa_turkey_tablo2 (Ad,Soyad,Sirket_Adi,Unvan) values(‘:1′,’:2′,’:3′,’:4′);

You can use the Query sql as shown in the example.

employeesDataset

Xml and JSON

Xml and JSON activities allow retrieving each element, attribute, in an .xml file. In addition, it allows the files in JSON format to be read and thrown into the data set.

Execute xpath

Execute xpath activity allows reaching the location of each element or attribution in the .xml file via Xpath and getting desired values.

*File name	The XML file name is written.
*Xml string	If any result is received as an XML string (Not a file with XML content) XML content is written. The other fields, prefixes, etc. XML is written to parse the content. Then, it is ensured that operations can be performed as a dataset. Note: If this field is used, the File name field does not need to be used.
*Xpath expression	The Xpath of which element/attribute to be referenced is referenced and the information related to element or attribute is selected by using Filter field.
*Filter	The information type (element/attribute) to be accessed within Xpath is entered. In the dropdown menu, two information types (element/attribute) can be selected.
Prefix	This is the area where prefixes are defined when using the elements in the XML file. In case more than one prefix is needed, other prefix fields are filled.
Uri	To define the first prefix, the URI of the prefix is provided here.
Prefix2	This is the area where prefixes are defined when using the elements in the XML file.
Uri2	To define prefix2, the URI of the prefix is provided here.
Prefix3	This is the area where prefixes are defined when using the elements in the XML file.
Uri3	To define the first prefix3, the URI of the prefix is provided here.
*Output dataset	A dataset name is written for the XPath execution result.
Delimiter	The delimiter is used to separate the Xpaths when more than one Xpath is used.

^{Note: * Fields selected with are required, others are optional}

You can use the File name as shown in the example.

C:UsersAliceDocumentsinvoice.xml

You can use the Xml string as shown in the example.

<string name=”string_name” text_string </string

You can use the Xpath expressions shown in the example.

<? Xml version = “1.0” encoding = “UTF-8”?>
<Invoice>
<Return_ID>135672</Return_ID>
<Store_ID>23465</Store_ID>
<Store_Name>BELGE</Store_Name>
<Supplier_Name>Third Part Company</Supplier_Name>
<Supplier_Account_No>7330028047</Supplier_Account_No>
<Brand_ID>14235</Brand_ID>
</Invoice>
Let’s consider a file with .xml extension that has XML content in this way. Let’s want to access the Store_ID element in the tree structure in the file. The Xpath Statement to be written for this would be as follows:

//Invoice/Store_ID

You can use the Filter as shown in the example.

ELEMENT

Let’s use the XPath specified in the example above. This Xpath takes us to the Store_ID element in the tree structure. That is, the address of an element to be reached with XPath. Thus, ELEMENT is selected from the combobox.

You can use the Prefix shown in the example.

ds:Reference

Based on the XML file content above, this field is not filled because there is no prefix for the elements in the .xml file. The prefix is specified in an xml file as follows:
<ds:Reference Id=”Reference-Id-28eeffb3-146c-4a8a-9e12-19541d39ee0e” URI=””>. The prefix of the Reference element in this expression is ‘ds’.

You can use the Prefix2 shown in the example.

cac:AdditionalDocumentReference

Based on the XML file content above, this field is not filled because there is no prefix for the elements in the .xml file. The As in the above mentioned ‘Prefix’ example, if there is another prefix like “ds”, a prefix is written in this field again. Xpath information also varies according to usage.
<cac:AdditionalDocumentReference>
<cbc:ID>0.00</cbc:ID>
<cbc:IssueDate>2020-03-18</cbc:IssueDate>
<cbc:DocumentType>ALLOWANCETOTALAMOUNT</cbc:DocumentType>
</cac:AdditionalDocumentReference>
As can be seen in this example, different prefixes (prefixes) can be included in the .xml file.

You can use the Prefix3 shown in the example.

caa:Username

Suppose that the file specified in the prefix2 example also has a field like the following:
<caa:Username>john.smith</cbc:DocumentType>
If you want to reach this field in the XML file, in addition to the cac and cbc prefixes, the caa prefix is also introduced in this field; Prefix3: becomes caa.

You can use the URI as shown in the example.

urn: oasis: names: specification: ubl: schema: xsd: CommonAggregateComponents-2

The prefix contains Uri information in the .xml file.
xmlns: cac = “urn: oasis: names: specification: ubl: schema: xsd: CommonAggregateComponents-2”, the area to the left of the equation and in quotes contains the Uri information. When writing the expression Uri, the part between the double quotes is written:
It is shown as urn: oasis: names: specification: ubl: schema: xsd: CommonAggregateComponents-2.

You can use the URI2 as shown in the example.

urn: oasis: names: specification: ubl: schema: xsd: CommonAggregateComponents-2

The prefix contains Uri information in the .xml file.
The field specified in the expression xmlns: ext = “urn: oasis: names: specification: ubl: schema: xsd: CommonExtensionComponents-2”, to the left of the equation, and in quotes contains the Uri information. When writing the expression Uri, the part between the double quotes is written:
It is shown as urn: oasis: names: specification: ubl: schema: xsd: CommonExtensionComponents-2.

You can use the URI3 as shown in the example.

urn: oasis: names: specification: ubl: schema: xsd: CommonAggregateComponents-2

or Prefix3 defined above, Uri information similar to Uri and Uri2 is written in the specified format.

You can use the Output dataset as shown in the example.

outputvalue

You can use the Delimiter as shown in the example.

If a single xpath is used, the Delimiter must not be filled.

If using multiple xpaths;

The sign separating the xpaths must be entered in the Delimiter field.

If xpaths are separated by “,”

,

Single Xpath

More than one Xpath

Each given xpath is taken as the header and the values are written explicitly line by line.

Get value

Get value activity ensures that the value in each element and / or property (attribute) in the .xml extension file to be processed.

*Input dataset	The name written in the output dataset field in the Execute Xpath activity is selected from the dropdown menu.
*Row	The row from which the element in the dataset will be taken is written.
Column	The column from which the element in the dataset will be taken is written.
*Output value	A variable name that will be created is written.

^{Note: * Fields selected with are required, others are optional.}

You can use the Input dataset as shown in example.

${inputvalue}

You can use the Row as shown in the example.

Four(4)

Let’s assume that we keep the location of an .xml file // Invoice as a reference in Xpath in the Execute Xpath component, select the ELEMENT option from the Filter field in accordance with this location and keep the reference field in the dataset.
<Invoice>
<Return_ID>135672</Return_ID>
<Store_ID>23465</Store_ID>
<Store_Name>BELGE</Store_Name>
<Supplier_Name>Third Part Company</Supplier_Name>
<Supplier_Account_No>7330028047</Supplier_Account_No>
<Brand_ID>14235</Brand_ID>
</Invoice>
// Invoice location typed in the xpath field includes all the elements in the xml expression. The information that the element to be accessed is in the row is written in the “Row” field. Whichever element we want to access, the first element (Return_ID) is taken as zero (0), and the other components are accessed by increasing numbers.
In this example, let’s want to access the “Supplier_Account_No” element; Four (4) should be written in the row field.

You can use the Column as shown in the example.

If the column value is a positive number, a search will be made according to the column number and the value will be returned.

0

If it is not a positive number, a search will be made according to the header information and the value will be returned.

//author

You can use the Output value as shown in the example.

outputValue

Update xml

Update xml activity updates XML expressions.

*File name	The XML file name is written.
*Xml string	If any result is received as an XML string (Not a file with XML content) XML content is written. The other fields, prefixes, etc. XML is written to parse the content. Then, it is ensured that operations can be performed as a dataset. Note: If this field is used, the File name field does not need to be used.
*Xpath expression	The Xpath of which element/attribute to be referenced is referenced and the information related to element or attribute is selected by using Filter field.
*Filter	The information type (element/attribute) to be accessed within Xpath is entered. In the dropdown menu, two information types (element/attribute) can be selected.
*New value	The new value of the element/attribute to be updated is written.
Prefix	This is the area where prefixes are defined when using the elements in the XML file.
Uri	To define the first prefix, URI of the prefix is provided here.
Prefix2	This is the area where prefixes are defined when using the elements in the XML file.
Uri2	To define prefix2, URI of the prefix is provided here.
Prefix3	This is the area where prefixes are defined when using the elements in the XML file.
Uri3	To define first prefix3, URI of the prefix is provided here.
Result variable name*	A variable name that will be created is written.

^{Note: * Fields selected with are required, others are optional.}

You can use the File name as shown in the example.

C:UsersAliceDocumentsinvoice.xml

You can use the Xml string as shown in the example.

<string name=”string_name” text_string </string

You can use the Xpath expressions shown in the example.

<? Xml version = “1.0” encoding = “UTF-8”?>
<Invoice>
<Return_ID>135672</Return_ID>
<Store_ID>23465</Store_ID>
<Store_Name>BELGE</Store_Name>
<Supplier_Name>Third Part Company</Supplier_Name>
<Supplier_Account_No>7330028047</Supplier_Account_No>
<Brand_ID>14235</Brand_ID>
</Invoice>
Let’s consider a file with .xml extension that has XML content in this way. Let’s want to access the Store_ID element in the tree structure in the file. The Xpath Statement to be written for this would be as follows:

//Invoice/Store_ID

You can use the Filter as shown in the example.

ELEMENT

Let’s use the XPath specified in the example above. This Xpath takes us to the Store_ID element in the tree structure. That is, the address of an element to be reached with XPath. Thus, ELEMENT is selected from the combobox.

You can use the New value as shown in the example.

<? Xml version = “1.0” encoding = “UTF-8”?>
<Invoice>
<Return_ID>135672</Return_ID>
<Store_ID>23465</Store_ID>
<Store_Name>BELGE</Store_Name>
<Supplier_Name>Third Part Company</Supplier_Name>
<Supplier_Account_No>7330028047</Supplier_Account_No>
<Brand_ID>14235</Brand_ID>
</Invoice>

Let’s change the value the Store_ID element.

9876

You can use the Prefix shown in the example.

ds:Reference

Based on the XML file content above, this field is not filled because there is no prefix for the elements in the .xml file. The prefix is specified in an xml file as follows:
<ds:Reference Id=”Reference-Id-28eeffb3-146c-4a8a-9e12-19541d39ee0e” URI=””>. The prefix of the Reference element in this expression is ‘ds’.

You can use the Prefix2 shown in the example.

cac:AdditionalDocumentReference

Based on the XML file content above, this field is not filled because there is no prefix for the elements in the .xml file. The As in the above mentioned ‘Prefix’ example, if there is another prefix like “ds”, a prefix is written in this field again. Xpath information also varies according to usage.
<cac:AdditionalDocumentReference>
<cbc:ID>0.00</cbc:ID>
<cbc:IssueDate>2020-03-18</cbc:IssueDate>
<cbc:DocumentType>ALLOWANCETOTALAMOUNT</cbc:DocumentType>
</cac:AdditionalDocumentReference>
As can be seen in this example, different prefixes (prefixes) can be included in the .xml file.

You can use the Prefix3 shown in the example.

caa:Username

Suppose that the file specified in the prefix2 example also has a field like the following:
<caa:Username>john.smith</cbc:DocumentType>
If you want to reach this field in the XML file, in addition to the cac and cbc prefixes, the caa prefix is also introduced in this field; Prefix3: becomes caa.

You can use the URI as shown in the example.

urn: oasis: names: specification: ubl: schema: xsd: CommonAggregateComponents-2

The prefix contains Uri information in the .xml file.
xmlns: cac = “urn: oasis: names: specification: ubl: schema: xsd: CommonAggregateComponents-2”, the area to the left of the equation and in quotes contains the Uri information. When writing the expression Uri, the part between the double quotes is written:
It is shown as urn: oasis: names: specification: ubl: schema: xsd: CommonAggregateComponents-2.

You can use the URI2 as shown in the example.

urn: oasis: names: specification: ubl: schema: xsd: CommonAggregateComponents-2

The prefix contains Uri information in the .xml file.
The field specified in the expression xmlns: ext = “urn: oasis: names: specification: ubl: schema: xsd: CommonExtensionComponents-2”, to the left of the equation, and in quotes contains the Uri information. When writing the expression Uri, the part between the double quotes is written:
It is shown as urn: oasis: names: specification: ubl: schema: xsd: CommonExtensionComponents-2.

You can use the URI3 as shown in the example.

urn: oasis: names: specification: ubl: schema: xsd: CommonAggregateComponents-2

or Prefix3 defined above, Uri information similar to Uri and Uri2 is written in the specified format.

You can use the Result variable name as shown in the example.

ResultVariable

Read JSON

Reads a json file or a string in json format into a json type variable.

*File Name	The JSON file name is written.
*JSON string	The string structure to be read is written.
*Result variable name	A variable name that will be created is written.

_{Note: * Fields selected with are required, others are optional.}

You can use the File Name as shown in the example.

C:RobustaXml-JsonreadJsontest.json

You can use the JSON string as shown in the example.

[{ “id”: 1 }] { “id”: 1, “firstname”: “Katerina”, “job”: { “site”: “www.javacodegeeks.com”, “name”: “Java Code Geeks” } }

You can use the Result variable name as shown in the example.

resultJson

Read JSON to Dataset

Allows the data defined in JSON format to be transferred to the dataset.

*JSON string	The string structure to be read is written.
*Output Dataset	The reference name is given to the dataset which will create in this field.

_{Note: * Fields selected with are required, others are optional.}

You can use the JSON string as shown in the example.

[{ “id”: 1 }] { “id”: 1, “firstname”: “Katerina”, “job”: { “site”: “www.javacodegeeks.com”, “name”: “Java Code Geeks” } }

You can use the Output Dataset as shown in the example.

readDS

Icu

Icu activities consist of components that give coordinate information of specfic image or text on the screen.

Match image

Match image activity is used for finding coordinates of specified image in screen.

*File name	File name with path.
*Base64	Base64 string of image file.
X-coordinate	If it is desired to limit the image to be searched on the screen within a certain area; this field must be filled in, along with the Y-coordinate, Height, and Width fields.
Y-coordinate	If it is desired to limit the image to be searched on the screen within a certain area; this field must be filled in, along with the X-coordinate, Height, and Width fields.
Width	If it is desired to limit the image to be searched on the screen within a certain area; this field must be filled in, along with the X-coordinate, Y-coordinate and Height fields.
Height	If it is desired to limit the image to be searched on the screen within a certain area; This field must be filled in, along with the X-coordinate, Y-coordinate and Width fields.
Retry count	The number of tries until the image is found, could be any numeric value.
Match score	Images are matched if their similarity percentage is higher than the match score.
Find first on top	Returns the coordinates of the upper left one when there are multiple matched images.
*Return x-position	Final x-position, variable name defined to assign the x-coordinate found.
*Return y-position	Final y-position, variable name defined to assign the y-coordinate found.

_{Note: * Fields selected with are required, others are optional.}

You can use the File name as shown in the example.

C:Temptest.jpg

This field must be left blank if the process is done with Base64 field.

You can use the Base64 as shown in the example.

iVBORw0KGgoAAAANSUhEUgAAAGYAAAAsCAYAAACXHM1oAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAE

This field must be left blank if the process is done with File name field.

You can use the X-coordinate as shown in the example.

700

If you want to limit the specified image in a certain area in screen, this field must be filled along with Y-coordinate, height and width.

You can use the Y-coordinate as shown in the example.

400

If you want to limit the specified image in a certain area in screen, this field must be filled along with X-coordinate, height and width.

You can use the Width as shown in the example.

100

If you want to limit the specified image in a certain area in screen, this field must be filled along with X-coordinate, Y-coordinate, and height.

You can use the Height as shown in the example.

50

If you want to limit the specified image in a certain area in screen, this field must be filled along with X-coordinate, Y-coordinate, and width.

You can use the Retry count as shown in the example.

3

You can use the Match score as shown in the example.

0.80

You can use the Return x-position as shown in the example.

xPositionValue

You can use the Return x-position as shown in the example.

yPositionValue

You can use Return x-position and Return y-position variables in Mouse activity in Keyboard & Mouse Operations.

Image can be converted to Base64 in different sites.

The coordinates of file whose path is specified in File name field are found on screen and returned to xPositionValue and yPositionValue variables. Using these returned variables in Mouse activity, the process of clicking on these coordinates can be done.

Gif is an unsupported extension for Match Image activity.

The values for Height and Width must be an integer.

Match text

Match text activity, regardless of the browser or application, is used for finding the coordinate on the currently open screen, in order to find the text to be specified via the component and perform an action.

*Text	The text that will be searched on the screen.
X-coordinate	If it is desired to limit the text to be searched on the screen within a certain area; this field must be filled in, along with the Y-coordinate, Height, and Width fields.
Y-coordinate	If it is desired to limit the text to be searched on the screen within a certain area; this field must be filled in, along with the X-coordinate, Height, and Width fields.
Width	If it is desired to limit the text to be searched on the screen within a certain area; this field must be filled in, along with the X-coordinate, Y-coordinate and Height fields.
Height	If it is desired to limit the text to be searched on the screen within a certain area; This field must be filled in, along with the X-coordinate, Y-coordinate and Width fields.
*Language	The language of the text to be scanned.
Retry count	The number of tries until the text is found, could be any numeric value.
*Return x-position	Final x-position, variable name defined to assign the x-coordinate found.
*Return y-position	Final y-position, variable name defined to assign the y-coordinate found.

_{Note: * Fields selected with are required, others are optional.}

You can use the Text as shown in the examples.

Deneme

${deneme}

You can use the X-coordinate as shown in the example.

700

You can use the Y-coordinate as shown in the example.

400

You can use the Width as shown in the example.

120

You can use the Height as shown in the example.

35

You can use the Language as shown in the example.

For Turkish:

TUR

For English:

ENG

You can use the Retry count as shown in the example.

5

You can use the Return x-position as shown in the example.

xPositionValue

You can use the Return y-position as shown in the example.

yPositionValue

You can use Return x-position and Return y-position variables in Mouse activity in Keyboard & Mouse Operations.

In the example above, the coordinates of the text specified in the Text field will be scanned and a value will be returned to the xPositionValue and yPositionValue variables (For example: 300,280). When we select LEFT_CLICK from the combobox in the Action field of the Mouse Activity and write these returned variables as $ {xPositionValue} and $ {xPositionValue} into the X Position and Y Position fields, the returned values 300 and 280 will be used in the Mouse activity with the variable. As a result of the operation, left mouse click will be performed on the text specified in the Text field.

The values for height and width must be an integer.

Save screen capture

Save screen capture activity allows taking a screenshot of the entire screen or a specific area on the screen.

*File name	File path where screenshot will be saved.
X-coordinate	If it is desired to limit the image to be screen capture on the screen within a certain area; this field must be filled in, along with the Y-coordinate, Height, and Width fields.
Y-coordinate	If it is desired to limit the image to be screen capture on the screen within a certain area; this field must be filled in, along with the X-coordinate, Height, and Width fields.
Width	If it is desired to limit the image to be screen capture on the screen within a certain area; this field must be filled in, along with the X-coordinate, Y-coordinate and Height fields.
Height	If it is desired to limit the image to be screen capture on the screen within a certain area; This field must be filled in, along with the X-coordinate, Y-coordinate and Width fields.

_{Note: * Fields selected with are required, others are optional.}

You can use the File name as shown in the example.

C:Robustarobusta.png

Supported image file types:

png

jpg

jpeg

You can use the X-coordinate as shown in the example.

68

You can use the Y-coordinate as shown in the example.

347

You can use the Width as shown in the example.

120

You can use the Height as shown in the example.

35

The values for height and width must be an integer.

Ocr

Ocr activities allow extracting a string or information from an image item.

Read as text

Read as text activity allows a desired image content to be transferred as text to a variable.

*File name	File name with path.
X-coordinate	If it is desired to limit the text to be read on the screen within a certain area; this field must be filled in, along with the Y-coordinate, Height, and Width fields.
Y-coordinate	If it is desired to limit the text to be read on the screen within a certain area; this field must be filled in, along with the X-coordinate, Height, and Width fields.
Width	If it is desired to limit the text to be read on the screen within a certain area; this field must be filled in, along with the Y-coordinate, X-coordinate, and Width fields.
Height	If it is desired to limit the text to be read on the screen within a certain area; this field must be filled in, along with the X-coordinate, Y-coordinate, and Height fields.
*Language	The language library is selected.
*Result text name	The name of the variable to which the OCR result is to be transferred.

_{Note: * Fields selected with are required, others are optional.}

You can use the File name as shown in the example.

C:Robustarobusta.png

You can use the X-coordinate as shown in the example.

68

X-coordinate, Y-coordinate, height and width field cannot be used alone. In case of using one, other fields must be filled.

You can use the Y-coordinate as shown in the example.

347

X-coordinate, Y-coordinate, height and width field cannot be used alone. In case of using one, other fields must be filled.

You can use the Width as shown in the example.

120

X-coordinate, Y-coordinate, height and width field cannot be used alone. In case of using one, other fields must be filled.

You can use the Height as shown in the example.

35

X-coordinate, Y-coordinate, height and width field cannot be used alone. In case of using one, other fields must be filled.

You can use the Language as shown in the example.

TUR

ENG

RUS

OCR-B

You can use the Result text name as shown in the example.

readRobustaOcr

If the X-coordinate, Y-coordinate, height and width fields are left blank, all of specified image is transferred to variable specified in the Result text name field. If the X-coordinate, Y-coordinate, height and width fields are given a value, the area that these fields specified is transferred to variable specified in the Result text name field.

The values for height and width must be an integer.

Screen ocr scan

Screen ocr scan activity allows a specified area on the screen and/or screen to be transferred to a variable as text.

X-coordinate	If it is desired to limit the screen to be scanned on the screen within a certain area; this field must be filled in, along with the Y-coordinate, Height, and Width fields.
Y-coordinate	If it is desired to limit the screen to be scanned on the screen within a certain area; this field must be filled in, along with the X-coordinate, Height, and Width fields.
Width	If it is desired to limit the screen to be scanned on the screen within a certain area; this field must be filled in, along with the X-coordinate, Y-coordinate and Height fields.
Height	If it is desired to limit the screen to be scanned on the screen within a certain area; this field must be filled in, along with the X-coordinate, Y-coordinate and Width fields.
*Language	The language library is selected.
*Result text name	The name of the variable to which the OCR result is to be transferred.

_{Note: * Fields selected with are required, others are optional.}

You can use the X-coordinate as shown in the example.

68

X-coordinate, Y-coordinate, height and width field cannot be used alone. In case of using one, other fields must be filled.

You can use the Y-coordinate as shown in the example.

347

X-coordinate, Y-coordinate, height and width field cannot be used alone. In case of using one, other fields must be filled.

You can use the Width as shown in the example.

120

X-coordinate, Y-coordinate, height and width field cannot be used alone. In case of using one, other fields must be filled.

You can use the Height as shown in the example.

35

X-coordinate, Y-coordinate, height and width field cannot be used alone. In case of using one, other fields must be filled.

You can use the Language as shown in the example.

TUR

ENG

RUS

OCR-B

You can use the Result text name as shown in the example.

screenOcrScan

If the X-coordinate, Y-coordinate, height and width fields is left blank, all of specified image is transferred to variable specified in the Result text name field. If the X-coordinate, Y-coordinate, height and width fields are given a value, the area that these fields specified is transfered to variable specified in the Result text name field.

The values for height and width must be an integer.

Read words

Read words activity allows a desired image content to be transferred to a variable as text line by line.

*File name	File name with path.
X-coordinate	If it is desired to limit the text to be read on the screen within a certain area; this field must be filled in, along with the Y-coordinate, Height, and Width fields.
Y-coordinate	If it is desired to limit the text to be read on the screen within a certain area; this field must be filled in, along with the X-coordinate, Height, and Width fields.
Width	If it is desired to limit the text to be read on the screen within a certain area; this field must be filled in, along with the Y-coordinate, X-coordinate, and Width fields.
Height	If it is desired to limit the text to be read on the screen within a certain area; this field must be filled in, along with the X-coordinate, Y-coordinate, and Height fields.
*Language	The language library is selected.
*Result text name	The name of the variable to which the OCR result is to be transferred.

_{Note: * Fields selected with are required, others are optional.}

You can use the File name as shown in the example.

C:Robustarobusta.png

You can use the X-coordinate as shown in the example.

68

X-coordinate, Y-coordinate, height and width field cannot be used alone. In case of using one, other fields must be filled.

You can use the Y-coordinate as shown in the example.

347

X-coordinate, Y-coordinate, height and width field cannot be used alone. In case of using one, other fields must be filled.

You can use the Width as shown in the example.

120

X-coordinate, Y-coordinate, height and width field cannot be used alone. In case of using one, other fields must be filled.

You can use the Height as shown in the example.

35

X-coordinate, Y-coordinate, height and width field cannot be used alone. In case of using one, other fields must be filled.

You can use the Language as shown in the example.

TUR

ENG

RUS

OCR-B

You can use the Result text name as shown in the example.

resultText

The variable result will be as follows. The results will be transferred to the variable in json format.

{“result”:[{“lineNumber”:1, words:[{“text”:”Hello”,”x”:10,”y”:10,”width”:200,”height”:20}

{“text”:”World”,”x”:220,”y”:10,”width”:205,”height”:20}]}]}

The related component also gives the confidence score besides the coordinates and the text read.

If the X-coordinate, Y-coordinate, height and width fields is left blank, all of specified image is transferred to variable specified in the Result text name field. If the X-coordinate, Y-coordinate, height and width fields are given a value, the area that these fields specified is transfered to variable specified in the Result text name field.

Example result for confidence value:

{“result”:[{“words”:[{“confidence”:81,”x”:2,”width”:53,”y”:4,”text”:”Succes”,”height”:17 {“confidence”:78,”x”:59,”width”:97,”y”:4,”text”:”Ratio”,”height”:17}],”lineNumber”:1}]}

The values for height and width must be an integer.

System

System activities allow to run commands, batch files on the command line.

Run cmd

Run cmd activity allows run every command and program executed via Cmd.

*Exe name	The program name typed on the command line using CMD commands.
*Working directory	CMD is the working directory of the program where the command will be run.
Wait until finish	It is specified whether the process will be suspended until the end of the CMD command. If True is selected, the process waits in the relevant step until the program is terminated, if False is selected, the process goes to the next step without waiting for the program to end.
Run as admin	When this field is checked, the program will be run as admin. Note: User Account Control Settings should be at the minimum level (Never notify).
Parameters	The parameters of the program.
Result variable name	Result variable name.

_{Note: * Fields selected with are required, others are optional.}

You can use the Exe name as shown in the example.

QAD.Applications.exe

cmd.exe

You can use the Working directory as shown in the example.

C:Temp

C:ebyn

You can use the Wait until finish as shown in the example.

If True is selected, the process waits in the relevant step until the program is terminated, if False is selected, the process goes to the next step without waiting for the program to end.

You can use the Parameters shown in the example.

MD Trial

C:ebynbdp.bat

User Account Control Settings should be at the minimum level (Never notify).

Call ext. method

It is used to call a specific method of an external application and get its result. Call Ext. method can be run with Java, Python and DLL.

*Path	Enter the file path to run.
*File name	The name of the file is written with its extension.
*Class name	Enter the class name of the method to be executed.
*Method name	Enter the method name to be executed.
Argument type	Parameter type is selected from Combobox.
Argument value	The value of the parameter is selected.
Argument option	It must be filled when the parameter type date is selected. Contains Date Format information.
*Response variable name	The variable name to which the incoming response will be saved is entered.

_{Note: * Fields selected with are required, others are optional.}

You can use the Path as shown in the example.

C:UsersDesktopDesktopfileReader

You can use the Path as shown in the example.

readfile.py

You can use the Class name as shown in the example.

Hello

You can use the Method name as shown in the example.

string

You can use the Arg type as shown in the example.

STRING

You can use the Arg value as shown in the example.

Postman request

You can use the Arg option as shown in the example.

12-02-1997

You can use the Response variable name as shown in the example.

degiskenismi

Call vb script

It shows the operations to be performed automatically with the help of “Vb script” in a way to be integrated with a workflow application.

*Script	The vb script code is written in this field.
Result variable name	Result variable name.

_{Note: * Fields selected with are required, others are optional.}

You can use the Script as shown in the example (Hidden sheet in an excel file).

Set objXLApp = CreateObject("Excel.Application")
objXLApp.Visible = false
Set objXLWb = objXLApp.Workbooks.Open("C:Robusta_Projectxxxxyz.xlsx")
Set oSheet = objXLWb.Worksheets("Summary") 
oSheet.Visible = xlSheetHidden			  
objXLWb.save
objXLWb.close false
objXLApp.Quit
Set objXLWb = nothing
Set objXLApp = nothing

If windows script version message is not wanted to appear in the result variable,

cscript //NoLogo

command should be added to the first line.

User custom log

This activity enables the user to receive custom preference log information.

*Log message in json format	Log message in json format. Needs to fill custom index
*Log message in text format	Log message in Text format. Pushes default index transaction-detail
Index	Monitoring Index Name. ( Default is transaction-detail)
Continue on error	The option to continue if an error occurs during logging is selected.

_{Note: * Fields selected with are required, others are optional.}

You can use the Log message in json format as shown in the example.

{ “cityCode” : “IST”, “cityName” : “Istanbul” } ${LogMessage}

You can use the Log message in text format as shown in the example.

customLog2

You can use the Index as shown in the example.

custom-logger-test

Windows System

Windows System activities allow users to conduct a number of operations in Windows.

Is window exists

The “Is window exists” activity checks if a specified window is currently open on the screen.

*Window title	Title of the window to work on. It supports wildcard (*,?) characters on search operations.
Match type	The desired option can be chosen when searching by Window title.
*Result variable name	The Result variable is used to store the output of the “Window Exists” activity. Type: Boolean Possible Values: `true`: The specified window is found. `false`: The specified window is not found.

_{Note: * Fields selected with are required, others are optional.}

You can use the Window title as shown in the example.

Untitled – Notepad – Matches with values matching the exact title “Untitled – Notepad”

*Note* – Matches with values containing “Note”

*Notepad – Matches with values ending with “Notepad”

Untitled* – Matches with values starting with “Untitled”

You can use the Match type as shown in the examples.

equals starts ends contains HIDE

SHOW

RESTORE

MINIMIZE

MAXIMIXE

Window actions

Windows actions activity allows various operations to be performed on a window.

*Window title	Title of the window to work on. It supports wildcard (*,?) characters on search operations.
Window action	Type of action to be performed on the window.

_{Note: * Fields selected with are required, others are optional.}

You can use the Window title as shown in the example.

Untitled – Notepad – Matches with values matching the exact title “Untitled – Notepad”

*Note* – Matches with values containing “Note”

*Notepad – Matches with values ending with “Notepad”

Untitled* – Matches with values starting with “Untitled”

You can use the Window action as shown in the examples.

ACTIVATE

HIDE

SHOW

RESTORE

MINIMIZE

MAXIMIXE

Get Active Window Title

The “Get Active Window Title” activity finds the title of the window that was active while the process was running.

*Active window title

Variable name used to store the active window title

_{Note: * Fields selected with are required, others are optional.}

You can use the Active window title name as shown in the example.

storeTitle

Generate random password

Generate random password activity is used to create a unique password.

Password length	Password length to be generated.
Uppercase count	Uppercase count to be generated.
Lowercase count	Lowercase count to be generated.
Numeric char count	Numeric char count to be generated.
Special char count	Special char count to be generated.
*Password	Result variable name of the generated secure password.

_{Note: * Fields selected with are required, others are optional.}

You can use the Password length as shown in the example.

15

You can use the Uppercase count as shown in the examples.

3

You can use the Lowercase count as shown in the examples.

2

You can use the Numeric char count as shown in the examples.

2

You can use the Special char count as shown in the examples.

2

You can use the Special char count as shown in the examples.

Password

Set secured value

Set secured value activity allows that the information defined in the Orchestrator Secured key module is used in the process.

*Secure value	The variable name to which the information is assigned.
*Key	The Vault value is invoked.

_{Note: * Fields selected with are required, others are optional.}

You can use the Secure value as shown in the example.

secureValue

You can use the Key count as shown in the examples.

vault(TEST,TEST)

Get credential

Get credential activity retrieves information of Generic Credentials defined in Windows Credential Manager.

*Generic credential name	Credential name.
*Result variable name	Result variable name of the credential.

_{Note: * Fields selected with are required, others are optional.}

You can use the Generic credential name as shown in the example.

test2.gmail

You can use the Result variable name as shown in the examples.

credentialResult

Schedule

Schedule activities provide the planning of another process and / or itself within the processes (in terms of working frequency, runtime, start-end dates, etc.). In this way, each process and / or itself can be planned in small pieces if desired.

Schedule process

It enables different processes and/or itself to be triggered within a process, at the desired frequency, time, start and end interval. Each triggered process runs by specifing the desired time period like a small process (Child process).

Run once	It allows the process to be run once. This field is selected depending on the usage.
Run immadiately	Allows the process to run immediately. This field is selected depending on the usage.
*Process key	The “Model Key” information of the process to be triggered is entered. The Model Key field is the field filled in while creating the process.
App key	“App key” information is entered in this field. App key also must containt level keys. Lower dash(_) must be written from top to lower level. Example ; TopLevel_MiddleLevel_SubLevel_Appkey
Priority	Set the priority order of the processes. Example ; 40
Quartz definition	This field is used to specify how often, when / in what time frame the process will run. The expression to be written in this field must be in the form of a Cron expression called “CRON/CRONTAB Expressions”.
Start date	The start date of the process to be triggered is entered. Date and time that will be entered can’t be older than the time when process run. It can be scheduled for a future date.
End date	The expiration date of the process to be triggered is entered.
Worker name	Name of the worker. Example ; MyWorker
Retry count	The number of attempts is written, can be any numeric value.
Parameters	The parameters to be sent to the triggered process are written in JSON format. JSON format allows more than one variable to take value and send it to the relevant process as parameters.

_{Note: * Fields selected with are required, others are optional.}

You can use the Process key as shown in the example.

ICU_Process

You can use the Quartz Definition as shown in the example.

0 * *? * * // – By writing this statement, the process is run every minute. Details and different examples of Cron/Crontab expressions are given below.

You can use the Start date as shown in the example.

YYYY-MM-DD HH:mm:ss

You can use the End date as shown in the example.

YYYY-MM-DD HH:mm:ss

You can use the Worker name as shown in the example.

MyWorker

You can use the Parameters as shown in the example.

In this example, let’s assume that there is an expression written in JSON format as {“from”: “${sender}”, “to”: “${recipient}”, “message”: “${message}”} in the parameters field. In this expression, it is seen that more than one variable to be created according to usage is created and takes values. The “from, to, message” expressions in the expression show how many variables will be used in the process to be triggered. These naming can be made upon request. The values of these variables are the expressions shown as “${sender}, ${recipient}, ${message}”. These values will be sent as parameters to the triggered process and will be used as variables in the process with the same name.

Cron/Crontabs expressions allow command, script and app to run in the specified time or time interval. By using these expressions in Scheduled process, time management can made easily.

Cron/Crontabs expressions consist of characters like *(asterisk), number, over-bar(-) etc. Each character has a different meaning. Parts that will not be used are expressed with * (Asterisk).

Example 1: Let’s create a crontab expression that will run every 10 minutes.

.——————- Second (0 – 59)
| .—————- Minute (0 – 59)
| | .————- Hour (0 – 23)
| | | .———- Day of the month (1 – 31)
| | | | .——- Month (1 – 12)
| | | | | .—- Weekdays (0 – 6) (Sunday=0 or 7)
| | | | | | |- Year
* * * * * * // The crontab command to run

Example 2: Let’s create a crontab expression that will run every midday at 12:00 and every evening at 18:00.

Let the Crontab expression 00 09-18 * * * *
00 – Every hour (00 clock start)
09-18 – From 9 A.M to 18 P.M (09, 10, 11, 12, 13, 14, 15, 16, 17, 18)
* – Every day
* – Every month
* – Weekdays
* – Year

Example 3: Let’s create a crontab expression that will run every at 12:00 noon and 18:00 p.m.

Let the Crontab expression 00 09-18 * * 1-5
00 – Every hour (00 clock start)
09-18 – From 9 A.M to 18 P.M every hour (09, 10, 11, 12, 13, 14, 15, 16, 17, 18)
* – Every day
* – Every month
1-5 – Monday (1), Tuesday (2), Wednesday (3), Thursday (4), Friday (5)
* – Year

If we detail the examples above and increase them

Statement	Explanation	Second	Minute	Hour	Month	Day of Week	Year
*** * * ? * ***	Every second	*	*	*	?	*	*
0 * * ? * *	Every minute	0	0	*	?	*	*
0 /2 ? * *	Every couple of minutes (2,4,…)	0	*/2	*	?	*	*
0 1/2 * ? * *	Every single minute (1, 3,…)	0	1/2	*	?	*	*

Can create those expressions.

For detailed information, visit https://www.freeformatter.com/cron-expression-generator-quartz.html#crongenerator.

Ssh

Ssh activities connect to a server and allows some file and command operations to be performed on the server.

Connect

Connect activity is used for connecting to a Ssh server.

*Session name	Reference name of session which will be connected.
*Username	The name of user who will connect to server.
*Password	The password of user who will connect to server.
*Host	The IP of server that will be connected.
Port	The port number of server that will be connected.

_{Note: * Fields selected with are required, others are optional.}

You can use the Session name as shown in the example.

testSession

You can use the Username as shown in the example.

robusta

You can use the Password as shown in the example.

sifre12345

You can use the Host as shown in the example.

192.10.1.1

You can use the Post as shown in the example.

The default port number is 22.

22

Execute command

Execute command activity is used for executing Linux commands in server.

*Session name	Reference name of session which is given in Connect activity.
*Command	Command to be executed in server.
*Timeout (sec)	Sets timeout period for generating error message and ending the process.
Command result	If there is a value of command field, it is assigned to name referenced.

_{Note: * Fields selected with are required, others are optional.}

You can use the Session name as shown in the example.

testSession

You can use the Command as shown in the example.

ssh test.server.com

You can use the Timeout (sec)as shown in the example.

8

You can use the Command result as shown in the example.

pwdResult

Get file

Get file activity is used for downloading the specified file from server.

*Session name	Reference name of session which will is given in the Connect activity.
*Remote file name	Path of the remote file name that will be downloaded.
“Local file name	Path of the local file name for downloaded files.
Overwrite	Overwrite if there is a file or folder with the same name.

_{Note: * Fields selected with are required, others are optional.}

You can use the Session name as shown in the example.

testSession

You can use the Remote file name as shown in the example.

/home/username/TestFolder/Get_File_Test.txt

You can use the Local file name as shown in the example.

C:Temp

Put file

Put file activity is used for uploading the specified file to server.

*Session name	Reference name of session which will be give in the Connect activity.
*Local file name	Path of the local file name that will be downloaded.
*Remote file name	Path of the remote file name for downloaded files.
Overwrite	Overwrite if there is a file or folder with the same name.

_{Note: * Fields selected with are required, others are optional.}

You can use the Session name as shown in the example.

testSession

You can use the Local file name as shown in the example.

C:TempGet_File_Test.txt

You can use the Remote file name as shown in the example.

/home/username/TestFolder/

Disconnect

Connect activity is used for disconnecting from a Ssh server.

*Session name

Reference name of session which will be connected.

_{Note: * Fields selected with are required, others are optional.}

You can use the Session name as shown in the example.

${testSession}

Ftp

Ftp activities enable users to perform different operations like creating file, copying file and renaming.

Connect

Connect activity enables to connect to FTP server.

*Connection name	Reference name of connection that will be connected.
Username	FTP username.
Password	FTP password.
Private key file	Private key file name with path.
*Host	Host information.
*Port	The information of FTP connection point (port).
Is secure	If connection is secure then connection type will be sftp, else connection type will be ftp.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

ftpConnection

You can use the Username as shown in the example.

robustaserver

You can use the Password as shown in the example.

Password123

You can use the Private key fileas shown in the example.

C:UsersDocumentsppFile.ppk

You can use the Host as shown in the example.

10.10.10.10

You can use the Port as shown in the example.

22

If connection is secure then port cannot be 21 and if connection is not secure then port cannot be 22.

You can use the Is secure as shown in the example.

True

If connection is secure then connection type will be sftp, else connection type will be ftp.

Create directory

Create directory activity is used for creating a new directory.

“Connection name	Reference name of connection which will be connected.
*Directory name	Directory name with path.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

${ftpConnection}

You can use the Directory name as shown in the example.

/home/Temp/Test

Change directory

Change directory activity is used for changing current directory.

“Connection name	Reference name of connection which will be connected.
*Directory name	Destination path without a file or folder name.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

${ftpConnection}

You can use the Directory name as shown in the example.

/home/Temp/Test

Rename

Rename activity is used for changing file or folder name in FTP server.

“Connection name	Reference name of connection which will be connected.
*Current name	Current name of file or folder with path.
*New name	New name of file or folder with path.
Overwrite	Overwrite if there is a file or folder with same name.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

${ftpConnection}

You can use the Current name as shown in the example.

/home/Temp/Test

You can use the New name as shown in the example.

/home/Temp/Test2

You can use the Overwrite as shown in the example.

True

Download

Download activity is used for downloading a file in FTP server.

“Connection name	Reference name of connection which will be connected.
*Remote file name	Path of the remote file name that will be downloaded.
*Local file name	Path of the local file name for downloaded files.
Overwrite	Overwrite if there is a file or folder with same name.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

${ftpConnection}

You can use the Remote file name as shown in the example.

/home/Temp/ftpTest.xlsx

You can use the Local file name as shown in the example.

C:TempTestftpTest.xlsx

You can use the Overwrite as shown in the example.

True

Upload

Upload activity is used for uploading a file to FTP server.

“Connection name	Reference name of connection which will be connected.
*Local file name	Path of the local file name that will be uploaded.
*Remote file name	Path of the remote file name for uploaded files.
Overwrite	Overwrite if there is a file or folder with same name.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

${ftpConnection}

You can use the Local file name as shown in the example.

C:TempTestftpTest.xlsx

You can use the Remote file name as shown in the example.

/home/Temp/ftpTest.xlsx

You can use the Overwrite as shown in the example.

True

Delete

Delete activity is used for deleting a file or folder in FTP server.

“Connection name	Reference name of connection which will be connected.
*File name	File name with path.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

${ftpConnection}

You can use the File name as shown in the example.

/home/Temp/Test/ftpTest.xlsx

List files

List files activity is used for listing the file names in specified location.

“Connection name	Reference name of connection that will be connected.
*Directory name	Directory name with path.
*Dataset name	Reference name of the dataset which will be created.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

${ftpConnection}

You can use the Directory name as shown in the example.

✔ C:RobustaTempExpressInvoice

Don’t forget to put “” at the end

✖ ~~C:RobustaTempExpressInvoice~~

You can use the Dataset name as shown in the example.

ftpList

File exists

File exists activity is used for checking if a file exists or not in FTP server.

“Connection name	Reference name of connection which will be connected.
*File name	File name with path.
Result variable name	Variable of the return value.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

${ftpConnection}

You can use the File name as shown in the example.

/home/Temp/Test/ftpTest.xlsx

You can use the Result variable name as shown in the example.

fileExist

If there is a value in file location, it returns True; if not, it returns False.

Disconnect

Disconnect activity enables to disconnect from FTP server.

*Connection name

Reference name of connection that will be connected.

_{Note: * Fields selected with are required, others are optional.}

You can use the Connection name as shown in the example.

${ftpConnection}/direction]

Cryptography

Cryptography activities are used to communicate securely in the presence of third parties.

Encryption

Encryption activity ensures that an intelligible data is made incomprehensible with the encryption method. Encryption is a double-sided encryption method, that is, an encrypted data can be decrypted with a key.

*Plain text	Unencrypted string is written.
*Encryption type	The method to be encrypted is selected.
*Result cipher text	The variable name of the directory that we want to be encrypted is written in an encrypted way.
*Key	Key information of the data to be encrypted is given.

_{Note: * Fields selected with are required, others are optional.}

You can use the Plain text as shown in the examples.

Hello, this is the text string I want encrypted.

You can use the Encryption type as shown in the examples.

AES

DES

TripleDES

You can use the Result cipher text as shown in the example.

decryptionData

You can define a key from using Generate key activity or you can define a key from using any key creator tool.

AES accepts 16 or 32 bits keys.

DES accepts 8 bits keys.

TripleMES accepts 24 bits keys.

Decryption

Decryption activity ensures that a data that has been rendered incomprehensible by the encryption method is made comprehensible.the encryption method. Encryption is a double-sided encryption method, that is, an encrypted data can be decrypted with a key.

*Ciper text	This is the field where the encrypted variable name should be written in the Encryption activity.
*Decryption type	The encrypted method is selected.
*Result plain text	It is the variable field where the decrypted data will be written.
*Key	The key information given in the Encryption activity is given in the same way.

_{Note: * Fields selected with are required, others are optional.}

You can use the Cliper text as shown in the examples.

${encryptedData}

You can use the Decryption type as shown in the examples.

AES

DES

TripleDES

You can use the Result plain text as shown in the example.

encryptedData

Caution

You must use the same key in the Encryption activity.

You can define a key from using Generate key activity or you can define a key from using any key creator tool.

AES accepts 16 or 32 bits keys.

DES accepts 8 bits keys.

TripleMES accepts 24 bits keys.

Hash

Hash activity ensures that an intelligible data is made incomprehensible with the encryption method. Hashing is a one-sided encryption method, that is, an encrypted data cannot be recovered. It is mostly used in comparison situations.

*Plain text	Unencrypted string is written.
*Hash type	The method to be encrypted is selected.
*Result cipher text	Enter the name of the variable that we want the directory to be encrypted in an encrypted way.
*Key	Key information of the data to be encrypted is given.

_{Note: * Fields selected with are required, others are optional.}

You can use the Plain text as shown in the examples.

Hello, this is the text string I want encrypted.

You can use the Hash type as shown in the examples.

MD5

HmacSHA512

You can use the Result cipher text as shown in the example.

encryptedData

You can use the Key as shown in the examples.

MD5: Desired lenght

HmacSHA512: Desired lenght

Generate key

Generate key activity allows to generate encryption key. An encryption key is a random string of bits generated to scramble and decrypt data.

*Encription type	The method to create the key is selected.
*Result key	The name of the variable whose key is to be transferred.

_{Note: * Fields selected with are required, others are optional.}

You can use the Encryption as shown in the examples.

AES

DES

TripleDES

You can use the Result key as shown in the example.

generatedKey

Computer Vision

Computer Vision activites are used to perform operations that a human can do visually with a computer system.

Get dominant color

Get dominant color activity finds the dominant color in an image so that images can be categorized by color.

*Image file name	Image file name with path.
*Result variable name	Variable name to be created.

_{Note: * Fields selected with are required, others are optional.}

You can use the Image file name as shown in the examples.

C:TempmyImage.jpg

You can use the Result variable name as shown in the examples.

newVariable

Image matching

Image matching activity is used to search for an image on a given source image. Starting from the X-Y point on the image, a search is made in an area equal to the determined width and height. If there is a match, the coordinate (X-Y) of the center point of the searched image on the searched image and the width/height values are assigned to the determined result variables. When x-position, y-position, width and height values aren’t entered, a search is made in the whole image.

*Source image	Source image file name with path.
*Source image Base64	Source image with base64 string. If image and its path are given in Source image field, Source image Base64 must not be used. In case of using it, an error will be returned.
*Searched image	File name and path of the image to be searched.
*Searched image Base64	Searched image with base64 string.
X-coordinate	If it is desired to limit the image to be searched on the screen within a certain area; this field must be filled in, along with the Y-coordinate, Height, and Width fields.
Y-coordinate	If it is desired to limit the image to be searched on the screen within a certain area; this field must be filled in, along with the X-coordinate, Height, and Width fields.
Width	If it is desired to limit the image to be searched on the screen within a certain area; this field must be filled in, along with the X-coordinate, Y-coordinate and Height fields.
Height	If it is desired to limit the image to be searched on the screen within a certain area; this field must be filled in, along with the X-coordinate, Y-coordinate and Width fields.
Start scale	If it is desired to try again when the searched image is not found on the image, the Start Scale field is filled. Specifies the start scale. Scale statements are double-type numbers (0.1, 0.5, 2.0).
End scale	If it is desired to try again when the searched image is not found on the image, the Start Scale field is filled. Specifies the end scale. Scale statements are double-type numbers (0.1, 0.5, 2.0).
Scale step	If it is desired to try again when the searched image is not found on the image, the Start Scale field is filled. Specifies the progression coefficient. Specifies the progression coefficient.
Match score	Images are matched if their similarity percentage is higher than the match score.
*Return x-position	If the image matches, the x-coordinate of the center point of the searched image is assigned to this variable.
*Return y-position	If the image matches, the y-coordinate of the center point of the searched image is assigned to this variable.
*Return height	If the image matches, the height of the center point of the searched image is assigned to this variable.
*Return width	If the image matches, the width of the center point of the searched image is assigned to this variable.

_{Note: * Fields selected with are required, others are optional.}

You can use the Source image as shown in the examples.

C:Robustarobusta.png

You can use the Source image Base64 as shown in the example.

iVBORw0KGgoAAAANSUhEUgAA…

You can use the Searched image as shown in the example.

C:Robustarobusta_logo.png

You can use the Searched image Base64 as shown in the examples.

iVBORw0KGgoAAAANSUhEUgAA…

You can use the X-coordinate as shown in the examples.

250

You can use the X-coordinate as shown in the examples.

170

You can use the Width as shown in the examples.

100

You can use the Width as shown in the examples.

75

You can use the Start scale as shown in the examples.

1.0

You can use the End scale as shown in the examples.

2.0

You can use the End scale as shown in the examples.

0.1

You can use the Match score as shown in the example.

0.80

You can use the Return x-position as shown in the examples.

x

You can use the Return y-position as shown in the examples.

y

You can use the Return height as shown in the examples.

h

You can use the Return width as shown in the examples.

w

The values for height and width must be an integer.

Compare histogram

Compare histogram activity is used to find similarity in images based on RGB values.

*Image 1	It is the field where the index information, file name and extension of the image to be compared are entered.
*Image 2	It is the field where the index information, file name and extension of the image to be compared are entered.
*Result variable name	The name of the variable to which the comparison result is to be transferred. The returned value is the percentage value (70.82, 50.0).

_{Note: * Fields selected with are required, others are optional.}

You can use the Image 1 as shown in the example.

C:RobustablueCar.png

You can use the Image 2 as shown in the example.

C:Robustalandscape.png

You can use the Result variable name as shown in the example.

histogramValue

Text matching

The “Text Matching” activity uses optical character recognition (OCR) technology to locate and match specific text within a target area on the screen. This activity is useful for automating tasks that involve interacting with text in images or on the screen.

*Source image	Source image file name with path.
*Source image Base64	Source image with base64 string.
*Text	Specifies the exact text string that the activity should search for within the target area. This text is used by the OCR engine to locate matching text on the screen.
Language	Specifies the language of the text to be recognized by the OCR engine. Setting the appropriate language improves the accuracy of text recognition. ENG / TR
X-coordinate	If it is desired to limit the text to be searched on the screen within a certain area; this field must be filled in, along with the Y-coordinate, Height, and Width fields.
Y-coordinate	If it is desired to limit the text to be searched on the screen within a certain area; this field must be filled in, along with the X-coordinate, Height, and Width fields.
Width	If it is desired to limit the image to be searched on the screen within a certain area; this field must be filled in, along with the X-coordinate, Y-coordinate and Height fields.
Height	If it is desired to limit the image to be searched on the screen within a certain area; this field must be filled in, along with the X-coordinate, Y-coordinate and Width fields.
Retry count	The number of tries until the image is found, could be any numeric value.
*Return x-position	If the text matches, the x-coordinate of the center point of the searched text is assigned to this variable.
*Return y-position	If the text matches, the y-coordinate of the center point of the searched text is assigned to this variable.

_{Note: * Fields selected with are required, others are optional.}

You can use the Source image as shown in the examples.

C:Robustarobusta.png

You can use the Source image Base64 as shown in the example.

iVBORw0KGgoAAAANSUhEUgAA…

You can use the Text as shown in the example.

Submit

You can use the X-coordinate as shown in the examples.

250

You can use the X-coordinate as shown in the examples.

170

You can use the Width as shown in the examples.

100

You can use the Width as shown in the examples.

75

You can use the Return x-position as shown in the examples.

x

You can use the Return y-position as shown in the examples.

y

The values for height and width must be an integer.

Count non zero

Count non zero activity shows the black and white dispersion ratio in image files.

*Input image	File name with path.
*Result variable name	The dispersion ratio is assigned to this variable.

_{Note: * Fields selected with are required, others are optional.}

You can use the Input image as shown in the example.

C:RobustaCar.png

You can use the Result variable name as shown in the example.

{“ratio”:1.3,”black”:6,”white”:450}

Mean

Mean activity finds the mean value of the RGB values, in other words, returns RGB color distribution in image.

*Input image	File name with path.
*Result variable name	It is the variable to which black and non black pixels in an image will be assigned.

_{Note: * Fields selected with are required, others are optional.}

You can use the Input image as shown in the example.

C:RobustablueCar.png

You can use the Result variable name as shown in the example.

{“blue”:128.55,”green”:128.55,”red”:128.55}

Base64 encoder

Base64 encoder activity converts an image file to base64 format.

*File name	File name with path.
*Result base64 file name	Result base64 file name.

_{Note: * Fields selected with are required, others are optional.}

You can use the File name as shown in the example.

C:RobustablueCar.png

Captcha solver (AzCAPTCHA)

Captcha is a service used for the analysis of security measures used for human and computer separation. Captcha solver activities solves captcha’s and returns the results.

AzCAPTCHA activity, uses AZcaptcha’s automated online captcha solver API service. You need an account and make payment to use Azcaptha’s services. You can find detailed information about creating an account and payment options from Azcaptcha’s website.

*Captcha key	API key of AzCAPTCHA’s subscription.
*File	Path, name and extension of image that will be solved.
*Response variable name	Variable name to store image that is solved.

_{Note: * Fields selected with are required, others are optional.}

You can use the Captcha key as shown in the example.

asds8dfcsf125dsdsfds5dasdasa3tyf

You can use the File as shown in the example.

C:SampleRobustacaptcha.png

You need to give the file path of image the captcha. To do that you need to download the capthca image to worker’s local file system. You can download the image using “Take Capture” activity, “Download File” activity or “Save screen capture” activity whichever is suitable for your process.

You can use the Response variable name as shown in the example.

captchaResult

AzCAPTCHA activity only solve image captchas. You cannot solve Google Recaptcha captchas with AzCAPTCHA activity. To solve Google Recaptcha’s you need use Captcha solver (ReCAPTCHA) activity.

Captcha solver (BestCAPTCHA)

Captcha is a service used for the analysis of security measures used for human and computer separation. Captcha solver activities solves captcha’s and returns the results.

BestCaptcha activity, uses BestCaptcha’s automated online captcha solver API service. You need an account and add credit to use BestCaptcha’s services. You can find detailed information about creating an account and payment options from BestCaptcha’s website.

*Access token	API key of BestCaptcha’s subscription.
*Template	Image file name with path or base64 string.
Case sensitive	(True/False) Uppercase and lowercase letters are treated as distinct of equivalent.
*Response variable name	Variable name to store image that is solved.

_{Note: * Fields selected with are required, others are optional.}

You can use the Access token as shown in the example.

asds8dfcsf125dsdsfds5dasdasa3tyf

You can use the Template as shown in the example.

C:SampleRobustacaptcha.png

You need to give a file path of image the captcha or you need to enter the base64 string of the captcha image. To do that you need to download the capthca image to worker’s local file system. You can download the image using “Take Capture” activity, “Download File” activity or “Save screen capture” activity whichever is suitable for your process. You can also use the “Base64 encoder” activity to create the base64 string.

You can use the Response variable name as shown in the example.

captchaResult

BestCapthca activity only solve image captchas. You cannot solve Google Recaptcha captchas with BestCaptcha activity. To solve Google Recaptcha’s you need use Captcha solver (ReCAPTCHA) activity.

Captcha solver (ReCAPTCHA)

Captcha is a service used for the analysis of security measures used for human and computer separation. Captcha solver activities solves captcha’s and returns the results.

ReCaptcha activity, uses BestCaptcha’s automated online captcha solver API service. You need an account and add credit to use BestCaptcha’s services. You can find detailed information about creating an account and payment options from BestCaptcha’s website.

*Application name	Name of application which has already been opened or attached.
*Access token	API key of BestCaptcha’s subscription.
Recaptcha field	The XPath of the HTML element containing the recaptcha id used in the website is written. By inspecting the page, the element containing the recaptcha data-sitekey tag is searched and the XPath of that element is obtained.
Submit button field	In this optional field, if it is necessary to press the submit button after the recaptcha is resolved (in some sites, it is necessary not to press it so that the recaptcha is not reset), the XPath of this button is entered.
Callback function name	This optional field is used for solving Hidden recaptcha. It can be needed in the background recaptchas on the site.

_{Note: * Fields selected with are required, others are optional.}

You can use the Application name as shown in the example.

${myApp}

You can use the Access token as shown in the example.

70EBF…..

You can use the Recaptcha field as shown in the example.

//*[@id=”g-recaptcha”]

You can use the Submit button field as shown in the example.

//*[@id=”automation..]

You can use the Callback function name field as shown in the example.

check

Note: This optional field is used to solve the hidden recaptcha. It may be needed in the background recaptchas on the site. In some cases, after the recaptcha is resolved, pressing the submit button resets the recaptcha and starts again. In order to avoid this situation, a javascript function needs to be triggered in the background after the captcha is successfully resolved. It is necessary to write the name of this function in this field, and the name of the function appears in the element tag named data-callback. In this example you can see that “data-callback” equals to “check”, it may get various names on other websites.

Barcode reader

Barcode reader activity finds and analyzes the barcode on the given image.

*Image file name	Image file name with path.
*New dataset name	Reference name of dataset which will be created.

_{Note: * Fields selected with are required, others are optional.}

You can use the Image file name as shown in the example.

C:Robustabarcode.png

You can use the New dataset name as shown in the example.

barcodeResult

Barcode reader activity returns dataset since the activity reads more than one barcode in a given image at the same time. Barcodes are assigned to variable by getting through dataset.

QR code reader

QR code reader activity finds and analyzes the QR code on the given image.

*Image file name	Image file name with path.
*Response variable name	Variable name to store QR code value.

_{Note: * Fields selected with are required, others are optional.}

You can use the Image file name as shown in the example.

C:Robustaqr.png

You can use the Response variable name as shown in the example.

qrResult

Get largest rectangle

Get largest rectangle activity is used for getting the largest rectangle-shaped object in an image.

*Image file name	Name and path of image file.
*Return x-position	Final x-position, variable name defined to assign the x-coordinate found.
*Return y-position	Final y-position, variable name defined to assign the y-coordinate found.
*Return width	Final width, variable name defined to assign the width found.
*Return height	Final height, variable name defined to assign the heightfound.

_{Note: * Fields selected with are required, others are optional.}

You can use the Image file image as shown in the example.

C:Robustarobusta.png

You can use the Return x-position as shown in the example.

xPositonvalue

You can use the Return y-position as shown in the example.

yPositonvalue

You can use the Return width as shown in the example.

widthValue

You can use the Return height as shown in the example.

heightValue

You can use Return x-position and Return y-position variables in Mouse activity in Keyboard & Mouse Operations.

In the example above, the coordinates of the text specified in the Text field will be scanned and a value will be returned to the xPositionValue and yPositionValue variables (For example: 300,280). When we select LEFT_CLICK from the combobox in the Action field of the Mouse Activity and write these returned variables as $ {xPositionValue} and $ {xPositionValue} into the X Position and Y Position fields, the returned values 300 and 280 will be used in the Mouse activity with the variable. As a result of the operation, left mouse click will be performed on the text specified in the Text field.

base64 decoder

Base64 decoder activity decodes an image from base64 format.

*Base64 string	base64 string that will be converted to an image file.
*Result file name	Name and path of image file that will be decoded from base64 string.

_{Note: * Fields selected with are required, others are optional.}

ebfbnrjrygw354646ıkghascagsr

You can use the Result file name as shown in the example.

C:RobustablueCar.png

Get dimensions

Get dimensions activity is used getting the dimensions of an image file.

*Image file name	Name and path of image file.
*Return width	Final width, variable name defined to assign the width found.
*Return height	Final height, variable name defined to assign the heightfound.

_{Note: * Fields selected with are required, others are optional.}

You can use the Image file image as shown in the example.

C:Robustarobusta.png

You can use the Return width as shown in the example.

widthValue

You can use the Return height as shown in the example.

heightValue

MRZ reader

MRZ reader activity is used for reading MRZ field in passports and id cards.

*MRZ string	MRZ string value.
*Image file name	Path and name of image file.
*Response variable name	Variable name to store HTTP response.

You can use the MRZ string as shown in the example.

I<NATSURNAME<<NAME1<NAME2<<<<<<<<<<<1234567890NAT1212920F1212150<<<<<<<0

You can use the Image file name as shown in the example.

C:RobustaCar.png

You can use the Response variable name as shown in the example.

httpVariable

An example response is as follows.

"checkDateOfBirth":"2","country":"UTO","checkNumber":"6","checkPersonalNumber":"1","serialNumber":"18","documentNumber":"98902C3","sex":"F","dateOfBirth":"740812","personalNumber":"ZE184226B<<<<<","type":"P<","number":"1898902C3","checkExpirationDate":"9","names":"ANNA MARIA","nationality":"UTO","checkComposit":"0","surname":"ERIKSSON","mrzString":"P<UTOERIKSSON<<ANNA<MARIA<<<<<<<<<<<<<<<<<<<n1898902C36UT07408122F1204159ZE184226B<<<<<10n","expirationDate":"120415"}"

Image Processing

Image Processing activities enable users to process or enhance images.

Gray scale

Gray scale activity is a method to convert an image to black&white or monochrome.

*Input image	Path file name and extension of the image that will be processed.
*Output image	Path, file name and extension of the image that is processed

_{Note: * Fields selected with are required, others are optional.}

You can use the Input image as shown in the example.

C:TempRobustarobusta.jpg

You can use the Output image name as shown in the example.

C:TempRobustagrayscale.jpg

Threshold

Threshold activity is used for increasing or decreasing noise in images.

*Input image	Path file name and extension of the image that will be processed.
*Output image	Path, file name and extension of the image that is processed.
Threshold type	Methods for increasing or decreasing noise in images.
Minimum value	Minimum value of threshold coefficient range.
Maximum value	Maximum value of threshold coefficient range.

_{Note: * Fields selected with are required, others are optional.}

You can use the Input image as shown in the example.

C:Robustarobusta.jpg

You can use the Output image name as shown in the example.

C:Robustagrayscale.jpg

You can use the Threshold type as shown in the examples.

Thresh_Binary : The threshold value is compared to each pixel’s value in the image, and pixels that exceed a certain threshold value are set to white while the remaining pixels are set to black.

Thresh_Binary_Inv : The threshold value is compared to each pixel’s value in the image, and pixels that exceed a certain threshold value are set to black while the remaining pixels are set to white.

Thresh_Trunc : The threshold value is compared to each pixel’s value in the image, and pixels that exceed a certain threshold value are set to this threshold value, while higher pixel values are preserved

Thresh_Tozero : The threshold value is compared to each pixel’s value in the image, and pixels that exceed a certain threshold value are preserved, while the remaining pixels are set to zero

Thresh_Tozero_Inv : The threshold value is compared to each pixel’s value in the image, and pixels that exceed a certain threshold value are set to zero, while the remaining pixels are preserved

Thresh_Otsu : The Otsu threshold determines an optimal threshold value using a histogram analysis method to achieve the best separation of object pixel density in the image

You can use the Minimum value as shown in the example.

50

The default value is 50.

You can use the Maximum value as shown in the example.

255

The default value is 255.

INPUT

OUTPUTS

Note: The maximum value is 255 and the min value is 170.

Note: The maximum value is 255 and the min value is 170.

Note: The maximum value is 255 and the min value is 170.

Note: The maximum value is 255 and the min value is 170.

Note: The maximum value is 255 and the min value is 170.

Blur

Blur activity is used for applying blurring effects to images.

*Input image	Path file name and extension of the image that will be processed.
*Output image	Path, file name and extension of the image that is processed.
Blur type	The methods to increase or decrease blurring on image.
Blur coefficient	Image gets more blurry as the blur coefficient increases.
X-coordinate	X-coordinate of the area to be edited or cropped.
Y-coordinate	Y-coordinate of the area to be edited or cropped.
Width	Width of the area to be edited or cropped.
Height	Height of the area to be edited or cropped.

_{Note: * Fields selected with are required, others are optional.}

You can use the Input image as shown in the example.

C:Robustarobusta.jpg

You can use the Output image name as shown in the example.

C:Robustagrayscale.jpg

You can use the Blur type as shown in the example.

Homogeneous_Blur : Homogeneous Blur averages each pixel’s value with its neighboring pixels.

Gaussian_Blur : Gaussian Blur convolves each pixel’s value with a Gaussian kernel to blur the image.

Median_Blur : Median Blur replaces each pixel’s value with the median of its neighboring pixels.

You can use the Blur coefficient as shown in the example.

9

The default value is 9.

You can use the X-coordinate as shown in the example.

86

You can use the Y-coordinate as shown in the example.

100

You can use the Width as shown in the example.

67

You can use the Height as shown in the example.

67

Sharpen

Sharpen activity is used for increasing or decreasing the sharpness of image.

*Input image	Path file name and extension of the image that will be processed.
*Output image	Path, file name and extension of the image that is processed.
Sharpen coefficient	Image gets sharper as the sharpen coefficient increases.

_{Note: * Fields selected with are required, others are optional.}

You can use the Input image as shown in the example.

C:Robustarobusta.jpg

You can use the Output image name as shown in the example.

C:Robustagrayscale.jpg

You can use the Sharpen coefficient as shown in the example.

7

The default number is 7.

Brighten

Brighten activity is used for increasing or decreasing the brighten of image.

*Input image	Path file name and extension of the image that will be processed.
*Output image	Path, file name and extension of the image that is processed.
Brightness level	Image gets brighter as the brightness level increases, value range is between 1 and 255. Image gets darker as the brightness level decreases for negative values, value range is between -255 and -1.

_{Note: * Fields selected with are required, others are optional.}

You can use the Input image as shown in the example.

C:Robustarobusta.jpg

You can use the Output image name as shown in the example.

C:Robustagrayscale.jpg

You can use the Brightness level as shown in the example.

50

Contrast

Contrast activity is used for increasing or decreasing image contrast.

*Input image	Path file name and extension of the image that will be processed.
*Output image	Path, file name and extension of the image that is processed.
Contrast Level	Image becomes brighter as the contrast level increases.

_{Note: * Fields selected with are required, others are optional.}

You can use the Input image as shown in the example.

C:Robustarobusta.jpg

You can use the Output image name as shown in the example.

C:Robustagrayscale.jpg

You can use the Contrast level as shown in the example.

Values from 1 to 255 can be entered to increase the picture contrast.

177

A value from 1 to 0 can be entered to reduce the picture contrast.

0.5

Default Value is 1.2

Erode

Erode (erosion) activity is used to make thin the areas in the image.

*Input image	Path file name and extension of the image that will be processed.
*Output image	Path, file name and extension of the image that is processed.
Erode coefficient	Image gets more eroded as the erode coefficient increases. Default value is 9.

_{Note: * Fields selected with are required, others are optional.}

You can use the Input image as shown in the example.

C:Robustarobusta.jpg

You can use the Output image name as shown in the example.

C:Robustagrayscale.jpg

You can use the Erode coefficient as shown in the example.

50

Dilate

Dilate (dilation) activity is used to expand the thin-seeming parts.

*Input image	Path file name and extension of the image that will be processed.
*Output image	Path, file name and extension of the image that is processed.
Dilate coefficient	Image gets more dilated as the dilate coefficient increases. Default value is 9.

_{Note: * Fields selected with are required, others are optional.}

You can use the Input image as shown in the example.

C:Robustarobusta.jpg

You can use the Output image name as shown in the example.

C:Robustagrayscale.jpg

You can use the Dilate coefficient as shown in the example.

50

Remove lines

Remove lines activity is used for removing lines in image.

*Input image	Path file name and extension of the image that will be processed.
*Output image	Path, file name and extension of the image that is processed.
Enhance Text?	If the checkbox is selected, it prevents deformations caused by removing the intersecting lines.

_{Note: * Fields selected with are required, others are optional.}

You can use the Input image as shown in the example.

C:Robustarobusta.jpg

You can use the Output image name as shown in the example.

C:Robustagrayscale.jpg

Deskew

Deskew activity is used for compensating for skewing in scanned images.

*Input image	Path file name and extension of the image that will be processed.
*Output image	Path, file name and extension of the image that is processed.

_{Note: * Fields selected with are required, others are optional.}

You can use the Input image as shown in the example.

C:TempRobustarobusta.jpg

You can use the Output image name as shown in the example.

C:TempRobustadeskew.jpg

Rotate

Rotate activity is used for rotating images.

*Input image	Path file name and extension of the image that will be processed.
*Output image	Path, file name and extension of the image that is processed.
Rotation	Direction that image will be rotated.
Rotation degree	Degree to which the image will be rotated. It must be an integer value between 0-180 and must be used when rotate right or rotate left options are chosen.

_{Note: * Fields selected with are required, others are optional.}

You can use the Input image as shown in the example.

C:Robustarobusta.jpg

You can use the Output image name as shown in the example.

C:Robustagrayscale.jpg

You can use the Rotation as shown in the example.

ROTATE_90_CLOCKWISE : rotates the image 90 degrees clockwise.

ROTATE_180 : rotates the image 180 degrees.

ROTATE_90_COUNTERCLOCKWISE : rotates the image 90 degrees counterclockwise.

You can use the Rotation degree as shown in the example.

45 120

Flip

Flip activity is used to flip images in the mirror direction.

*Input image	Path file name and extension of the image that will be processed.
*Output image	Path, file name and extension of the image that is processed.
Flix axis	Axis that image will be reflected over.

_{Note: * Fields selected with are required, others are optional.}

You can use the Input image as shown in the example.

C:Robustarobusta.jpg

You can use the Output image name as shown in the example.

C:Robustaflipped.jpg

You can use the Flip axis as shown in the example.

Y_AXIS

X_AXIS

X_AND_Y_AXIS

Resize

Resize activity is used for enlarging or reducing image to the desired size.

*Input image	Path file name and extension of the image that will be processed.
*Output image	Path, file name and extension of the image that is processed.
Proportion	Value to resize the image proportionally.

_{Note: * Fields selected with are required, others are optional.}

You can use the Input image as shown in the example.

C:Robustarobusta.jpg

You can use the Output image name as shown in the example.

C:Robustagrayscale.jpg

You can use the Proportion as shown in the example.

1.25

Crop

Crop activity is used for cropping the specified portion of image.

*Input image	Path file name and extension of the image that will be processed.
*Output image	Path, file name and extension of the image that is processed.
X-coordinate	X-coordinate of the area to be edited or cropped.
Y-coordinate	Y-coordinate of the area to be edited or cropped.
Width	Width of the area to be edited or cropped.
Height	Height of the area to be edited or cropped.

_{Note: * Fields selected with are required, others are optional.}

You can use the Input image as shown in the example.

C:Robustarobusta.jpg

You can use the Output image name as shown in the example.

C:Robustagrayscale.jpg

You can use the X-coordinate as shown in the example.

120

You can use the Y-coordinate as shown in the example.

250

You can use the Width as shown in the example.

100

You can use the Height as shown in the example.

50

Google Cloud Vision

Google Cloud Vision component uses Google Cloud Vision API. Vision API offers powerful pre-trained machine learning models. To use the Google Cloud Vision component and its activities, you need a Google Cloud account and an appropriate subscription to access the API key. Some of the Google Cloud Vision features are free to use. You can learn more information from Google Cloud Vision documentation. All activity responses are in the JSON format.

Note: Google Vision API only accepts Google Storage files or image files in Base64 formats. You need to upload your local image files to Google Cloud Storage, or you can encode your image files in Base64 format. If you don’t want to use Google Cloud Storage, you can use the Base64 Encoder activity to encode your local image files.

Text detection

Text detection activity detects words from image files. It uses optical character recognition (OCR) technology. The results are JSON format, including the entire extracted string, individual words, and their bounding boxes.

You can find detailed information and documentation about Google Cloud Vision text detection features.

*Api key	Google Cloud Vision API Key
*Image path/url	Image Google Cloud Storage url
*Base64	Image file’s Base64 String
*Response variable name	Variable name to store the http response

Note: You can either use Image path/url or Base64 field in your process.

You can use the Api key as shown in the example.

bb3c53c6-8515-4e34-97c8-8281de60972d

You can use the Image path/url as shown in the example.

gs://cloud-samples-data/vision/ocr/sampleimage.jpg

You can use the Base64 as shown in the example.

/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsKCwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/2wBDAQMEBAUEBQkFBQkUDQsNFBQUF……………./58x/8BX+R/9k=

You can use the Response variable name fileas shown in the example.

getRespone

Object recognition

Object recognition activity can detect and extract multiple object with object localization. Object localization identifies multiple objects in an image and provides a LocalizedObjectAnnotation for each object in the image. Each LocalizedObjectAnnotation identifies information about the object, the position of the object, and rectangular bounds for the region of the image that contains the object.

You can find detailed information and documentation about Google Cloud Vision dedect multiple objects features.

*Api key	Google Cloud Vision API Key
*Image path/url	Image Google Cloud Storage url
*Base64	Image file’s Base64 String
*Response variable name	Variable name to store the http response

Note: You can either use Image path/url or Base64 field in your process.

You can use the Api key as shown in the example.

bb3c53c6-8515-4e34-97c8-8281de60972d

You can use the Image path/url as shown in the example.

gs://cloud-samples-data/vision/ocr/sampleimage.jpg

You can use the Base64 as shown in the example.

/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsKCwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/2wBDAQMEBAUEBQkFBQkUDQsNFBQUF……………./58x/8BX+R/9k=

You can use the Response variable name fileas shown in the example.

getRespone

Image properties detection

Image properties detection activity detects general attributes of the image, such as dominant color.

You can find detailed information and documentation about Google Cloud Vision detect image properties features.

*Api key	Google Cloud Vision API Key
*Image path/url	Image Google Cloud Storage url
*Base64	Image file’s Base64 String
*Response variable name	Variable name to store the http response

Note: You can either use Image path/url or Base64 field in your process.

You can use the Api key as shown in the example.

bb3c53c6-8515-4e34-97c8-8281de60972d

You can use the Image path/url as shown in the example.

gs://cloud-samples-data/vision/ocr/sampleimage.jpg

You can use the Base64 as shown in the example.

/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsKCwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/2wBDAQMEBAUEBQkFBQkUDQsNFBQUF……………./58x/8BX+R/9k=

You can use the Response variable name fileas shown in the example.

getRespone

Face detection

Face detection activity detects multiple faces within an image along with the associated key facial attributes.

You can find detailed information and documentation about Google Cloud Vision detect faces features.

*Api key	Google Cloud Vision API Key
*Image path/url	Image Google Cloud Storage url
*Base64	Image file’s Base64 String
*Response variable name	Variable name to store the http response

Note: You can either use Image path/url or Base64 field in your process.

You can use the Api key as shown in the example.

bb3c53c6-8515-4e34-97c8-8281de60972d

You can use the Image path/url as shown in the example.

gs://cloud-samples-data/vision/ocr/sampleimage.jpg

You can use the Base64 as shown in the example.

/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsKCwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/2wBDAQMEBAUEBQkFBQkUDQsNFBQUF……………./58x/8BX+R/9k=

You can use the Response variable name fileas shown in the example.

getRespone

Label detection

Label detection activity can detect and extract information about entities in an image, across a broad group of categories. Labels can identify general objects, locations, activities, animal species, products, and more.

You can find detailed information and documentation about Google Cloud Vision detect labels features.

*Api key	Google Cloud Vision API Key
*Image path/url	Image Google Cloud Storage url
*Base64	Image file’s Base64 String
*Response variable name	Variable name to store the http response

Note: You can either use Image path/url or Base64 field in your process.

You can use the Api key as shown in the example.

bb3c53c6-8515-4e34-97c8-8281de60972d

You can use the Image path/url as shown in the example.

gs://cloud-samples-data/vision/ocr/sampleimage.jpg

You can use the Base64 as shown in the example.

/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsKCwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/2wBDAQMEBAUEBQkFBQkUDQsNFBQUF……………./58x/8BX+R/9k=

You can use the Response variable name fileas shown in the example.

getRespone

Landmark detection

Landmark detection activity detects popular natural and human-made structures within an image.

You can find detailed information and documentation about Google Cloud Vision detect landmark features.

*Api key	Google Cloud Vision API Key
*Image path/url	Image Google Cloud Storage url
*Base64	Image file’s Base64 String
*Response variable name	Variable name to store the http response

Note: You can either use Image path/url or Base64 field in your process.

You can use the Api key as shown in the example.

bb3c53c6-8515-4e34-97c8-8281de60972d

You can use the Image path/url as shown in the example.

gs://cloud-samples-data/vision/ocr/sampleimage.jpg

You can use the Base64 as shown in the example.

/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsKCwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/2wBDAQMEBAUEBQkFBQkUDQsNFBQUF……………./58x/8BX+R/9k=

You can use the Response variable name fileas shown in the example.

getRespone

Logo detection

Logo detection activity detects popular product logos within an image.

You can find detailed information and documentation about Google Cloud Vision detect logos features.

*Api key	Google Cloud Vision API Key
*Image path/url	Image Google Cloud Storage url
*Base64	Image file’s Base64 String
*Response variable name	Variable name to store the http response

Note: You can either use Image path/url or Base64 field in your process.

You can use the Api key as shown in the example.

bb3c53c6-8515-4e34-97c8-8281de60972d

You can use the Image path/url as shown in the example.

gs://cloud-samples-data/vision/ocr/sampleimage.jpg

You can use the Base64 as shown in the example.

/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsKCwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/2wBDAQMEBAUEBQkFBQkUDQsNFBQUF……………./58x/8BX+R/9k=

You can use the Response variable name fileas shown in the example.

getRespone

Web detection

Web detection activity detects Web references to an image.

You can find detailed information and documentation about Google Cloud Vision detect Web entities and pages features.

*Api key	Google Cloud Vision API Key
*Image path/url	Image Google Cloud Storage url
*Base64	Image file’s Base64 String
*Response variable name	Variable name to store the http response

Note: You can either use Image path/url or Base64 field in your process.

You can use the Api key as shown in the example.

bb3c53c6-8515-4e34-97c8-8281de60972d

You can use the Image path/url as shown in the example.

gs://cloud-samples-data/vision/ocr/sampleimage.jpg

You can use the Base64 as shown in the example.

/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsKCwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/2wBDAQMEBAUEBQkFBQkUDQsNFBQUF……………./58x/8BX+R/9k=

You can use the Response variable name fileas shown in the example.

getRespone

Crop hint detection

Crop hint detection activity suggests vertices for a crop region on an image.

You can find detailed information and documentation about Google Cloud Vision detect crop hints features.

*Api key	Google Cloud Vision API Key
*Image path/url	Image Google Cloud Storage url
*Base64	Image file’s Base64 String
*Response variable name	Variable name to store the http response

Note: You can either use Image path/url or Base64 field in your process.

You can use the Api key as shown in the example.

bb3c53c6-8515-4e34-97c8-8281de60972d

You can use the Image path/url as shown in the example.

gs://cloud-samples-data/vision/ocr/sampleimage.jpg

You can use the Base64 as shown in the example.

/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsKCwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/2wBDAQMEBAUEBQkFBQkUDQsNFBQUF……………./58x/8BX+R/9k=

You can use the Response variable name fileas shown in the example.

getRespone

Explicit content detection

Explicit content detection activity detects explicit content such as adult content or violent content within an image. This feature uses five categories (adult, spoof, medical, violence and racy) and returns likelihood that each is present in a given image.

You can find detailed information and documentation about Google Cloud Vision detect explicit content (SafeSearch) features.

*Api key	Google Cloud Vision API Key
*Image path/url	Image Google Cloud Storage url
*Base64	Image file’s Base64 String
*Response variable name	Variable name to store the http response

Note: You can either use Image path/url or Base64 field in your process.

You can use the Api key as shown in the example.

bb3c53c6-8515-4e34-97c8-8281de60972d

You can use the Image path/url as shown in the example.

gs://cloud-samples-data/vision/ocr/sampleimage.jpg

You can use the Base64 as shown in the example.

/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsKCwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/2wBDAQMEBAUEBQkFBQkUDQsNFBQUF……………./58x/8BX+R/9k=

You can use the Response variable name fileas shown in the example.

getRespone

Microsoft Cognitive Services

Microsoft Cognitive Services component uses Microsoft (Azure) Cognitive Services API. Microsoft Azure Cognitive Services is a set of APIs that make it easy for you to include advanced artificial intelligence capabilities in your apps. To use Microsoft Cognitive Services, you need an Azure Account and a proper subscription model for available APIs. Some Microsoft Cognitive Services features are free to use and you can learn more information from Microsoft Cognitive Services documentation. Some activity responses are in JSON format.

Computer Vision and Face API work with image files. Image files must have a public url address in a web site or storage.

Language API works with text, you can input texts in the modeler.

There are 9 separate activities under Microsoft Cognitive services. These activities work on Computer Vision API, Language API and Face API services. You should create the appropriate APIs from the Azure administration panel to run the related activities. You will need the appropriate API endpoint url and API key information to use each activity.

You can examine the table to find out which activity works with which API.

Computer Vision API
Language API
Face API

Text Dedection
Object Dedection
Analyze Image
Describe Image
Tag Image

Language Dedection
Sentiment Analysis
Key Phrase Extraction

Face Dedection

Text detection

Text detection activity detects words from image files. It uses optical character recognition (OCR) technology. The results are JSON format, including the entire extracted string, individual words, and their bounding boxes.

You can find detailed information and documentation about Microsoft Cognitive Services text detection features.

*Ocp Apim Subscription Key	Microsoft Computer Vision API Key
*Endpoint	Microsoft Computer Vision API Url
*Image Url	Image file’s public url address
*Response variable name	Variable name to store the http response

2dfc034684a3434fb3270534c5efdc66

https://yourapiurl.cognitiveservices.azure.com/

http://example.com/images/test.jpg

getResponse

Face detection

Face detection activity detects faces from image files. Detect human faces in an image, return face rectangles, and optionally with faceIds, landmarks, and attributes.

You can find detailed information and documentation about Microsoft Cognitive Services face detection features.

*Ocp Apim Subscription Key	Microsoft Face API Key
*Endpoint	Microsoft Face API Url
*Image Url	Image file’s public url address
*Response variable name	Variable name to store the http response

2dfc034684a3434fb3270534c5efdc66

https://yourapiurl.cognitiveservices.azure.com/

http://example.com/images/test.jpg

getResponse

Language detection

Sentiment analysis

Sentiment analysis, features help you find out what people think of your brand or topic by mining text for clues about positive or negative sentiment, and can associate them with specific aspects of the text.

You can find detailed information and documentation about Microsoft Cognitive Services sentiment analysis features.

*Ocp Apim Subscription Key	Microsoft Language API Key
*Endpoint	Microsoft Language API Url
*Text	The text you want to detect in which language
*Response variable name	Variable name to store the http response

2dfc034684a3434fb3270534c5efdc66

https://yourapiurl.cognitiveservices.azure.com/

Great atmosphere. Close to plenty of restaurants, hotels, and transit! Staff are friendly and helpful.

getResponse

Key phrase extraction

You can use key phrase extraction to identify the main concepts in the text quickly. For example, in the text “The food was delicious, and the staff was wonderful.“, the key phrase extraction will return the main topics: “food” and “wonderful staff.”

You can find detailed information and documentation about Microsoft Cognitive Services key phrase extraction features.

*Ocp Apim Subscription Key	Microsoft Language API Key
*Endpoint	Microsoft Language API Url
*Text	The text you want to detect in which language
*Response variable name	Variable name to store the http response

2dfc034684a3434fb3270534c5efdc66

https://yourapiurl.cognitiveservices.azure.com/

The food was delicious, and the staff was wonderful.

getResponse

Object detection

Object detection returns the bounding box coordinates (in pixels) for each object found in the image. You can use this functionality to process the relationships between the objects in an image. The object detection function applies tags based on the objects or living things identified in the image.

You can find detailed information and documentation about Microsoft Cognitive Services object detection features.

*Ocp Apim Subscription Key	Microsoft Computer Vision API Key
*Endpoint	Microsoft Computer Vision API Url
*Image Url	Image file’s public url address
*Response variable name	Variable name to store the http response

2dfc034684a3434fb3270534c5efdc66

https://yourapiurl.cognitiveservices.azure.com/

http://example.com/images/test.jpg

getResponse

Analyze image

The Computer Vision Image Analysis service can extract a wide variety of visual features from your images. For example, it can determine whether an image contains adult content, find specific brands or objects, or find human faces.

You can find detailed information and documentation about Microsoft Cognitive Services analyze image features.

*Ocp Apim Subscription Key	Microsoft Computer Vision API Key
*Endpoint	Microsoft Computer Vision API Url
*Image Url	Image file’s public url address
*Response variable name	Variable name to store the http response

2dfc034684a3434fb3270534c5efdc66

https://yourapiurl.cognitiveservices.azure.com/

http://example.com/images/test.jpg

getResponse

Describe image

Describe image can analyze an image and generate a human-readable phrase that describes its contents. The algorithm returns several descriptions based on different visual features, and each description is given a confidence score. The final output is a list of descriptions ordered from highest to lowest confidence.

You can find detailed information and documentation about Microsoft Cognitive Services describe image features.

*Ocp Apim Subscription Key	Microsoft Computer Vision API Key
*Endpoint	Microsoft Computer Vision API Url
*Image Url	Image file’s public url address
*Response variable name	Variable name to store the http response

2dfc034684a3434fb3270534c5efdc66

https://yourapiurl.cognitiveservices.azure.com/

http://example.com/images/test.jpg

getResponse

Tag image

Tag image can return content tags for thousands of recognizable objects, living beings, scenery, and actions that appear in images. Tags are not organized as a taxonomy and do not have inheritance hierarchies. Tagging is not limited to the main subject, such as a person in the foreground, but also includes the setting (indoor or outdoor), furniture, tools, plants, animals, accessories, gadgets, and so on.

You can find detailed information and documentation about Microsoft Cognitive Services tag image features.

*Ocp Apim Subscription Key	Microsoft Computer Vision API Key
*Endpoint	Microsoft Computer Vision API Url
*Image Url	Image file’s public url address
*Response variable name	Variable name to store the http response

2dfc034684a3434fb3270534c5efdc66

https://yourapiurl.cognitiveservices.azure.com/

http://example.com/images/test.jpg

getResponse

SAP

You can automate end-user processes by connecting the SAP GUI application with the SAP component. While using the SAP component, you can use the necessary activities (e.g. Mouse Actions, Set Methods, Functions etc.) under the Applications component while interacting with the SAP application.

Your SAP GUI version must be 7.60 or newer to use the SAP component.

To perform your automation operations in the SAP application, you need to find the clickable fields or form fields on the application. You can use the Tracker app to find clickable or form fields.
You can access the Tracker application using path C:Robusta…drivertrackertracker.exe.

You can access the information required to use the Tracker application from the Help menu or by pressing the F1 key.

Enable SAP® GUI Scripting on Presentation Server

Choose the menu item Options… from the system menu of the SAP® Logon.

Choose the node Scripting.

The Scripting must be installed and activated.

It is better to disable the notifications, otherwise you got a requester for each script execution.
It is better to disable the using of native Windows dialogs. On this way the native Windows dialogs, e.g. like Save as or Open, are replaced with a dynpro-based dialog. So you have the possibility to record your activities also with these dialogs.

Enable SAP® GUI Scripting on Application Server

Use the transaction code RZ11 in the ok field.

Use the profile parameter sapgui/user_scripting and press the Display button.

The current value must be TRUE.

If it is FALSE, press the Change Value button and change it to TRUE on all servers.

Open SAP session

Open SAP session activity opens the SAP application and login the system.

*SAP Application name	Reference name of the application will be opened.
*Connection name	SAP Logon screen’s connection name.
*Username	Enter the username used when logining the SAP application.
*Password	Enter the password used when logining the SAP application.
Client	Enter the client value when logining the SAP application.
Language	Enter the language value when logining the SAP application.
*SAP Logon exe path	The directory of the SAP application is entered.
Wait time	Can be used during login to the SAP application.(ms)
Maximize	Maximizes the application window if it is checked.

_{Note: * Fields selected with are required, others are optional.}

You can use the SAP Application name as shown in the example.

newSapConnection

You can use the Connection name as shown in the example.

You can find your connection name from your SAP Logon screen. You can copy and paste the value. You must enter the same parameters.

SAP Test Connection

You can use the Username as shown in the example.

You can use your or worker’s username to connect the application.

username

You can use the Client as shown in the example.

You can find your client information from SAP Logon screen.

001

You can use the Language as shown in the example.

You can find your language information from SAP Logon screen.

EN

You can use the SAP Logon exe path as shown in the example.

Default SAP logon path is written in the field. If your or worker’s SAP Logon path is in another directory, please make the necessary adjustments.

C:Program Files (x86)SAPFrontEndSAPguisaplogon.exe

You can use the Wait time as shown in the example.

10000

The Session can be closed with the Application > Close activity.

Set SAP command

Set SAP session activity opens the requested page.

*SAP Application name	Name of the application which has already been opened attached.
*Okcode	SAP Transaction code field.

_{Note: * Fields selected with are required, others are optional.}

You can use the SAP Application name as shown in the example.

${newSapConnection}

You can use the Okcode as shown in the example.

A T-code is a transaction code used whenever executing particular task. You can enter the T-code in the OKcode field.

SU01

Close SAP

The “Close SAP” activity is used to gracefully close an open SAP (Systems, Applications, and Products) application session. This activity ensures that all open windows and dialogs within the SAP application are properly closed

*SAP Application name

Reference name of the application will be closed.

_{Note: * Fields selected with are required, others are optional.}

You can use the SAP Application name as shown in the example.

SAPClose

Get statusbar info

Gap statusbar info activity enables retrieval of SAP responses.

*SAP Application name	Name of the application which has already been opened attached.
*Statusbar type	The type of status is selected
Response variable	The variable to which the response will be assigned is defined.

_{Note: * Fields selected with are required, others are optional.}

You can use the SAP Application name as shown in the example.

${newSapConnection}

You can use the Statusbar type as shown in the example.

You can choose the appropriate type from the list.

MESSAGE

If MESSAGE is selected,
Example output: ‘Order created successfully.’

MESSAGE TYPE

If MESSAGE TYPE is selected,
Example output: ‘S’ (in the case of success), ‘E’ (in the case of error).

You can use the Response variable as shown in the example.

You can get the related message from status bar, and store in a variable.

getStatus[/direciton]

Username	Your username (eg. john.doe)
Password	Your password (eg. abc123)
Worker Port Number	8843
Orch Address	cloud.robusta.ai or Your orchestrator server IP address

File name	C:TrainingProcessesMoveFileFiletoMove.txt
Destination path	C:TrainingProcessesMoveFileFoldertoMoveFiletoMoveNew.txt

Name	Add column: Days Between
*Dataset name	${Flight_RouteDS}
*Column name	Days Between

Name	Add column: Concatanated Dates
*Dataset name	${Flight_RouteDS}
*Column name	Concatanated Dates

Name	Imap/Smtp connection : Connect to E-mail account
Configuration name	connectionName
*Connection name	testCon
*Imap host	imap.gmail.com
*Imap port	993
*Imap user	E-mail address for IMTP protocol.
*Imap password	${password}
Imap ssl	True
*Smtp host	smtp.gmail.com
*Smtp port	587
*Smtp user	E-mail address for SMTP protocol.
*Smtp password	${password}
Smtp tls enabled	True
Smtp tls required	True

Name	Open: Flight_Routes Excel
*Excel name	Flight_Routes
*Excel file name	Current directory where the file is located

Name	Get size: Flight Routes
*Dataset name	${Flight_RoutesDS}
Size type	ROW
*Result variable name	getSize

Name	Loop for each flight route
Cardinality (Multi-instance)	${getSize}
Multi-instance type	Sequential
Exclusive	True

Name	Get action: Return Date
*Dataset name	${Flight_RouteDS}
*Column	R.Date
Result variable name	${loopCounter}
Row	returnDateStr

Name	Get action: Depart Date
*Dataset name	${Flight_RouteDS}
*Column	D.Date
Result variable name	${loopCounter}
Row	departureDateStr

Name	Set action: Days Between
Dataset name	${Flight_RouteDS}
*Type	STRING
*Column	Days Between
*Value	=H${loopcounter+2}-G${loopcounter+2}
Row	${loopCounter}

Name	Set action: Concatanated Dates
Dataset name	${Flight_RouteDS}
*Type	STRING
*Column	Concatanated Dates
*Value	${departureDateStr}-${returnDateStr}
Row	${loopCounter}

Name	Save and close: Flight_Routes Excel
*Excel name	${Flight_Routes}
*Action	SAVE_AND_CLOSE
Excel file name	Current directory where the file is located

Name	Search : E-mails for flight routes price request
*Connection name	${testCon}
*Folder name	INBOX
Has attachment?	True
Search limit	10
Min date	${minDate}
Subject	Flight Routes
Unread	True
*New dataset name	emailSearchDS

Name	Get size : Request count
*Dataset name	${emailSearchDS}
Size type	ROW
*Result variable name	emailSearchDSSize

Name	Loop for each e-mail request
Exclusive	True
Multi-instance type	Sequential
Cardinality (Multi-instance)	${emailSearchDSSize}

Name	Read/Save/Attachment : Dowload to ‘archieve’ folder
*Connection name	${testCon}
*Dataset name	emailSearchDS
Mail no	${loopCounter}
Mark as read?	True
Save attachments?	True
Save path	The location you want to save the files.
Attachment database name	AttachmentDS

Name	Get size : Attached file count
*Dataset name	${AttachmentDS}
Size type	ROW
*Result variable name	listFileDSSize

Name	Reply : Request is not valid
*Connection name	${testCon}
*Dataset name	${emailSearchDS}
Mail no	${loopCounter}
Message	Cannot process more than one attached file
Is HTML?	True
Reply all?	True

Mail	Forward
*Connection name	${testCon}
*Dataset name	${emailSearchDS}
Mail no	${loopCounter}
*From	sender’s e-mail address
*To	recipient’s e-mail address
Message	This mail is forwarded by Robusta RPA tool.

Name	Open: Booking.com
*Application name	bookingDemo
*Type	CHROME
*Url	https://booking.kayak.com
Wait until load	True
Timeout (sec)	120
Maximize	True

Name	Mouse actions : From Airport
*Application name	${bookingDemo}
Button	LEFT
*Field	//div[contains(@id,”originairport-display-inner”)]

Name	Set methods : From airport
*Application Name	${bookingDemo}
*Field	//input[@name=”origin”]
Clear	True
*Type	text
*Text	${fromAirport}
Wait until visible	True

Name	Mouse actions: Select From Airport
*Application name	${bookingDemo}
Button	LEFT
*Field	//div[@class=”item-info”]
Wait until load	True
Wait until visible	True

Name	Set methods : To airport
*Application Name	${bookingDemo}
*Field	//input[@name=”destination”]
Clear	True
*Type	text
*Text	${toAirport}
Wait until visible	True

Robusta RPA

Robusta RPA: Your Digital Workforce

How Robusta RPA Works

Robusta RPA System Requirements

Robusta Orchestrator Server System Requirements1

Robusta Digital Worker System Requirements3

Robusta RPA Architectural Structure

Robusta Orchestrator and Robusta Worker Service Architecture

Robusta Orchestrator and Robusta Worker Installation Architecture

Articles

Attended vs Unattended Robots

Attended Robots

Unattended Robots

Attended Robots

Differences

Unattended Robots

Quick Start Guide

Articles

How to Install Robusta Worker

Installing Robusta RPA Worker

Starting Robusta RPA Worker and Connection to Robusta Orchestrator

Starting Robusta RPA Worker

Connection to Robusta Orchestrator Web Application

Design a Process with Robusta Modeler

Sample Processes

Articles

A Sample RPA Process with Excel Operations

PROCESS SCENARIO

STEP BY STEP PROCESS

CONNECT TO EXCEL AND CREATE A DATASET

Excel > Open

Excel > Read excel to dataset

Dataset > Get size

The first flow condition

The second flow condition

ADD COLUMNS

Dataset > Add column

Dataset > Add column

PROCESS ROWS IN SUB-PROCESS.

Structural > Sub process

Dataset > Get action

Dataset > Get action

Dataset > Set action

Dataset > Set action

FINISH YOUR EXCEL OPERATION

Excel > Write dataset to excel

Excel > Save and close

A Sample RPA Process with E-mail Operations

PROCESS SCENARIO

STEP BY STEP PROCESS

Mail > Imap/Smtp connection

Activities> Script task

Mail > Search

Dataset > Get size

Structural> Sub process

Mail > Read/Save/Attachment

Dataset > Get size

Mail > Reply

Mail > Forward

A Sample RPA Process with Web Applications Operations

PROCESS SCENARIO

STEP BY STEP PROCESS

Applications > Mouse actions

Applications > Mouse actions

Applications > Set methods

Applications > Mouse actions

Applications > Mouse actions

Applications > Set methods

Applications > Mouse actions

Applications > Mouse actions

Applications > Set methods

Applications > Mouse actions

Applications > Set methods

Applications > Mouse actions

Applications > Wait actions

Activties> Script task

Applications > Close

Applications > Functions

Activities> Script task

Robusta Orchestrator Server System Requirements¹

Robusta Digital Worker System Requirements³

Name	Mouse actions: Select To Airport
*Application name	${bookingDemo}
Button	LEFT
*Field	(//div[@class=”item-info”])[2]
Wait until load	True
Wait until visible	True

Name	Mouse actions: Departure Date
*Application name	${bookingDemo}
Button	LEFT
*Field	//div[contains(@id,”dateRangeInputdisplay-start-inner”)]

Name	Set methods: Departure Date
*Application Name	${bookingDemo}
*Field	//div[contains(@id,”departinput”)]
Clear	True
*Type	text
*Text	${departureDate}
Wait until visible	True

Name	Mouse actions: Return Date
*Application name	${bookingDemo}
Button	LEFT
*Field	//div[contains(@id,”dateRangeInputdisplay-end-inner”)]

Name	Set methods: Return Date
*Application Name	${bookingDemo}
*Field	//div[contains(@id,”returninput”)]
Clear	True
*Type	text
*Text	${returnDate}
Wait until visible	True

Name	Mouse actions: Click Search
*Application name	${bookingDemo}
Button	LEFT
*Field	(//button[contains(@id,”submit”)])[1]

Name	Wait actions: Check if loaded
*Application name	${bookingDemo}
*Field	//[@class=”col-advice”]//[@aria-busy=”false”]
*Wait for	visible

Name	Functions: Get Ticket Row Count
*Application name	${bookingDemo}
*Field	//*[@class=”resultWrapper”]
Result variable name	ticketRowCount
Action	elementcount

Name	Get methods: Ticket Price
*Application name	${bookingDemo}
*Field	//span[@class=”price option-text”]
*Type	text
Result variable name	ticketPrice

Scheduling Parameters	Explanation
Every	This parameter enables scheduling by minute, hour, day, week, month and year. Depending on the selections made in this area, the detailed selection screen with minute/hour/day values appears on the right side. Multiple values can be selected by holding down the control (CTRL) key on the detail screen. For example, for a process that will run every 15 minutes, this parameter should be selected as Hour and 0/15/30/45 selections should be made at the same time on the right pane.
Start Date	The date to start scheduling is selected.
End Date	The date the scheduling will end is selected.
Run Once	If the process is to be run only once, this field is selected without entering any scheduling parameters. If the Run Immediately is not selected, the process will begin on the date selected in the Start Date field.
Run Immediately	This field enables the process to run immediately once there is an available and appropriate Robusta worker.