Clockify Connector Reference

1 metrics73 dimensions

Fields

The Clockify connector exposes 74 fields (1 metrics, 73 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Clockify Fields

Clockify clients fields

The clients report of the Clockify connector includes 7 fields.

ID	Type	Name	Description
clients__address	TEXT	clients.address	clients.address
clients__archived	BOOLEAN	clients.archived	clients.archived
clients__email	TEXT	clients.email	clients.email
clients__id	TEXT	clients.id	clients.id
clients__name	TEXT	clients.name	clients.name
clients__note	TEXT	clients.note	clients.note
clients__workspaceId	TEXT	clients.workspaceId	clients.workspaceId

Clockify projects fields

The projects report of the Clockify connector includes 18 fields.

ID	Type	Name	Description
projects__archived	BOOLEAN	projects.archived	projects.archived
projects__billable	BOOLEAN	projects.billable	projects.billable
projects__budgetEstimate	TEXT	projects.budgetEstimate	projects.budgetEstimate
projects__clientId	TEXT	projects.clientId	projects.clientId
projects__clientName	TEXT	projects.clientName	projects.clientName
projects__color	TEXT	projects.color	projects.color
projects__costRate	TEXT	projects.costRate	projects.costRate
projects__duration	TEXT	projects.duration	projects.duration
projects__estimate	OBJECT	projects.estimate	projects.estimate
projects__hourlyRate	OBJECT	projects.hourlyRate	projects.hourlyRate
projects__id	TEXT	projects.id	projects.id
projects__memberships	OBJECT	projects.memberships	projects.memberships
projects__name	TEXT	projects.name	projects.name
projects__note	TEXT	projects.note	projects.note
projects__public	BOOLEAN	projects.public	projects.public
projects__template	BOOLEAN	projects.template	projects.template
projects__timeEstimate	TIMESTAMP	projects.timeEstimate	projects.timeEstimate
projects__workspaceId	TEXT	projects.workspaceId	projects.workspaceId

Clockify tags fields

The tags report of the Clockify connector includes 4 fields.

ID	Type	Name	Description
tags__archived	BOOLEAN	tags.archived	tags.archived
tags__id	TEXT	tags.id	tags.id
tags__name	TEXT	tags.name	tags.name
tags__workspaceId	TEXT	tags.workspaceId	tags.workspaceId

Clockify tasks fields

The tasks report of the Clockify connector includes 13 fields.

ID	Type	Name	Description
tasks__assigneeId	TEXT	tasks.assigneeId	tasks.assigneeId
tasks__assigneeIds	OBJECT	tasks.assigneeIds	tasks.assigneeIds
tasks__billable	BOOLEAN	tasks.billable	tasks.billable
tasks__budgetEstimate	NUMERIC	tasks.budgetEstimate	tasks.budgetEstimate
tasks__costRate	TEXT	tasks.costRate	tasks.costRate
tasks__duration	TEXT	tasks.duration	tasks.duration
tasks__estimate	TEXT	tasks.estimate	tasks.estimate
tasks__hourlyRate	TEXT	tasks.hourlyRate	tasks.hourlyRate
tasks__id	TEXT	tasks.id	tasks.id
tasks__name	TEXT	tasks.name	tasks.name
tasks__projectId	TEXT	tasks.projectId	tasks.projectId
tasks__status	TEXT	tasks.status	tasks.status
tasks__userGroupIds	OBJECT	tasks.userGroupIds	tasks.userGroupIds

Clockify time_entries fields

The time_entries report of the Clockify connector includes 13 fields.

ID	Type	Name	Description
time_entries__billable	BOOLEAN	time_entries.billable	time_entries.billable
time_entries__customFieldValues	OBJECT	time_entries.customFieldValues	time_entries.customFieldValues
time_entries__description	TEXT	time_entries.description	time_entries.description
time_entries__id	TEXT	time_entries.id	time_entries.id
time_entries__isLocked	BOOLEAN	time_entries.isLocked	time_entries.isLocked
time_entries__kioskId	TEXT	time_entries.kioskId	time_entries.kioskId
time_entries__projectId	TEXT	time_entries.projectId	time_entries.projectId
time_entries__tagIds	TEXT	time_entries.tagIds	time_entries.tagIds
time_entries__taskId	TEXT	time_entries.taskId	time_entries.taskId
time_entries__timeInterval	OBJECT	time_entries.timeInterval	time_entries.timeInterval
time_entries__type	TEXT	time_entries.type	time_entries.type
time_entries__userId	TEXT	time_entries.userId	time_entries.userId
time_entries__workspaceId	TEXT	time_entries.workspaceId	time_entries.workspaceId

Clockify user_groups fields

The user_groups report of the Clockify connector includes 4 fields.

ID	Type	Name	Description
user_groups__id	TEXT	user_groups.id	user_groups.id
user_groups__name	TEXT	user_groups.name	user_groups.name
user_groups__userIds	OBJECT	user_groups.userIds	user_groups.userIds
user_groups__workspaceId	TEXT	user_groups.workspaceId	user_groups.workspaceId

Clockify users fields

The users report of the Clockify connector includes 10 fields.

ID	Type	Name	Description
users__activeWorkspace	TEXT	users.activeWorkspace	users.activeWorkspace
users__customFields	OBJECT	users.customFields	users.customFields
users__defaultWorkspace	TEXT	users.defaultWorkspace	users.defaultWorkspace
users__email	TEXT	users.email	users.email
users__id	TEXT	users.id	users.id
users__memberships	OBJECT	users.memberships	users.memberships
users__name	TEXT	users.name	users.name
users__profilePicture	TEXT	users.profilePicture	users.profilePicture
users__settings	OBJECT	users.settings	users.settings
users__status	TEXT	users.status	users.status

Clockify other fields

The Clockify connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
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
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date

API Connectors