Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION

How-to: Getting started with the UiPath connector in Qlik Application Automation

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
MarkGeurtsen
Support
Support

How-to: Getting started with the UiPath connector in Qlik Application Automation

Last Update:

Aug 9, 2022 11:32:00 AM

Updated By:

Ankit_KSingh

Created date:

Nov 8, 2021 4:18:00 AM

This article gives an overview of the available blocks in the UIPath connector in Qlik Application Automation.
The UIPath connector is built to enable Qlik SaaS users to run processes from Qlik Sense and be able to trigger workflows based on insights gained through your analytics.

Authentication

Authentication to UIPath happens using oAuth2 making use of the authorization code flow or 3-legged-oauth. Users will be redirected to the UIPath login page where they provide consent to Qlik Application Automation. Before starting, you will have to create an external application in the UiPath console and obtain your logical account name.

You can find the Logical Account Name in your browser when you are signed in to UIPath. Your browser URL will show the following URL: https://cloud.uipath.com/{account_name}/portal_/home.
Copy this {account_name} part to the input field.

Next we have to obtain a client ID and client secret. For this it is necessary to create an external application in the UiPath console. You will need to have administrator permissions or ask an admin to help you out on this. 

  1. Head to the Admin area in the UiPath console using the left side bar.
  2. Go to External Applications
  3. Click on Add Application.
  4. Provide a name for the application. This can be of your own choice, we recommend calling it Qlik Application Automation to use this as an identifier.
  5. Make sure the type is Confidential Application.
  6. Click on Add Scopes. In the panel on the right, select Orchestrator API Access and choose the following permissions: OR.JobsOR.ExecutionOR.Folders. Now click on Save.
  7. Provide the redirect URL for the application. Make sure this is set to https://connector.qlikcloud.com/callback.
  8. Click on Add and you will be presented with a popup containing a client ID and a client secret. Copy these to the connector prompt.

In the connector prompt click on save and this will take you to the UiPath login page. The user will be asked to consent to the following permissions:

  • openid
  • profile
  • email
  • offline_access
  • OR.Jobs
  • OR.Execution
  • OR.Folders

Available blocks

The blocks that are available in the UiPath connector focus on being able to retrieve information about jobs and being able to start/stop/restart the jobs:

  • List Processes
  • List Folders
  • List Jobs
  • Get Job
  • Stop Job
  • Restart Job
  • Start Job
  • Run Job and Wait to Finish

Starting a job

To start a new job, you can use the Start Job block in Qlik Application Automation. A few inputs will be required to start the job:

  • Tenant Name - This can be obtained from the UIPath console in the top right corner.
  • Release Key - A lookup can be used for this.
  • Folder ID - Also through a lookup
  • Input Data - A JSON object for the input parameters of the process.

Running a job and waiting for it to finish

You can start a job and wait for it to finish and get the output from the Job. For this purpose, you can use the Run Job and Wait to Finish block in Qlik Application Automation. A few inputs will be required same as the Start Job block:

  • Tenant Name - This can be obtained from the UIPath console in the top right corner.
  • Release Key - A lookup can be used for this.
  • Folder ID - Also through a lookup
  • Input Data - A JSON object for the input parameters of the process.
  • Timeout - Maximum number of seconds to wait before timing out.

 

The information in this article is provided as-is and to be used at your own discretion. Depending on the tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Tags (1)
Labels (2)
Comments
Dalton_Ruer
Support
Support

I will be sharing much more about this exciting new connector in the future but as this is a "getting started" post I figured it would be good to simply share a "getting started" video. 

In this video I demonstrate how easy it is to connect and help you understand the basics of "folders" and "release keys" etc that are required parameters. I demonstrate with 1 automation how to simply hard code values to assign to input parameters in your UiPath process, but then I show you how to configure a dashboard to call your automation and utilize values from within it, to feed the input parameters. 

Analytics to Execution! What an exciting time we live in. 

 

Dalton_Ruer
Support
Support

Since creating the video the Application Automation Team added another block. A really, really cool block that enables you to Run the UiPath process and Wait to get the results. 

UiPathStartRunAndWait.png

 

But WAIT, there's more. (Couldn't resist the pun) There is more. In fact I walk you through a use case built for this block. 

https://community.qlik.com/t5/Member-Articles/UiPath-Connector-Nobody-wants-to-wait-Or-do-they/ta-p/...

 

Version history
Last update:
‎2022-08-09 11:32 AM
Updated by: