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 más información, vea Conexión a aplicaciones SaaS.
- Rellene las propiedades de conexión necesarias.
Proporcione un nombre para la conexión en Nombre de la conexión.
Seleccione Abrir metadatos de conexión para definir metadatos para la conexión cuando se haya creado.
Haga clic en Crear.
| Setting | Description |
|---|---|
| Data gateway | Seleccione una Data Movement gateway si su caso de uso así lo requiere. Nota informativa Este campo no está disponible con la suscripción Qlik Talend Cloud Starter porque Data Movement gateway no se admite. Si tiene otro nivel de suscripción y no desea utilizar Data Movement gateway, seleccione Ninguna. Para obtener información sobre las ventajas de Data Movement gateway y los casos de uso que lo requieren, consulte Pasarela de movimiento de datos de Qlik. |
| Start Date | Indique la fecha, en el 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 |