I have already created my app on Adalo, but I would like to switch all my data to Supabase instead.
I have tried following Erik’s tutorial.
I’ve tried to connect it through the external collections link by adding the API base URL, api key & authorisation but I keep coming up with errors.
On Supabase, I have no policy restrictions on the table populated with data.
Is there another method to connect Adalo to Supabase?
we can connect to xano
are you comfortable wth that ?
my whatsapp +23415023756
It has to be supabase ideally. We’re not on Xano…
Let see how it’s should be done
We can discuss this on call depending on functionality
Are you part of the Adalo team? Or a separate developer ?
Am a separate developer
This number doesn’t work
Can you provide yours instead ?
+2347015023756
This should work
Shoot me a message now
Hi @parle,
You should be able to connect Supabase table as an external collection. It won’t work as External Users (Eric has made some videos about that).
If you could share screenshots of errors maybe someone can help you with identifying the issue.
Best,
Victor.
Dear @primedev06,
This is a forum to share and help each others to solve issues, so that community can benefit from the commonly created knowledge.
Please adhere to the community guidelines - if you can help, please share the solution.
Best,
Victor.
Hi @parle,
I see that you’ve added screenshots to your original post.
From what I see there, the API endpoint returns 0 results - does anything exist in the table? Also is RLS enabled and if yes, are you allowing to read with anon key?
Best,
Victor.
P.S. Just in case - it might be a good idea not to alter your original post but to create a reply. I noticed that you’ve added screenshots just accidentally.
Thank you for the advice. Yes, there is data inside the table. I have not added any policies or enabled RLS on the table.
@parle either you are configuring something incorrectly on Adalo side or your Supabase table doesn’t return the data.
I’ve just run a test on one of my Supabase projects, connecting external collections works like a charm:
So I would advice checking Supabase settings. You can try fetching data using curl or from Postman to see if API works or not.
Just in case, info for the future: most probably you will need to change Get One, Create, Update and Delete Endpoint settings in the 2nd screen, so that they correspond to the API rules provided by Supabase.
Best,
Victor.
Issue is resolved. Thank you, i had to double check my Supabase settings and test on postman . All connected now
