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
Więcej informacji zawiera temat Łączenie się z aplikacjami SaaS.
- Wprowadź wymagane właściwości połączenia.
Podaj nazwę połączenia w polu Nazwa połączenia.
Wybierz opcję Otwórz metadane połączenia, aby zdefiniować metadane połączenia po jegu utworzeniu.
Kliknij polecenie Utwórz.
| Setting | Description |
|---|---|
| Data gateway | Wybierz bramę Brama danych ruchu danych, jeżeli jest wymagana do danego zastosowania. Informacja To pole jest niedostępne w subskrypcji Qlik Talend Cloud Starter, ponieważ brama Brama danych ruchu danych jest w niej nieobsługiwana. Jeśli masz inny poziom subskrypcji i nie chcesz korzystać z bramy Brama danych ruchu danych, wybierz opcję Brak. Informacje o zaletach bramy Brama danych ruchu danych i o okolicznościach, w których jest wymagana, zawiera temat Brama danych Qlik — ruch danych. |
| Start Date | Wprowadź datę, w formacie |
| 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 |