Get Queue Items – “Invalid OData query options. Error code: 1000” when filtering by date

Hello Everyone,

I am trying to filter queue items in the Get Queue Items activity based on today’s date, but I am getting the following error:

Get Queue Items: Invalid OData query options. Error code: 1000

I tried multiple approaches including:

  • system date format
  • the format mentioned in the activity tooltip
  • full datetime values
  • date with and without time
  • UTC and local time formats

However, the same error still appears.

In the screenshot attached, I have highlighted the field where I am entering the date filter.

Could you please help with the correct OData date filter syntax for Get Queue Items or suggest how to filter queue items based on today’s date without getting this error?

Please Note: - The activity works fine without any date filter criteria.

Hi @Narendra_c

The Get Queue Items activity does not support date-based filtering using From/To or CreationTime.Adding any date value results in an invalid OData query (Error 1000).

The correct approach is to retrieve the queue items first and then filter them in the workflow using CreationTime.Date = Now.Date, or use the Reference field if it contains date information.

If solution works for you please mark as solved or let us know if u still face issue

Thanks & Happy Automations

hi @Narendra_c ,

Get all queue items without any filter , then filter in UiPath using LINQ:

queueItems.AsEnumerable().Where(Function(x) x.CreationTime.Date = DateTime.Today).ToList()

Steps:

  1. Get Queue Items → Leave “From/To” fields empty
  2. Set high “Top” value (1000+) or use pagination
  3. Add Assign activity with above LINQ code

@Narendra_c

the issue is because of the setting in orchestrator change it and then try

Orchestrator → Tenant → Settings → -> general → Under API settings Disable strict API

reference - Orchestrator - Settings

cheers

2 Likes

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