Data Table nodes are here to make your life easier when it comes to handling data. These nodes have been designed for common operations such as adding/removing columns and rows, merging tables, and efficiently sorting data.

In this guide, we'll show you how to use Data Table nodes to effortlessly replace values in rows and make changes to numeric data.

How to Setup?

To begin, Login to your Robomotion workspace. If you haven't registered yet, you can create your workspace from the provided link. Once you have access to your workspace, you can proceed by utilizing the Data Table package to replace values. For any operations involving numerical data, feel free to employ the Number package.

About the Data Table Package

The DataTable Package is designed to empower automation developers, making data transformations a breeze. It comprises various nodes tailored to different data manipulation tasks, with one particularly significant node being the 'Replace Values' node. This node is dedicated to altering the values you intend to modify.

On the other hand, the Number package serves various purposes, including assigning values, decreasing/increasing values, and generating random values.

Building Blocks for Successful Flow

To utilize the 'Replace Values' and 'Data Table to CSV' nodes, you'll need to download the 'Data Table' package. Similarly, if you intend to use the 'Decrement' node, you must download the 'Number' package.

To obtain both the 'Data Table' and 'Number' packages, simply navigate to the 'Packages' menu and follow the download instructions

Node Overview

• Inject: This node initializes the flow.
• Function: In this node, variables, objects, etc., to be used in the flow are defined.
• Replace Values: This node replaces the desired value in a table with a new one.
• For Each: The for-each loop is used to iterate through elements of arrays and collections (like Array). It is also known as the enhanced for loop.
• Decrement: This node is used to decrease a numeric value. The input must be an integer.
• Goto: To ensure flow continuity, this node provides the connection and routing between the nodes used to ensure process repetition when an error is received. When the flow reaches this node, it continues from wherever it was redirected.
• Label: This node holds the redirection of the 'Goto' node and continues the flow from where it is located.
• Data Table to CSV: This node converts a table to a CSV file. The path to the CSV file and the table must be provided as input.
• Stop: This node is used to halt the flow.

Flow Steps

1. Access to the workspace is granted through the instructions outlined in the "How to Set Up" section.
2. ‘Inject’ node is used to initialize the flow.
3. Within the 'Prepare Data Table' function node, the variables msg.csv_path and msg.table are defined. The msg.csv_path variable is utilized to specify the path for writing the modified table's output to a CSV file. It is essential to define the path for this variable. On the other hand, the msg.table variable is employed to designate the table to be updated.

msg.csv_path = "C:\\Robomotion\\Templates\\myCSV.csv"; //The path to the CSV file where the output will be saved.

msg.table = {
  columns: ["Name", "Surname", "Age"],
  rows: [{
      Name: 'Jack',
      Surname: 'Smith',
      Age: 21
    },
    {
      Name: 'Harry',
      Surname: '',
      Age: 30
    },
    {
      Name: 'Charlie',
      Surname: '',
      Age: 50
    }
  ]
};

return msg; 

4. In the 'Replace Surnames' node, the data to be modified is replaced throughout the entire table. In this flow, all values that are defined as empty in the 'Prepare Data Table' function node are substituted with '-'.

5. The 'For Each' node iterates through all elements of the msg.table.rows array. The msg.table.rows variable is used to access rows in the table, with each element being defined within the msg.item variable.

6. The 'Decrement' node decreases the specified value for the specified element. In this example, it will subtract 2 from the age value that has been defined.

7. In the 'Replace Ages' node, the reduced value is defined as the new value and then substituted for the old age value.

8. The 'Go To Next Item' node is employed to revisit each element of the array defined in the 'For Each' node. The flow is redirected to the 'Label Next Item' node. This loop persists until all elements have been processed.
9. Once the loop is concluded, the final table is saved to the previously specified CSV file.

Here you can find the whole flow chart:

https://casestudies.robomotion.io/designer/shared/BkJTR5cGZ21Y97HgWKohhe

File System nodes are designed to facilitate a wide array of activities within your workflow, including file and folder creation, reading from and writing to files, and checking for file existence. In this specific workflow, the focus is on verifying the existence of a specified file. If the file is found, the system proceeds to read, copy, relocate it to a different location, and finally, delete the original source file. In cases where the file is not found, the system creates the file, adds predefined text to it, copies it to a designated destination folder, and subsequently removes the source file.

