How do I get my call api column to refresh automatically?

Ask for Help
1

I have a call api column that “powers” the rest of the table in Glide.

It only refreshes if I update the refresh every … minutes field in the column settings.
How do I get it to refresh automatically?

The logic is:

  1. Record is added to CRM (happens in CRM)
  2. Get all records from CRM using call API

![Screenshot 2024-12-10 at 10.16.33|261x499]
(upload://keve6zFJaXrqcOXMhclgE9tYNaT.png)
(no that isn’t my full API token)

The data doesn’t refresh at all, 2 mins is just because I’m testing.
If I update 2 mins to something else, it will refresh.

I’m happy to trigger the refresh from within Glide. Question is how.

2

I would suggest using a scheduled workflow if you have access to it. That way, you’re sure it fires based on schedule, and do what you want.

If the above is not doable, then maybe adding a parameter to your URL that doesn’t break it, and link it to a timestamp that updates every X minutes based on a math column.

3

The trigger is every time I visit the screen.

Or alternatively, when I add a new lead from within Glide that syncs back to the CRM.

What is it that triggers the api call to run if not the refresh every … mins value?

4

If the refresh value doesn’t do it, then you can follow my suggestion above.

For this one.

There isn’t a native way to do it, but an alternative is adding an AI component that doesn’t show anything on the screen, but triggers an update in a timestamp field. Then you use that timestamp in the URL you use for the Call API column.

1 Like
5

is the refresh value not working a bug?

6

Solution

When adding lead to CRM from Glide:

  • Add row to leads-list table (using the same workflow for adding leads to CRM)
  • Add timestamp to a field in leads-list table that does nothing

Question is still why refresh every … mins doesn’t do anything

7

From the documentation for Call API.

“Note that setting a refresh rate does not mean Glide will automatically make the call at that interval. The call will only happen again if there has been some event that makes it clear that data needs to be updated, such as a user interacting with that data in the app, or a developer viewing that data in the Data Editor. If the data is hidden or not in use, it will not update.”

1 Like
8

Thanks, what is an example of this @Jeff?

I update the time stamp in the row for a record and I want that to trigger the api request. This isn’t doing it though.

9

I would imagine any time the table is initially cached and loaded, any time data in the row changes that might affect the result from the API.

1 Like
10

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.