Hi @frederikdc, thank you for your reply.
Sadly, it seems the List Rows module is not able to search in linked records or lookup fields. Can you confirm that’s also the case on your end?
I ended up making API requests with the Make Basic Auth Requests module in Make but getting HTML only. I found this item: Allow setting multiple BASEROW_PUBLIC_URL (#2499) · Issues · Baserow / baserow · GitLab
Am I correct to assume it means I can’t use my URL to access the database as it always points to the app?
Regarding the port number, can you point me to the documentation highlighting where to find the right one and how to integrate it into the API call module, hopefully bypassing the URL access highlighted above?
Initially I tried using the Make an API Call module from Baserow in Make but the path I can use is only relative to https://api.baserow.io when the API documentation for my project specifically requests another one, based on my custom URL. Is there any way to bypass this in the module?
Thank you for your continued support.
Yes, the functionality of the List Rows block is rather limited.
No, it seems like the Make an API call block can not be used for self-hosted instances.
So you will need to use the Make Basic Auth Requests block. To detect which url you need to use to communicate with the API, you can always open the inspector of your browser and go to the network tab. This will show you all the API calls.
I also noticed that Baserow’s Make modules are limited, are there any updates on improving them?
My use case is quite usual: I get some data from a module, like a customer email, and I want to check if my baserow table this email already exists or not.
However I can only search/list rows by their ID! This is not useful to find rows.
I ended up using Google Sheet with Make (unfortunately) but I really really wanted to stick with Baserow instead of Big Tech Google…
With Google Sheet module I can easily search a row …
Hi,
We don’t have any control over the functionality of the Make modules. What you can do is using the raw HTTP request block and do a call directly to the Baserow API. A second alternative is switching to n8n where the Baserow blocks are a bit more advanced. But honestly, I do most of my calls with HTTP request nodes because the performance is a bit higher.
I post multiple times because my post are still under approval. But I solved it! without api. The module “list rows” is good, the is a search, I put there the email and it output the row containing that email. I don’t know why I haven’t found it earlier.
So at least with one condition is possible to search.
Oh wait but also on Make there is a SEARCH field in the list rows… same as Zapier. So only in N8N Baserow modules are more powerful
Oh ok, I shall write to them. I checked on Zapier and there is the module “list rows” which has a “search” parameter so there it should work… N8N is too much for me now, I have checked previous replies about using API calls and tried to create an API call but failed.
Is it really that doable to create an API call looking for a value in a given column? Can you please write an example of the cURL so that I just need to substitute my tokens and ID there?
My use case is:
I get some data from external webhook. Within that data there is the customer email.
In my Baserow table I have different columns and the first column is indeed the email column.
I just want to check if the email that arrives from webhook does exist or does not exist in that column. How to do that with API calls?
I hope that custom API baserow module outputs a 0 if the email does not exist and a 1 if it does exist…
Thanks but eventually I got it sorted by the module “list rows” . in that I added the email item from the webhook and it finds the row ID. From that I can update the row because I know its ID. Seems like API are not needed
