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
Weitere Informationen finden Sie unter Herstellung einer Verbindung zu SaaS-Anwendungen.
- Füllen Sie die erforderlichen Verbindungseigenschaften aus.
Geben Sie einen Namen für die Verbindung in Verbindungsname ein.
Wählen Sie Verbindungsmetadaten öffnen aus, um nach der Erstellung Metadaten für die Verbindung zu definieren.
Klicken Sie auf Erstellen.
| Setting | Description |
|---|---|
| Data gateway | Wählen Sie ein Data Movement Gateway aus, wenn dies für Ihren Anwendungsfall erforderlich ist. Informationshinweis Dieses Feld ist für das Qlik Talend Cloud Starter-Abonnement nicht verfügbar, da dieses Abonnement Data Movement Gateway nicht unterstützt. Wenn Sie eine andere Abonnementstufe haben und Data Movement Gateway nicht verwenden möchten, wählen Sie Keine. Weitere Informationen zu den Vorteilen von Data Movement Gateway und den Anwendungsfällen, in denen es erforderlich ist, finden Sie unter Qlik Data Gateway – Datenbewegung. |
| Start Date | Geben Sie das Datum im Format |
| 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 |