Windsor brings all your Clockify data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Clockify Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| clients__address | TEXT | clients.address | clients.address | clients |
| clients__archived | BOOLEAN | clients.archived | clients.archived | clients |
| clients__email | TEXT | clients.email | clients.email | clients |
| clients__id | TEXT | clients.id | clients.id | clients |
| clients__name | TEXT | clients.name | clients.name | clients |
| clients__note | TEXT | clients.note | clients.note | clients |
| clients__workspaceId | TEXT | clients.workspaceId | clients.workspaceId | clients |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| projects__archived | BOOLEAN | projects.archived | projects.archived | projects |
| projects__billable | BOOLEAN | projects.billable | projects.billable | projects |
| projects__budgetEstimate | TEXT | projects.budgetEstimate | projects.budgetEstimate | projects |
| projects__clientId | TEXT | projects.clientId | projects.clientId | projects |
| projects__clientName | TEXT | projects.clientName | projects.clientName | projects |
| projects__color | TEXT | projects.color | projects.color | projects |
| projects__costRate | TEXT | projects.costRate | projects.costRate | projects |
| projects__duration | TEXT | projects.duration | projects.duration | projects |
| projects__estimate | OBJECT | projects.estimate | projects.estimate | projects |
| projects__hourlyRate | OBJECT | projects.hourlyRate | projects.hourlyRate | projects |
| projects__id | TEXT | projects.id | projects.id | projects |
| projects__memberships | OBJECT | projects.memberships | projects.memberships | projects |
| projects__name | TEXT | projects.name | projects.name | projects |
| projects__note | TEXT | projects.note | projects.note | projects |
| projects__public | BOOLEAN | projects.public | projects.public | projects |
| projects__template | BOOLEAN | projects.template | projects.template | projects |
| projects__timeEstimate | TIMESTAMP | projects.timeEstimate | projects.timeEstimate | projects |
| projects__workspaceId | TEXT | projects.workspaceId | projects.workspaceId | projects |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| tags__archived | BOOLEAN | tags.archived | tags.archived | tags |
| tags__id | TEXT | tags.id | tags.id | tags |
| tags__name | TEXT | tags.name | tags.name | tags |
| tags__workspaceId | TEXT | tags.workspaceId | tags.workspaceId | tags |
| tasks__assigneeId | TEXT | tasks.assigneeId | tasks.assigneeId | tasks |
| tasks__assigneeIds | OBJECT | tasks.assigneeIds | tasks.assigneeIds | tasks |
| tasks__billable | BOOLEAN | tasks.billable | tasks.billable | tasks |
| tasks__budgetEstimate | NUMERIC | tasks.budgetEstimate | tasks.budgetEstimate | tasks |
| tasks__costRate | TEXT | tasks.costRate | tasks.costRate | tasks |
| tasks__duration | TEXT | tasks.duration | tasks.duration | tasks |
| tasks__estimate | TEXT | tasks.estimate | tasks.estimate | tasks |
| tasks__hourlyRate | TEXT | tasks.hourlyRate | tasks.hourlyRate | tasks |
| tasks__id | TEXT | tasks.id | tasks.id | tasks |
| tasks__name | TEXT | tasks.name | tasks.name | tasks |
| tasks__projectId | TEXT | tasks.projectId | tasks.projectId | tasks |
| tasks__status | TEXT | tasks.status | tasks.status | tasks |
| tasks__userGroupIds | OBJECT | tasks.userGroupIds | tasks.userGroupIds | tasks |
| time_entries__billable | BOOLEAN | time_entries.billable | time_entries.billable | time_entries |
| time_entries__customFieldValues | OBJECT | time_entries.customFieldValues | time_entries.customFieldValues | time_entries |
| time_entries__description | TEXT | time_entries.description | time_entries.description | time_entries |
| time_entries__id | TEXT | time_entries.id | time_entries.id | time_entries |
| time_entries__isLocked | BOOLEAN | time_entries.isLocked | time_entries.isLocked | time_entries |
| time_entries__kioskId | TEXT | time_entries.kioskId | time_entries.kioskId | time_entries |
| time_entries__projectId | TEXT | time_entries.projectId | time_entries.projectId | time_entries |
| time_entries__tagIds | TEXT | time_entries.tagIds | time_entries.tagIds | time_entries |
| time_entries__taskId | TEXT | time_entries.taskId | time_entries.taskId | time_entries |
| time_entries__timeInterval | OBJECT | time_entries.timeInterval | time_entries.timeInterval | time_entries |
| time_entries__type | TEXT | time_entries.type | time_entries.type | time_entries |
| time_entries__userId | TEXT | time_entries.userId | time_entries.userId | time_entries |
| time_entries__workspaceId | TEXT | time_entries.workspaceId | time_entries.workspaceId | time_entries |
| today | DATE | Today | Today's date | |
| user_groups__id | TEXT | user_groups.id | user_groups.id | user_groups |
| user_groups__name | TEXT | user_groups.name | user_groups.name | user_groups |
| user_groups__userIds | OBJECT | user_groups.userIds | user_groups.userIds | user_groups |
| user_groups__workspaceId | TEXT | user_groups.workspaceId | user_groups.workspaceId | user_groups |
| users__activeWorkspace | TEXT | users.activeWorkspace | users.activeWorkspace | users |
| users__customFields | OBJECT | users.customFields | users.customFields | users |
| users__defaultWorkspace | TEXT | users.defaultWorkspace | users.defaultWorkspace | users |
| users__email | TEXT | users.email | users.email | users |
| users__id | TEXT | users.id | users.id | users |
| users__memberships | OBJECT | users.memberships | users.memberships | users |
| users__name | TEXT | users.name | users.name | users |
| users__profilePicture | TEXT | users.profilePicture | users.profilePicture | users |
| users__settings | OBJECT | users.settings | users.settings | users |
| users__status | TEXT | users.status | users.status | users |