How to Setup?

To begin, Login to your Robomotion workspace. If you haven't registered yet, you can create your workspace from the provided link.

What is the 'Node Name' Node?

• Inject: This node is used to initialize the flow.
• Function: In this node, variable, object etc. to be used in the flow are defined.
• Create File/Dir: Used to create a file/folder.
• Path Exists: Checks if the given Path exists. This node is of boolean type. The output of the node is true or false.
• Switch: Used for routing the flow according to certain conditions.
• Read File: This node is used to read a specific text file.
• Write File: This node is used to write text into a specific text file.
• Copy File/Dir: Copy a file/folder from the source path to the destination path.
• Delete File/Dir: Used to delete the file/folder.
• Stop: This node is used to stop the flow.

Flow Steps:

1. Access to the workspace is provided through the information provided under "How to set up."
2. The 'Inject' node is utilized to initialize the flow.
3. Variables are defined within the 'Prepare' function node.

msg.filePath = "C:\\Robomotion\\Templates\\myText1.txt"; // The directory of the folder to be checked for files should be given
msg.destinationDir = "C:\\Robomotion\\Templates\\Copy\\"; // The directory of the destination folder to be copied must be given
msg.destinationPath = "C:\\Robomotion\\Templates\\Copy\\myText1.txt"; // The directory of the destination file to be copied must be given

msg.text = "This place should be given text."; // The text to be written in the file should be given
return msg;

4. The 'Create Destination Dir' node generates the destination folder for the copy operation, taking the defined msg.destinationDir variable as input. Since a folder will be created, the 'Options' setting should be set to 'Directory.' Additionally, the 'Continue on Error' option should be selected, as it will trigger an error if a folder already exists.

5. The 'Path Exists' node checks whether there are files in the defined path. This node is of boolean type, and its output is either true or false.
6. The 'Switch' node controls the output of 'Path Exists'.

If the output is true, it indicates that the file exists. The robot reads the file using the 'Read File' node. After reading the file, the 'Copy File/Dir' node is used to copy the file from the source folder to the destination folder. Subsequently, the source file is deleted using the 'Delete File/Dir' node, and the flow comes to an end.

If the output is false, the robot creates the file using the 'Create File/Dir' node and continues its work.

7. The text defined in the 'Prepare' function node is written to the file using the 'Write File' node.

8. The 'Copy File/Dir' node is used for copying the file from the source folder to the destination folder.

9. The source file is subsequently deleted using the 'Delete File/Dir' node.

Here you can find the whole flow chart:

https://casestudies.robomotion.io/designer/shared/CYBLrZXLs7nDQURQidZ9zw

In this blog post, we will walk you through an example of utilizing the Assistant node in Robomotion.

How to Setup?

To begin, Login to your Robomotion workspace. If you haven't registered yet, you can create your workspace from the provided link. First, make sure the "Assistant" package is installed for this workflow. Once the package is installed, you can proceed with the workflow, leveraging its functionalities for your tasks.

About the Assistant Package

With the Assistant package, you can do many things, such as sending messages to the Assistant application, uploading files, and uploading pictures.

Exploring Assistant Package: Navigating Package, Installing, and Understanding Flow Steps:

1. Go to your workspace.

2. To open the packages page, simply click on the cube icon.

3. Enter "Assistant" in the package search field, and then right-click on the package and select the option to download it.

4. The “App In” node is used to initialize the flow.

5. The function node named "Setups" contains JavaScript code for defining variables.

6. Function node named “Setups” Code-Block:

msg.header = "Robomotion Assistant"; // Enter a name for your assistant.
msg.message = "How can I help you ?"; // Enter the message your assistant wants to send.

msg.labels = ["Start"]; // The message you want to send to the assistant.

msg.message_ = ""; // Enter the message your assistant wants to send.

return msg;

7. Feel free to adjust the interface color of the assistant as per your preference by using the "Change Theme" node.

8. “Stop” node is used to stop the flow.

Adding an app to the "Bot Console"

1. Click the "Master" button located at the top of your workspace.

2. Select the "Create Version" button on the screen that appears.

3. Once the version has been added, proceed to click the "Publish" button.

4. Click on the menu

5. Click on "Admin Console”.

