BPAWorkQueueItem

[mohammedareebdps]

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

[shashank.kumar280]

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

[mohammedareebdps]

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