Skip to main content
Question

URL to manually refresh a connected table

  • July 17, 2017
  • 0 replies
  • 571 views
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.
    This topic has been closed for replies.

    • MCFNeil
    • Quickbase Alumni
    • July 18, 2017
    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.
    • anthony3123anth
    • Author
    • Quickbase Alumni
    • July 18, 2017
    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.
    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.
    • MCFNeil
    • Quickbase Alumni
    • July 18, 2017
    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()})"
      Terms & ConditionsAccessibility statement