Windsor brings all your Everhour data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Everhour Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| clients__businessDetails | TEXT | clients.businessDetails | clients.businessDetails | clients |
| clients__createdAt | TEXT | clients.createdAt | clients.createdAt | clients |
| clients__enableResourcePlanner | BOOLEAN | clients.enableResourcePlanner | clients.enableResourcePlanner | clients |
| clients__excludedLabels | OBJECT | clients.excludedLabels | clients.excludedLabels | clients |
| clients__favorite | BOOLEAN | clients.favorite | clients.favorite | clients |
| clients__id | NUMERIC | clients.id | clients.id | clients |
| clients__invoicePublicNotes | TEXT | clients.invoicePublicNotes | clients.invoicePublicNotes | clients |
| clients__lineItemMask | TEXT | clients.lineItemMask | clients.lineItemMask | clients |
| clients__name | TEXT | clients.name | clients.name | clients |
| clients__paymentDueDays | NUMERIC | clients.paymentDueDays | clients.paymentDueDays | clients |
| clients__projects | OBJECT | clients.projects | clients.projects | clients |
| clients__reference | TEXT | clients.reference | clients.reference | clients |
| clients__status | TEXT | clients.status | clients.status | clients |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| projects__canSyncTasks | BOOLEAN | projects.canSyncTasks | projects.canSyncTasks | projects |
| projects__connectionStatus | TEXT | projects.connectionStatus | projects.connectionStatus | projects |
| projects__createdAt | TEXT | projects.createdAt | projects.createdAt | projects |
| projects__estimatesType | TEXT | projects.estimatesType | projects.estimatesType | projects |
| projects__favorite | BOOLEAN | projects.favorite | projects.favorite | projects |
| projects__foreign | BOOLEAN | projects.foreign | projects.foreign | projects |
| projects__hasWebhook | BOOLEAN | projects.hasWebhook | projects.hasWebhook | projects |
| projects__id | TEXT | projects.id | projects.id | projects |
| projects__isTemplate | BOOLEAN | projects.isTemplate | projects.isTemplate | projects |
| projects__name | TEXT | projects.name | projects.name | projects |
| projects__platform | TEXT | projects.platform | projects.platform | projects |
| projects__privacy | TEXT | projects.privacy | projects.privacy | projects |
| projects__status | TEXT | projects.status | projects.status | projects |
| projects__unarchiveDisabledBy | TEXT | projects.unarchiveDisabledBy | projects.unarchiveDisabledBy | projects |
| projects__users | OBJECT | projects.users | projects.users | projects |
| projects__workspaceId | TEXT | projects.workspaceId | projects.workspaceId | projects |
| projects__workspaceName | TEXT | projects.workspaceName | projects.workspaceName | projects |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| tasks__assignees | OBJECT | tasks.assignees | tasks.assignees | tasks |
| tasks__completed | BOOLEAN | tasks.completed | tasks.completed | tasks |
| tasks__completedAt | TEXT | tasks.completedAt | tasks.completedAt | tasks |
| tasks__createdAt | TEXT | tasks.createdAt | tasks.createdAt | tasks |
| tasks__dueOn | TEXT | tasks.dueOn | tasks.dueOn | tasks |
| tasks__id | TEXT | tasks.id | tasks.id | tasks |
| tasks__iteration | TEXT | tasks.iteration | tasks.iteration | tasks |
| tasks__labels | OBJECT | tasks.labels | tasks.labels | tasks |
| tasks__name | TEXT | tasks.name | tasks.name | tasks |
| tasks__projects | OBJECT | tasks.projects | tasks.projects | tasks |
| tasks__status | TEXT | tasks.status | tasks.status | tasks |
| tasks__time | OBJECT | tasks.time | tasks.time | tasks |
| tasks__type | TEXT | tasks.type | tasks.type | tasks |
| tasks__url | TEXT | tasks.url | tasks.url | tasks |
| time__cost | NUMERIC | time.cost | time.cost | time |
| time__costRate | NUMERIC | time.costRate | time.costRate | time |
| time__createdAt | TEXT | time.createdAt | time.createdAt | time |
| time__date | TEXT | time.date | time.date | time |
| time__history | OBJECT | time.history | time.history | time |
| time__id | NUMERIC | time.id | time.id | time |
| time__isLocked | BOOLEAN | time.isLocked | time.isLocked | time |
| time__lockReasons | OBJECT | time.lockReasons | time.lockReasons | time |
| time__task | OBJECT | time.task | time.task | time |
| time__time | NUMERIC | time.time | time.time | time |
| time__user | NUMERIC | time.user | time.user | time |
| time_records__createdAt | TEXT | time_records.createdAt | time_records.createdAt | time_records |
| time_records__date | TEXT | time_records.date | time_records.date | time_records |
| time_records__id | NUMERIC | time_records.id | time_records.id | time_records |
| time_records__task | OBJECT | time_records.task | time_records.task | time_records |
| time_records__time | NUMERIC | time_records.time | time_records.time | time_records |
| time_records__user | NUMERIC | time_records.user | time_records.user | time_records |
| today | DATE | Today | Today's date | |
| users__avatarUrl | TEXT | users.avatarUrl | users.avatarUrl | users |
| users__avatarUrlLarge | TEXT | users.avatarUrlLarge | users.avatarUrlLarge | users |
| users__budget | OBJECT | users.budget | users.budget | users |
| users__capacity | NUMERIC | users.capacity | users.capacity | users |
| users__cost | NUMERIC | users.cost | users.cost | users |
| users__costHistory | OBJECT | users.costHistory | users.costHistory | users |
| users__createdAt | TEXT | users.createdAt | users.createdAt | users |
| users__email | TEXT | users.email | users.email | users |
| users__enableResourcePlanner | BOOLEAN | users.enableResourcePlanner | users.enableResourcePlanner | users |
| users__groups | OBJECT | users.groups | users.groups | users |
| users__headline | TEXT | users.headline | users.headline | users |
| users__id | NUMERIC | users.id | users.id | users |
| users__isEmailVerified | BOOLEAN | users.isEmailVerified | users.isEmailVerified | users |
| users__name | TEXT | users.name | users.name | users |
| users__rate | NUMERIC | users.rate | users.rate | users |
| users__resourcePlannerAccess | OBJECT | users.resourcePlannerAccess | users.resourcePlannerAccess | users |
| users__role | TEXT | users.role | users.role | users |
| users__status | TEXT | users.status | users.status | users |
| users__timeTrackingPolicy | OBJECT | users.timeTrackingPolicy | users.timeTrackingPolicy | users |
| users__type | TEXT | users.type | users.type | users |