Bulk Item update in Blue Prism

[ManishRaw]

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
------------------------------

[Tejaskumar_Darji]

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
------------------------------