6. Select the "Bots" button located at the bottom of the Robomotion admin section.

7. On the page that appears, click the "ADD BOT" button.

8. Configure the necessary settings, with "Published Flow" as the name of your flow and "Flow Version" representing the added version. Finally, click the "CREATE" button.

9. Click on "Bot Console”.

10. On the page that opens, locate your bot and double-click on it.

11. Click on the "Create Instance" button.

12. Click on the "Open App" button.

13. Click on the “Run” button.

14. Your assistant interface is now prepared.

Flow Chart:

Here you can find the whole flow chart: https://casestudies.robomotion.io/designer/shared/Lbsd4WwwY6AV6PtnHru66X

Efficient email management is essential for businesses and individuals alike. The Core.Mail package of Robomotion provides a powerful set of tools to simplify and automate various email-related tasks, from sending important messages to searching for specific emails in your inbox.

In this comprehensive guide, we will delve into the 'send mail' and 'search mail' nodes within the Core.Mail package, enabling you to run your email processes easily.

How to Setup?

To begin, Login to your Robomotion workspace. If you haven't registered yet, you can create your workspace from the provided link. You can use the Core Mail package for email operations. You don't need to install this package; it comes pre-installed by default.

About Core Mail Package

The Core Mail Package comprises 11 nodes that empower you to perform various email-related operations. These capabilities range from connecting to email accounts to sending, searching, and moving emails, among others. This package simplifies the automation of email-related tasks, allowing you to streamline and enhance your email processes effortlessly.

Flow Steps:

1. The Inject node is used to initialize the flow

2. The input values in the 'send mail' node are entered as follows:

• From: Enter the sender's email address.
• To: Enter the email address to which the mail will be sent.
• Subject: Write the subject of the email to be sent.
• Body: Write the content of the email to be sent.
• Cc: Enter the email address you want to add to Cc (optional).
• Bcc: Enter the email address you want to add to Bcc (optional).

3. Select the credentials information found in Options.

4. The input values in the 'search mail' node are entered as follows:

• Mail Folder: Enter the folder you want to search in. 'INBOX' is the default option, but you can change this field (e.g., Starred, snoozed, sent, etc.).
• Subject: Enter the email subject you want to search for.

5. Select the credentials information in the Options.
6. Enter the date range you want to search for in Options. Date information should be entered in the day/month/year format.
7. To view the results, use the debug node.

Here you can find the whole flow chart: https://casestudies.robomotion.io/designer/shared/QSK5RUHdbW9Fh9njmJArgi

When an error occurs during the operation of the flow, it is managed using both the Catch node and the Try Catch structure. Errors are an inherent aspect of many processes and can vary from simple typos to intricate issues that demand hours of debugging to rectify.

An example of the error-handling structure is provided below. This example functions by verifying the existence of a specified file path. If the file does not exist within the folder directory, it is checked three times before the flow is halted. However, if the file does exist within the folder directory, it is read, and the flow is terminated

How to Setup?

To begin, Login to your Robomotion workspace. If you haven't registered yet, you can create your workspace from the provided link.

Node Overview

• Inject: This node initializes the flow.
• Function: In this node, variables, objects, etc., to be used in the flow are defined.
• Path Exists: This node checks if the given path exists. It is of boolean type, and its output is either true or false.
• Read File: This node is used to read a specific text file.
• Catch: It is used to catch an error if one occurs during the execution of the flow.
• Switch: This node is used for routing the flow based on specific conditions.
• Goto: To ensure flow continuity, this node establishes connections and routing between nodes to guarantee process repetition when an error is encountered. When the flow reaches this node, it continues from wherever it was redirected.
• Label: This node holds the redirection point for the 'Goto' node, allowing the flow to continue from its location.
• Stop: This node is used to halt the flow.

Flow Steps

1. Access to the workspace is granted through the instructions provided in the "How to Set Up" section.
2. The 'Inject' node is utilized to initiate the flow.
3. Inside the 'Prepare' function node, the variable 'msg.filePath' is defined. This variable will serve as the input for the 'Path Exists' node, and the file path to be checked for existence should be specified.

msg.filePath = "C:\\Robomotion\\Templates\\myText.txt"; // The directory of the folder to be checked for files should be given
return msg;

