Search contacts without any deal within a date range

[jwu (Jason Wu)]

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.

[Saif (Saif Ali Shaik)]

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

[Saif (Saif Ali Shaik)]

@jwu - Just checking in if you might have found any alternative here?

Sorry, couldn’t find any help from the team.

[jwu (Jason Wu)]

Yes, they confirmed it’s a bug but it’s not fixed yet.
The alternative I found and later told by the support team is to add a second or a minute to your date range instead of using it on the zero minute mark.

Example payload:

{    
    "filter_rule" : [
        {
            "attribute" : "updated_at",
            "operator": "is_in_the_range",
            "value":["2020-12-03T08:00:01-06:00","2020-12-03T09:00:01-06:00"]
       }
    ],
    "detail": true
}