Available operators in filtered_search

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"
    }
  ]
}

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.

Any Update on this?
Or any documentation available to list all possible filtered_search opeators?

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

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