Supabase + Bubble connection with API connector

@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 :sweat:
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 :wink:

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 :wink: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.

1 Like

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 :pray:

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!

2 Likes

@nickdev have you disabled RLS policy for your table in supabase ?

2 Likes

Thanks it’s working :smiley: RLS policy was the issue

1 Like

Hey @siddharth,
how do I make the api call for updates of a data

2 Likes

You can simply user the patch api. I’m Supabase you find all the API’s well documented.

2 Likes

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 :smiley:

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?

1 Like

Thanks, i was not saving the response