blue prismは外向けに情報がほとんど出ていないので、何ができるか迷うよね😣😥👎 でも大丈夫、そんな貴方のために、blue prismで使える26の標準VBO (Visual Business Object)とアクションの一覧を紹介するよ😚😄 活用してね😘✨

対象

Blue Prism 6.5.0.12573

標準Visual Business Object

C:\Program Files\Blue Prism Limited\Blue Prism Automate\VBO\ にXMLの形でスキーマが置かれているようだね😚😄

Calendars

Functions for working with calendars and dates.

Add Working Days
Count Working Days In Range
Get Other Holidays In Range
Get Public Holidays In Range
Get Working Days In Range
Is Other Holiday
Is Public Holiday
Is Weekend
Is Working Day

Data - OLEDB

A SQL interface for interacting with OLEDB data sources.

Close
Get Collection
Open
Set Connection
Execute

Data - SQL Server

SQL Server interaction object.

Begin Transaction
Commit Transaction
Configure
Execute
Get Collection
Get CSV File
Get Number
Get Records Affected
Get Text
Rollback Transaction
Set Connection

Email - POP3/SMTP

Retrieve email via POP3 protocol and send using SMTP protocol.

Configure
Delete Message
Get Message
List Messages
Save Attachments
Send Message

Google Sheets

Common actions to interact with Google Sheets. Requires a Google API Client ID and Secret for operation - these must be created as Environment Variables called "Google Sheets API Client ID" and "Google Sheets API Client Secret" respectively

Get Range Values
Set Range Values
Append Data
Clear Range
Create Workbook
Get API Tookens

MS Excel

VBO for interacting with Microsoft Excel.

Activate Workbook
Activate Worksheet
Attach
Attach to workbook
Close All Instances
Close Current Workbook
Close Instance
Close Workbook
Copy
Copy and Paste Worksheet Range
Create Instance
Create Workbook
Create Worksheet
Cut
Delete
Delete Worksheet
Exit
Find Next Empty Cell
Format Cell
Format Current Cell
Get Active Cell
Get Active Cell Value
Get Cell Value
Get Formatted Cell Value
Get Number Of Rows
Get Worksheet As Collection
Get Worksheet As Collection (Fast)
Get Worksheet as Collection Offset
Get Worksheet Name
Get Worksheet Names
Get Worksheet Position
Get Worksheet Range As Collection
Go To Cell
Go To Next Cell
Go To Next Empty Cell Down
Go To Next Empty Cell Left
Go To Next Empty Cell Right
Go To Next Empty Cell Up
Hide
Hide Other Worksheets
Hide Worksheet
Import CSV
Insert
Is Read Only
Move Worksheet
Open Instance
Open Workbook
Paste
Protect Workbook
Release Instance
Remove Blank Rows
Run Macro
Save Current Workbook
Save Current Workbook As
Save Workbook
Save Workbook As
Select
Set Cell Value
Set Current Instance
Set Events Enabled
Set Window Location
Set Window Size
Set Window State
Show
Split Worksheet
Worksheet Exists
Write Collection
Write To Clipboard

MS Outlook Email

VBO for interacting with Microsoft Outlook email functions.

Send Email
Reply All to Email
Reply to Email
Forward Email
Save Email As File
Delete Email
Mark Email As Read
Mark Email As Unread
Move Email to Inbox Sub Folder
Save Attachments
Save Attachment
Get Sent Items (Basic)
Get Sent Items (Advanced)
Get Sent Items (Expert)
Get Received Items (Basic)
Get Received Items (Advanced)
Get Received Items (Expert)

MS Word

VBO for interacting with Microsoft Word.

Add Table Row
Attach Instance
Clear Clipboard
Close
Copy to Clipboard
Create Document
Create Instance
Detach Instance
Exit
ExportPDF
Find Text
Get Body
Get Footer Text
Get Highlighted Text
Get Table Cell Value
Hide
Open
Paste from Clipboard
Replace Highlighted Text
Save As
Select All
Select Next Cell
Select Next Field
Set Current Instance
Set Selected Cell Text
Set Selected Checkbox
Set Table Cell Value
Show
Type Text
Update Bookmark

System - Active Directory

Business Object for interacting with Active Directory using the LDAP based API in .NET.

