Application-based developer helpers
These helpers work with specific third-party applications and perform commonly needed tasks.
Blue Prism credential and queue management helpers
- Set any credential attribute in Blue Prism Credential Manager
- Load collection of data into work queue
- Retrieve process-related configuration data from the work queue
- Remove all tags from work given queue items
Google tool and usage helpers
- Translate text to new language using Google
- Standardize address format using Google
Microsoft Internet Explorer helpers
Engage
- Send binary value to HTTP endpoint using POST or GET methods
- Send collection to HTTP endpoint using POST method
- Send JSON formatted text to HTTP endpoint using POST method
- Send string to HTTP endpoint using specified method
- Download file using pop-up bar in Internet Explorer
- Get full text from an active webpage
- Insert value into webpage HTML elements using Javascript
Manage application
- Open a new instance of Internet Explorer
- Shut down given instance of Internet Explorer
- Upload HTTP certificate file and return certificate ID
- Close all windows in Internet Explorer
Navigate
- Open the first window and go to URL in new Internet Explorer instance
- Go to URL using Internet Explorer
Microsoft InfoPath helpers
- Get field values and download attachments from InfoPath Form
Microsoft Outlook helpers
Get details (i.e., id, subject, dates, body, to/cc/bcc/from)
- Get email details for all mail from a subfolder with a given subject line
- Get email details for all mail received since a date
- Get email details for all mail with a given subject line
- Get email details for all mail with a given subject line (accepting wildcards)
- Get email details for all sent emails with a given subject line
- Get email details for unread mail
- Get body text from open email in Outlook
- Get sender address and subject line of the first email in the current Outlook folder
- Get all emails (with details) from Outlook folder
Manage application
- Shut down Outlook including all instances
Move/delete email
- Delete email from Outlook inbox
- Move email to given Outlook folder
- Move email to given Outlook folder
Save email
- Save all emails in the sent folder as .msg files to folder path
- Save current email in given file format (text, outlook template, outlook message, HTML, MHT) to folder path
- Using given naming pattern, save all attachments in an Outlook email to folder path
- Using given naming pattern, save the specific attachment in an Outlook email to folder path
- Save current Outlook email to folder path as html file
- Save current Outlook email to folder path as text file
- Save Outlook email as a pdf file to a folder path
- Save attachment(s) in given Outlook email to folder path
Send email
- Send email in predefined template/addressee with given updated information
- Forward email to predefined addressee
- Reply all to a given email ID with the given message with an option to provide new subject line
- Reply all to a given email ID with given message
- Reply to the sender of a given email ID with a given message with an option to provide new subject line
- Send an email with a given subject, body, to/cc/bcc parameters
- Reply all to a given email ID with a given message with an option to add/remove recipients
- Reply all to a given email ID with a given message with an option to provide new subject line
Microsoft PowerPoint helpers
Edit presentation
- Add new slide in selected layout in PowerPoint presentation
- Close and optionally save the presentation in PowerPoint
- Copy given presentation slide in PowerPoint
- Create a new PowerPoint presentation with the selected layout [1099-VBO]
- Duplicate slide in PowerPoint presentation [1100-VBO]
- Get slide count of PowerPoint presentation [1101-VBO]
- Insert new slide to a given location within PowerPoint presentation [1102-VBO]
- Paste slide to a target location within PowerPoint presentation [1103-VBO]
- Perform given paste-special to a target location within PowerPoint presentation [1104-VBO]
- Remove slide from PowerPoint presentation [1105-VBO]
- Select given slide in PowerPoint presentation [1106-VBO]
Edit slide
- Add file object to a PowerPoint slide [1107-VBO]
- Add shape to a PowerPoint slide [1108-VBO]
- Crop image in PowerPoint Presentation to specific coordinates within itself [1109-VBO]
- Edit text and format of a given shape in PowerPoint slide [1110-VBO]
- Edit header text in PowerPoint slide [1111-VBO]
- Resize content area on PowerPoint slide [1112-VBO]
Manage application
- Bring PowerPoint application to the forefront
- Open a new instance of PowerPoint
- Open PowerPoint file
- Run a macro in PowerPoint
- Save the file as new PowerPoint presentation
- Save presentation changes in PowerPoint
- Shut down given instance of PowerPoint
- Start slideshow in PowerPoint
Microsoft PowerShell helpers
- Download SFTP file to folder path using PowerShell
- Return ‘true’ if file exists in SFTP server; otherwise return ‘false’
- Upload file to SFTP server with PowerShell
Microsoft Word helpers
- Export Word file as *.PDF to given folder path
- Get the full text of a file in Word
- Open Word file
- Open Word file and get full text
- Print file as PDF in Word
- Shut down Word, including all instances
SAP Concur helpers
- Go to new URL while within SAP Concur webpage
- Log in to SAP Concur through webpage with provided credentials
- Maximize SAP Concur webpage window
- Open SAP Concur webpage
- Shut down SAP Concur webpage
Tableau helpers
- Export Tableau dashboard images to folder path
- Log in to Tableau dashboard webpage using provided credentials
- Open dashboard webpage in Tableau
- Return ‘true’ when filter settings are as expected within Tableau dashboard; Otherwise returns false
- Save Tableau dashboard to folder path
- Set filters within the Tableau dashboard
- Shut down Tableau dashboard webpage
Zip helpers
- Save all files in a folder path (including subfolders) to a given zip file and folder path
- Save Zip file contents to folder path
General developer helpers
These helpers are designed to fulfill basic needs that could present in just about any automation. They will speed developer productivity, ease testing and simplify maintenance activities.
Collection management helpers
Create a collection
- Create a collection by combining two source collections
- Create a collection by copying the current row
- Create a collection by parsing string delimited by user-defined text
Delete records
- Delete all rows that have given value in a column
- Delete the first row when the given value matches a value in a column
Get values
- Create given character-delimited string including all row in a collection
- Create comma-delimited string containing column names
- Get all rows where specified text is in a column
- Get the first row with matching value in given column
- Get value from a given field
- Get value of every row in a column
- Get field value if same value exists elsewhere within a column (i.e., more than one occurrence)
Modify collection
- Create a collection by copying rows based upon the value in column
- Get and then remove columns from a collection
- Move column in a collection
- Move columns in a collection conforming to new column map
- Retain the first match and remove later matches based upon column value
- Create single-row collection using two columns in a multi-row collection so that one row is field names and another row values
- Transpose a multi-row single-column collection into single-row multi-column collection
- When field label is given value, update the value in a given field with the given text
Update values in a collection
- Replace all matching values in collection with given value
- Replace given text in each row of a column with given text
Verify contents
- Return ‘true’ if a collection doesn’t have any rows; otherwise returns ‘false’
- Return ‘true’ if a given collection field is null; otherwise returns ‘false’
File processing and management helpers
- Save all files in a folder path (including subfolders) to a given zip file and folder path
- Save Zip file contents to folder path
- Copy FTP file to local or server-based shared file path
- Rename the file by appending random text to current name
- Return ‘true’ if file appears in folder within defined period; otherwise returns ‘false’
HTTP helpers
- Send a binary value to HTTP endpoint using POST or GET methods
- Send collection to HTTP endpoint using POST method
- Send JSON formatted text to HTTP endpoint using POST method
- Send string to HTTP endpoint using the specified method
- Upload HTTP certificate file and return certificate ID
Regex helpers
- Delete all special characters in provided regex text
- Get first text that matches given regex pattern in a given string
- Get all text that matches given regex pattern in a given string
- Replaces partial regex expression with the given text
- Return ‘true’ if regex pattern is found in provided string; otherwise returns ‘false’
Screen capture helpers
- Capture screen image and save to folder path
String handling helpers
- Attempt to find an email address, if any, from within given text; returns null if no email found
- Attempt to find field values with given labels from the provided text; returns null if no email found
- Attempt to find phone number (10-digit; 10-digit with +1 country code) in given text and standardizes format (###-###-####)
- Convert text-delimited string into collection
- Get a random string of numbers
- Get field values with given labels from a given collection
- Get next letter in alphabet
- Parse return-delimited text into collection rows
- Remove trailing zeros after decimal place
- Replace one character in text with given character
XML helpers
- Convert XML code to a data collection
- Convert XML code to a nested data collection