4. The 'msg.try_count' variable is defined within the 'Set Try Count' function node. This variable stores the initial count of how many times the try-catch structure will be invoked when an error occurs in the flow.

msg.try_count = 0;
return msg;

5. The 'Path Exists' node verifies whether files exist in the specified path. This node is of boolean type, and its output can be either true or false.

6. The 'Switch' node controls the output of 'Path Exist' node.

If the output is true, it signifies that the file exists. In such cases, the robot reads the file using the 'Read File' node, and then the flow comes to a halt. This represents the error-free scenario, and the Try Catch structure remains inactive. However, if the output is false, the flow continues with the 'throw' function node.

7. The robot triggers an error during the 'throw' function node phase because it is unable to locate the file in the designated path.

throw "The file you defined in msg.sourcePath was not found."
return msg;

8. The 'Catch' node contains the function node that encountered an error.

9. In the 'Plus Try Count' node, the previously defined 'msg.try_count' index is incremented by 1.

msg.try_count += 1;
return msg;

10. The 'Switch' node examines the value of this index. If it is less than 3, the flow is rerouted to the 'Path' using the 'Go To Path' node. The 'Path Exists' node verifies whether the file exists. In the 'Go To' node, select the appropriate 'Label' node from the options section.

If the index is greater than 3, the flow is terminated. This means that the file has been checked three times and has not been found. The Try Catch structure also operates based on the value of the index.

The index value is optional and can be modified as needed.

Here you can find the whole flow chart: https://casestudies.robomotion.io/designer/flows/HEwetqz9vGMuawiCy4efdY

Downloading files from the internet is a fundamental task that many of us encounter in our digital lives. Whether it's grabbing a software update, acquiring research documents, or saving media files, the ability to efficiently download files is essential.

By the end of this blog post, you will have a clear understanding of how to automate and streamline the file download process, making it easier and more efficient for your specific needs.

Let's dive in!

How to Setup?

To begin, Login to your Robomotion workspace. If you haven't registered yet, you can create your workspace from the provided link.

Flow Steps

1. Go to your workspace.
2. The ‘Inject’ node is used to initialize the flow.
3. The function node named "Config" contains JavaScript code to define variables.

Function node named “Config” Code-Block:

msg.FilePath = ""; // [Required] Path to the file you want to download
msg.FileDownloadPath = ""; // [Required] The path to will save the document you want to download

return msg;

4. The "Download File" node is responsible for downloading the file
5. The "Stop" node is used to stop the flow.

• You can access the complete flowchart at the following link: https://casestudies.robomotion.io/designer/shared/94HHmsUJd6BwoTK7vidWFF

Slack, a popular instant messaging application, has transformed the landscape of business communication. It serves as a catalyst for improving teamwork and connectivity among professionals.

In this blog post, we will delve into a practical example, showcasing the utilization of the Slack node within Robomotion. By the end of this guide, you will have a clear understanding of how to use the capabilities of this node to optimize communication workflows and enhance productivity within your team.

How to Setup?

To begin, Login to your Robomotion workspace. If you haven't registered yet, you can create your workspace from the provided link. First, make sure the "Slack" package is installed for this workflow. Once the package is installed, you can proceed with the workflow, leveraging its functionalities for your tasks.

About the Slack Package

The Slack package provides a straightforward interface for accessing the Slack app. With this package, you can perform various tasks, including sending messages to Slack channels, uploading images, and more.

Exploring Slack Package: Navigating Package, Installing, and Understanding Flow Steps:

1. Go to your workspace.
2. Click the cube icon to access the packages page.

3. Enter "Slack" into the package search field, then right-click on the package and select "Download."

4. The “Inject” node is used to initialize the flow.
5. The function node named “Config” includes some javascript code to define variables.
6. Function node named “Config” Code-Block:

msg.SendMessage = "Hello"; //[Required] Type the message you want to send.
msg.TextMessage = msg.SendMessage;
msg.ChannelName = ""; //[Required] Type the channel name.
msg.webhook = ""; //[Required] Enter your Slack channel webhook.

msg.req = {
  "payload": "{\"text\":\"" + msg.TextMessage + "\"}",
};

return msg;

7. The "Connect" node establishes a connection to your account using a provided Bot Token. To acquire the Bot Token, you must create a vault and then create a vault item named "API Key/Token.

