This topic refers to functionality that is not available to accounts on the Quick Base Essential plan. If the functionality described here does not match what you're seeing in Quick Base, your account is probably on this plan.
A connection belongs to you and contains references to the service that it connects to, for example, Salesforce.com or QuickBooks Online. You can reuse your connection to create multiple connected tables in multiple Quick Base apps and create new connections as needed.
Multiple connections to a service
We recommend that you create a second connection to a service, such as QuickBooks Online, only if you need to access a new account or company. While some data sources, such as Salesforce.com, allow multiple connections to the same company information, others, such as QuickBooks Online, do not.In fact, QuickBooks Online allows only one connection to a company, regardless of the connection owner. You may need to coordinate among app admins when creating QuickBooks connections.
For example, if you sign in differently to access different companies in QuickBooks Online, then you would have two different QuickBooks connections: one to Company A and one to Company B. Each of these connections provides access to the QuickBooks data associated with the company, user name, and password that you supplied.
Since connections are unique to you, you can give each connection a name. For example, Pam’s QBO Company A connection.
What do I need to create a connection?
Each data source has different requirements for providing Quick Base with access to your data. Many data sources, such as Salesforce.com and QuickBooks Online, use Open Authentication (OAuth), an industry standard that securely grants access to data, while protecting personal information, such as your user name and password.
In addition to credentials, some data sources also have other requirements:
Salesforce.com: requires that your Salesforce.com account have API access enabled. Your user account must also have the API Enabled permission selected.
QuickBooks Online: requires that you are a QuickBooks Online Administrator. QuickBooks Online allows only one active connection to a company. If you create a new QuickBooks Online connection to the same company, the prior connection is invalid.
Tip: For help while creating a new connected table, click the Help icon in the top right and we'll guide you along.
View, test, or delete your connections
To view details about your connection and test, change, or delete connections, click the user dropdown on the Global bar, then click My preferences. Your connections display in the My Connections area.
Important: Deleting a connection for Gmail, Google Drive, or QuickBooks will invalidate other QuickBase Sync connections that were created with the same Gmail, Google Drive, or QuickBooks log in credentials. This happens because when a connection is deleted, we send a request to the connected service to revoke the OAuth token that was used by that connection. When Google or QuickBooks receives the request, they invalidate all the OAuth tokens for Quick Base Sync for that user. The connections in Quick Base will fail until the connection owner reauthorizes the connection to get a new valid OAuth token.
View connected table details and history
To view Details about your connected table, including the connected service, connection owner, connected fields, filter, and schedule for the connected table, access the connection in Table Settings. You can also view a History of recent refreshes, and edit the connection filter, refresh schedule, or switch to use a different connection, if necessary.
Did this help you? Give us a rating:
© 1999-2020 QuickBase, Inc. All rights reserved. Legal Notices.