jwu
(Jason Wu)
December 7, 2020, 2:38am
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.
Saif
(Saif Ali Shaik)
December 16, 2020, 3:30pm
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
Saif
(Saif Ali Shaik)
February 4, 2021, 9:39am
4
@jwu - Just checking in if you might have found any alternative here?
Sorry, couldn’t find any help from the team.
jwu
(Jason Wu)
February 4, 2021, 2:31pm
7
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
}
Saif
(Saif Ali Shaik)
Closed
March 1, 2021, 12:30pm
8
This topic was automatically closed after 25 days. New replies are no longer allowed.