Click on the links in the specified order to create the secure environment.

• https://docs.robomotion.io/reference/products/designer/vaults/
• https://docs.robomotion.io/concepts/core/vaults/

Following these procedures, you can choose the necessary vault from the options section of the "connect" node.

8. The "Send Message" node is employed to send messages to the Slack channel.

9. The Slack Disconnect node is utilized to disconnect a specific account. It requires only one input: the connection_id.

10. The "Stop" node is used to stop the flow.

• You can access the complete flowchart at the following link: https://casestudies.robomotion.io/designer/shared/WqUtdxKCZVs5c4m87J1kDG

In a world where PDF documents reign supreme for sharing and preserving content, the need to download them efficiently is a common task. Whether it's research papers, user manuals, or reports, we all find ourselves needing to gather PDFs from the vast expanse of the internet. However, manually downloading each PDF file can quickly become a tedious and time-consuming process.

One such remarkable feature in our RPA tool is the browser package—a comprehensive suite comprising 23 meticulously designed nodes. From opening browsers to capturing screenshots, these nodes offer a versatile set of capabilities that can revolutionize the way we interact with web content.

In this blog post, we will explain how to automate the process of downloading PDFs using Browser Automation with Robomotion.

Visual Snapshot

How to Setup?

To begin, Log in to your Robomotion workspace. If you haven't registered yet, you can create your workspace from the provided link.

About Browser Package

The browser package refers to a collection of nodes that are specifically designed to interact with web browsers. These nodes enable automation of web-based tasks and processes by providing a set of actions that mimic human interactions with a browser.

The browser package consists of 23 nodes, each representing a specific action that can be performed within a web browser. These actions range from basic functions like opening and closing browsers, clicking on elements, and navigating forward or backward, to more advanced operations like capturing screenshots, handling alerts, and even executing custom scripts within the browser environment.

Flow Steps

1. ‘Inject’ node is used to initialize the flow.
2. The "Config" function node contains JavaScript code designed to define variables.

Function Node Named “Config” Code-Block:

//User Directory Path to save Chrome settings 
msg.user_directory_path = "YourUserDataDirFolderPath";
//Download Path to save PDF files
msg.download_path = "YourDownloadFolderPath";
//Give a url for the pdf file to download
msg.url = "https://www.fedex.com/content/dam/fedex/us-united-states/services/Fees_Shipping_Information.pdf";
return msg;

3. During the initial run, you should establish a connection to the "Save Settings" sub-flow node, which comprises four individual nodes:

3. 1. The "Create User Data Dir" node within the "File Create" category is used to generate the "User Data Dir" folder at the specified path.

3. 2. The node called "Create Download Dir" under the "File Create" category is used to establish the "Download Folder" at the provided path.

3. 3. The node labeled "Open Browser First Run" is used to select the browser type and initiate the browser driver on the machine.

3. 4. The 'Open Link First Run' node is used to navigate, directing you to the specified URL.

3. 5. Once the page loads, follow these steps to save your settings:

• Open Chrome Settings.

• On the currently displayed page, navigate to "Privacy and Security".

• Choose "Site Settings".

• Choose the "Additional Content Settings".

• Choose the PDF documents.

• Select "Download PDFs".

3. 6. You can now stop the flow and disconnect the "Save Settings" sub-flow.

4. Once the main flow has stopped and disconnected from the "Save Settings" sub-flow, you can proceed by establishing a connection to the "Open Browser" node. Subsequently, you can initiate the flow once more.

5. The "Open Link" node is utilized to access the provided PDF download URL. This action will trigger the opening of the webpage and initiate the immediate download of the PDF documents. The downloaded document will be saved to the designated "Download Folder" path, which is specified within the "Config" function node.

6. The “Stop” node is used to stop the flow.

As we automate tasks and processes to save time and reduce errors, handling data seamlessly becomes a top priority. This is where the "Array" package steps in, offering a way to effortlessly manage and manipulate arrays within your RPA workflows.

In this blog post, we'll dive into a specific use case: pushing array values to table row entries. This task may sound complex, but with the right package and nodes, it becomes a running process that enhances your automation projects.

