o.zhdan
(olga)
1
I need to use /api/filtered_search/[entity]
to get filtered data by updated_at
. The
Freshsales | Refreshingly new CRM & Deal Management Software page only has an example of using the is_in
operator, but it does not suit me.
How to write such a request correctly:
{
"filter_rule": [
{
"attribute": "lead_updated_at.updated_at",
"operator": "is_less_then",
"value": "2020-10-10"
}
]
}
Saif
(Saif Ali Shaik)
2
Hi @o.zhdan,
Right. The Docs has only example with respect to is_in
operator.
Let me try to get some help from someone who’s more experienced working with Freshsales APIs and let you know.
jwu
(Jason Wu)
4
Any Update on this?
Or any documentation available to list all possible filtered_search opeators?
o.zhdan
(olga)
5
Yes. Support gave examples
{
"filter_rule" : [
{
"attribute" : "created_at",
"operator":"is_in_the_range",
"value":["06/10/2020", "21/10/2020"]
}
]
}
or
{
"filter_rule" : [
{
"attribute" : "updated_at",
"operator":"is_after",
"value":"2020-10-13"
}
]
}
2 Likes
stevemc
(Steve McMillen)
6
How about more?
I usually find these by trial and error. I found “is_not_in” also. I have to assume that “is_before” is valid. what else?
It would be nice if all the operators were documented.
1 Like