QueueIetems API resulting all items without any filter

Help Studio
,
1

Hi All,

I am trying to get all failed items from Queue using Orchestrator API.

Environment: On-Prem Orchestrator
Version: 2024.10
Endpoint:

https://<Orchestrator>/Development/orchestrator_/odata/QueueItems?filter=QueueDefinitionId%20eq%203528%20%20and%20(Status%20eq%20%272%27))&$expand=Robot,ReviewerUser&$orderby=Id%20desc

But getting all items, not the failed items alone.

Params:
filter - QueueDefinitionId%20eq%203528%20%20and%20(Status%20eq%20%272%27))

Headers:
Authorization - “Bearer ”
X-UiPath-OrganizationUnitId - 31
Content-Type - application/json;odata.metadata=minimal;odata.streaming=true

Currently checking it from postman, from swagger I am not able to do this since authentication has issues.

2

Hi,

End Point - /odata/QueueItems

Here are some additional filter options:

Field Example Filter Description
Status Status eq 'Failed' Filters by item status.
QueueDefinitionId QueueDefinitionId eq 12345 Filters by specific queue.
CreationTime CreationTime gt 2024-01-01T00:00:00Z Filters by creation date/time.
Reference Reference eq 'YourCustomReference' Filters by reference field.
3

@hi @sarathi125 ,

in endpoint you can add below data,

----odata/QueueItems?$filter= Status eq ‘Failed’ and in headers section you can pass you queue ID.

it will help

A HTTP GET request is shown in Postman with specific headers highlighted, including "X-UIPATH-OrganizationUnitId" and a successful 200 OK response. (Captioned by AI)
A HTTP GET request is shown in Postman with specific headers highlighted, including "X-UIPATH-OrganizationUnitId" and a successful 200 OK response. (Captioned by AI)806×338 30.1 KB

4

@sarathi125,

Can you try like this in decoded format.

https://<Orchestrator>/Development/orchestrator_/odata/QueueItems?filter=QueueDefinitionId eq 3528  and (Status eq '2'))&$expand=Robot,ReviewerUser&$orderby=Id desc
5

Hi @ashokkarale,

Still getting all items,

https://<Orchestrator>/Development/orchestrator_/odata/QueueItems?filter=QueueDefinitionId eq 3528  and (Status eq '2'))&$expand=Robot,ReviewerUser&$orderby=Id desc
6

@Gokul001,

I am able to get all 1186 items from the queueitems, but not getting the failed items

7

Resolved it by the below items,

The image displays query parameters with keys and values, including filters, limits, expansions, and order-by criteria for data retrieval. (Captioned by AI)
The image displays query parameters with keys and values, including filters, limits, expansions, and order-by criteria for data retrieval. (Captioned by AI)836×317 14.5 KB

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.