I’ve been enthusiastically working to integrate Baserow into my workflow. Despite my efforts and time invested in navigating through the documentation and community tickets, I’ve encountered some challenges that have hindered my progress.
I am committed to making this transition work, but I’ve reached a point where I could really use your expert guidance to move forward efficiently.
My primary challenge revolves around building scenarios using Make.com in conjunction with Baserow. Specifically, I’m struggling to utilize the ‘List Rows’ module effectively. Despite following the available documentation, I seem to be missing something crucial, as my search queries don’t return any results.
As recommended in tickets here, I also try the Make an API call and the HTTP modules, with no luck.
Could anyone provide insights or examples on how to correctly configure the ‘List Rows’ module to search records with specific conditions? Here are some examples of what I need to achieve:
The default Baserow blocks in Make are indeed a bit basic when it comes to filtering records. My suggestion is to use the Make an API call block.
In your Baserow dashboard, you can click on the 3 dots next to the database and select View API docs. This will offer you a lot of information about what you need to enter in the building block.
For example: the List rows section of each table shows you to url where you need to make the call to:
Wouldn’t it be easier to simply rework the Baserow Element in Make.com? As per your promise, Baserow should be a no-coding solution and having to adjust parameters in the API element is coding.
This is the current element “List Rows” to search for rows in Baserow which is too simplistic and not accurate:
Could you kindly rework this List Row Elements to make it more useful and including all the filters as per the columns in the Baserow Table? It would be really great.
Hey @artoflogic, we’ll create an issue for this request and add it to the pipeline. In case you or anyone else from the community who’s experienced with Make wants to make this happen faster, we can share the source code of the integration.
Dear @olgatrykush, thank you very much. Unfortunately, we only have experience using Make.com but not programming Make.com elements. But who knows, if you can, why don’t you share the source code?. Maybe somebody reading this would have an idea of how to best modify your Make.com element. I think its just one filter missing but honestly, we would need to educate ourselves a bit on how to add this.
Hi all / @olgatrykush has there been any update on this? We’ve just moved from Airtable but can’t seem to find any documentation or examples on how to use the ‘Search’ field on the List Row module.
I’ve tried following the Baserow API documentation (e.g. filter__field_2752976__contains=8223) but nothing seems to work??
Ah! Figured it out. Search and filters are not the same. Search is just a text searches that searches across all rows, you can test it with the little search icon in the Baserow UI top right. Filters are totally different. The make.com search box just needs a piece of text to look for … that’s it.
I am struggling with the same issue. It would be super helpful to have a guide on how to integrate with the right syntax the fields names, filter types and values to run comprehensive searches using the List rows module in Make.com.
Is there anyone within Baserow that could provide a couple of examples on how to structure the search parameters?
Btw @stuartb, the Search box in the Make module seems to only search in the first column. Just tried it to replicate the search on my table using the little search icon and I was able to find records when the List rows module gave none
@frederikdc I tried running the search using the API call but being self-hosted with some apps on top, what I get back when querying my URL is HTML code from my app (despite specifically pointing to the database only…)
Interesting, what I tried searching is either in linked fields or lookup fields from these linked fields. If you search for something in these fields type, does it work for you?
Ah maybe it only supports certain field types, mine are just standard text/number fields, maybe that’s the issue. Baserow should really have some documentation around all of this!
The main point is the the possibilities of the search field in the List Rows block are rather limited. You can only search for a certain text. All records where that text appears in one of the fields will be returned. For more fine filtering, you need the `
Click the 3 dots next to a database and select View API Docs. This will show you the URL for API calls. It is possible that you need to add a port number when self-hosting.
