Toggl Connector Reference
The Toggl connector exposes 124 fields (14 metrics, 110 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Toggl Fields
Toggl organizations fields
The organizations report of the Toggl connector includes 16 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| organizations__admin | BOOLEAN | organizations.admin | organizations.admin |
| organizations__at | TEXT | organizations.at | organizations.at |
| organizations__created_at | TEXT | organizations.created_at | organizations.created_at |
| organizations__id | TEXT | organizations.id | organizations.id |
| organizations__is_chargify | BOOLEAN | organizations.is_chargify | organizations.is_chargify |
| organizations__is_multi_workspace_enabled | BOOLEAN | organizations.is_multi_workspace_enabled | organizations.is_multi_workspace_enabled |
| organizations__is_unified | BOOLEAN | organizations.is_unified | organizations.is_unified |
| organizations__max_workspaces | NUMERIC | organizations.max_workspaces | organizations.max_workspaces |
| organizations__name | TEXT | organizations.name | organizations.name |
| organizations__owner | BOOLEAN | organizations.owner | organizations.owner |
| organizations__payment_methods | TEXT | organizations.payment_methods | organizations.payment_methods |
| organizations__pricing_plan_id | TEXT | organizations.pricing_plan_id | organizations.pricing_plan_id |
| organizations__server_deleted_at | TEXT | organizations.server_deleted_at | organizations.server_deleted_at |
| organizations__suspended_at | TEXT | organizations.suspended_at | organizations.suspended_at |
| organizations__trial_info | OBJECT | organizations.trial_info | organizations.trial_info |
| organizations__user_count | NUMERIC | organizations.user_count | organizations.user_count |
Toggl organizations_groups fields
The organizations_groups report of the Toggl connector includes 5 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| organizations_groups__at | TEXT | organizations_groups.at | organizations_groups.at |
| organizations_groups__group_id | TEXT | organizations_groups.group_id | organizations_groups.group_id |
| organizations_groups__name | TEXT | organizations_groups.name | organizations_groups.name |
| organizations_groups__users | OBJECT | organizations_groups.users | organizations_groups.users |
| organizations_groups__workspaces | OBJECT | organizations_groups.workspaces | organizations_groups.workspaces |
Toggl organizations_users fields
The organizations_users report of the Toggl connector includes 13 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| organizations_users__admin | BOOLEAN | organizations_users.admin | organizations_users.admin |
| organizations_users__avatar_url | TEXT | organizations_users.avatar_url | organizations_users.avatar_url |
| organizations_users__can_edit_email | BOOLEAN | organizations_users.can_edit_email | organizations_users.can_edit_email |
| organizations_users__email | TEXT | organizations_users.email | organizations_users.email |
| organizations_users__groups | OBJECT | organizations_users.groups | organizations_users.groups |
| organizations_users__id | TEXT | organizations_users.id | organizations_users.id |
| organizations_users__inactive | BOOLEAN | organizations_users.inactive | organizations_users.inactive |
| organizations_users__invitation_code | TEXT | organizations_users.invitation_code | organizations_users.invitation_code |
| organizations_users__joined | BOOLEAN | organizations_users.joined | organizations_users.joined |
| organizations_users__name | TEXT | organizations_users.name | organizations_users.name |
| organizations_users__owner | BOOLEAN | organizations_users.owner | organizations_users.owner |
| organizations_users__user_id | TEXT | organizations_users.user_id | organizations_users.user_id |
| organizations_users__workspaces | OBJECT | organizations_users.workspaces | organizations_users.workspaces |
Toggl time_entries fields
The time_entries report of the Toggl connector includes 24 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| time_entries__at | TEXT | time_entries.at | time_entries.at |
| time_entries__billable | BOOLEAN | time_entries.billable | time_entries.billable |
| time_entries__billable_amount_in_cents | NUMERIC | time_entries.billable_amount_in_cents | Billable amount of the time entry, in cents. |
| time_entries__currency | TEXT | time_entries.currency | Currency of the billable amount and hourly rate. |
| time_entries__description | TEXT | time_entries.description | time_entries.description |
| time_entries__duration | NUMERIC | (Deprecated) time_entries.duration | time_entries.duration |
| time_entries__duronly | BOOLEAN | (Deprecated) time_entries.duronly | time_entries.duronly |
| time_entries__hourly_rate_in_cents | NUMERIC | time_entries.hourly_rate_in_cents | Hourly rate applied to the time entry, in cents. |
| time_entries__id | TEXT | time_entries.id | time_entries.id |
| time_entries__pid | TEXT | (Deprecated) time_entries.pid | time_entries.pid |
| time_entries__project_id | TEXT | time_entries.project_id | time_entries.project_id |
| time_entries__seconds | NUMERIC | time_entries.seconds | Tracked duration of the time entry, in seconds. |
| time_entries__server_deleted_at | TEXT | (Deprecated) time_entries.server_deleted_at | time_entries.server_deleted_at |
| time_entries__start | TEXT | time_entries.start | time_entries.start |
| time_entries__stop | TEXT | time_entries.stop | time_entries.stop |
| time_entries__tag_ids | OBJECT | time_entries.tag_ids | time_entries.tag_ids |
| time_entries__tags | OBJECT | (Deprecated) time_entries.tags | time_entries.tags |
| time_entries__task_id | TEXT | time_entries.task_id | time_entries.task_id |
| time_entries__tid | TEXT | (Deprecated) time_entries.tid | time_entries.tid |
| time_entries__uid | TEXT | (Deprecated) time_entries.uid | time_entries.uid |
| time_entries__user_id | TEXT | time_entries.user_id | time_entries.user_id |
| time_entries__username | TEXT | time_entries.username | Full name of the user who tracked the time entry. |
| time_entries__wid | TEXT | (Deprecated) time_entries.wid | time_entries.wid |
| time_entries__workspace_id | TEXT | (Deprecated) time_entries.workspace_id | time_entries.workspace_id |
Toggl workspace fields
The workspace report of the Toggl connector includes 3 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| workspace__admins | OBJECT | workspace.admins | workspace.admins |
| workspace__groups_count | NUMERIC | workspace.groups_count | workspace.groups_count |
| workspace__members_count | NUMERIC | workspace.members_count | workspace.members_count |
Toggl workspace_clients fields
The workspace_clients report of the Toggl connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| workspace_clients__archived | BOOLEAN | workspace_clients.archived | workspace_clients.archived |
| workspace_clients__at | TEXT | workspace_clients.at | workspace_clients.at |
| workspace_clients__id | TEXT | workspace_clients.id | workspace_clients.id |
| workspace_clients__name | TEXT | workspace_clients.name | workspace_clients.name |
| workspace_clients__server_deleted_at | TEXT | workspace_clients.server_deleted_at | workspace_clients.server_deleted_at |
| workspace_clients__wid | TEXT | workspace_clients.wid | workspace_clients.wid |
Toggl workspace_projects fields
The workspace_projects report of the Toggl connector includes 25 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| workspace_projects__active | BOOLEAN | workspace_projects.active | workspace_projects.active |
| workspace_projects__actual_hours | NUMERIC | workspace_projects.actual_hours | workspace_projects.actual_hours |
| workspace_projects__at | TEXT | workspace_projects.at | workspace_projects.at |
| workspace_projects__auto_estimates | BOOLEAN | workspace_projects.auto_estimates | workspace_projects.auto_estimates |
| workspace_projects__billable | BOOLEAN | workspace_projects.billable | workspace_projects.billable |
| workspace_projects__cid | TEXT | workspace_projects.cid | workspace_projects.cid |
| workspace_projects__client_id | TEXT | workspace_projects.client_id | workspace_projects.client_id |
| workspace_projects__color | TEXT | workspace_projects.color | workspace_projects.color |
| workspace_projects__created_at | TEXT | workspace_projects.created_at | workspace_projects.created_at |
| workspace_projects__currency | TEXT | workspace_projects.currency | workspace_projects.currency |
| workspace_projects__current_period | OBJECT | workspace_projects.current_period | workspace_projects.current_period |
| workspace_projects__estimated_hours | NUMERIC | workspace_projects.estimated_hours | workspace_projects.estimated_hours |
| workspace_projects__first_time_entry | workspace_projects.first_time_entry | workspace_projects.first_time_entry | |
| workspace_projects__fixed_fee | NUMERIC | workspace_projects.fixed_fee | workspace_projects.fixed_fee |
| workspace_projects__id | TEXT | workspace_projects.id | workspace_projects.id |
| workspace_projects__is_private | BOOLEAN | workspace_projects.is_private | workspace_projects.is_private |
| workspace_projects__name | TEXT | workspace_projects.name | workspace_projects.name |
| workspace_projects__rate | NUMERIC | workspace_projects.rate | workspace_projects.rate |
| workspace_projects__rate_last_updated | TEXT | workspace_projects.rate_last_updated | workspace_projects.rate_last_updated |
| workspace_projects__recurring | BOOLEAN | workspace_projects.recurring | workspace_projects.recurring |
| workspace_projects__recurring_parameters | OBJECT | workspace_projects.recurring_parameters | workspace_projects.recurring_parameters |
| workspace_projects__server_deleted_at | TEXT | workspace_projects.server_deleted_at | workspace_projects.server_deleted_at |
| workspace_projects__template | BOOLEAN | workspace_projects.template | workspace_projects.template |
| workspace_projects__wid | TEXT | workspace_projects.wid | workspace_projects.wid |
| workspace_projects__workspace_id | TEXT | workspace_projects.workspace_id | workspace_projects.workspace_id |
Toggl workspace_tasks fields
The workspace_tasks report of the Toggl connector includes 11 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| workspace_tasks__active | BOOLEAN | workspace_tasks.active | workspace_tasks.active |
| workspace_tasks__at | TEXT | workspace_tasks.at | workspace_tasks.at |
| workspace_tasks__estimated_seconds | NUMERIC | workspace_tasks.estimated_seconds | workspace_tasks.estimated_seconds |
| workspace_tasks__id | TEXT | workspace_tasks.id | workspace_tasks.id |
| workspace_tasks__name | TEXT | workspace_tasks.name | workspace_tasks.name |
| workspace_tasks__project_id | TEXT | workspace_tasks.project_id | workspace_tasks.project_id |
| workspace_tasks__recurring | BOOLEAN | workspace_tasks.recurring | workspace_tasks.recurring |
| workspace_tasks__server_deleted_at | TEXT | workspace_tasks.server_deleted_at | workspace_tasks.server_deleted_at |
| workspace_tasks__tracked_seconds | NUMERIC | workspace_tasks.tracked_seconds | workspace_tasks.tracked_seconds |
| workspace_tasks__user_id | TEXT | workspace_tasks.user_id | workspace_tasks.user_id |
| workspace_tasks__workspace_id | TEXT | workspace_tasks.workspace_id | workspace_tasks.workspace_id |
Toggl other fields
The Toggl connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | Account ID. | |
| account_name | TEXT | Account Name | Account name. | |
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Date. | |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |
Windsor vs Coupler.io
