# Toggl

Toggl is a cloud-based time-tracking platform.

Toggl integration replicates data using the [Toggl API v8](https://github.com/toggl/toggl_api_docs/blob/master/toggl_api.md).

See the [Schema](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#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.

Information noteMake sure that the account you use has read access to the tables you want to fetch.

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:

1. Log into your [Toggl](https://accounts.toggl.com/track/login/) account.
2. Click the Workspace menu in the lower left corner.
3. Click Profile settings.
4. Locate the API token field.
5. Copy the API token.

## Creating the connection

For more information, see [Connecting to SaaS applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Landing/connecting-web-applications.htm).

1. Fill in the required connection properties.

2. Provide a name for the connection in Connection name.

3. Select Open connection metadata to define metadata for the connection when it has been created.

4. Click Create.

Connection settings

| Setting | Description |
| --- | --- |
| Data gateway | Select a Data Movement gateway if required by your use case.<br><br>Information note<br><br>This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None.<br><br>For information on the benefits of Data Movement gateway and use cases that require it, see [Qlik Data Gateway - Data Movement](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/replication-gateway.htm). |
| Start Date | Enter the date, in the format `MM/DD/YYYY`, from which the data must be replicated from your source to your target. |
| 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 `time_entries` table.<br><br>If the value is 5, Toggle replicates the past five days’ worth of data for the `time_entries` table during every replication job. |

## Schema

Information note

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

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** | [Toggl documentation](https://github.com/toggl/toggl_api_docs/blob/master/chapters/clients.md)<br><br>[Toggl API method](https://github.com/toggl/toggl_api_docs/blob/master/chapters/workspaces.md#get-workspace-clients "Opens in new tab: Toggl API method") |

clients table foreign keys

| Join clients with | on |
| --- | --- |
| [workspaces](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#workspaces) | ```<br>clients.wid = workspaces.id<br>``` |
| [groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#groups) | ```<br>clients.wid = groups.wid<br>``` |
| [projects](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#projects) | ```<br>clients.wid = projects.wid<br>```<br><br>```<br>clients.id = projects.cid<br>``` |
| [tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#tags) | ```<br>clients.wid = tags.wid<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#tasks) | ```<br>clients.wid = tasks.wid<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#users) | ```<br>clients.wid = users.default_wid<br>``` |
| [workspace_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#workspace-users) | ```<br>clients.wid = workspace_users.wid<br>``` |

clients table schema

| **at**<br><br><br>DATE-TIME |
| --- |
| **cur**<br><br><br>STRING |
| **hrate**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **name**<br><br><br>STRING |
| **notes**<br><br><br>STRING |
| **wid**<br><br><br>INTEGER |

### groups

The `groups` table contains info about the groups in your Toggl account.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | at |
| **Useful links** | [Toggl documentation](https://github.com/toggl/toggl_api_docs/blob/master/chapters/groups.md)<br><br>[Toggl API method](https://github.com/toggl/toggl_api_docs/blob/master/chapters/workspaces.md#get-workspace-groups "Opens in new tab: Toggl API method") |

groups table foreign keys

| Join groups with | on |
| --- | --- |
| [workspaces](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#workspaces) | ```<br>groups.wid = workspaces.id<br>``` |
| [clients](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#clients) | ```<br>groups.wid = clients.wid<br>``` |
| [projects](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#projects) | ```<br>groups.wid = projects.wid<br>``` |
| [tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#tags) | ```<br>groups.wid = tags.wid<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#tasks) | ```<br>groups.wid = tasks.wid<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#users) | ```<br>groups.wid = users.default_wid<br>``` |
| [workspace_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#workspace-users) | ```<br>groups.wid = workspace_users.wid<br>``` |

groups table schema

| **at**<br><br><br>DATE-TIME |
| --- |
| **id**<br><br><br>INTEGER |
| **name**<br><br><br>STRING |
| **wid**<br><br><br>INTEGER |

### projects

The `projects` table contains info about the projects in your Toggl account.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | at |
| **Useful links** | [Toggl documentation](https://github.com/toggl/toggl_api_docs/blob/master/chapters/projects.md)<br><br>[Toggl API method](https://github.com/toggl/toggl_api_docs/blob/master/chapters/workspaces.md#get-workspace-projects "Opens in new tab: Toggl API method") |

projects table foreign keys

| Join projects with | on |
| --- | --- |
| [workspaces](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#workspaces) | ```<br>projects.wid = workspaces.id<br>``` |
| [clients](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#clients) | ```<br>projects.wid = clients.wid<br>```<br><br>```<br>projects.cid = clients.id<br>``` |
| [groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#groups) | ```<br>projects.wid = groups.wid<br>``` |
| [tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#tags) | ```<br>projects.wid = tags.wid<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#tasks) | ```<br>projects.wid = tasks.wid<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#users) | ```<br>projects.wid = users.default_wid<br>``` |
| [workspace_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#workspace-users) | ```<br>projects.wid = workspace_users.wid<br>``` |

projects table schema

| **active**<br><br><br>BOOLEAN |
| --- |
| **at**<br><br><br>DATE-TIME |
| **billable**<br><br><br>BOOLEAN |
| **cid**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **is\_private**<br><br><br>BOOLEAN |
| **name**<br><br><br>STRING |
| **wid**<br><br><br>INTEGER |

### tags

The `tags` table contains info about the tags in your Toggl account.

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Toggl documentation](https://github.com/toggl/toggl_api_docs/blob/master/chapters/tags.md)<br><br>[Toggl API method](https://github.com/toggl/toggl_api_docs/blob/master/chapters/workspaces.md#get-workspace-tags "Opens in new tab: Toggl API method") |

tags table foreign keys

| Join tags with | on |
| --- | --- |
| [workspaces](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#workspaces) | ```<br>tags.wid = workspaces.id<br>``` |
| [clients](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#clients) | ```<br>tags.wid = clients.wid<br>``` |
| [groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#groups) | ```<br>tags.wid = groups.wid<br>``` |
| [projects](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#projects) | ```<br>tags.wid = projects.wid<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#tasks) | ```<br>tags.wid = tasks.wid<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#users) | ```<br>tags.wid = users.default_wid<br>``` |
| [workspace_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#workspace-users) | ```<br>tags.wid = workspace_users.wid<br>``` |

tags table schema

| **id**<br><br><br>INTEGER |
| --- |
| **name**<br><br><br>STRING |
| **wid**<br><br><br>INTEGER |

### 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** | [Toggl documentation](https://github.com/toggl/toggl_api_docs/blob/master/chapters/tasks.md)<br><br>[Toggl API method](https://github.com/toggl/toggl_api_docs/blob/master/chapters/workspaces.md#get-workspace-tasks "Opens in new tab: Toggl API method") |

tasks table foreign keys

| Join tasks with | on |
| --- | --- |
| [workspaces](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#workspaces) | ```<br>tasks.wid = workspaces.id<br>``` |
| [clients](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#clients) | ```<br>tasks.wid = clients.wid<br>``` |
| [groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#groups) | ```<br>tasks.wid = groups.wid<br>``` |
| [projects](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#projects) | ```<br>tasks.wid = projects.wid<br>``` |
| [tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#tags) | ```<br>tasks.wid = tags.wid<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#users) | ```<br>tasks.wid = users.default_wid<br>```<br><br>```<br>tasks.uid = users.id<br>``` |
| [workspace_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#workspace-users) | ```<br>tasks.wid = workspace_users.wid<br>``` |
| [time_entries](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#time-entries) | ```<br>tasks.id = time_entries.tid<br>```<br><br>```<br>tasks.uid = time_entries.uid<br>``` |

tasks table schema

| **active**<br><br><br>BOOLEAN |
| --- |
| **at**<br><br><br>DATE-TIME |
| **estimated\_seconds**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **name**<br><br><br>STRING |
| **pid**<br><br><br>INTEGER |
| **uid**<br><br><br>INTEGER |
| **wid**<br><br><br>INTEGER |

### 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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#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** | [Toggl API method](https://github.com/toggl/toggl_api_docs/blob/master/reports/detailed.md "Opens in new tab: Toggl API method") |

time\_entries table foreign keys

| Join time\_entries with | on |
| --- | --- |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#tasks) | ```<br>time_entries.tid = tasks.id<br>```<br><br>```<br>time_entries.uid = tasks.uid<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#users) | ```<br>time_entries.uid = users.id<br>``` |

time\_entries table schema

| **billable**<br><br><br>NUMBER |
| --- |
| **client**<br><br><br>STRING |
| **cur**<br><br><br>STRING |
| **description**<br><br><br>STRING |
| **dur**<br><br><br>INTEGER |
| **end**<br><br><br>DATE-TIME |
| **id**<br><br><br>INTEGER |
| **is\_billable**<br><br><br>BOOLEAN |
| **pid**<br><br><br>INTEGER |
| **project**<br><br><br>STRING |
| **start**<br><br><br>DATE-TIME |
| **tags**<br><br><br>ARRAY |
| **task**<br><br><br>STRING |
| **tid**<br><br><br>INTEGER |
| **uid**<br><br><br>INTEGER |
| **updated**<br><br><br>DATE-TIME |
| **use\_stop**<br><br><br>BOOLEAN |
| **user**<br><br><br>STRING |

### users

The `users` table contains info about the users in your Toggl account.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | at |
| **Useful links** | [Toggl documentation](https://github.com/toggl/toggl_api_docs/blob/master/chapters/users.md)<br><br>[Toggl API method](https://github.com/toggl/toggl_api_docs/blob/master/chapters/workspaces.md#get-workspace-users "Opens in new tab: Toggl API method") |

users table foreign keys

| Join users with | on |
| --- | --- |
| [workspaces](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#workspaces) | ```<br>users.default_wid = workspaces.id<br>``` |
| [clients](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#clients) | ```<br>users.default_wid = clients.wid<br>``` |
| [groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#groups) | ```<br>users.default_wid = groups.wid<br>``` |
| [projects](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#projects) | ```<br>users.default_wid = projects.wid<br>``` |
| [tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#tags) | ```<br>users.default_wid = tags.wid<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#tasks) | ```<br>users.default_wid = tasks.wid<br>```<br><br>```<br>users.id = tasks.uid<br>``` |
| [workspace_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#workspace-users) | ```<br>users.default_wid = workspace_users.wid<br>``` |
| [time_entries](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#time-entries) | ```<br>users.id = time_entries.uid<br>``` |

users table schema

| **at**<br><br><br>DATE-TIME |
| --- |
| **beginning\_of\_week**<br><br><br>INTEGER |
| **date\_format**<br><br><br>STRING |
| **default\_wid**<br><br><br>INTEGER |
| **email**<br><br><br>STRING |
| **fullname**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **image\_url**<br><br><br>STRING |
| **invitation**<br><br><br>STRING |
| **jquery\_date\_format**<br><br><br>STRING |
| **jquery\_timeofday\_format**<br><br><br>STRING |
| **language**<br><br><br>STRING |
| **new\_blog\_post**<br><br><br>STRING |
| **record\_timeline**<br><br><br>BOOLEAN |
| **render\_timeline**<br><br><br>BOOLEAN |
| **retention**<br><br><br>INTEGER |
| **should\_upgrade**<br><br><br>BOOLEAN |
| **sidebar\_piechart**<br><br><br>BOOLEAN |
| **store\_start\_and\_stop\_time**<br><br><br>BOOLEAN |
| **timeline\_enabled**<br><br><br>BOOLEAN |
| **timeline\_experiment**<br><br><br>BOOLEAN |
| **timeofday\_format**<br><br><br>STRING |

### 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** | [Toggl documentation](https://github.com/toggl/toggl_api_docs/blob/master/chapters/workspace_users.md)<br><br>[Toggl API method](https://github.com/toggl/toggl_api_docs/blob/master/chapters/workspace_users.md#get-workspace-users "Opens in new tab: Toggl API method") |

workspace\_users table foreign keys

| Join workspace\_users with | on |
| --- | --- |
| [workspaces](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#workspaces) | ```<br>workspace_users.wid = workspaces.id<br>``` |
| [clients](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#clients) | ```<br>workspace_users.wid = clients.wid<br>``` |
| [groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#groups) | ```<br>workspace_users.wid = groups.wid<br>``` |
| [projects](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#projects) | ```<br>workspace_users.wid = projects.wid<br>``` |
| [tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#tags) | ```<br>workspace_users.wid = tags.wid<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#tasks) | ```<br>workspace_users.wid = tasks.wid<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#users) | ```<br>workspace_users.wid = users.default_wid<br>``` |

workspace\_users table schema

| **active**<br><br><br>BOOLEAN |
| --- |
| **admin**<br><br><br>BOOLEAN |
| **at**<br><br><br>DATE-TIME |
| **email**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **invite\_url**<br><br><br>STRING |
| **name**<br><br><br>STRING |
| **uid**<br><br><br>INTEGER |
| **wid**<br><br><br>INTEGER |

### workspaces

The `workspaces` table contains info about the workspaces in your Toggl account.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | at |
| **Useful links** | [Toggl documentation](https://github.com/toggl/toggl_api_docs/blob/master/chapters/workspaces.md)<br><br>[Toggl API method](https://github.com/toggl/toggl_api_docs/blob/master/chapters/workspaces.md#get-workspaces "Opens in new tab: Toggl API method") |

workspaces table foreign keys

| Join workspaces with | on |
| --- | --- |
| [clients](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#clients) | ```<br>workspaces.id = clients.wid<br>``` |
| [groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#groups) | ```<br>workspaces.id = groups.wid<br>``` |
| [projects](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#projects) | ```<br>workspaces.id = projects.wid<br>``` |
| [tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#tags) | ```<br>workspaces.id = tags.wid<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#tasks) | ```<br>workspaces.id = tasks.wid<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#users) | ```<br>workspaces.id = users.default_wid<br>``` |
| [workspace_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Toggl.htm#workspace-users) | ```<br>workspaces.id = workspace_users.wid<br>``` |

workspaces table schema

| **admin**<br><br><br>BOOLEAN |
| --- |
| **at**<br><br><br>DATE-TIME |
| **default\_currency**<br><br><br>STRING |
| **default\_hourly\_rate**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **logo\_url**<br><br><br>STRING |
| **name**<br><br><br>STRING |
| **only\_admins\_may\_create\_projects**<br><br><br>BOOLEAN |
| **only\_admins\_see\_billable\_rates**<br><br><br>BOOLEAN |
| **premium**<br><br><br>BOOLEAN |
| **rounding**<br><br><br>INTEGER |
| **rounding\_minutes**<br><br><br>INTEGER |