Filtering API call with Supabase

Database & APIs

I was having a bit of trouble setting up the api call to get specific items GPS coordinates from supabase, after a bunch of trial and error I finally got it to work. Wanted to share it with people with similar requirements.

Set up the API call like this:

https://shkgbaxpqffqxjhcsdfasadfakbu.supabase.co/rest/v1/stuff?select=gps_coordinates&thing_id=eq.[thing_id]

1. Use your own base url from supabase I changed it the example.
2. The table I want to query is called stuff, substitute it for your own.
3. The column I want to filter for a particular thing is called gps_coordinates, substitute for your own column.
4. Create a variable called thing_id (the thing you want to filter by), set the type, in my case its string and either fill the default or not.
5. Then when you go to test and checkmark the variable and enter the actual thing_id.

So now the result that comes back is data that is found in the gps_coordinates column and only in the row which has a matching thing_id. In my case gps coordinates for a particular thing.

What threw me off was using curly brackets but flutterflow takes square brackets for the variable.

Hope this helps someone.

What have you tried so far?

Bunch of stuff.

Did you check FlutterFlow's Documentation for this topic?
No