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
Para obter mais informações, consulte Conectando-se a aplicativos SAP.
- Preencha as propriedades de conexão obrigatórias.
Forneça um nome para a conexão em Nome da conexão.
Selecione Abrir metadados de conexão para definir metadados para a conexão quando ela for criada.
Clique em Criar.
| Setting | Description |
|---|---|
| Data gateway | Selecione um Gateway Data Movement se for necessário para seu caso de uso. Nota informativa Esse campo não está disponível com a assinatura do Iniciante do Qlik Talend Cloud, pois esta não é compatível com o Gateway Data Movement. Se você tiver outro nível de assinatura e não quiser usar o Gateway Data Movement, selecione Nenhum. Para obter informações sobre os benefícios do Gateway Data Movement e casos de uso que exigem isso, consulte Qlik Data Gateway - Movimentação de dados. |
| Start Date | Digite a data, no formato |
| 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 |