How to get the Contacts after a perticular dateAdded via API call

Development
1

Hi,
i am new to Mautic ,
currently i am working in Python and i need to get the contacts from mautic, for that i use the
https://xyz.mautic.net//api/contacts API; this will get all the data when i call the API
To avoid the duplication and to avoid the processing of bulk amount of data from my end;
Is there any way to add conditions or filters in API call like get all the contact after a particular dateAdded (dateAdded>=‘2022-01-01T10:26:09+00:00’)

Eg :- https://xyz.mautic.net//api/contacts?search=dateAdded>=‘2022-01-01T10:26:09+00:00’

Please help me to fix this,
Thank you

2

Maybe try advanced filtering as described here:

https://developer.mautic.org/#advanced-filtering

3

Hi @prajith,
I am currently facing the same issue. I don’t seem to succeed, although I am using advanced filtering.
Please let me know if you manage to solve it and how.
Thanks!

Later edit: after some more research I found the issue below and managed to fix my code thanks to escopecz answer.

4

GET /api/contacts?
where[0][expr]=orX&
where[0][val][0][col]=dateAdded&
where[0][val][0][expr]=gt&
where[0][val][0][val]=2024-08-02 15:00:00&
where[0][val][1][col]=dateModified&
where[0][val][1][expr]=gt&
where[0][val][1][val]=2024-08-02 15:00:00

I want to get the contacts when their dateAdded or dateModified later than a specific datetime. But the request above doesn’t work. Can someone help me? Thank you

5

Did you tried OrderBy param for GET/contacts can be used?

Got an Advanced Filtering thread here, If could be helpful for you.

Blockquote
Mautic Developer Documentation