Can not Get records via API with a filter using a Field name contains a "space"

Bika.ai discussions
1

Can not Get records via API with a filter using a Field name contains a “space” even after I encoded it.
I am using Make.com and this below text is in Vietnamese.

If I put the name “Mãgiáoviên” it went right.
If I put the name “Mã giáo viên” (with spaces between) it went wrong.

for example:

working: https://bika.ai/api/openapi/bika/v2/spaces/spcTlHH0nO4W42naWPJWzb3V/resources/databases/datnVitbyaRR5O2xvc4ZE6Tc/records?filter=Mãgiáoviên==“lvv76lx”

not working: https://bika.ai/api/openapi/bika/v2/spaces/spcTlHH0nO4W42naWPJWzb3V/resources/databases/datnVitbyaRR5O2xvc4ZE6Tc/records?filter=Mã giáo viên==“lvv76lx”

Hope you check and fix it

chrome_o3NYztYvtm
chrome_o3NYztYvtm975×898 161 KB

2

Hi @Vincent_Lo , field names can’t use system reserved characters, and spaces aren’t allowed either. If you do need spaces, just wrap the name in braces like this: {single text}.

You can find more details here:

1 Like
3

I didn’t know that. :smiley: Thank you Thea.

this topic should now be closed.

4

No worries! Your feedback really helped us improve, and we’ve already updated the tutorial in the community to reflect the changes.

https://community.bika.ai/t/how-to-retrieve-filtered-records-list-using-api-v2/868/3