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

[Rui_Leite]

Using the activity get queue items with a datetime variable in the “from” field, returns an error (see title)
The datetime variable is being created with an assign and given the value Datetime.now
I tried different formats and got the same error.

This component was working before we migrated from Orchestrator on-premise to the cloud.
Any help would be appreciated

Project dependencies:

"UiPath.Excel.Activities": "[2.12.3]",
"UiPath.GSuite.Activities": "[1.16.2]",
"UiPath.Mail.Activities": "[1.15.2]",
"UiPath.System.Activities": "[22.4.1]",
"UiPath.UIAutomation.Activities": "[22.4.5]

[lrtetala (Lakshman Reddy)]

Hi @Rui_Leite

Please check on the below doc

Orchestrator - Response Codes

Cheers!!

[mkankatala (Mahesh Kankatala)]

Hi @Rui_Leite

Instead of using the Datetime variable, try change the datatype to string datatype.

- Assign -> datetime (String) = Datetime.Now.toString

Hope it helps!!

[rikulsilva (Henrique Lima da Silva)]

Hi @Rui_Leite

DateTime.Now should work. Instead use variable, open de Advanced Editor e try add DateTime.Now directly

If the issue persists, kindly share screenshot for your Get Queue Items Actiity and properties

Cheers

[Rui_Leite]

Did you mean use datetime.now in the properties panel instead of a variable?
I tried it and got the same result.

Here’s the properties panel and debug panel while executing.

The problem is 100% in the From field, if I leave it empty, it works.

[Rui_Leite]

I’ve seen the document but it doesn’t seem to specify what I should do to fix the error, I am missing something?

[Rui_Leite]

The field From in the activity only supports datetime variables.

[mkankatala (Mahesh Kankatala)]

Okay then use the below one,

- Assign -> TodayDate (System.DateTime) = DateTime.Parse(Datetime.now)

Or

- Assign -> TodayDate (System.DateTime) = CDate(Now.toString)

Hope it helps!!

[rikulsilva (Henrique Lima da Silva)]

@Rui_Leite

Try to update the UiPath.System.Activity in Manage Packages.

It seems like a bug in the version you are using

Cheers

[Richard.King]

@Rui_Leite Did you find a resolution to this issue? I know another customer facing the same issue as they are migrating to cloud. They have tried several package versions. All of the package versions work on my cloud and fail on their cloud. They created their cloud tenant only a couple of weeks ago.

[Richard.King]

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

[Thao_Tran]

Thanks @Richard.King, it works for me
Another way to fix this is removing the time filter in the activity Get queue items (putting anything in there will cause the issue), but it’s not my favorite.

[g.ward (Gareth Ward)]

Why did this mystery setting suddenly appear, it has no documentation either if you click the link - it has caused so much grief

[nitesh.kumar]

Anyone found the resolution of this issue? I tried all the above solution but didn’t worked except removing the time filter in the Get Queue items activity.

[Rui_Leite]

Check the response that @Richard.King posted
It worked for me

[nitesh.kumar]

Awesome. Thank you so much, i tried too now and it worked.