Toggl Connector Reference

14 metrics110 dimensions

Fields

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	TIMESTAMP	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
account_id	TEXT	Account ID	Account ID.
account_name	TEXT	Account Name	Account name.
data_fetched_at	TIMESTAMP	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	TIMESTAMP	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

API Connectors