[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”

[Et al.] Intelligent Development – Developing Intelligently

Along with the emergence of the Fourth Industrial Revolution (4IR) we are seeing an increased usage of rebranded terms, that now contain the word “Intelligent”. We find ourselves surrounded by concepts like Intelligent Automation, Intelligent Digital Workplaces, Intelligent Customer Experience, Intelligent Infrastructure and many more. How much longer until we are faced with the newContinue reading “[Et al.] Intelligent Development – Developing Intelligently”

[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)”

[Power BI] Creating a Hamburger Menu for Filters in Power BI

Level of Difficulty: Beginner – Senior. Often we create Power BI reports that require some sort of filtering mechanism but filters take up a lot of real-estate that could be used for other visuals instead. What if we could hide and show a filter pane using a “hamburger” menu mechanism? We can and here’s how.Continue reading “[Power BI] Creating a Hamburger Menu for Filters in Power BI”

[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”

[Automation]: Using Power Automate with SQL Server (Primary keys that aren’t int)

Level of Difficulty: Beginner – Senior. Are you in a situation where you’re using a SQL database and you’ve already designed, created and gone through all 700 iterations of the review? Primary keys already created of type uniqueidentifier with default value of NEWID(). Then Fred comes with his clever idea of adding some sort ofContinue reading “[Automation]: Using Power Automate with SQL Server (Primary keys that aren’t int)”

[Et al.] Look After The BAs!

As a Developer in an Agile environment, I want to appreciate the Business Analysts (BA) so that we can continue working in a respectful and collaborative manner. Sounds like a user story right? Well maybe it should be so that we can persistently practise this principle. Often we are faced with feuds between colleagues inContinue reading “[Et al.] Look After The BAs!”