Is anyone aware of method for non-admin to manually refresh a connected (gmail) table?I have a gmail connected table with minimum refresh time (one hour). Sometimes we are aware of an email from customer but have to wait up to an hour to sync to table before we can work on it - difficult to explain to a customer.The 'Refresh Data' button seems to only appear for admin, hoping there is a URL to trigger a refresh.Cheers,Anthony.

Sorry for the mix up. Because URLs are naturally a GET request (to pull information from the server), but the refresh is a server side action. We need to use a POST to initiate the refresh.So your formula URL button would be:"javascript:$.post('https://mydomain.quickbase.com/qb/sync/refreshTasks?replicationID=12345').then(function(res,code) {console.log(res,code);window.location.reload()})"

I have the same error as JoJo when trying this solution. The URL works for my Administrator account for not for any other person. It works if I "Test as" them or their role however.Edit: For anyone else having the same issue that JoJo and myself had I found the issue to be that the user clicking the Refresh URL needs to have delete rights in that table for their assigned role. I had not given delete rights since the user couldn't actually delete the sync'd projects anyway.

You can initiate the refresh with a url similar to this:https://mydomain.quickbase.com/qb/sync/refreshTasks?replicationID=12345The trick is knowing your replication ID. You will need, as the admin, monitor your network traffic during a manual refresh, and pull out the ReplicationID. Then you should be able to add a button for everybody to refresh the data.

Hi Matthew,Thanks for your reply.By inspecting the 'refresh data' element I get a replication-id=25948The URL I construct is http://muif.quickbase.com/qb/sync/refreshTasks?replicationID=25948The response is 'no such operation'Have I formed the URL incorrectly? Regards,Anthony.

I'm very curious about this one too .... i tried to make that URL after looking at the source code of the page to obtain the ReplicationID and received the same error.

URL to manually refresh a connected table

21 Replies

MCFNeil
Qrew Captain
7 years ago
Sorry for the mix up.

Because URLs are naturally a GET request (to pull information from the server), but the refresh is a server side action. We need to use a POST to initiate the refresh.

So your formula URL button would be:

"javascript:$.post('https://mydomain.quickbase.com/qb/sync/refreshTasks?replicationID=12345').then(function(res,code) {console.log(res,code);window.location.reload()})"
- KeithWeber
  Qrew Member
  6 years ago
  I have the same error as JoJo when trying this solution. The URL works for my Administrator account for not for any other person. It works if I "Test as" them or their role however.
  
  Edit: For anyone else having the same issue that JoJo and myself had I found the issue to be that the user clicking the Refresh URL needs to have delete rights in that table for their assigned role. I had not given delete rights since the user couldn't actually delete the sync'd projects anyway.
- MCFNeil
  Qrew Captain
  7 years ago
  Keep in mind that sometimes the refresh action on the server takes longer than the refresh action in the browser. So you might have to manually refresh the browser after a bit to see the updated information.
- QuickBaseCoachD
  Qrew Captain
  7 years ago
  Thx Matthew, much appreciated Community Contribution.
MCFNeil
Qrew Captain
7 years ago
You can initiate the refresh with a url similar to this:

https://mydomain.quickbase.com/qb/sync/refreshTasks?replicationID=12345

The trick is knowing your replication ID. You will need, as the admin, monitor your network traffic during a manual refresh, and pull out the ReplicationID.

Then you should be able to add a button for everybody to refresh the data.
- VivekVishwanat2
  Qrew Cadet
  4 years ago
  Hi Matthew,
  
  A very good alternative approach.
  
  This Approach does not show the errors .--> as its a button.
  
  If I want to show the errors to Non-Admin users, Is there a way to show errors after the Sync run.
  
  ------------------------------
  Vivek Vishwanath
  Hyderabad, India
  +91 8185868789
  ------------------------------
- ELANAMETH
  Qrew Cadet
  3 years ago
  Is anyone aware of a good way to configure this in a webhook, as QB is phasing out JS?
  
  ------------------------------
  E. P.
  ------------------------------
  - RaziD_
    Qrew Cadet
    3 years ago
    For webhook please see my response at this post:
    
    https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=aeaf08cb-3f79-4d60-a5ea-540b2015222c&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer
    
    Thank you
    
    ------------------------------
    Razi D.
    Desta Tech LLC
    razi@destatechs.com
    ------------------------------
anthony3123anth
Qrew Trainee
7 years ago
Hi Matthew,

Thanks for your reply.

By inspecting the 'refresh data' element I get a replication-id=25948

The URL I construct is http://muif.quickbase.com/qb/sync/refreshTasks?replicationID=25948

The response is 'no such operation'

Have I formed the URL incorrectly?

Regards,
Anthony.
QuickBaseCoachD
Qrew Captain
7 years ago
I'm very curious about this one too .... i tried to make that URL after looking at the source code of the page to obtain the ReplicationID and received the same error.

Forum Discussion

URL to manually refresh a connected table

21 Replies

Related Content

Pipelines - Connected Table Refresh

Is it possible to manually trigger a connected table refresh using an API call?

Filter records based on table connection

Connected table not updating when record is changed in the connected database

Thumbnail pictures refreshing slowly

Recent Discussions

Empower Hour Tomorrow!

When the Expiration Date is On or Before Today, Change the Contract Status to Expired

Rollup Help

New Forms Return and Cancel Buttons Glitch

How to handle error in Upload step in Pipeline