Ok. So if instead the column loaded just one endpoint that was identical for each row, it would be one update? or would it still be 300.
[I guess I should just test it like @ThinhDinh did]ā¦
In that example, I would expect it to be a single call. So a single update.
But yes, best to test it for yourself.
1 Like
The cache is per app, not per user, and values are cached for 30 days (soon you will be able to make this shorter). In the example, assuming the parameters donāt change and arenāt using per-user values, it would be 300 updates per month, assuming all of the rows are needed for the app to work.
7 Likes
Whew! Thought I had misunderstood something!
1 Like
Thatās neat. Thanks David!
This is awesome. Would help a lot.
If values in Airtable are updated based on user actions in Glide-
You can save yourself updates by simply appending a number parameter which sequentially increases for all users each time such an update is executed.
I see that header values canāt be dynamically filled in?
I have a use case where I want to assign unique SHA256 Keys to users which refresh daily and pass them along with the header to Make.com
Question is whether the header values will be dynamic at some point?
Not sure what you mean here? I am using a date format that captures minutes. But it is a set column that happens at a click of the button, so only relevant to that row in one particular instance. The API call uses that timestamp at the end of API endpoint to retrieve a data from airtable.
This row is like a temporary row that can be wiped each day. Would that help with the update issue?
So your API Call is configured as an action, as opposed to a computed column?
If thatās the case, then you can ignore my comment. It only applies when itās used as a column. The other thing is that there is a new feature now (again when using it as a column) that allows you to define the cache interval. So the cache-busting technique is no longer required.
Ok so if that cache time field is empty does that mean it āneverā gets a new result? My API is a column.
But now it makes sense if it doesnāt fetch a new value, as I only need it to to be fetched at an initial point when data is entered. It hasnāt been updating the field at a later time, even though the original value has now been changed behind the scenes in Airtable.
Good question. I donāt know if thereās a default from Glide in this case.
It was the case before the public release, but they removed it due to security issues. I faced the same issue, one of the services I use have an expiring token. I donāt know if they can bring it back.
Can you give me an example of a dummy parameter in a URL?
Iāve noticed an introduction of a cache time.
Will this count as an update for every column every time itās refreshed?
Thatās kind of moot now since the introduction of the Cache Time setting.
But itās just an extra parameter that you tag on the end of the API endpoint URL.
So letās say the endpoint is https://someapi.com, then what you could do is send something like https://someapi.com?fredflinstone=20230829
What you call it doesnāt really matter, because you want the API to ignore it. But, if you wanted to force Glide to update the cached result, all you have to do is change it (eg. https://someapi.com?fredflinstone=20230830). Glide will see that the URL has changed, and will send a fresh API call to update itās cached result.
But as I said, you donāt need to bother with this any more. Just set the update interval that you want in the Cache Time.
It depends if the API call for each row is different or not. If theyāre all the same, then itās a just a single update. Put another way, it will be an update for each unique call.
2 Likes
Is call API still available for PRO plans or only for BUSINESS plan? Today I saw the business tag when selecting the call and I was wondering if I had misunderstood or not.
Business plan only now.
That didnāt take long. I wonder why the change? Updates?
Is it part of the non-profit plan?
sad news, I had made plans to use this.
1 Like
Nothing stopping anyone from using it stillā¦just need to be on a Business account.