How can I get queue items from Orchestrator and use them to create a DataTable or a FileName.xlsx?

[samuel.chaane (Samuel)]

1. Items are like this in the queue
   
   

I want to add all the dates, open, high, low, close, … volume into a data table

[Aman_Kapoor]

You can use the “Get Transaction Item” activity & there you can pass the name of the queue & pass the output. Once you fetch this item, you can get these details by using TransactionItem.Specific.Content(“Date”) etc

Once you get all these values, put them in an array & assign to “ArrayRow” field of add data row activity after building the datatable with column names.

[samuel.chaane (Samuel)]

I am getting “The given key was not present in the dictionary” on all of them.

[nikhil.girish]

@samuel.chaane Refer this link

How to get queue items then make a summary excel?

Hi @atoth3 I have a solution for you. I just created a sample workflow which takes data from a queue using Get Queue Item. Then it loads the data to a datatable using For Each loop. I’m also using the Add Data Row activity and passing the items to the datatable as an array row. Then finally, writing the data to an excel. So this is similar to your case Check out the sample workflow. The key here is, in the loop, we have to change the TypeArgument to QueueItem for it to loop th…

Hope this helps u

[samuel.chaane (Samuel)]

Thanks a lot, it worked a magic. TypeArgument “UiPath.Core.QueueItems” was the reason behind all this frustrations.

[nikhil.girish]

U are welcome !! Happy Learning