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 | ユース ケースに応じて Data Movement gateway を選択します。 情報メモ Qlik Talend Cloud スターター サブスクリプションでは Data Movement gateway をサポートしていないため、この項目は使用できません。別のサブスクリプション ティアを利用しており、Data Movement gateway を使用しない場合は、 [None] (なし) を選択します。 Data Movement gateway の利点とそれを必要とするユース ケースの詳細については、「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 |