Filters with API

Bonsoir :grinning:,
Is it possible to do these kind of filtering with the API?

  • Filter text contains

  • Filter all rows before another date

  • Filter rows greater than a number


Hi @Sao.

We have a roadmap item to allow for querying via SQL, which would enable filtering via the criteria you listed. In the interim, one thing you try is creating formula columns (of type Toggle) for each of those filters, which should return either True or False based on your filter criteria. Then via API, you should be able to specify filters against those formula columns.


1 Like


Thank you very much.
Can we add columns with formulas via the API ?