Need the count of success and new transactions in a queue

Help Orchestrator
,
1

hi all, i need to know how many transactions in a queue are in new state and successful state with out using get queue items as it has limitation of 100 items only . and my queue has around 1.5 lakh records in it.

I just need the count of success and new transactions in it. how can i acheive it.

2

@vishal_nachankar

Without getting items you might not…even if it is only 100…you can run in loop and use skip and get next set of items

Or use uipth insights which gets consolidated data but only can be used in insights

Cheers

3

Do you have access to Orchestrator backend DB as the count is more than a lack. if you have access - you could check it from the orchestrator server connecting to DB.

OR try below also.

  1. Use the UiPath Orchestrator API**: You can make API calls to the Orchestrator to get the queue items.
  2. Filter by Status**: Use the API to filter items by their status (e.g., “New” and “Successful”).
  3. Count the Items**: Parse the response to count the number of items in each state.

Note- I haven’t tried any of the above method. Just sharing some thoughts only

4

give a try at swaggger and get the count directly

5

can you tell me how to do that?

6

@vishal_nachankar

looks like you can get the count directly by using this api call

The image shows two API endpoints under "QueueProcessingRecords" for UiPath, highlighting the endpoint to retrieve queue processing status for all queues. (Captioned by AI)
The image shows two API endpoints under "QueueProcessingRecords" for UiPath, highlighting the endpoint to retrieve queue processing status for all queues. (Captioned by AI)1746×376 39.2 KB

The image shows a detailed model schema of a queue processing status DTO, specifically highlighting attributes related to the number of successful transactions, application exceptions, and business exceptions. (Captioned by AI)
The image shows a detailed model schema of a queue processing status DTO, specifically highlighting attributes related to the number of successful transactions, application exceptions, and business exceptions. (Captioned by AI)1456×672 45.8 KB

check swagger for more details : <orchestratorURL>/swagger/index.html

cheers

7

Use swagger for learning and RnD at the Orchestrator Rest API

The image provides instructions on how to access the Swagger API definition for an Orchestrator instance by appending a specific URL suffix, along with an example URL. (Captioned by AI)
The image provides instructions on how to access the Swagger API definition for an Orchestrator instance by appending a specific URL suffix, along with an example URL. (Captioned by AI)1056×138 19.9 KB

taken from: https://docs.uipath.com/orchestrator/automation-cloud/latest/api-guide/authorizing-api-calls-in-swagger

endpoint:

This image shows an API query setup for retrieving a collection of queue items from a service, with various parameters such as mandatoryPermissions, atLeastOnePermissions, $filter, and $count highlighted to include the total count of items in the result. (Captioned by AI)
This image shows an API query setup for retrieving a collection of queue items from a service, with various parameters such as mandatoryPermissions, atLeastOnePermissions, $filter, and $count highlighted to include the total count of items in the result. (Captioned by AI)1153×967 43.3 KB

Filter:

QueueDefinitionId eq XXXX and Status in ('New', 'Successful')

every other needed items can also be procured dynamically with the the Rest Api

Once it is working within swagger, then port it to the
grafik

And process the response

Kindly note:
grafik
And that afterwards the calls can also be optimized for reducing the returned data e.g. using Select and reduce the returned properties ( as you are only interessted on the total count)

8

message":"Folder does not exist or the user does not have access to the folder.","errorCode":1100,"traceId":"00-d070cb422f63659be907f2ef955b0f90-9759191f750b664f-00"

I have the bearer token and in swagger it is working but in UiPath i am getting the above error.

9

ensure that you have connected to the same folder feed as used within swagger

grafik
grafik306×104 6.53 KB

10

Yes i am connect to the same folder. i have access to different tenants. region based basically

11

then please share with us your implementation details done within UiPath. thanks

12

what all details u need

13

what was done in UiPath e.g. used Activity and its relevant configuration etc. Without additional insights that we can inpsect we only can give general comments

14

I am using http request with end point as
“https://***/odata/QueueProcessingRecords/UiPathODataSvc.RetrieveQueuesProcessingStatus?%24filter=QueueDefinitionName%20eq%20’IT003.US.PMT_8D_Download_Process_Dev’&%24count=true”

In headers i am passing

A screenshot showing a headers configuration window with three entries for Content-Type, X-UIPATH-OrganizationUnitId, and Authorization in a UiPath workflow. (Captioned by AI)
A screenshot showing a headers configuration window with three entries for Content-Type, X-UIPATH-OrganizationUnitId, and Authorization in a UiPath workflow. (Captioned by AI)1111×357 38.3 KB

15

Cilent id is created with this scopes
OR.Queues OR.Queues.Read OR.Queues.Write OR.Folders.Read OR.TestDataQueues OR.TestDataQueues.Read OR.TestDataQueues.Write

16

kindly note that the following activity was mentioned:

17

in http orchestator i dont have the options to add the headers and all as token and all is required for authentication

18

excactly as it will be done as inbuilt. So the benefit

19

But i am not able to do that using orchestrator http request… when i try using that i am getting html response. for that reason only i switched from orchestrator http request to normal http request. My orchestator is on premise not on cloud

20

when it has swagger it will also work for on-prem

However, before extending this ping-pong. feel free to use our recommendations and when assistance is needed on this then share with us directly relevant information.

e.g. for

might be better to

for sure there are alternates to get this task done. However we recommend of not fast hopping between options as on afirst try an issue occurs. Maybe better to focus on issue analysis