How to use Filter with "Lookup" field via API?


Get URL:
https://bika.ai/api/openapi/bika/v2/spaces/spcTlHH0nO4W42naWPJWzb3V/resources/databases/datlmjU437ZCj5iSUfbr70fS/records?filter={Mã tỉnh}==“20”

Above is a lookup field.
I try to use filter parameter to search it but failed. am I doing wrong?

Hi @Vincent_Lo , filtering directly on link or lookup fields via API isn’t supported yet.

This is aligned with how filters currently behave in the product interface. That said, we’ve added your request to our backlog so the team can review it for future improvements.

Really appreciate you raising this — it helps us shape what to prioritize next.

The feature is existed on AITable. I was able to achieve result I want with AItable.

Hope you bring this in front of your desk and finish it soon here on Bika platform.

Hi, thanks for pointing this out and for sharing your experience with AITable.

Support for filtering on link/lookup fields has already been added to our backlog, and the team will be reviewing it.

We really appreciate your patience and feedback.