Search contacts without any deal within a date range

Product APIs
#1

Hi,
I would like to search for contacts created in a date range where there is no related deal created.

I have tried with the filtered search with no success.

    curl --location --request POST 'https://cliqstudios.freshsales.io/api/filtered_search/contact?per_page=100&include=owner,deals' \
--header 'Authorization: Token token={myToken}' \
--header 'Content-Type: application/json' \
--data-raw '{    
    "filter_rule" : [
        {
            "attribute" : "updated_at",
            "operator": "is_in_the_range",
            "value":["2020-12-03T08:00:00-06:00","2020-12-03T09:01:00-06:00"]
       },
       {
            "attribute" : "deal_ids",
            "operator": "is_in",
            "value": [null
       }
    ],
    "detail": true
}'

Does anyone know how to achieve this via API call or a report?
Thanks.

#3

Hi @jwu,

We don’t readily have experts on Freshsales API on the forum. We are trying to get some help from Freshsales team on this. I would keep this thread updated as I come across any solution from Freshsales team.

cc: @shyam.sunder