Toggl
Toggl is a cloud-based time-tracking platform.
Toggl integration replicates data using the Toggl API v8.
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 set up your Toggl account, you need:
- Your Toggl API token is specific to your user. When replicating data, Qlik Talend Cloud is only able to access the same data as your user in Toggl.
- To replicate time entry data from multiple workspaces, you must be an Admin in the workspace from which you want to replicate data. Verify that you have this permission in Toggl before proceeding.
To retrieve your API token:
- Log into your Toggl account.
- Click the Workspace menu in the lower left corner.
- Click Profile settings.
- Locate the API token field.
- Copy the API token.
Creating the connection
자세한 내용은 SaaS 응용 프로그램에 연결을 참조하십시오.
- 필요한 연결 속성을 입력합니다.
연결 이름에 연결 이름을 입력합니다.
연결이 만들어질 때 연결에 대한 메타데이터를 정의하려면 연결 메타데이터 열기를 선택합니다.
만들기를 클릭합니다.
| Setting | Description |
|---|---|
| Data gateway | 사용 사례에 필요한 경우 데이터 이동 게이트웨이를 선택합니다. 정보 메모 이 필드는 데이터 이동 게이트웨이를 지원하지 않으므로 Qlik Talend Cloud 시작 구독에서는 사용할 수 없습니다. 다른 구독 계층이 있고 데이터 이동 게이트웨이를 사용하지 않으려면 없음을 선택합니다. 데이터 이동 게이트웨이의 이점과 이를 필요로 하는 사용 사례에 대한 자세한 내용은 Qlik 데이터 게이트웨이 - 데이터 이동를 참조하십시오. |
| Start Date | 데이터를 소스에서 대상으로 복제해야 하는 날짜를 |
| API Token | API token. |
| Trailing Days | Enter the number of days to be used as an attribution window when replicating time entry data. This is only applicable to the If the value is 5, Toggle replicates the past five days’ worth of data for the |
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 1.
Depending on your destination, table and column names may not appear as they are outlined below.
clients
The clients table contains info about the clients in your Toggl account.
Replication Method | CDC |
Primary Key | id |
Replication Key | at |
| Useful links |
groups
The groups table contains info about the groups in your Toggl account.
Replication Method | CDC |
Primary Key | id |
Replication Key | at |
| Useful links |
projects
The projects table contains info about the projects in your Toggl account.
Replication Method | CDC |
Primary Key | id |
Replication Key | at |
| Useful links |
tags
The tags table contains info about the tags in your Toggl account.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
tasks
The tasks table contains info about the tasks in your Toggl account.
Note: Tasks are only available for Toggl starter and other paid workspaces.
Replication Method | CDC |
Primary Key | id |
Replication Key | at |
| Useful links |
time_entries
The time_entries table contains info about time entries. Note: This table uses an attribution window to replicate data. Refer to the Replicating time entry data section for more info.
Time entries and user permissions
The time entries Stitch replicates are dependent upon the user whose API token is used to create the integration in Stitch. Stitch is only able to access the same data as the user whose token is used.
For example: If the user is unable to access a workspace, or is not an Admin in that workspace, Stitch will not be able to replicate time entry data for those workspaces. In this case, only the user’s own time entries will be accessible by Stitch.
If data from a workspace is missing, verify that the user whose API token is being used in Stitch has Admin permissions in that workspace.
Replication Method | CDC |
Primary Key | id |
Replication Key | updated |
| Useful links |
users
The users table contains info about the users in your Toggl account.
Replication Method | CDC |
Primary Key | id |
Replication Key | at |
| Useful links |
workspace_users
The workspace_users table contains info about the users in a workspace.
Replication Method | CDC |
Primary Key | id |
Replication Key | at |
| Useful links |
workspaces
The workspaces table contains info about the workspaces in your Toggl account.
Replication Method | CDC |
Primary Key | id |
Replication Key | at |
| Useful links |