topic Re: BPAWorkQueueItem in Product Forum

BPAWorkQueueItem

mohammedareebdps — Wed, 03 Aug 2022 15:20:25 GMT

Hi,

I am trying to insert items into a work queue through SQL. I am using Blue Prism v7.0.1.

My questions are:

1. Is inserting a row in the BPAWorkQueueItem table enough?
2. How is the item id generated? I was trying to insert a row using SQL Server management studio and it kept giving me error on the "id" column : (Guid should contain 32 digits with 4 dashes) even when I used the correct format for the id. Is there a way to generate this id programmatically?
3. What is the queueident column for?

Any help would be greatly appreciated. I have been pulling my hair out trying to figure this out for days.

Regards,
Mohammad Areeb

Re: BPAWorkQueueItem

shashank.kumar280 — Wed, 03 Aug 2022 15:55:05 GMT

Hi Mohammad,

There is Blue Prism API to add items to queue and do other actions. Have you already considered using this?

https://bpdocs.blueprism.com/bp-7-0/en-us/api-spec-7-0-1.html?Highlight=blueprism%20api%20#tag/Work-Queues/paths/~1api~1v7~1workqueues~1{workQueueId}~1items/post

Re: BPAWorkQueueItem

mohammedareebdps — Wed, 03 Aug 2022 16:38:38 GMT

The thing is we don't want to install the Authentication Server required for the API.