Is there an activity like get queue transaction record from orchestrator?

[mlellison (Max Ellison)]

Hi everyone!

Instead of doing below
Orchestrator > Folder > Queues > View Transactions > Export

Is there an alternative way to get the same transaction report? (e.g. by using UiPath activity?)

Just like we need not to go to orchestrator to find asset data manually, we use Get Asset activity.

Thanks!

[arjunshenoy]

Hi @mlellison

You can do this by using the /odata/QueueDefinitions(QUEUE_ID)/UiPathODataSvc.Reports endpoint.

GET for

https://cloud.uipath.com/your_org_name/your_tenant_name/orchestrator_/odata/QueueDefinitions(YOUR_QUEUE_ID)/UiPathODataSvc.Reports?$top=1000&$expand=Robot,ReviewerUser&$orderby=Id%20desc

Hope this helps,
Best Regards.

[mlellison (Max Ellison)]

Hi @arjunshenoy

Thanks for the quick response, let me try this out!

Say in Queue A, there are some transaction record created previously, and today i run the same queue and generated some new transaction record, is it possible to get only the new transaction record (only records for those items that have just performed an action)?

[arjunshenoy]

@mlellison

Yes. Either you can filter the report directly to group the ‘New’ transactions or you can introduce a filter directly in the endpoint something like this:

url = "https://<orchestrator_url>/odata/QueueItems?$filter=Status eq 'New'"

Hope this helps,
Best Regards.

[Anil_G (Anil Gorthi)]

@mlellison

Actually you have an activity for this get queue items …which does the exact same job and it has almost all filters you need available in the properties

https://docs.uipath.com/activities/docs/get-queue-items

This will give a enumerable of queue items variable we can then write the required data to excel using for loop

Hope this helps

Cheers

[mlellison (Max Ellison)]

To those who want to learn how to get any data from orchestrator without manually clicking on it, you may find this video very helpful

UiPath Orchestrator API - Quick Tour