How to pass param thru hyperlink that triggers an RPA to open a web page & submit param in page

PeterV

New Member
Hello,

I am brand new to the world of RPA. I have a need and it seems the only way I can see to meet it is possibly through RPA. I want to confirm the following is possible using RPA and determine a suitable RPA product to do it.

Background
Our company has a space management app with a web page where any of our 1,400 employees can sign into (using SSO & DUO) and manually enter a building ID and room ID (format: BLDID-RMID, e.g., CG1-2042) to visually see where the room is located in the building. When a BLDID-RMID is entered, this web page will display the appropriate floor plan in that building and highlight that room (showing exactly where it is).

The Problem
I want to create an Excel or Google spreadsheet listing all of our building and room IDs. The text of each BLDID-RMID in the spreadsheet would actually be individual unique hyperlinks (e.g., https://RPAlocateroom.com/BLDID-RMID) that when clicked by an employee would trigger an RPA that would:

1) open the person's browser
2) load the room mapping web page (e.g., https://locateroom.com)
3) if DUO authentication occurs, recognize this and pause until authentication (through their cell phone) is complete and page is loaded
4) Accept a parameter passed through the hyperlink to the RPA (e.g., https://RPAlocateroom.com/BLDID-RMID)
5) Automatically enter the BLDID-RMID parameter into a specific Building-Room data entry field on the https://locateroom.com web page
6) Automatically click the submit button on the webpage (Causing room location to be displayed)

So to the end user employee, the operation of the RPA is invisible. The employee clicks the hyperlinked BLDG-RM text in the spreadsheet and a browser window pops up visually highlighting exactly where that room is located on the floorplan of the appropriate floor and building.

Restrictions
1) The RPA software to develop this (hyperlink triggered, parameter accepting) RPA routine must not cost more than $200-$300 (one time).
2) The developed RPA routine (triggered by clicking hyperlinks) must be easily deployable to many employees that may click on these links (preferably without requiring any prior installation or maybe by requiring a one-time auto-prompted installation when used the first time) without additional fees per employee that use the deployed RPA (click these links)
3) The room highlighting webpage utilizes SSO and DOU to authorize employee access. The RPA routine must allow for this DUO authentication interruption when the person accesses the webpage (clicks a BLDID-RMID link).

Am I smoking something really good thinking this is possible? Or is this actually possible (at this price point) with one or more of the RPA tools out there?

Thank you much for your help and expertise,

PeterV
 
Last edited:
Top