# Filter AWX API response with timestamp

**URL:** <https://forum.ansible.com/t/filter-awx-api-response-with-timestamp/37345>\
**Category:** AWX Project\
**Tags:** awx\
**Created:** [November 14, 2022, 3:30pm UTC](https://forum.ansible.com/t/filter-awx-api-response-with-timestamp/37345 "2022-11-14T15:30:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Zafar\_Iqbal](https://avatars.discourse-cdn.com/v4/letter/z/8491ac/32.png) [@Zafar\_Iqbal](https://forum.ansible.com/u/Zafar_Iqbal)\
**Post date:** [November 14, 2022, 3:30pm UTC](https://forum.ansible.com/t/filter-awx-api-response-with-timestamp/37345/1 "2022-11-14T15:30:13Z")

</div>

Hi,  
We need to find the list of failed jobs in the last one hour through the AWX API.

We have tried multiple combinations and always get a list of all the failed jobs.

Has anyone tried this and have any examples to share?  
Thanks

---

<div class="post-metadata">

**Author:** ![AWX\_Project](https://avatars.discourse-cdn.com/v4/letter/a/eada6e/32.png) [@AWX\_Project](https://forum.ansible.com/u/AWX_Project)\
**Post date:** [November 16, 2022, 7:45pm UTC](https://forum.ansible.com/t/filter-awx-api-response-with-timestamp/37345/2 "2022-11-16T19:45:23Z")

</div>

Have you tried a query like this: [https://localhost:8043/api/v2/jobs/?finished\_\_gt=2022-10-26T17:02:09.833133Z&status=failed](https://localhost:8043/api/v2/jobs/?finished__gt=2022-10-26T17:02:09.833133Z&status=failed)  
Granted you will need to do a calculation to get now - 1h but that filter should get failed jobs since the timestamp.

Let us know if that works or not.

-The AWX Team