The "Array" package provides a wealth of functionalities that empower RPA developers to work with arrays in an intuitive way. One of the standout operations is the "Push" operation, which proves invaluable when it comes to appending data to table rows.

Imagine you have a dataset that you want to efficiently incorporate into your automation workflow. To make this happen, you'll first need to structure your data. One of the most versatile ways to organize data is by using an Excel spreadsheet. Excel not only allows you to input and arrange information neatly but also serves as an excellent source for RPA data manipulation.

So, the first step is to create an Excel spreadsheet that houses the data you want to work with. This could range from customer information to product details or any other dataset relevant to your specific RPA use case. The key is to organize your data into columns, making it easier to push these values into table rows later on.

Visual Snapshot

How to Setup?

To begin, Log in to your Robomotion workspace. If you haven't registered yet, you can create your workspace from the provided link.

First, ensure that the OpenAI package is installed for this flow. Once the package is installed, you can proceed with the flow by utilizing its functionalities for your tasks.

About the Array Package

This package offers a collection of 12 nodes, each tailored to perform specific array operations effortlessly. From creating and accessing arrays to advanced tasks like filtering, mapping, and aggregation, these nodes enable you to efficiently manage and transform array data.

Building Blocks for Flow Success

This flow utilizes the Core Excel package. If you attempt the identical operations using the MS Excel Package, the flow will result in an error. The success of this flow hinges on the Array package, which must be installed before you execute the flow.

How to install a package?

1. Click the cube icon to access the packages page

2. Right-click on a package and then select "Install."

Flow Steps

1. ‘Inject’ node is used to initialize the flow.

2. Function node named “Config” includes some javascript code to define variables.

Function Node Named “Config” Code-Block:

//Excel Path of Data Table
msg.excel_path = "YourDataTableExcelPath";
//Defining Array
msg.array = [];
return msg;

3. The "Open Excel" node is used to initiate the opening process for the provided Excel file path. It requires a file path with the ".xlsx" extension as input and produces an output termed as the "Excel File Descriptor."

4. The "Get Range" node is utilized for data retrieval. It requires an Excel File Descriptor as input, and in this case, we're using the default msg.excel_fd variable. The output is an object that encompasses arrays of rows and columns. In the options tab, we've selected "All Range" as the target and opted to include "Headers" for column identification.

5. The "For Each Row" For Each node is employed to iterate through and process each row of data. It requires an array variable as input. In this flow, we are processing each row within the msg.table.rows array.

6. The "Array Push" node is used to append a value to a row within an array.

7. The "Go To Next Row" Go To node is used to navigate to a specific label. In this scenario, it is used to transition to the next row.

8. The "Next Row" label node serves as a reference point for navigation within the process.

9. The "Debug: Array" node is utilized for displaying variable values within the flow. If a particular variable is provided, the node will exhibit only the value of the specified variable. In this instance, we utilize the msg.array variable to showcase the values of the array.

10. “The Stop" node is used to stop the flow.

If you have a variable type of number in your flow, but you need to convert this number to string; You can convert number to string by using 'To String' node of ‘Number’ packages.

To begin, Log in to your Robomotion workspace. If you haven't registered yet, you can create your workspace from the provided link.

About the Number Package

The number package consists of 5 nodes. In this package, you will find five essential nodes: 'Assign', 'To String', 'Decrement', 'Increment', and 'Random'. The Number package is a powerful toolset designed to run and simplify basic number operations in your programming workflow. As its name suggests, this package focuses on fundamental numeric tasks, providing a collection of nodes that enable efficient handling and manipulation of numerical data.

Building Blocks for Successful Flow

• To use the 'Assign' node and the 'To String' node, it is necessary to install the 'Number' package.

• You can obtain the 'Number' package by accessing the 'Packages' menu and initiating the download from there.

About 'Assign' Node Inputs

• The value must be entered in the Value data box
• The output of ''Assign” node is variable type of number.

About 'To String' Node Inputs

• Make sure to enter the output value of the 'Assign' node into the Number data field.

• The output of the 'To String' node is of the string variable type.

Flow Steps

1. ‘Inject’ node is used to initialize the flow.
2. Use the 'Assign' node to assign a numerical value.
3. Use the 'To String' node to convert a number into a string.‘To String’ node is used to convert number to string.
4. Stop the flow using the 'Stop' node.