@siddharth Can I build a plot with the data from the Supabase API? I made a lot of tries, but I don’t really understand how can I use a data from the API in Data Source
field while building a plot
@dominok56 Can u please define “plot”
Actually I didn’t have any ideas about proxy here
But I can say that the response is really fast
Hey @siddharth
It´s fast but not as Bubble so when it comes to speed and compliance, getting out of the Bubble servers is necessary.
If you take a look at it let me know
Thanks a lot.
@siddharth I meant a chart
In the API connector there will be a drop-down option
to use this API as action or use as data you should be marking it as a data in order to get it in proper data position.
Hey @siddharth
How do you do with Supabase to get Bubble´s database at once? Like for example Supabase connect to Bubble so Supabase gets all the list of countries in Bubble or all records.
Thanks a lot.
as per your question I am trying to answer but if this answer is not satisfactory please reply Say you have a table called countries which has unique IDS for each country and name of each country so now if you call that table without specifying a particular ID or country name the whole list will be fetched.
This does not have to do anything with bubble database.
Hey @siddharth
Would you mind creating a real scenario where you want to create a backup every day to Supabase of 5 Bubble tables?
Keeping in mind that there would be updated records and new records.
How can you do that in Supabase?
Thanks a lot man.
Thanks for sharing
Hey I’m getting an empty response everytime
The response is only []
@nickdev I had this issue on one Supabase API as well. It is not a Supabase issue though since with Postman it worked just fine. So my advice is first to use Postman and see if it works there. If so, Bubble is doing something “weird” with the call.
I ended up having Bubble and Postman next to each other and set each setting exactly the same. I also tested the output with RequestBin — A modern request bin to collect, inspect and debug HTTP requests and webhooks - Pipedream
In my case, everything was the same and still the API call from Bubble gave me a 400 error in Supabase. I then changed the body of the API call in Bubble to “Raw” and suddenly it worked!
Hope this helps!
@nickdev have you disabled RLS policy for your table in supabase ?
Thanks it’s working RLS policy was the issue
Hey @siddharth,
how do I make the api call for updates of a data
You can simply user the patch api. I’m Supabase you find all the API’s well documented.
Well I have a solution,
Call a GET call use it as action
Make a group where data should be displayed
Add a Refresh button or icon or make it do it after every x minutes or second and in the workflow call the same API
Hope it helps
Hey @siddharth
I want to get a callback notification when a row is successfully deleted. As of now the table is deleted but am not getting any response back if the action is successfull or not.
Thanks
You mean table or row deleted? I get response calls on all my Supabase calls so you can run a workflow if needed on success or a fail.
Did you made sure that on initialization of the API you save the response as well?
Thanks, i was not saving the response