Teamwork
Teamwork is a team project management solution.
Teamwork integration replicates data using the Teamwork 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.
To retrieve your API key:
- Log into your Teamwork account.
- Click your profile icon in the main navigation menu.
- Navigate to Settings > API Keys.
- Copy and paste your API key into a secured file.
Creating the connection
Daha fazla bilgi için bk. SaaS uygulamalarına bağlanma.
- Zorunlu bağlantı özelliklerini doldurun.
Bağlantı adı kısmında bağlantı için bir ad sağlayın.
Oluşturulduğu zaman bağlantı için meta verileri tanımlamak üzere Bağlantı meta verilerini aç'ı seçin.
Oluştur'a tıklayın.
| Setting | Description |
|---|---|
| Data gateway | Kullanım durumunuz gerektiriyorsa bir Veri Hareketi ağ geçidi seçin. Bilgi notu Qlik Talend Cloud Başlangıç Kılavuzu aboneliği Veri Hareketi ağ geçidi desteklenmediğinden bu alan, söz konusu abonelikle kullanılamaz. Başka bir abonelik kademeniz varsa ve Veri Hareketi ağ geçidi kullanmak istemiyorsanız Hiçbiri'ni seçin. Veri Hareketi ağ geçidi avantajları ve bunu gerektiren kullanım durumları hakkında bilgi için bkz. Qlik Data Gateway - Veri Hareketi. |
| Start Date | Verilerin kaynağınızdan hedefinize çoğaltılması gereken tarihi |
| Subdomain | You can find your subdomain in the URL of your Teamwork account. If the URL is my-teamwork-site.teamwork.com, the subdomain is my-teamwork-site. |
| API Key | API key. |
Schema
Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
The schema and info displayed below is for version 2.
Depending on your destination, table and column names may not appear as they are outlined below.
collaborators
The collaborators table contains info about the collaborators in your Teamwork account.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
companies
The companies table contains info about the companies in your Teamwork account.
Replication Method | CDC |
Primary Key | id |
| Useful links |
company
The company table contains info about the company in your Teamwork account.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
customers
The customers table contains info about the customers in your Teamwork account.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
customer
The customer table contains info about the customer in your Teamwork account.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
inboxes
The inboxes table contains info about the inboxes in your Teamwork account.
Replication Method | CDC |
Primary Key | id |
| Useful links |
milestones
The milestones table contains info about the milestones in your Teamwork account.
Replication Method | CDC |
Primary Key | id |
| Useful links |
notebooks
The notebooks table contains info about the notebooks in your Teamwork account.
Replication Method | CDC |
Primary Key | id |
| Useful links |
pages
The pages table contains info about the pages in your Teamwork account.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
projects
The projects table contains info about the projects in your Teamwork account.
Replication Method | CDC |
Primary Key | id |
| Useful links |
spaces
The spaces table contains info about the spaces in your Teamwork account.
Replication Method | CDC |
Primary Key | id |
| Useful links |
tags
The tags table contains info about the tags in your Teamwork account.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
tasks
The tasks table contains info about the tasks in your Teamwork account.
Replication Method | CDC |
Primary Key | id |
| Useful links |
ticket_details
The ticket_details table contains info about the tickets in your Teamwork account.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
ticket_priorities
The ticket_priorities table contains info about the priorities in your Teamwork account.
Replication Method | CDC |
Primary Key | id |
| Useful links |
ticket_search
The ticket_search table contains info about the tickets in your Teamwork account.
Replication Method | CDC |
Primary Key | id |
| Useful links |
ticket_types
The ticket_types table contains info about the types in your Teamwork account.
Replication Method | CDC |
Primary Key | id |
| Useful links |
tickets
The tickets table contains info about the tickets in your Teamwork account.
Replication Method | CDC |
Primary Key | id |
| Useful links |
users
The users table contains info about the users in your Teamwork account.
Replication Method | CDC |
Primary Key | id |
| Useful links |