Hellow forum,
I want to extract all the items present in the queue and then store them in an excel file. I have not been able to find an answer to this query. Any help would be appreciable.
Thanks in advance.
As suggested by @Gokul001 you can use get queue items but it has a limitation of 100 items so use it in a loop and use the skip property to skip and retreive the next set of queue items to get all the items
Cheers
1 Like
Hi @Gokul001 ,
I have seen this video but the problem is i dont want to iterate through each queue item as i dont want to go through each column name.
Is there any way by which i can directly paste the queueitems into an excel sheet.
I don’t think so we can able to get all the queue item at one go… You need to loop through and get the data.
Regards
Gokul
You cannot avoid loop but if you don’t want to write the column names you can avoid that but again by using a loop on quls.SpecificContent.keys. So that dynamically you can create a table and add data to that.
cheers
have a look on the following:
similar to what we can do in orchestrator (Queues > View Transactions)
we can do also this via ORC Rest API on endpoint:
odata/QueueDefinitions(YourQueueID)/UiPathODataSvc.Reports
along with some other ODATA settings like filter, order, …
But the same, when the maximum of results per call is exceeded we do paging by top and skip settings
I am facing a issue in get queue item only get 100 transaction. How to add all data data in excel?
Anil_G
Yoichi
ashokkarale
Akash_Javalekar1
mnurhaikal
seki_i
mateuszmacheta
lrtetala
David_Hernandez2
Erimateia