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 Starter 订阅，因为它不支持 数据移动网关。如果您有另一个订阅层并且不想使用 数据移动网关，请选择无。 有关 数据移动网关 的优势和需要它的用例的信息，请参阅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 |