Everhour Connector Reference

The Everhour connector exposes 86 fields (14 metrics, 72 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Everhour Fields

Everhour clients fields

The clients report of the Everhour connector includes 13 fields.

ID	Type	Name	Description
clients__businessDetails	TEXT	clients.businessDetails	clients.businessDetails
clients__createdAt	TEXT	clients.createdAt	clients.createdAt
clients__enableResourcePlanner	BOOLEAN	clients.enableResourcePlanner	clients.enableResourcePlanner
clients__excludedLabels	OBJECT	clients.excludedLabels	clients.excludedLabels
clients__favorite	BOOLEAN	clients.favorite	clients.favorite
clients__id	NUMERIC	clients.id	clients.id
clients__invoicePublicNotes	TEXT	clients.invoicePublicNotes	clients.invoicePublicNotes
clients__lineItemMask	TEXT	clients.lineItemMask	clients.lineItemMask
clients__name	TEXT	clients.name	clients.name
clients__paymentDueDays	NUMERIC	clients.paymentDueDays	clients.paymentDueDays
clients__projects	OBJECT	clients.projects	clients.projects
clients__reference	TEXT	clients.reference	clients.reference
clients__status	TEXT	clients.status	clients.status

Everhour projects fields

The projects report of the Everhour connector includes 17 fields.

ID	Type	Name	Description
projects__canSyncTasks	BOOLEAN	projects.canSyncTasks	projects.canSyncTasks
projects__connectionStatus	TEXT	projects.connectionStatus	projects.connectionStatus
projects__createdAt	TEXT	projects.createdAt	projects.createdAt
projects__estimatesType	TEXT	projects.estimatesType	projects.estimatesType
projects__favorite	BOOLEAN	projects.favorite	projects.favorite
projects__foreign	BOOLEAN	projects.foreign	projects.foreign
projects__hasWebhook	BOOLEAN	projects.hasWebhook	projects.hasWebhook
projects__id	TEXT	projects.id	projects.id
projects__isTemplate	BOOLEAN	projects.isTemplate	projects.isTemplate
projects__name	TEXT	projects.name	projects.name
projects__platform	TEXT	projects.platform	projects.platform
projects__privacy	TEXT	projects.privacy	projects.privacy
projects__status	TEXT	projects.status	projects.status
projects__unarchiveDisabledBy	TEXT	projects.unarchiveDisabledBy	projects.unarchiveDisabledBy
projects__users	OBJECT	projects.users	projects.users
projects__workspaceId	TEXT	projects.workspaceId	projects.workspaceId
projects__workspaceName	TEXT	projects.workspaceName	projects.workspaceName

Everhour tasks fields

The tasks report of the Everhour connector includes 14 fields.

ID	Type	Name	Description
tasks__assignees	OBJECT	tasks.assignees	tasks.assignees
tasks__completed	BOOLEAN	tasks.completed	tasks.completed
tasks__completedAt	TEXT	tasks.completedAt	tasks.completedAt
tasks__createdAt	TEXT	tasks.createdAt	tasks.createdAt
tasks__dueOn	TEXT	tasks.dueOn	tasks.dueOn
tasks__id	TEXT	tasks.id	tasks.id
tasks__iteration	TEXT	tasks.iteration	tasks.iteration
tasks__labels	OBJECT	tasks.labels	tasks.labels
tasks__name	TEXT	tasks.name	tasks.name
tasks__projects	OBJECT	tasks.projects	tasks.projects
tasks__status	TEXT	tasks.status	tasks.status
tasks__time	OBJECT	tasks.time	tasks.time
tasks__type	TEXT	tasks.type	tasks.type
tasks__url	TEXT	tasks.url	tasks.url

Everhour time fields

The time report of the Everhour connector includes 11 fields.

ID	Type	Name	Description
time__cost	NUMERIC	time.cost	time.cost
time__costRate	NUMERIC	time.costRate	time.costRate
time__createdAt	TEXT	time.createdAt	time.createdAt
time__date	TEXT	time.date	time.date
time__history	OBJECT	time.history	time.history
time__id	NUMERIC	time.id	time.id
time__isLocked	BOOLEAN	time.isLocked	time.isLocked
time__lockReasons	OBJECT	time.lockReasons	time.lockReasons
time__task	OBJECT	time.task	time.task
time__time	NUMERIC	time.time	time.time
time__user	NUMERIC	time.user	time.user

Everhour time_records fields

The time_records report of the Everhour connector includes 6 fields.

ID	Type	Name	Description
time_records__createdAt	TEXT	time_records.createdAt	time_records.createdAt
time_records__date	TEXT	time_records.date	time_records.date
time_records__id	NUMERIC	time_records.id	time_records.id
time_records__task	OBJECT	time_records.task	time_records.task
time_records__time	NUMERIC	time_records.time	time_records.time
time_records__user	NUMERIC	time_records.user	time_records.user

Everhour users fields

The users report of the Everhour connector includes 20 fields.

ID	Type	Name	Description
users__avatarUrl	TEXT	users.avatarUrl	users.avatarUrl
users__avatarUrlLarge	TEXT	users.avatarUrlLarge	users.avatarUrlLarge
users__budget	OBJECT	users.budget	users.budget
users__capacity	NUMERIC	users.capacity	users.capacity
users__cost	NUMERIC	users.cost	users.cost
users__costHistory	OBJECT	users.costHistory	users.costHistory
users__createdAt	TEXT	users.createdAt	users.createdAt
users__email	TEXT	users.email	users.email
users__enableResourcePlanner	BOOLEAN	users.enableResourcePlanner	users.enableResourcePlanner
users__groups	OBJECT	users.groups	users.groups
users__headline	TEXT	users.headline	users.headline
users__id	NUMERIC	users.id	users.id
users__isEmailVerified	BOOLEAN	users.isEmailVerified	users.isEmailVerified
users__name	TEXT	users.name	users.name
users__rate	NUMERIC	users.rate	users.rate
users__resourcePlannerAccess	OBJECT	users.resourcePlannerAccess	users.resourcePlannerAccess
users__role	TEXT	users.role	users.role
users__status	TEXT	users.status	users.status
users__timeTrackingPolicy	OBJECT	users.timeTrackingPolicy	users.timeTrackingPolicy
users__type	TEXT	users.type	users.type

Everhour other fields

The Everhour 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	Report
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