# API to easyJOB - "invalid-filter-or-order"

**URL:** <https://community.awork.com/t/api-to-easyjob-invalid-filter-or-order/753>\
**Category:** Developer Forum\
**Created:** [11. März 2024 um 13:36 UTC](https://community.awork.com/t/api-to-easyjob-invalid-filter-or-order/753 "2024-03-11T13:36:50Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![olaf.heinrich](https://avatars.discourse-cdn.com/v4/letter/o/76d3ee/32.png) [@olaf.heinrich](https://community.awork.com/u/olaf.heinrich)\
**Post date:** [11. März 2024 um 13:36 UTC](https://community.awork.com/t/api-to-easyjob-invalid-filter-or-order/753/1 "2024-03-11T13:36:50Z")

</div>

Hi dear support team,  
Since Friday 3:00 p.m. UTC we have no longer received times from awork via our interface. We still query the times with the same query:

[https://thjnk.awork.com/api/v1/timeentries?page=1&pageSize=1000&filterby=startDateUtc](https://thjnk.awork.com/api/v1/timeentries?page=1&pageSize=1000&filterby=startDateUtc) ge datetime’2024-03-04T00:00’ and duration gt 0.0

But we now get the following error message: „code“:„invalid-filter-or-order“,„description“:„Something is wrong with the given ‚filterby‘ expression.“}

Can you please check where this problem lies?  
thanks in advance!  
Olaf

---

<div class="post-metadata">

**Author:** ![Nils](https://dub1.discourse-cdn.com/flex013/user_avatar/community.awork.com/nils/32/96_2.png) [@Nils](https://community.awork.com/u/Nils)\
**Post date:** [11. März 2024 um 13:51 UTC](https://community.awork.com/t/api-to-easyjob-invalid-filter-or-order/753/2 "2024-03-11T13:51:15Z")

</div>

Hi @olaf.heinrich ,

do you have a trace id from the response header for us to check the request?

Best

Nils

---

<div class="post-metadata">

**Author:** ![olaf.heinrich](https://avatars.discourse-cdn.com/v4/letter/o/76d3ee/32.png) [@olaf.heinrich](https://community.awork.com/u/olaf.heinrich)\
**Post date:** [11. März 2024 um 14:55 UTC](https://community.awork.com/t/api-to-easyjob-invalid-filter-or-order/753/3 "2024-03-11T14:55:15Z")

</div>

Hi @Nils  
unfortunately we don´t have a trace ID.  
I just can give you the recent error message.  
we did not change any Settings or script in the API.  
Can you find out if there were any changes on Awork last Friday?

Greetings Olaf

---

<div class="post-metadata">

**Author:** ![Nils](https://dub1.discourse-cdn.com/flex013/user_avatar/community.awork.com/nils/32/96_2.png) [@Nils](https://community.awork.com/u/Nils)\
**Post date:** [11. März 2024 um 15:02 UTC](https://community.awork.com/t/api-to-easyjob-invalid-filter-or-order/753/4 "2024-03-11T15:02:55Z")

</div>

Hi @olaf.heinrich,

i was able to repro the issue, but it seems the query to the api is wrong. You filter for `duration gt 0.0` but duration is an integer field. Can you please change the filter to `duration gt 0` then everything should work.

Best

Nils

---

<div class="post-metadata">

**Author:** ![olaf.heinrich](https://avatars.discourse-cdn.com/v4/letter/o/76d3ee/32.png) [@olaf.heinrich](https://community.awork.com/u/olaf.heinrich)\
**Post date:** [11. März 2024 um 15:44 UTC](https://community.awork.com/t/api-to-easyjob-invalid-filter-or-order/753/5 "2024-03-11T15:44:42Z")

</div>

Hi Nils,  
thanks for the tip, If t is an Integer-field - how can we represent minutes?  
Until friday everything worked fine, were there maybe a change?

---

<div class="post-metadata">

**Author:** ![Nils](https://dub1.discourse-cdn.com/flex013/user_avatar/community.awork.com/nils/32/96_2.png) [@Nils](https://community.awork.com/u/Nils)\
**Post date:** [11. März 2024 um 15:49 UTC](https://community.awork.com/t/api-to-easyjob-invalid-filter-or-order/753/6 "2024-03-11T15:49:43Z")

</div>

Hi @olaf.heinrich ,

the duration is in seconds, so a minute is a duration of 60.

We haven’t been able to identify a reason why it worked before, but we updated one of our major libraries and i might have impacted this case. The filter expression was always wrong, but maybe we allowed this wrong value before and now the parser is more strict.

Can you change the filter on your side?

Best

Nils

---

<div class="post-metadata">

**Author:** ![olaf.heinrich](https://avatars.discourse-cdn.com/v4/letter/o/76d3ee/32.png) [@olaf.heinrich](https://community.awork.com/u/olaf.heinrich)\
**Post date:** [11. März 2024 um 15:51 UTC](https://community.awork.com/t/api-to-easyjob-invalid-filter-or-order/753/7 "2024-03-11T15:51:40Z")

</div>

ok, thanks!  
that sounds logical 🙂  
We will try it to change in seconds…

---

<div class="post-metadata">

**Author:** ![olaf.heinrich](https://avatars.discourse-cdn.com/v4/letter/o/76d3ee/32.png) [@olaf.heinrich](https://community.awork.com/u/olaf.heinrich)\
**Post date:** [11. März 2024 um 16:14 UTC](https://community.awork.com/t/api-to-easyjob-invalid-filter-or-order/753/8 "2024-03-11T16:14:52Z")

</div>

Hi Nils, it seems to working now 🙂  
Thx!