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?

can you really use contains for a date field tho? also i think dates must be like ```
‘2019-12-01T09:13:28’

@zweerk01,
Try this:
$filter = Timestamp gt 2019-12-01T00:00:00.00Z and Timestamp lt 2019-12-31T00:00:00.00Z

You can use the following function operators (with examples):


Source:

2 Likes

@bcorrea It is not a date field. The model describes the field as string.

@Adrian_Star Your custom timestamp filter worked. I tried it before but with the single quotation marks like this: ‘2020-01-17T07:22:33.424Z’. Thanks!

1 Like

isnt uipath using odata v2.0 tho?

I’m not fluent in this. I’m still learning.

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