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 |