Getting InvalidOData error while trying to fetch queue items using Get Queue Items

[santo.reddy2023]

I want to get data from queue for last 24 hours. I am trying to use Now.AddDays(-1) in from and leaving To empty but i am getting below error. I am using version 23.10.

Below is how my Get Queue Items properties lookslike.

Below is how my code looks like.

[ppr (Peter Preuss)]

@santo.reddy2023
Welcome to the forum

can you check:

• the usage of the right QueueName
• UiPath Studio is attached to the right folder feed, which contains the Queue

@santo.reddy2023

I am using version 23.10.

Let us know also which Version of UiPath.System.Activities is used

[santo.reddy2023]

It is 23.10.1 version

[ppr (Peter Preuss)]

take a backup of your XAML / Project

@ppr

UiPath.System.Activities

try upgrading to 23.10.2 and try again
when it is failling again
try downgrading toa 22.10.X

[santo.reddy2023]

Still the same. I Tried with 23.10.1, 22.10.1 & 22.10.3

[ppr (Peter Preuss)]

@santo.reddy2023

22.10.1 & 22.10.3

in our crosscheck

• 23.10.2
• 22.10.8
  did work. We tested not all other versions explicitly

[copy_writes (chethan)]

Please check the connection in assistant.

and please check the folder access.
if everything looks good please create one more queue and check if you can able to fetch or not.

Orchestrator API query functions

Hi guys, I am querying the QueueItemEvents in our on-premise Swagger UI. When I use a simple $filter=Status eq ‘Successful’ there is a hit with code 200. But when I try to filter with a string function like $filter=contains(Timestamp,‘2019-12’) to get only events from December 2012 it gives a code 400 with body: { “message”: “Invalid OData query options.”, “errorCode”: 1000, “resourceIds”: null } What am I missing?

[philips.pabeda]

Have you resolved this issue?
I encounter the same issue.

[RPraschma (Richard Praschma)]

Where you able to resolve this issue?
I am running in the same problem.
The moment I add a value to the “from” property I get this error message.
With the “from” property I have no issue.

Same goes with the “To” property.
I tried “Now.AddDays(-1)” as DateTime and as Nullable DateTime
I also tried “Now.AddDays(-1).Date” or just “Now”

[santo.reddy2023]

Couldnt solve it. Probelm still exists. Tried all the options so far which i got to know.

[g.ward (Gareth Ward)]

Also have this bug, bumping to get UiPath’s attention

[Alex_Dickens (A.Dickens)]

Bumping for attention, a very annoying bug!

[Thao_Tran]

I found another post with the solution

Get queue items returns error "Invalid odata query options code 1000"

Navigate to Orchestrator> Tenant > Settings > General Scroll down to “API Settings” and disable the checkbox selected Save the configurations

Another way to fix this is removing the time filter in the activity Get queue items (putting anything in there will cause the issue), and then using Linq to filter the output. But to do this, I have to use the Postponed field or a specific content to store the transaction creation time.

Note that I tried to change system.acitivites package version (23.10.2/3/4 all failed), and use datatype Nullable(datetime) instead of system.datetime.

[TJTheBuilder (TJ)]

I’ll point out that I have had a similar but perhaps not identical issue, where I’m getting this error. It was because the queue item reference contains an apostrophe, and removing/replacing that has allowed items to be returned. It may be worth checking your references.