Hey all, I use a SQL query in Supabase editor. How can I make sure to use this SQL query when fetching data from supabase? For example I use a table with 10 cities in it. The sql query says that the output is one random city. I want to integrate the SQL in the GET API call
Lucas G
7 months ago
API calls to supabase use PostgREST which is an API layer for Postgres. It doesn't have the ability to fetch a random item, only the standard filtering options are available
What you'll need is a function
Supabase supports RPC via this endpoint: rest/v1/rpc/
Lucas G
7 months ago
Create a database function, make sure it is safe to call it, and use the rpc endpoint to run it. The response will be the function's result
.jpeg/public)