# FlutterFlow question API/query

**URL:** <https://ifnotnil.com/t/flutterflow-question-api-query/3312>\
**Category:** General Programming\
**Created:** [7 June 2023 19:19 UTC](https://ifnotnil.com/t/flutterflow-question-api-query/3312 "2023-06-07T19:19:20Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Spiff](https://ifnotnil.com/letter_avatar_proxy/v4/letter/s/b782af/32.png) [@Spiff](https://ifnotnil.com/u/Spiff)\
**Post date:** [7 June 2023 19:19 UTC](https://ifnotnil.com/t/flutterflow-question-api-query/3312/1 "2023-06-07T19:19:20Z")

</div>

Is anybody experienced with FlutterFlow here? I have a performance question. Maybe some web/API expert can also chime in even if you’re not using FlutterFlow.

I have a Supabase view which I’d like to access from FlutterFlow. The view has a few columns and I’d like to filter on one of these columns. There are two (simple) ways of doing it:  
1- a query in FlutterFlow setting a filter on this column in FlutterFlow  
2- an API call in FlutterFlow using the filter on this column as a query parameter.

My understanding is that with option #1, FlutterFlow would request the full dataset and then filtering out the rows according to my filter. Option #2 would instead only request the filtered rows. So I would think #2 would be faster.

What would you guys say?

---

<div class="post-metadata">

**Author:** ![thorstenstueker](https://ifnotnil.com/letter_avatar_proxy/v4/letter/t/aca169/32.png) [@thorstenstueker](https://ifnotnil.com/u/thorstenstueker)\
**Post date:** [7 June 2023 19:42 UTC](https://ifnotnil.com/t/flutterflow-question-api-query/3312/2 "2023-06-07T19:42:18Z")

</div>

Depends on the API. But normally the API is faster in that case. I would anyhow use the API while it is something you can implement faster and that’s it

---

<div class="post-metadata">

**Author:** ![npalardy](https://ifnotnil.com/user_avatar/ifnotnil.com/npalardy/32/10_2.png) [@npalardy](https://ifnotnil.com/u/npalardy)\
**Post date:** [7 June 2023 23:20 UTC](https://ifnotnil.com/t/flutterflow-question-api-query/3312/3 "2023-06-07T23:20:23Z")

</div>

Personally I’d go for #2 and filter the data at the source instead of grabbing everything and then filtering locally

Esp if the filter might eliminate a LOT of the data from view

No point transferring lots of data just to not show it

Now the life side is that this could cause more round trips - if you HAVE all the data locally and can filter instantly locally then there may be no round trips

I’d start with # 2 and IF round tripping is an issue switch to # 1, hold the data locally, and filter as you want

BUT with this data could get “stale” (ie the back end could get new data that you are interested in but you dont refetch it all the time - that however can be detected and dealt with)

---

<div class="post-metadata">

**Author:** ![Spiff](https://ifnotnil.com/letter_avatar_proxy/v4/letter/s/b782af/32.png) [@Spiff](https://ifnotnil.com/u/Spiff)\
**Post date:** [9 June 2023 05:01 UTC](https://ifnotnil.com/t/flutterflow-question-api-query/3312/4 "2023-06-09T05:01:16Z")

</div>

Thank you!

---

<div class="post-metadata">

**Author:** ![YogiYang](https://ifnotnil.com/letter_avatar_proxy/v4/letter/y/ecccb3/32.png) [@YogiYang](https://ifnotnil.com/u/YogiYang)\
**Post date:** [10 June 2023 13:14 UTC](https://ifnotnil.com/t/flutterflow-question-api-query/3312/5 "2023-06-10T13:14:04Z")

</div>

> [@Spiff](#):
>
> 2- an API call in FlutterFlow using the filter on this column as a query parameter.

Can we send query parameters to Supabase from FlutterFlow?

---

<div class="post-metadata">

**Author:** ![Spiff](https://ifnotnil.com/letter_avatar_proxy/v4/letter/s/b782af/32.png) [@Spiff](https://ifnotnil.com/u/Spiff)\
**Post date:** [10 June 2023 13:41 UTC](https://ifnotnil.com/t/flutterflow-question-api-query/3312/6 "2023-06-10T13:41:55Z")

</div>

Yes, that’s possible. With the parameter’s value either a fixed value or a variable.

---

<div class="post-metadata">

**Author:** ![YogiYang](https://ifnotnil.com/letter_avatar_proxy/v4/letter/y/ecccb3/32.png) [@YogiYang](https://ifnotnil.com/u/YogiYang)\
**Post date:** [18 June 2023 05:50 UTC](https://ifnotnil.com/t/flutterflow-question-api-query/3312/7 "2023-06-18T05:50:01Z")

</div>

Can you point me to any document or tutorial on this please?

---

<div class="post-metadata">

**Author:** ![Spiff](https://ifnotnil.com/letter_avatar_proxy/v4/letter/s/b782af/32.png) [@Spiff](https://ifnotnil.com/u/Spiff)\
**Post date:** [18 June 2023 06:20 UTC](https://ifnotnil.com/t/flutterflow-question-api-query/3312/8 "2023-06-18T06:20:11Z")

</div>

[https://youtu.be/22fuYHe0ZZU](https://youtu.be/22fuYHe0ZZU)

I can’t tell if this is a good tutorial or not because I haven’t watched one on API calls. The API calls are pretty self explanatory in FlutterFlow.
