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. ...
Forum Discussion
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
------------------------------
MarkShnier__You
Qrew Legend
Qrew Legendtag teaming w/ Chayce.
This post here says this
- In URL:
- "qbhostname": replace with hostname (the text before quickbase.com in your realm URL)
- #####: replace with your replication ID
- For those like me who didn't know how to find this, if you go to your connected table page, press F12 to bring up the developer tools console. Click on the "Network" option across the top. I filtered for refresh to limit what displayed. Click on any item and then click on "Headers" to make sure you're on the right tab. Then, click the Refresh table button in QB, quickly click on the "refreshTasks?replicationID=..." that shows up under the "Name" side, and capture the Request URL that comes up. It can happen pretty quickly so you have to be read to go. I just took a screenshot since it was the fastest. There may be another place to find it where the ID/URL sticks around, but I couldn't find it. See screenshot attached.
- In Headers Value:
- "####": replace with your user token
- In Body: Information can be found on the Advanced Settings of the table
- Name: replace "Table Name" with name of table, not ID
- singleRecordName: replace "Name" with the name for single records in the table
- pluralRecordName: replace "Names" with the name for multiple records
------------------------------
Brittany ......
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Thank you Chayce and Mark! Much appreciated.
------------------------------
Christine Carpentier
------------------------------Hi Mark, i have been trying to set up the same solution in one of my applications and made absolutely sure i followed the screenshots and additional instructions you and Chayce made, but am faced with a pipeline error as follows:
Remote API returned authentication error: {'errorCode': 401, 'errorMessage': 'Sign in required', 'data': None}Does this error give you any insight as to what could be wrong? is additional authentication required to be entered in the Make Request step or is this an issue with User token ?
- MarkShnier__You
QuickbaseDevel1 did you provide a valid user token? Not an Application Token, but a User Token?
