Skip to main content
Question

Pipelines - Connected Table Refresh

  • March 26, 2024
  • 0 replies
  • 1285 views

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
------------------------------

Forum|alt.badge.img+9
  • Registered
  • March 26, 2024

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.