Join the Webstudio community

Updated 2 months ago

Issue with Baserow variable

At a glance

The community member is trying to follow the steps in a video to use the Baserow API, but is encountering an error related to a field that does not exist in their database. The comments suggest that the field IDs in the video may be different from the community member's Baserow setup, and they should refer to their own Baserow API documentation to find the correct field IDs.

The community member also mentions issues with multi-select filters not working, and another community member suggests that the "AND" filter type may be the issue, as it requires all filters to match. However, there is no definitive answer provided in the comments.

The community member shares a link to their Baserow setup, and another community member offers to take a look, suggesting that the boolean field type may be causing issues when the value is undefined. The community members continue to discuss and troubleshoot the issue, but there is no explicitly marked answer.

Useful resources
I am trying to follow the steps mentioned this video : https://www.youtube.com/watch?v=oAaGTsHt-aE&ab_channel=Webstudio

{
"ok": false,
"data": {
"error": "ERROR_FILTER_FIELD_NOT_FOUND",
"detail": "The field 2624772 was not found in the table."
},
"status": 400,
"statusText": "Bad Request"
}

I am alway getting the above error. I done have field 2624772 in by database. From where it is taking this field ? Somewhere is it hardcoded ?

Can you plase help me on this ?
Attachment
cms.JPG
2
J
S
O
16 comments
Your baserow db will have different IDs than the video. Doing a quick search in the video it looks like he's got that ID for his opensource table. You'll need to find your own in your baserow API documentation.
Attachment
CleanShot_2024-11-25_at_18.52.022x.png
Got it Jeremy. Thank you for the quick help. I am good now.
Multi filter is not working. if i select more than one check box it is not working whereas single selection it is working
Do you see any issue with my filter ?
filter type AND sounds to me like all those filters need to be matched, not either or ...
haven't read the docs though
do btw out of curiousity, if you ask gpt your question, is it helpful?
Dont see an issue right away, but can you share the builder link? You can dm it. If the query param isnt active, then it should print undefined which baserow ignores. Though I'm not sure the behavior for boolean
@John Siciliano Did you mean to put a thumbs down on Oleg's comment?
Yes thumbs down as in “that’s not it”
Though because it’s Boolean it may be an issue
Hi @John Siciliano , I tried multiple with 'single select' option as well (true/false) but same results. Working only for single selection. I have dim my link. Can you please have a look and help me ? Thanks in advance !!!
Not sure after looking. I think boolean might still be applying when the value is undefined whereas other field types don't. So if I'm filtering by field Type and type isn't in the query params, then it prints out undefined the the api will ignore it.

If you tried single select, make sure you are using the ID of the select value and no the value itself. See attached which is an example from my baserow
Attachment
Screenshot_2024-12-02_at_6.57.14_AM.png
Thanks @John Siciliano , Let me try and get back to you.
Add a reply
Sign up and join the conversation on Discord