Quickbase
Quickbase is a no-code application development platform for dynamic work management.
Quickbase integration replicates data using the QuickBase REST API.
See the Schema section for a list of objects available for replication.Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
You need administrator permissions in your Quickbase account.
To create a user token:
- Log into your Quickbase account.
- In the upper-right corner, select your user name, and then select Manage User Tokens.
- Click New user token.
- Enter the token details: a Name and a Description.
- In the Assign token to apps section, use the drop-down lists to select the apps to which the token will be assigned.
- Click Save.
The new token appears in the list of user tokens.
Creating the connection
如需詳細資訊,請參閱連線到 SaaS 應用程式。
- 填寫所需的連線屬性。
在連線名稱中提供連線名稱。
選取開啟連線中繼資料以在建立後定義連線的中繼資料。
按一下建立。
| Setting | Description |
|---|---|
| Data gateway | 如您的使用情況有需要,選取 資料移動閘道。 資訊備註 此欄位無法用於 Qlik Talend Cloud 啟動器 訂閱,因為不支援 資料移動閘道。若您有另一個訂閱層級且不想使用 資料移動閘道,選取無。 如需關於 資料移動閘道 福利的資訊以及需要此項的使用案例,請參閱 Qlik 資料閘道 - 資料移動。 |
| Start Date | 以 |
| Quick Base Application ID | You can find the application ID of your Quickbase site in the URL of your account homepage. If the URL is https://yourcompany.quickbase.com/db/bq7z6x7xx, the application ID is bq7z6x7xx. |
| Quick Base API URL | API URL. |
| Quick Base User Token | User token. |
| Page Size | Optional. The default value is set to 100. |
Schema
Depending on your destination, table and column names may not appear as they are outlined below.
apps
Replication Method | Full Table |
Primary Key | id |
| Useful links |
events
Replication Method | Full Table |
Primary Key | id |
| Useful links |
roles
Replication Method | Full Table |
Primary Key | id |
| Useful links |
app_tables
Replication Method | Full Table |
Primary Key | id |
| Useful links |
tables
Replication Method | Full Table |
Primary Key | id |
| Useful links |
table_relationships
Replication Method | Full Table |
Primary Key | id tableId |
| Useful links |
table_reports
Replication Method | Full Table |
Primary Key | id |
| Useful links |
reports
Replication Method | Full Table |
Primary Key | id |
| Useful links |
fields
Replication Method | Full Table |
Primary Key | id tableId |
| Useful links |
fields_usage
Replication Method | Full Table |
Primary Key | id tableId |
| Useful links |