joscares
(Joshua Oscares)
September 12, 2023, 2:39am
1
this is the get jobs endpoint im using and all history of jobs are captured and it makes the process long so is there any filter on this endpoint? like per day?
Hi @joscares ,
Have you checked it?
Hi @sherlin.s ,
I was just setting up an example when you deleted your post so I’m going to finish responding anyways in case it helps you or someone else that stumbles on the topic.
In my environment I have ran 4 Jobs with the following start times over the last year or so.
2020-11-20T09:11:00.91Z
2020-11-20T09:12:15.387Z
2021-10-21T18:03:43.097Z
2021-10-21T18:03:44.073Z
If I run the following GET request and Parameters
{{orchestrator_url}}/{{account_name}}/{{tenant_name}}/odata/Jobs?
$fil…
joscares
(Joshua Oscares)
September 12, 2023, 4:57am
3
I tried constructing the new endpoint always receiving invalid odata query
Hi
You can use filter clause like these
The UiPath Documentation Portal - the home of all our valuable information. Find here everything you need to guide you in your automation journey in the UiPath ecosystem, from complex installation guides to quick tutorials, to practical business...
@Mads_Commerou
Please try using filters on time …they look something liek this
$filter=TimeStamp ge 2023-01-22T02:00:20.043Z.
For more details on api please check the swagger files
Get swagger by appending swagger/index.html to your orchestrator url
Cheers
Cheers @joscares
joscares
(Joshua Oscares)
September 12, 2023, 6:43am
5
I tried this kind of query but it still not valid query
odata/jobs?$top=10$filter=WSAMZN-AF1Q27IS%27Documentation%27
Anil_G
(Anil Gorthi)
September 12, 2023, 7:31am
6
@joscares
in the filter you did not provide what field to be filtered
cheers
ppr
(Peter Preuss)
September 12, 2023, 7:41am
7
we would miss the exact filter criteria within the expected syntax
You can also prototype with swagger:
taken from: Orchestrator - API References
And applying modifications as defined here:
http://docs.oasis-open.org/odata/odata/v4.0/errata03/os/complete/part1-protocol/odata-v4.0-errata03-os-part1-protocol-complete.html
joscares
(Joshua Oscares)
September 13, 2023, 1:37am
8
I created this new filter and still invalid query
odata/jobs?$top=10$filter=WSAMZN-AF1Q27ISandStartTimegt2023-09-13T08:00:00
can you identify whats wrong?
Anil_G
(Anil Gorthi)
September 13, 2023, 4:35am
9
@joscares
Still in the first part there is no key identifier which is being filtered
WSAMZN-AF1Q27IS and StartTime gt 2023-09-13T08:00:00
Cheers