# Orchestrator API - Queue item filter for StartProcessing and EndProcessing

**URL:** <https://forum.uipath.com/t/orchestrator-api-queue-item-filter-for-startprocessing-and-endprocessing/467833>\
**Category:** Automation Starter\
**Tags:** question, studio, activities\
**Created:** [August 25, 2022, 5:47am UTC](https://forum.uipath.com/t/orchestrator-api-queue-item-filter-for-startprocessing-and-endprocessing/467833 "2022-08-25T05:47:36Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Naveen\_Chaganti](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/naveen_chaganti/32/265534_2.png) [@Naveen\_Chaganti](https://forum.uipath.com/u/Naveen_Chaganti)\
**Post date:** [August 25, 2022, 5:47am UTC](https://forum.uipath.com/t/orchestrator-api-queue-item-filter-for-startprocessing-and-endprocessing/467833/1 "2022-08-25T05:47:36Z")

</div>

Hi team

I am using orchestartor API to fetch failed and successful queue item details and i am able to fetch that using below query

**"/odata/QueueItems?$filter=(Status eq ‘Failed’ or Status eq ‘Successful’) and QueueDefinitionId eq " + QueueID**

but now i want to pass starttime grater than "  
08/24/2022 07:10:12" and le now.tostring in the filter to fetch the failed and successful queue item between that time range

tried using below query but below one not skipping as well as not fetching top 100 instead of that it fetching all the items

"/odata/QueueItems?$skip=10&$top=100&$count=true&$filter=(Status eq ‘Failed’ or Status eq ‘Successful’) and QueueDefinitionId eq " + QueueID

any one having idea on this @Palaniyappan @ovi

@ovi @loginerror **there is a issue with get queue item , still unable to fetch end transaction time**

---

<div class="post-metadata">

**Author:** ![marian.platonov](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/marian.platonov/32/260263_2.png) [@marian.platonov](https://forum.uipath.com/u/marian.platonov)\
**Post date:** [August 25, 2022, 7:41am UTC](https://forum.uipath.com/t/orchestrator-api-queue-item-filter-for-startprocessing-and-endprocessing/467833/2 "2022-08-25T07:41:42Z")

</div>

Check this example and adapt it:

```auto
https://ORCH_HOSTNAME/odata/QueueItems?$orderby=Id%20desc&$top=1000&$filter=((QueueDefinitionId eq QueueID and (EndProcessing eq 2022-08-09 and StartProcessing eq 2022-08-09)))

```

More details here:

Date Functions [OData Version 4.0. Part 1: Protocol Plus Errata 03](http://docs.oasis-open.org/odata/odata/v4.0/errata03/os/complete/part1-protocol/odata-v4.0-errata03-os-part1-protocol-complete.html#_The_%24search_System) (11.2.5.1.2 Built-in Query Functions)

Building API Requests examples: [Building API Requests](https://docs.uipath.com/orchestrator/reference/building-api-requests)

---

<div class="post-metadata">

**Author:** ![marian.platonov](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/marian.platonov/32/260263_2.png) [@marian.platonov](https://forum.uipath.com/u/marian.platonov)\
**Post date:** [August 25, 2022, 7:44am UTC](https://forum.uipath.com/t/orchestrator-api-queue-item-filter-for-startprocessing-and-endprocessing/467833/3 "2022-08-25T07:44:22Z")

</div>

Another example:

**GET** for `https://ORCHESTRATOR_URL/odata/QueueItems?$orderby=Id%20desc&$top=1000&$select=EndProcessing&$filter=((QueueDefinitionId eq 3 and (EndProcessing gt 2022-08-04 and EndProcessing lt 2022-08-06)))`

_Example results:_

 ![image](https://global.discourse-cdn.com/uipath/original/4X/b/f/3/bf38b0baef25f6b2e225d8ec829172eb2425863e.png)  
m

---

<div class="post-metadata">

**Author:** ![Naveen\_Chaganti](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/naveen_chaganti/32/265534_2.png) [@Naveen\_Chaganti](https://forum.uipath.com/u/Naveen_Chaganti)\
**Post date:** [August 25, 2022, 9:00am UTC](https://forum.uipath.com/t/orchestrator-api-queue-item-filter-for-startprocessing-and-endprocessing/467833/4 "2022-08-25T09:00:15Z")

</div>

hi @marian.platonov

Thank you for the response

It will give only top 1000 but i need to get the more than 5000 records from queue for reporting between the timestamp

do you know how to skip already fetched 1000 items using api

and one more thing above query will fetch only end processing fields and **but i need all the fields of data in queue which the status in Failed or successful state between the time period**

---

<div class="post-metadata">

**Author:** ![marian.platonov](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/marian.platonov/32/260263_2.png) [@marian.platonov](https://forum.uipath.com/u/marian.platonov)\
**Post date:** [August 25, 2022, 10:44am UTC](https://forum.uipath.com/t/orchestrator-api-queue-item-filter-for-startprocessing-and-endprocessing/467833/5 "2022-08-25T10:44:14Z")

</div>

### 

Rate Limit for Results Displayed for Automation Cloud Orchestrator API Request

Note that, for Automation Cloud Orchestrator services, the results displayed by the API requests are limited to **1000** entries for each page.  
You can use `$top` and `$skip` parameters in your requests to retrieve subsequent pages. For example, use the `GET https://cloud.uipath.com/odata/QueueItems?$top=1000&$skip=2000` request to retrieve the robot log entries between 2001 and 3000.

> **[Orchestrator - Building API Requests](https://docs.uipath.com/orchestrator/standalone/2023.10/api-guide/building-api-requests)**
>
> The UiPath Documentation Portal - the home of all our valuable information. Find here everything you need to guide you in your automation journey in the UiPath ecosystem, from complex installation guides to quick tutorials, to practical business...

> **[Orchestrator - Building API Requests](https://docs.uipath.com/orchestrator/standalone/2023.10/api-guide/building-api-requests)**
>
> The UiPath Documentation Portal - the home of all our valuable information. Find here everything you need to guide you in your automation journey in the UiPath ecosystem, from complex installation guides to quick tutorials, to practical business...

---

<div class="post-metadata">

**Author:** ![marian.platonov](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/marian.platonov/32/260263_2.png) [@marian.platonov](https://forum.uipath.com/u/marian.platonov)\
**Post date:** [August 25, 2022, 12:19pm UTC](https://forum.uipath.com/t/orchestrator-api-queue-item-filter-for-startprocessing-and-endprocessing/467833/6 "2022-08-25T12:19:56Z")

</div>

Mark as the solution the correct post in the thread in order to help other users.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/system/32/182466_2.png) [@system](https://forum.uipath.com/u/system)\
**Post date:** [August 28, 2022, 12:20pm UTC](https://forum.uipath.com/t/orchestrator-api-queue-item-filter-for-startprocessing-and-endprocessing/467833/7 "2022-08-28T12:20:15Z")

</div>

Closed on August 28, 2022, 12:20pm UTC

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