Bulk Item update in Blue Prism
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
22-09-22 10:18 AM
Hi Team,
We have a scenario below:
1. Extract data for multiple Items from application database in Bulk.
2. Call API endpoint to update the data for multiple Items in Bulk.
My question here is, is there a way by which we can update the Blue Prism Queue Item in Bulk as well?
Like marking multiple Items as Exception/Completed, Deferring them or Tagging them etc?
------------------------------
Manish Rawat
Project Manager
Mercer
New Delhi
------------------------------
We have a scenario below:
1. Extract data for multiple Items from application database in Bulk.
2. Call API endpoint to update the data for multiple Items in Bulk.
My question here is, is there a way by which we can update the Blue Prism Queue Item in Bulk as well?
Like marking multiple Items as Exception/Completed, Deferring them or Tagging them etc?
------------------------------
Manish Rawat
Project Manager
Mercer
New Delhi
------------------------------
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
22-09-22 01:24 PM
Hello Manish,
For 1) Using SQL VBO - Get Collection Action, you can get all the data from DB in a single collection in one go.
For 2) As far as I know, there is no bulk activity on the work queue item provided default. But you can get a list of Item IDs in one go for certain scenarios and then perform your action using a loop. Generally, WorkQueue-related actions run very fast even running in the loop does not require a long time. Apart from that, some specific bulk updates would require having a customized SQL query run on your BPAWorkQueueItem table in Blue Prism Database.
For example, this Action returns a list of Exception Items and then you can loop on all these items to perform actions.

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".
Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------
For 1) Using SQL VBO - Get Collection Action, you can get all the data from DB in a single collection in one go.
For 2) As far as I know, there is no bulk activity on the work queue item provided default. But you can get a list of Item IDs in one go for certain scenarios and then perform your action using a loop. Generally, WorkQueue-related actions run very fast even running in the loop does not require a long time. Apart from that, some specific bulk updates would require having a customized SQL query run on your BPAWorkQueueItem table in Blue Prism Database.
For example, this Action returns a list of Exception Items and then you can loop on all these items to perform actions.
------------------------------
If I was of assistance, please vote for it to be the "Best Answer".
Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------
