Extracting Datatables from Queue

[elliot.barling]

I have seen a lot of varying questions surrounding queue items and how they should be extracted. My question is this:

I add a datatable variable to the queue using the ‘Bulk Add Queue Items’ activity which should create a datatable equivalent for this queue item.
How do I then get this queue item in its entirety into a datatable again for the bot the then process?

I currently have the following in my process workflow:

^ Do While
^ Get Transaction Item (extracts item as a ‘QueueItem’ variable)

I now need to convert that ‘QueueItem’ variable into a datatable variable

Thanks

[ashokkarale]

@elliot.barling,

You will have to deserialize the JSON. Use like this.

DT = Newtonsoft.Json.JsonConvert.DeserializeObject(Of Datatable)(QueueItem.SpecificContent("your datatable key").ToString)

Thanks,
Ashok

[mkankatala (Mahesh Kankatala)]

Hi @elliot.barling

Check the below thread for better understanding,

Gather DataTable from work Queue

Hey Team, I have a bunch of datatables (with nested datatables within them) stored in my queue which have been extracted from the Process Application How do I get the datatables… into the queue as it looks as though queue items can only be strings? Out of the queue as I can only seem to pull out a ‘QueueItem’ variable at the moment Thanks

Hope it helps!!