Add User to Group
Create User
Object Exists (Dynamic)
User Exists (Displayname)
User Exists (UserPrincipalName)

Utility - Collection Manipulation

Utility functions for manipulating collections.

Append Field (Number)
Append Field (Text)
Append Rows to Collection
Collection Contains Field
Collection Contains Value
Copy Rows
Delete Column
Delete Field
Field Exists
Fill Blanks
Filter Collection
Get Collection Fields
Merge Collection
Read Collection Field
Remove dots from headers
Remove Empty Rows
Remove Null Rows
Rename Collection Fields
Rename Field
Reverse Collection
Set Collection Field
Set Column Names From Expected Collection
Set Column Names From First Row
Sort Collection
Split Collection
Transpose Collection

Utility - Date and Time Manipulation

Utility functions for manipulating dates and times.

DateAdd
Format Date
Get Last Working Day
Get Maximum TimeSpan
Get Time of Day
Get Time Zones
local to UTC
UTC to local

Utility - Encryption

Provides encryption and decryption facilities. Use the BPServer interface to generate a key to use with these actions.

Decrypt
Encrypt

Utility - Environment

Utilities for interacting with the environment - read screen resolution, determine OS type, etc.

Clear Clipboard
Font Smoothing Enabled
Get Clipboard
Get Machine Name
Get Screen Resolution
Get User Name
Kill Process
Read Memory Stats
Read Process Working Set
Run Process Until Ended
Set Clipboard
Start Process
Wait for Process
Wait for Process Window

Utility - File Management

Utility methods for interacting with the file System.

Append to Text File
Append to Text File
Combine Path
Configure
Copy File
Create Directory
Delete Directory
Delete File
Delete Files
Directory Exists
Download File
File Exists
Get CSV Text As Collection
Get File Size
Get Files
Get Folders
Get Special Folder Path
Move File
Read All Text from File
Read Lines From File
Split Path
Sub Directory Exists
Write Binary Data
Write Text File

Utility - Foreground Locker

Controls access to foreground operations by providing a locking mechanism.

Lock Foreground
Release Foreground Lock

Utility - General

General utility functions which don't fit into specific categories.

Process Exists
Sleep
Window Exists

Utility - HTTP

Communicates with web services using the HTTP protocol.

HTTP Request
Load Certificate
Post
Post JSON

Utility - Image Manipulation

Utility methods for analysing and manipulating images.

Find First Pixel From Bottom
Find First Pixel From Left
Get Sub Image Position
Image Contains Colour
Image Is Uniform Colour
Image is White

Utility - JSON

An object for parsing JSON into a collection and turning a collection into JSON.

Collection to JSON
JSON to Collection
JSON to Collection (skipping JArray)

Utility - Locking

Manages locks on items.

Lock Item
Release Lock
Set Up Queue Item

Utility - Network

A utility object with network related actions.

Ping

Utility - Numeric Operations

Mathematical functions

Calculate Rolling Average (fixed denominator)
Calculate Rolling Average (variable denominator)
Get Absolute Value

Utility - Strings

Utility functions for manipulating text.

Compare Font Text
Delete Characters
Escape Sendkeys String
Extract Regex Values
Format Number
Generate New GUID
Get Collection as CSV
Get CSV As Collection
Get Newline Character
Get XML Attribute
Get XML Elements
InStr
InStrRev
Join Lines
Join Text
PadLeft
Remove Non-word Characters
Split Lines
Split Lines by Length
Split Text
Test Regex Match

Utility - Windows Compressed File

The VBO utility to manage Windows Compressed files

Create Zip from Folder
Add File to Zip
Extract All from Zip
Delete File from Zip
Get Zip Contents
Find File in Zip

Webservices - OAuth2.0

Business Object for authorization using OAuth2.0.

Load Certificate
Request

Webservices - REST

Connects to REST based webservice API's.

Delete
Get
Post
Put
Setup OAuth

Blue Prism Digital Exchange (クラウド)

Blue Prism DX ( https://digitalexchange.blueprism.com/dx/ )で使える主なVBOは以下のページにまとまっているので見てね😘✨

Blue Prism オンボーディング～はじめよう! Blue Prism～第 6 回 Blue Prism Digital Exchange (DX) から部品をダウンロード - ブログ