I want to create a process in which I need to get the details of queue item from orchestrator whether it’s successful,failed or anything …I need to get all the details and additional exception details also in the Excel sheet . Could anyone plz help.
Hi @Neha_Aggarwal1 ,
You can use get queue items activity. It will give you all the queueitems in that queue. You can even use filters based on Status, priority etc.
https://docs.uipath.com/activities/other/latest/user-guide/get-queue-items
You can loop each queueitems and get required data
For ex: item.SpecificContent(“ClaimID”).ToString (As shown in above image)
Hope it helps.
and how to get the exception reason also? , could u plz elaborate
You can create same workflow as shown above and retrieve all the required data. And for exception reason, as @vishal.kp suggested, you can use item.ProcessingException.Reason
i have to write the data into excel sheet also ,could u plz elaborate this too, after the writeline acitivity i have to use write range or how to do that?
Hi @Neha_Aggarwal1 ,
Use Build datatable activity to create a datatable with required columns.
Use Get Queue Items activity to get all the queues. (You can select only failed queues in the property panel)
Use a for each activity to loop into each queue items. (Type argument of for each should be UiPath.Core.QueueItem)
Use add data row activity to add required data to the datatable.
At the end use write workbook range to write into excel file.
Build data table configuration:
Hope this helps.
Regards,
Harshith
Please check this on how to retrieve each field …create a report from queue items
cheers
thanku so much for help, one more doubt how we can get the status details also from queue ,like its new,deleted,failed, retried or anything .
this is giving error ,not working
Try : item.Status
item.ProcessingException.Reason
This works for failed queues.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
