Cloud Orchestrator API QueueItems Date Filter Error

[c-jbring (JBring)]

Hello All,
We are migrating from on-premise Orchestrator to cloud Orchestrator and discovering that the API functionality differs between the two deployments. In on-prem, we are able to use the OData filter to only find certain QueueItems created or processed during specified dates. However, those same filters on the StartProcessing property do not work in the cloud API.

Below, I’m showing two screenshots from Postman: one that shows we do have 7 queueitems in the returned data when not including the StartProcessing filter, and one screenshot that shows the error “Invalid OData query options.” The only difference is the addition of the StartProcessing filter.

How do we resolve this issue? I tried using $skip and $top, but those only make sense if the OData $orderby works reliably - and it doesn’t.

Is this date filter on QueueItems a known issue with Cloud API, and if so when can we expect a resolution? How do we get around it in the meanwhile?

Thanks for any assistance,
John

FYI, here are results coming back from the on-premise call:

[marian.platonov]

Check this thread Orchestrator API - Queue item filter for StartProcessing and EndProcessing - #2 by marian.platonov

[c-jbring (JBring)]

I did see this post when researching the error and I added the filter as you showed. I see the same error (see screenshot).

[marian.platonov]

I used the below GET request, and I didn’t receive any errors:

https://cloud.uipath.com/YOUR_ORG_NAME/YOUR_TENANT_NAME/odata/QueueItems?$filter=((QueueDefinitionId eq 471724 and Status eq 'Successful' and (StartProcessing eq 2023-11-01 and EndProcessing eq 2023-11-01)))&$top=1000&$expand=Robot,ReviewerUser&$orderby=Id%20desc

[c-jbring (JBring)]

I copied your url (after “odata/QueueItems?”, of course) and plugged it in on my side and it did not work. Is there a security setting on the platform I’m missing or something?

[Lockie_v]

Hey there, I am experiencing the same issue, have you been able to find a solution?