# Rest API - OrWhere

**URL:** <https://forum.mautic.org/t/rest-api-orwhere/25692>\
**Category:** Product Support\
**Created:** [October 15, 2022, 1:00pm UTC](https://forum.mautic.org/t/rest-api-orwhere/25692 "2022-10-15T13:00:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sharon-asana](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/sharon-asana/32/2021_2.png) [@sharon-asana](https://forum.mautic.org/u/sharon-asana)\
**Post date:** [October 15, 2022, 1:00pm UTC](https://forum.mautic.org/t/rest-api-orwhere/25692/1 "2022-10-15T13:00:20Z")

</div>

I’m using the Mautic Rest API and trying to achieve the following:  
All contacts that were either added or modified at a certain time frame.

What i’m doing so far is running two queries and getting:

1. added contacts  
`/api/contacts?where[0][col]=dateAdded&where[0][expr]=gte&where[0][val]=2022-10-13 23:59:59&where[1][col]=dateModified&where[1][expr]=isNull`

2. modified contacts  
`/api/contacts?where[0][col]=dateModified&where[0][expr]=gte&where[0][val]=2022-10-13 23:59:59`

Then removing the modified contacts from the added results set.

I’m very keen on finding a solution to get all at once in order to complete a very nice solution using Airbyte

I hope it’s possible.

---

<div class="post-metadata">

**Author:** ![bobkitz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/bobkitz/32/12780_2.png) [@bobkitz](https://forum.mautic.org/u/bobkitz)\
**Post date:** [June 11, 2023, 10:04pm UTC](https://forum.mautic.org/t/rest-api-orwhere/25692/2 "2023-06-11T22:04:59Z")

</div>

Did you find a solution for using Airbyte with Mautic?

---

<div class="post-metadata">

**Author:** ![yuyu](https://avatars.discourse-cdn.com/v4/letter/y/71e660/32.png) [@yuyu](https://forum.mautic.org/u/yuyu)\
**Post date:** [August 5, 2024, 12:47pm UTC](https://forum.mautic.org/t/rest-api-orwhere/25692/3 "2024-08-05T12:47:22Z")

</div>

Did you find a solution for this topic?