Bulk Item update in Blue Prism

ManishRaw — Thu, 22 Sep 2022 09:18:00 GMT

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

RE: Bulk Item update in Blue Prism

Tejaskumar_Darji — Thu, 22 Sep 2022 12:24:00 GMT

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

topic RE: Bulk Item update in Blue Prism in Product Forum

Bulk Item update in Blue Prism

RE: Bulk Item update in Blue Prism