[RPA] Using SQL User-Defined Table Types in UiPath as a Component of a Data Exchange Architecture

Level of Difficulty: Intermediate – Senior. This post will assist in understanding what SQL user-defined table types (UDTTs) are and how they can be used within UiPath as a part of a Data Exchange Architecture (DEA). Following explanations of UDTTs and DEA approaches, we will do a practical implementation walkthrough. User-Defined Table Types (UDTTs) User-definedContinue reading “[RPA] Using SQL User-Defined Table Types in UiPath as a Component of a Data Exchange Architecture”

[Automation] YouTube Playlist Monitoring Using Python

Level of Difficulty: Beginner – Senior. There are many different workflow and automation suites/platforms available out there (some of which include IFTTT, Power Automate and Tonkean) that allow users to interact with their YouTube connector. Most of these workflows classify the functions within the connectors as either a Trigger or an Action. A trigger wouldContinue reading “[Automation] YouTube Playlist Monitoring Using Python”

[Automation] Monitoring Gmail Inbox Using Python

Level of Difficulty: Beginner – Senior. Many automation solutions make use of the functionality provided by mail services as it serves as an important element that allows for communication between humans and the automation process. There are many benefits provided by using Google Mail (Gmail), one of which is cost – for that reason, thisContinue reading “[Automation] Monitoring Gmail Inbox Using Python”

[RPA] The Use of Design Patterns in UiPath Processes

Level of Difficulty: Senior. This post will assist in understanding the practical use of design patterns and how they can be applied to the development of processes within UiPath. What’re Design Patterns? In a nutshell, a design pattern can be described as a template (or format) that is used to structure code in order toContinue reading “[RPA] The Use of Design Patterns in UiPath Processes”

[Automation] Working With The UiPath Automation Hub API And Postman (Then Getting The Code)

Level of Difficulty: Beginner – Senior. Does your organisation use Automation Hub to capture and consolidate automation ideas and collateral? Have you ever wanted to interact with the data you have in Automation Hub in an automated manner? Well UiPath makes that easier now with the Automation Hub API – no more front-end automations neededContinue reading “[Automation] Working With The UiPath Automation Hub API And Postman (Then Getting The Code)”

[Python] Using Python for SQL Schema and Table Validation and Logging Progress to Microsoft Teams

Level of Difficulty: Intermediate to Senior. So you’ve reached created a database, you’ve created schemas and tables. You’ve managed to create an automation Python script that communicates with the database, however, you’ve reached a crossroad where you need to validate your SQL tables. Some of the validation might include ensuring that the tables exist andContinue reading “[Python] Using Python for SQL Schema and Table Validation and Logging Progress to Microsoft Teams”

[RPA] Uploading Files to Azure Blob Storage in UiPath Processes

Level of Difficulty: Intermediate – Senior. This post will assist in using Azure Blob Storage to store files used in UiPath processes. A funny thing happened the other day… Jackson broke the news to the team that his laptop was stolen. After some panic, he lets everyone know that at least the latest solution wasContinue reading “[RPA] Uploading Files to Azure Blob Storage in UiPath Processes”

[Python] Auto-Format Code According to PEP 8

Level of Difficulty: Beginner to Senior. So you’ve written a Python Script, Kevin has just told your team that all code needs to be reviewed and part of the team’s Key Performance Indicators (KPIs) will be PEP 8 compliance. Now there’s a slight sense of chaos and stress because “What is PEP 8?! Can oneContinue reading “[Python] Auto-Format Code According to PEP 8”

[Python] Setting up alerts on SQL Server Job Agent failures

Level of Difficulty: Beginner to Intermediate. So you’ve found yourself in a semi-ops situation where you need to do daily checks on SQL Server Agent Jobs because the client, Steve, has concerns that his data is not updating. Now you have to go through the manual process of opening SQL Server Management Studio then loggingContinue reading “[Python] Setting up alerts on SQL Server Job Agent failures”