How can I generate an Excel report within the UiPath REFramework that captures the status of processed queue items?

[Narendranathan_V]

How can I generate an Excel report within the UiPath REFramework that captures the status of processed queue items? for example, My automation processes 10 items: 7 were successful, 2 resulted in business exceptions, and 1 encountered a system exception. I need to log each item’s outcome in the report and at the end I need to send a report to business

[saintseiyer (Seiya Kawashima)]

To report QueueItems in Excel, you can use Orchestrator Http Request .

By entering the specified Key, the output will be provided as a JSON.
The JSON contains details such as Reference, Status (Succeeded, Error, ApplicationError, BusinessError), etc.
First, convert the JSON into a DataTable, then apply the necessary filters. After that, you can simply paste the filtered data into Excel.

[AJ_Ask]

Hi @Narendranathan_V

By using Get Queue Items also you can achieve it. & Then write that data table to Excel.

HO To get the all the transaction item from the queue

Hi @copy_writes This is how the basic structure will look as there is limitation for get queue items to fetch only 100 we need to add skip with increase in 100 each time [image] also you need to add if condtion to break the loop if the count is 0 in the queue. Add Skip counter with 100 for next set of queue items. In this you can use the for each queue item to create a datatable with all the data. [image] Hope this helps

But I would say Orchestrator HTTP request is better way.

Hope this helps:)

[ashokkarale]

@Narendranathan_V,

Instead of trying to generate report after bot execution finished, create the report while it’s running.

Every transaction will go to Process state so in this xaml add your logic to add each transaction to an excel file.

Thanks,
Ashok

[Anjani_Kapoor (Anjani Kumar)]

In the end state, Use “GetQueueItems” activity, store collections of queue item into a variable using the activity. loop through the collection of queue items and capture the required information into a data table.

[akhantwal]

could you please explain what could be added in the (key)

[postwick (Paul Ostwick)]

You wouldn’t use REFramework for this. What you’re asking to do is fairly simple. Just use Get Queue Items to get an array of queue items from the queue, then loop through that array and extract the information about each item and add to a datatable. Then write the datatable to Excel.