Windsor brings all your Toggl data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Toggl Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| organizations__admin | BOOLEAN | organizations.admin | organizations.admin | organizations |
| organizations__at | TEXT | organizations.at | organizations.at | organizations |
| organizations__created_at | TEXT | organizations.created_at | organizations.created_at | organizations |
| organizations__id | NUMERIC | organizations.id | organizations.id | organizations |
| organizations__is_chargify | BOOLEAN | organizations.is_chargify | organizations.is_chargify | organizations |
| organizations__is_multi_workspace_enabled | BOOLEAN | organizations.is_multi_workspace_enabled | organizations.is_multi_workspace_enabled | organizations |
| organizations__is_unified | BOOLEAN | organizations.is_unified | organizations.is_unified | organizations |
| organizations__max_workspaces | NUMERIC | organizations.max_workspaces | organizations.max_workspaces | organizations |
| organizations__name | TEXT | organizations.name | organizations.name | organizations |
| organizations__owner | BOOLEAN | organizations.owner | organizations.owner | organizations |
| organizations__payment_methods | TEXT | organizations.payment_methods | organizations.payment_methods | organizations |
| organizations__pricing_plan_id | NUMERIC | organizations.pricing_plan_id | organizations.pricing_plan_id | organizations |
| organizations__server_deleted_at | TEXT | organizations.server_deleted_at | organizations.server_deleted_at | organizations |
| organizations__suspended_at | TEXT | organizations.suspended_at | organizations.suspended_at | organizations |
| organizations__trial_info | OBJECT | organizations.trial_info | organizations.trial_info | organizations |
| organizations__user_count | NUMERIC | organizations.user_count | organizations.user_count | organizations |
| organizations_groups__at | TEXT | organizations_groups.at | organizations_groups.at | organizations_groups |
| organizations_groups__group_id | NUMERIC | organizations_groups.group_id | organizations_groups.group_id | organizations_groups |
| organizations_groups__name | TEXT | organizations_groups.name | organizations_groups.name | organizations_groups |
| organizations_groups__users | OBJECT | organizations_groups.users | organizations_groups.users | organizations_groups |
| organizations_groups__workspaces | OBJECT | organizations_groups.workspaces | organizations_groups.workspaces | organizations_groups |
| organizations_users__admin | BOOLEAN | organizations_users.admin | organizations_users.admin | organizations_users |
| organizations_users__avatar_url | TEXT | organizations_users.avatar_url | organizations_users.avatar_url | organizations_users |
| organizations_users__can_edit_email | BOOLEAN | organizations_users.can_edit_email | organizations_users.can_edit_email | organizations_users |
| organizations_users__email | TEXT | organizations_users.email | organizations_users.email | organizations_users |
| organizations_users__groups | OBJECT | organizations_users.groups | organizations_users.groups | organizations_users |
| organizations_users__id | NUMERIC | organizations_users.id | organizations_users.id | organizations_users |
| organizations_users__inactive | BOOLEAN | organizations_users.inactive | organizations_users.inactive | organizations_users |
| organizations_users__invitation_code | TEXT | organizations_users.invitation_code | organizations_users.invitation_code | organizations_users |
| organizations_users__joined | BOOLEAN | organizations_users.joined | organizations_users.joined | organizations_users |
| organizations_users__name | TEXT | organizations_users.name | organizations_users.name | organizations_users |
| organizations_users__owner | BOOLEAN | organizations_users.owner | organizations_users.owner | organizations_users |
| organizations_users__user_id | NUMERIC | organizations_users.user_id | organizations_users.user_id | organizations_users |
| organizations_users__workspaces | OBJECT | organizations_users.workspaces | organizations_users.workspaces | organizations_users |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| time_entries__at | TEXT | time_entries.at | time_entries.at | time_entries |
| time_entries__billable | BOOLEAN | time_entries.billable | time_entries.billable | time_entries |
| time_entries__description | TEXT | time_entries.description | time_entries.description | time_entries |
| time_entries__duration | NUMERIC | time_entries.duration | time_entries.duration | time_entries |
| time_entries__duronly | BOOLEAN | time_entries.duronly | time_entries.duronly | time_entries |
| time_entries__id | NUMERIC | time_entries.id | time_entries.id | time_entries |
| time_entries__pid | NUMERIC | time_entries.pid | time_entries.pid | time_entries |
| time_entries__project_id | NUMERIC | time_entries.project_id | time_entries.project_id | time_entries |
| time_entries__server_deleted_at | TEXT | time_entries.server_deleted_at | time_entries.server_deleted_at | time_entries |
| time_entries__start | TEXT | time_entries.start | time_entries.start | time_entries |
| time_entries__stop | TEXT | time_entries.stop | time_entries.stop | time_entries |
| time_entries__tag_ids | OBJECT | time_entries.tag_ids | time_entries.tag_ids | time_entries |
| time_entries__tags | OBJECT | time_entries.tags | time_entries.tags | time_entries |
| time_entries__task_id | NUMERIC | time_entries.task_id | time_entries.task_id | time_entries |
| time_entries__tid | NUMERIC | time_entries.tid | time_entries.tid | time_entries |
| time_entries__uid | NUMERIC | time_entries.uid | time_entries.uid | time_entries |
| time_entries__user_id | NUMERIC | time_entries.user_id | time_entries.user_id | time_entries |
| time_entries__wid | NUMERIC | time_entries.wid | time_entries.wid | time_entries |
| time_entries__workspace_id | NUMERIC | time_entries.workspace_id | time_entries.workspace_id | time_entries |
| today | DATE | Today | Today's date | |
| workspace__admins | OBJECT | workspace.admins | workspace.admins | workspace |
| workspace__groups_count | NUMERIC | workspace.groups_count | workspace.groups_count | workspace |
| workspace__members_count | NUMERIC | workspace.members_count | workspace.members_count | workspace |
| workspace_clients__archived | BOOLEAN | workspace_clients.archived | workspace_clients.archived | workspace_clients |
| workspace_clients__at | TEXT | workspace_clients.at | workspace_clients.at | workspace_clients |
| workspace_clients__id | NUMERIC | workspace_clients.id | workspace_clients.id | workspace_clients |
| workspace_clients__name | TEXT | workspace_clients.name | workspace_clients.name | workspace_clients |
| workspace_clients__server_deleted_at | TEXT | workspace_clients.server_deleted_at | workspace_clients.server_deleted_at | workspace_clients |
| workspace_clients__wid | NUMERIC | workspace_clients.wid | workspace_clients.wid | workspace_clients |
| workspace_projects__active | BOOLEAN | workspace_projects.active | workspace_projects.active | workspace_projects |
| workspace_projects__actual_hours | NUMERIC | workspace_projects.actual_hours | workspace_projects.actual_hours | workspace_projects |
| workspace_projects__at | TEXT | workspace_projects.at | workspace_projects.at | workspace_projects |
| workspace_projects__auto_estimates | BOOLEAN | workspace_projects.auto_estimates | workspace_projects.auto_estimates | workspace_projects |
| workspace_projects__billable | BOOLEAN | workspace_projects.billable | workspace_projects.billable | workspace_projects |
| workspace_projects__cid | NUMERIC | workspace_projects.cid | workspace_projects.cid | workspace_projects |
| workspace_projects__client_id | NUMERIC | workspace_projects.client_id | workspace_projects.client_id | workspace_projects |
| workspace_projects__color | TEXT | workspace_projects.color | workspace_projects.color | workspace_projects |
| workspace_projects__created_at | TEXT | workspace_projects.created_at | workspace_projects.created_at | workspace_projects |
| workspace_projects__currency | TEXT | workspace_projects.currency | workspace_projects.currency | workspace_projects |
| workspace_projects__current_period | OBJECT | workspace_projects.current_period | workspace_projects.current_period | workspace_projects |
| workspace_projects__estimated_hours | NUMERIC | workspace_projects.estimated_hours | workspace_projects.estimated_hours | workspace_projects |
| workspace_projects__first_time_entry | TEXT | workspace_projects.first_time_entry | workspace_projects.first_time_entry | workspace_projects |
| workspace_projects__fixed_fee | NUMERIC | workspace_projects.fixed_fee | workspace_projects.fixed_fee | workspace_projects |
| workspace_projects__id | NUMERIC | workspace_projects.id | workspace_projects.id | workspace_projects |
| workspace_projects__is_private | BOOLEAN | workspace_projects.is_private | workspace_projects.is_private | workspace_projects |
| workspace_projects__name | TEXT | workspace_projects.name | workspace_projects.name | workspace_projects |
| workspace_projects__rate | NUMERIC | workspace_projects.rate | workspace_projects.rate | workspace_projects |
| workspace_projects__rate_last_updated | TEXT | workspace_projects.rate_last_updated | workspace_projects.rate_last_updated | workspace_projects |
| workspace_projects__recurring | BOOLEAN | workspace_projects.recurring | workspace_projects.recurring | workspace_projects |
| workspace_projects__recurring_parameters | OBJECT | workspace_projects.recurring_parameters | workspace_projects.recurring_parameters | workspace_projects |
| workspace_projects__server_deleted_at | TEXT | workspace_projects.server_deleted_at | workspace_projects.server_deleted_at | workspace_projects |
| workspace_projects__template | BOOLEAN | workspace_projects.template | workspace_projects.template | workspace_projects |
| workspace_projects__wid | NUMERIC | workspace_projects.wid | workspace_projects.wid | workspace_projects |
| workspace_projects__workspace_id | NUMERIC | workspace_projects.workspace_id | workspace_projects.workspace_id | workspace_projects |
| workspace_tasks__active | BOOLEAN | workspace_tasks.active | workspace_tasks.active | workspace_tasks |
| workspace_tasks__at | TEXT | workspace_tasks.at | workspace_tasks.at | workspace_tasks |
| workspace_tasks__estimated_seconds | NUMERIC | workspace_tasks.estimated_seconds | workspace_tasks.estimated_seconds | workspace_tasks |
| workspace_tasks__id | NUMERIC | workspace_tasks.id | workspace_tasks.id | workspace_tasks |
| workspace_tasks__name | TEXT | workspace_tasks.name | workspace_tasks.name | workspace_tasks |
| workspace_tasks__project_id | NUMERIC | workspace_tasks.project_id | workspace_tasks.project_id | workspace_tasks |
| workspace_tasks__recurring | BOOLEAN | workspace_tasks.recurring | workspace_tasks.recurring | workspace_tasks |
| workspace_tasks__server_deleted_at | TEXT | workspace_tasks.server_deleted_at | workspace_tasks.server_deleted_at | workspace_tasks |
| workspace_tasks__tracked_seconds | NUMERIC | workspace_tasks.tracked_seconds | workspace_tasks.tracked_seconds | workspace_tasks |
| workspace_tasks__user_id | NUMERIC | workspace_tasks.user_id | workspace_tasks.user_id | workspace_tasks |
| workspace_tasks__workspace_id | NUMERIC | workspace_tasks.workspace_id | workspace_tasks.workspace_id | workspace_tasks |