Orchestrator HTTP Api - $filter Get jobs request

[jasonsavory]

I’m using the API get all jobs request to great success, however in the year we’ve been running we’ve amassed quite the list of jobs. Is there a way to apply a filter like you can in the Orchestrator visual interface to get only jobs from the last day for example?

I’ve tried adding a $filter parameter of "eq(Interval,‘Last day’) but this feels cobbled together from msdn resources and is clearly not the correct way to do this

[MARIODC]

Hi @jasonsavory,

This might not be the answer for the entire inquiry but just for reference here a documentation where you can see the list for available filters:

URI Conventions (OData Version 2.0) · OData - the Best Way to REST

BE Safe!

[Mateus_Cruz]

Hello!

The API Filter clause doesn’t support that relative time syntax, so you need to specify the actual time interval:

Orchestrator API - Use Interval in request Filter

Hello! Filters need to use OData’s format, so you need to calculate when is “last day” and use its string representation. For example: $filter=TimeStamp ge 2020-08-27T02:00:20.043Z. If you’re doing that with a workflow, you can use something like String.Format("{0}/odata/RobotLogs/?$filter=TimeStamp ge {1}", OrchestratorURL, Datetime.Now.AddDays(-1).ToString("yyyy-MM-ddTHH:mm:ssZ")).