Skip to main content
Question

Pipelines - Connected Table Refresh


Is it possible to run a table Refresh/Sync, for a Google Drive Connected Table,  within a pipeline?  I want to refresh a table at a specific scheduled time and then run a Table to Table import job.  The refresh scheduling on the connected table is not specific enough since it is anytime within a one hour period. Thank you in advance for any help that you can provide.



------------------------------
Christine Carpentier
------------------------------

5 replies

Forum|alt.badge.img+9

Yes, you can. You need to get the 'replicationID' for your sync table, but then you can create a Pipeline using the 'Request' Channel where you POST the following: 

URL: https://yourrealm.quickbase.com/qb/sync/refreshTasks?replicationID=yourReplicationID

Headers: 

Authorization: QB-USER-TOKEN your usertoken

Then you can schedule your pipeline to run at the set interval you need.



------------------------------
Chayce Duncan
------------------------------

Thanks to the feedback from Mark and Chayce, my pipeline is successfully running a refresh on the connected table. However, the pipeline job completes upon kick-off of the refresh instead of completion of the refresh. My plan was to add a second step in the pipeline to execute a table import but this won't work if the the refresh/sync is still running. Am I missing something or do I need to keep these two steps in separate pipelines and schedule the second job (import job) with a few minutes lag to allow the refresh to complete? 

Thanks again for the help!



------------------------------
Christine Carpentier
------------------------------

Forum|alt.badge.img+5

ChayceDuncan/ MarkShnier__You :

This was very helpful! Thank you. 
I have attached my pipeline since I initially had issues. Hope it helps someone:


Forum|alt.badge.img+3

Thank you for having a look at my question Mark. I did indeed apply a User Token, even created a new one to be sure. The two applications involved are in the same Realm. attaching the setup of the pipeline for info.


Forum|alt.badge.img+14

The use of the ReplicationID feature with Pipelines has been disabled in October 2026 by Quickbase - as it is deemed a security risk and Syncs must now be triggered manually or by schedule only. 

We have had to switch back to Manual Syncs or Scheduled Syncs and rework pipeline flows around the timing of the Syncs.