filterByFormula on API not working

[hoangbao2106]

I am testing the API and noticed that the filterByFormula in the GET database is not working. The API returns all the rows in the database. This function works on AItable, but not on Bika.

[Kelvin]

Apologies for the confusion! The filterByFormula parameter has been deprecated in Bika’s API, and the documentation contained an error. For details on why this occurred and a temporary workaround, please refer to:

Why doesn't the Get Records API Endpoint support the `filterByFormula` parameter?

In Bika.ai, we intentionally deprecated the filterByFormula parameter for the Get Records API after careful consideration. Here’s why: Performance Optimization: Bika.ai’s data tables are designed to handle datasets exponentially larger than those supported by AITable. Formula-based filtering can severely degrade query performance at this scale, leading to slower responses and inefficient resource usage. Scalability First: Our priority is to ensure fast, reliable API interactions for all us…