Examples of building bots

Use these example tasks to become familiar with the features and learn to build bots in Automation 360.

Example of entering data into a web form from a worksheet
In this example, you build a bot to enter multiple rows of data from an XLSX sheet into a web form. Use actions from the Excel advanced, Loop, and Recorder packages.
Example of passing a value between bots
Learn how to pass a value from one TaskBot to another by using a dictionary variable.
Example of using a conditional statement
In this example, you build a bot that prints a message based on whether a cell has a value or is empty. Use the actions from the Excel basic or Excel advanced, If, and Message Box packages.
Example of using Python script to join a list
Build a bot that uses a Python function to print the message Go Be Great!, the Automation Anywhere version of Hello World. In this example, the bot combines a list of string values and prints them to a message box.
Example of using the DLL package
Build a very simple DLL that will generate a message. Create a bot to run the DLL.
Example of transferring data from CSV file to Excel worksheet
In this example, you build a bot to update the product inventory in an Excel worksheet with new product names from a CSV file. Use actions from the CSV/TXT, Excel advanced, IF/ELSE, and Loop packages.
Run TaskBot to merge Excel sheets
Download and run sample TaskBot from the Bot Store to merge two spreadsheets.
Example of migrating data from Excel to a database
In this example, you build a bot to transfer values from an Excel spreadsheet to a database using actions from the Database, Excel advanced, and Loop packages.
Example of using the Run action
The Run action from the TaskBot package enables you to run and pass values to one or more child bots. In this example, you use the Run action to pass two values from a parent bot to the child bot; the child bot adds the values and passes the sum back to the parent bot.
Example of using the SOAP web service action
Use the SOAP web service action to pass two numeric values and return the sum from an online calculator application.
Example of using Get structure command from SAP BAPI package
Using the SAP BAPI package, build a bot that inputs a structure to get data.
Example of writing data to SAP using SAP BAPI package
Using the SAP BAPI package, build a bot that writes data to the SAP database.
Example of using Run standard workflow from SAP BAPI package
Using the Run standard workflow action from the SAP BAPI package, build a bot that retrieves data from SAP systems.
Example of using the VBScript package in a resilient bot
Build a bot that executes a Microsoft Visual Basic script. Use the Try/Catch package to gracefully end the bot if it fails, making it resilient to crashes. A resilient bot allows scheduled and queued bots to continue even if the current bot encounters an error.
Build a Bot Insight dashboard bot
In this example, you build a bot that retrieves data from a website to create visualizations in Bot Insight.
Example of using multiple analyze actions in a task
Build a bot that uses multiple Open and Close Analyze actions in a task to analyze and compare the sales data for each quarter of XYZ Company, and create visualizations in Bot Insight.
Example of updating default package version across bots
This example shows how to perform a bulk update of multiple bots in the Control Room repository and use the default version of the Excel advanced and Message Box packages.
Example of using JSON package actions in a bot
Build a bot that runs a JSON script with multiple records. In this example, we use a JSON file that contains a list of feeds from a blog, and the bot extracts the required information from the JSON file and prints it to a message box.
Example using Email actions in a bot
In this example, we use email actions to perform email-related operations using Outlook Client.
Example of using Custom column option in Data Table package
In this example, you will build a bot to read a CSV file, assign it to a data table variable, and then modify the table by adding a new column. Use the Custom column option in the Data Table package to insert columns at a specified index.
Example of using a file variable
This bot building example uses a file variable containing employee addresses, and the bot extracts and prints the required information into a message box.
Create dictionary type variables
Use Automation 360 to create dictionary type variables using different dictionary subtypes and key value type parameters.