Level of Difficulty: Intermediate – Senior. There are so many really good and useful resources made available on how to use the GitHub API. A lot of work has gone into integrating Azure DevOps and GitHub into automation projects and this is done through their APIs. I have found certain Azure DevOps functions to beContinue reading “[Automation] GitHub (and Enterprise) API Versus Azure DevOps API”
Author Archives: Jacqui Muller
[RPA] Publishing Test Cases From UiPath Studio to UiPath Test Manager
Level of Difficulty: Intermediate – Senior. This post assumes that the background information and pre-work has already been done. The pre-work mainly refers to the understanding of the business problem, the identification of test cases and unit tests as well as the development of the test cases and unit tests. A two-part series was releasedContinue reading “[RPA] Publishing Test Cases From UiPath Studio to UiPath Test Manager”
[Python] Scraping Context (Categories, Topics and Entities) From Websites Using TextRazor and Python
Level of Difficulty: Beginner – Senior. Say you have a website that you’d like to scrape to find out what information the website represents. Well the good news is that you can, in Python, using a library named TextRazor. TextRazor allows you to scrape categories, entities and topics from the website. To use this library,Continue reading “[Python] Scraping Context (Categories, Topics and Entities) From Websites Using TextRazor and Python”
[Automation] Making a SOAP API Call in Python, Using a Session Key
Level of Difficulty: Beginner – Senior. Let’s say you’re working on a system that needs to query a legacy SOAP API. Although SOAP APIs are becoming more scarce as REST and Open Data APIs are taking the world by storm, the reality is that SOAP APIs still exist and are still used. In most SOAPContinue reading “[Automation] Making a SOAP API Call in Python, Using a Session Key”
[Automation] Starting a K2 Workflow from UiPath
Level of Difficulty: Beginner – Senior. UiPath has written an activity (UiPath.K2.Activities) that starts a K2 workflow. It seems quite simple at first; the only input properties that it expects are the service URL, username, password and workflow ID. It was ideal for what I was trying to achieve, until it wouldn’t load my workflowsContinue reading “[Automation] Starting a K2 Workflow from UiPath”
[Automation] Things I wish I knew Before my First Power Automate Hyperautomation Implementation
Level of Difficulty: Beginner – Senior. Any toolset comes with it’s own unique tricks and challenges. There is a ‘first time’ for everything which comes with a list of lessons learnt. By sharing these lists, we better prepare the community of developers who may be facing similar challenges. Here’s a summarised list of lessons learntContinue reading “[Automation] Things I wish I knew Before my First Power Automate Hyperautomation Implementation”
[Automation] Using Power Automate as a Data Integration Tool with Excel (for Bulk Processing)
Level: Beginner – Senior. Power Automate connects into multiple different platforms and systems, making it a very powerful integration tool. Power Automate has been positioned by Microsoft as a platform that aims to facilitate Robotic Process Automation (RPA). Although there is still some work to be done before the Power Automate toolset can match competitors,Continue reading “[Automation] Using Power Automate as a Data Integration Tool with Excel (for Bulk Processing)”
[Automation] Retrieving a List of Mail Senders From a Shared Mailbox (Using Outlook and Python)
Level of Difficulty: Beginner – Senior. Have you ever had a use case where you have a shared mailbox setup on your Outlook but you don’t have the credentials to the account behind the mailbox (if one exists)? Well you can get around that by running the Python script detailed in this post. The approachContinue reading “[Automation] Retrieving a List of Mail Senders From a Shared Mailbox (Using Outlook and Python)”
[Automation] Working with SQL transactions in UiPath
Level of Difficulty: Beginner – Senior. When working with databases, the use of transactions is a very healthy habit to get used to. It will save you from those update or delete statements without a where clause that cannot be undone (especially in prod… Imagine…). UiPath presents the Start Transaction activity which claims to doContinue reading “[Automation] Working with SQL transactions in UiPath”
[Business Intelligence] Connecting a Google Sheet to Power BI as a Data Source
Level of Difficulty: Beginner – Senior. The market for data collection, visualisation and analysis tools spans across many different providers on many different platforms and in some cases, the best way to become exposed to the variety of tools is by mixing and matching between them. So why not visualise a Google Sheet on PowerContinue reading “[Business Intelligence] Connecting a Google Sheet to Power BI as a Data Source”
The JPanda 