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は以下のページにまとまっているので見てね😘✨