# Syncing/refreshing API column manually

**URL:** <https://community.glideapps.com/t/syncing-refreshing-api-column-manually/73819>\
**Category:** Ask for Help\
**Created:** [June 2, 2024, 5:32pm UTC](https://community.glideapps.com/t/syncing-refreshing-api-column-manually/73819 "2024-06-02T17:32:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Martin\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martin_b/32/74360_2.png) [@Martin\_B](https://community.glideapps.com/u/Martin_B)\
**Post date:** [June 2, 2024, 5:32pm UTC](https://community.glideapps.com/t/syncing-refreshing-api-column-manually/73819/1 "2024-06-02T17:32:47Z")

</div>

Hello,

Is there a way i can set a button for my user to refresh an API COLUMN?

The refresh rate in the API column even set to 1 minute doesn’t seem to work.  
My app is in EXTRA data sync mode.

Thanks  
(i answer other posts in a bit)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [June 2, 2024, 7:43pm UTC](https://community.glideapps.com/t/syncing-refreshing-api-column-manually/73819/2 "2024-06-02T19:43:47Z")

</div>

If you can pass it a value that changes each time a button is pressed, then it would probably work. Maybe set a unique ID or something similar. Something that isn’t necessary needed for the API and can be ignored by the API, but would still trigger it at the same time.

---

<div class="post-metadata">

**Author:** ![Martin\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martin_b/32/74360_2.png) [@Martin\_B](https://community.glideapps.com/u/Martin_B)\
**Post date:** [June 3, 2024, 6:34pm UTC](https://community.glideapps.com/t/syncing-refreshing-api-column-manually/73819/3 "2024-06-03T18:34:03Z")

</div>

Thanks Jeff.

The problem is coming from the fact my API CALL is to a **Glide big table** from another app that i use for all users.

And big tables don’t update real time. (Glide documentation)

I had decided to use Big table because they are the only one we can QUERY with an API CALL (SQL select, order etc).

I therefore have to go back to normal Glide table…  
So my API call gives me a json output with all the rows of the table.  
So from there i have to find a way to order and filter this JSON…  
I was thinking transforming the JSON into an Array so i can use Query column on it.

My blockage now: transforming a json with n rows into an array i can query.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 3, 2024, 11:50pm UTC](https://community.glideapps.com/t/syncing-refreshing-api-column-manually/73819/4 "2024-06-03T23:50:50Z")

</div>

Is your query dynamic? Maybe using a SQL data source can work here?