Clockify

Creating the data source

Adding the data source

By adding the Clockify data source to Kondado, you can access your data in your Data Warehouse or Data Lake – process also known as ETL or ELT

To add the Clockify data source, follow the steps below:

1) Log in to your Clockify account

Attention: The Clockify user used must have WORKSPACE_OWN or WORKSPACE_ADMIN permissions for the workspaces you want to replicate

2) Click on your profile picture in the left sidebar and then on “Profile settings”

3) In the API section you will find your API key (click on “Generate” if you don't have your API key yet). copy this value

4) Login to Kondado, go to the add data sources section and select the Clockify data source

5) On the data source data filling page, paste the value obtained in step (3) in “API key”

6) Now just name your data source and click SAVE

Pipelines

Relationship chart

Click to expand

Clients

Replication type: Full

Parameters:

Workspaces: Filter which workspaces will be replicated or leave it empty to replicate all

Relationships:

workspaceid → Workspaces > id

Clockify client: a company or person that projects can be linked to.

Campo	Tipo
id	text	[en] Unique identifier of the client.
archived	boolean	[en] Whether the client is archived.
workspaceid	text	[en] Identifier of the workspace the client belongs to. Workspaces > > id
address	text	[en] Address of the client.
name	text	[en] Name of the client.

Projects

Replication type: Full

Parameters:

Workspaces: Filter which workspaces will be replicated or leave it empty to replicate all

Relationships:

clientid → Clients > id
workspaceid → Workspaces > id

Clockify project: a body of work that time entries are logged against, usually linked to a client and carrying its own rates and estimates.

Campo	Tipo
id	text	[en] Unique identifier of the project.
archived	boolean	[en] Whether the project is archived.
name	text	[en] Name of the project.
color	text	[en] Color associated with the project, in hex.
billable	boolean	[en] Whether time logged on the project is billable by default.
clientid	text	[en] Identifier of the client linked to the project. Clients > > id
timeestimate__active	boolean	[en] Whether the project time estimate is active.
timeestimate__estimate	text	[en] Project time estimate in ISO 8601 duration format (e.g. PT0S).
timeestimate__type	text	[en] Type of the time estimate (e.g. AUTO or MANUAL).
timeestimate__resetoption	text	[en] Reset option for the time estimate (e.g. per period); null when no reset applies.
note	text	[en] Notes for the project.
public	boolean	[en] Whether the project is public in the workspace.
workspaceid	text	[en] Identifier of the workspace the project belongs to. Workspaces > > id
template	boolean	[en] Whether the project is a template.
hourlyrate__currency	text	[en] Currency of the project hourly rate.
hourlyrate__amount	float	[en] Amount of the project hourly rate.
duration	text	[en] Total time already logged on the project, in ISO 8601 duration format.
estimate__estimate	text	[en] Overall project estimate in ISO 8601 duration format.
estimate__type	text	[en] Type of the overall project estimate (e.g. AUTO or MANUAL).
clientname	text	[en] Name of the client linked to the project.
costrate__currency	text	[en] Currency of the project cost rate.
costrate__amount	float	[en] Amount of the project cost rate (cost per hour).

Campo	Tipo
id	text	[en] Unique identifier of the tag.
archived	boolean	[en] Whether the tag is archived.
workspaceid	text	[en] Identifier of the workspace the tag belongs to. Workspaces > > id
name	text	[en] Name of the tag.

Tasks

Replication type: Full

Parameters:

Workspaces: Filter which workspaces will be replicated or leave it empty to replicate all

Relationships:

assigneeid → Users > id
projectid → Projects > id
assignee_user_id > assignees → Users > id

Main object

Clockify task: a subdivision of a project that time can be assigned to.

Campo	Tipo
id	text	[en] Unique identifier of the task.
status	text	[en] Status of the task (e.g. ACTIVE, DONE).
name	text	[en] Name of the task.
assigneeid	text	[en] Identifier of the user set as primary assignee of the task. Users > > id
projectid	text	[en] Identifier of the project the task belongs to. Projects > > id
estimate	text	[en] Task time estimate in ISO 8601 duration format.
duration	text	[en] Total time logged on the task, in ISO 8601 duration format.

clockify_tasks__assignees

Task assignees: the users assigned to a Clockify task (task-to-user relation).

Campo	Tipo
task_id	text	[en] Identifier of the task the assignee is assigned to.
assignee_user_id	text	[en] Identifier of the user assigned to the task. Users > > id

Campo

Tipo

task_id

text

[en] Identifier of the task the assignee is assigned to.

assignee_user_id

text

[en] Identifier of the user assigned to the task.

Users > > id

Time entries

This pipeline does not capture deletions. If a record is deleted in the tool, it will remain in your destination until the table undergoes an advanced edit. That is why we provide a Full version, which always reads all the data.

Replication type: Incremental with update window

Parameters:

Update window (days): How many days previous to the savepoint the same period will still be refreshed
Workspaces: Filter which workspaces will be replicated or leave it empty to replicate all
Read start date (Savepoint): Data replication initial date

Relationships:

workspaceid → Workspaces > id
projectid → Projects > id
userid → Users > id
tag_id > tags → Tags > id

Main object

Clockify time entry: a logged block of worked time, with start, end and duration, linked to a user, a project and optionally a task.

Campo	Tipo
id	text	[en] Unique identifier of the time entry.
timeinterval__duration	text	[en] Duration of the time entry in ISO 8601 duration format (e.g. PT25M).
timeinterval_start	timestamp	[en] Start date and time of the time entry.
timeinterval_end	timestamp	[en] End date and time of the time entry.
islocked	boolean	[en] Whether the time entry is locked for editing.
workspaceid	text	[en] Identifier of the workspace the entry belongs to. Workspaces > > id
description	text	[en] Description of the work logged in the time entry.
taskid	text	[en] Identifier of the task associated with the time entry, if any.
billable	boolean	[en] Whether the time entry is billable.
projectid	text	[en] Identifier of the project associated with the time entry. Projects > > id
userid	text	[en] Identifier of the user who logged the time. Users > > id

clockify_timeentries__tags

Time-entry tags: the relation between a time entry and the tags applied to it.

Campo	Tipo
timeentry_id	text	[en] Identifier of the time entry the tag is associated with.
tag_id	text	[en] Identifier of the tag applied to the time entry. Tags > > id

Campo

Tipo

timeentry_id

text

[en] Identifier of the time entry the tag is associated with.

tag_id

text

[en] Identifier of the tag applied to the time entry.

Tags > > id

Time entries [Integral]

Replication type: Full

Parameters:

Workspaces: Filter which workspaces will be replicated or leave it empty to replicate all

Relationships:

workspaceid → Workspaces > id
projectid → Projects > id
userid → Users > id
tag_id > tags → Tags > id

Main object

Clockify time entry: a logged block of worked time, with start, end and duration, linked to a user, a project and optionally a task.

Campo	Tipo
id	text	[en] Unique identifier of the time entry.
timeinterval__duration	text	[en] Duration of the time entry in ISO 8601 duration format (e.g. PT25M).
timeinterval_start	timestamp	[en] Start date and time of the time entry.
timeinterval_end	timestamp	[en] End date and time of the time entry.
islocked	boolean	[en] Whether the time entry is locked for editing.
workspaceid	text	[en] Identifier of the workspace the entry belongs to. Workspaces > > id
description	text	[en] Description of the work logged in the time entry.
taskid	text	[en] Identifier of the task associated with the time entry, if any.
billable	boolean	[en] Whether the time entry is billable.
projectid	text	[en] Identifier of the project associated with the time entry. Projects > > id
userid	text	[en] Identifier of the user who logged the time. Users > > id

clockify_timeentries__tags

Time-entry tags: the relation between a time entry and the tags applied to it.

Campo	Tipo
timeentry_id	text	[en] Identifier of the time entry the tag is associated with.
tag_id	text	[en] Identifier of the tag applied to the time entry. Tags > > id

Campo

Tipo

timeentry_id

text

[en] Identifier of the time entry the tag is associated with.

tag_id

text

[en] Identifier of the tag applied to the time entry.

Tags > > id

User groups

Replication type: Full

Parameters:

Workspaces: Filter which workspaces will be replicated or leave it empty to replicate all

Relationships:

workspaceid → Workspaces > id

Clockify user group: a grouping of users within a workspace, used to organize teams and permissions.

Campo	Tipo
id	text	[en] Unique identifier of the user group.
workspaceid	text	[en] Identifier of the workspace the group belongs to. Workspaces > > id
name	text	[en] Name of the user group.

Campo

Tipo

text

[en] Unique identifier of the user group.

workspaceid

text

[en] Identifier of the workspace the group belongs to.

Workspaces > > id

name

text

[en] Name of the user group.

Users

Replication type: Full

Parameters:

Workspaces: Filter which workspaces will be replicated or leave it empty to replicate all

Main object

Clockify user: a person who is a member of the workspace, with their personal preferences and settings.

Campo	Tipo
id	text	[en] Unique identifier of the user.
status	text	[en] Status of the user in the workspace (e.g. ACTIVE, INACTIVE).
profilepicture	text	[en] URL of the user profile picture.
name	text	[en] Name of the user.
activeworkspace	text	[en] Identifier of the workspace currently active for the user.
settings__timetrackingmanual	boolean	[en] Whether the user logs time manually instead of using the timer.
settings__groupsimilarentriesdisabled	boolean	[en] Whether grouping of similar time entries is disabled for the user.
settings__dashboardviewtype	text	[en] Default dashboard view type for the user (e.g. PROJECT, TEAM).
settings__dateformat	text	[en] User preferred date format (e.g. MM/DD/YYYY).
settings__weekstart	text	[en] Day the week starts for the user (e.g. MONDAY).
settings__iscompactviewon	boolean	[en] Whether compact view is enabled for the user.
settings__longrunning	boolean	[en] Whether the user is alerted about long-running time entries.
summaryreportsettingsgroup	text	[en] Primary grouping criterion for the user summary reports.
summaryreportsettingssubgroup	text	[en] Secondary grouping criterion for the user summary reports.
settings__dashboardpintotop	boolean	[en] Whether the dashboard is pinned to the top for the user.
settings__weeklyupdates	boolean	[en] Whether the user receives weekly email updates.
settings__sendnewsletter	boolean	[en] Whether the user is subscribed to the newsletter.
settings__mystartofday	text	[en] Start-of-day time configured by the user (e.g. 09:00).
settings__timeformat	text	[en] User preferred time format (e.g. HOUR12, HOUR24).
settings__timezone	text	[en] User time zone (e.g. America/Sao_Paulo).
settings__dashboardselection	text	[en] Data scope shown on the dashboard (e.g. ME for the user, TEAM for the team).
settings__projectlistcollapse	float	[en] Number of projects beyond which the project list is collapsed.
settings__collapseallprojectlists	boolean	[en] Whether all project lists are collapsed by default.
defaultworkspace	text	[en] Identifier of the user default workspace.
email	text	[en] Email of the user.

clockify_users_memberships

User memberships: the user associations to workspaces, projects or groups, with their status, type and rates.

Campo	Tipo
user_id	text	[en] Identifier of the user the membership belongs to.
costrate	text	[en] Cost rate associated with the user membership.
targetid	text	[en] Identifier of the membership target (workspace, project or group).
membershipstatus	text	[en] Status of the membership (e.g. ACTIVE, PENDING).
membershiptype	text	[en] Type of the membership, indicating the target (e.g. WORKSPACE, PROJECT).
hourlyrate_amount	float	[en] Amount of the hourly rate associated with the membership.
hourlyrate_currency	text	[en] Currency of the hourly rate associated with the membership.

Workspaces

Replication type: Full

Clockify workspace: the top-level container that groups projects, clients, users, tags and time entries, with its own time-tracking settings and permissions.

Campo	Tipo
id	text	[en] Unique identifier of the workspace.
canseetimesheet	boolean	[en] Whether the timesheet view is enabled in the workspace.
automaticlock__firstday	text	[en] Day of the week on which the automatic time-entry lock period starts (e.g. MONDAY).
automaticlock__olderthanvalue	float	[en] Number of periods used by the rule that automatically locks entries older than this value.
automaticlock__changeday	text	[en] Day of the week on which the automatic lock takes effect for weekly locking.
automaticlock__olderthanperiod	text	[en] Time unit of the age-based lock rule (e.g. DAYS, WEEKS).
automaticlock__type	text	[en] Type of automatic time-entry lock (e.g. WEEKLY, MONTHLY, OLDER_THAN).
automaticlock__dayofmonth	float	[en] Day of the month on which the automatic lock occurs for monthly locking.
isprojectpublicbydefault	boolean	[en] Whether new projects are public by default.
projectfavorites	boolean	[en] Whether the project favorites feature is enabled.
onlyadminscreatetag	boolean	[en] Whether only admins can create tags in the workspace.
forcetags	boolean	[en] Whether adding at least one tag is required when logging time.
onlyadminscreateproject	boolean	[en] Whether only admins can create projects.
tracktimedowntosecond	boolean	[en] Whether time tracking is recorded down to the second.
timeroundinginreports	boolean	[en] Whether time rounding is applied in reports.
hourlyrate__currency	text	[en] Currency of the workspace default hourly rate (e.g. BRL, USD).
hourlyrate__amount	float	[en] Amount of the workspace default hourly rate.
timetrackingmode	text	[en] Workspace time-tracking mode (e.g. DEFAULT, STOPWATCH_ONLY).
onlyadminsseebillablerates	boolean	[en] Whether only admins can see billable rates.
onlyadminsseepublicprojectsentries	boolean	[en] Whether only admins can see time entries on public projects.
onlyadminscreatetask	boolean	[en] Whether only admins can create tasks.
projectpickerspecialfilter	boolean	[en] Whether the project picker uses a special filter (e.g. filter by client).
forceprojects	boolean	[en] Whether selecting a project is required when logging time.
canseetracker	boolean	[en] Whether users can see the time tracker.
projectgroupinglabel	text	[en] Label used to group projects in the workspace (e.g. client).
forcetasks	boolean	[en] Whether selecting a task is required when logging time.
forcedescription	boolean	[en] Whether entering a description is required when logging time.
defaultbillableprojects	boolean	[en] Whether new projects are billable by default.
name	text	[en] Name of the workspace.
imageurl	text	[en] URL of the workspace image or logo.
locktimeentries	timestamp	[en] Date up to which time entries are locked for editing.
onlyadminsseealltimeentries	boolean	[en] Whether only admins can see all users time entries.
onlyadminsseedashboard	boolean	[en] Whether only admins can see the dashboard.
round__minutes	float	[en] Interval in minutes used to round time-entry duration.
round__round	text	[en] Rounding direction for duration (e.g. round up, down or to nearest).
featuresubscriptiontype	text	[en] Subscription or plan tier that determines the features available in the workspace (e.g. FREE, PREMIUM).

Notes

Part of this documentation was automatically generated by AI and may contain errors. We recommend verifying critical information

Add Clockify as a data source on Kondado

Connect your Clockify time-tracking data to Kondado for ETL/ELT into your data warehouse or lake.

Verify Clockify permissions

Log in to Clockify with a user that has WORKSPACE_OWN or WORKSPACE_ADMIN permissions for the workspaces you want to replicate.

Generate your Clockify API key

Click your profile picture in the left sidebar, go to "Profile settings", then find or generate your API key in the API section and copy it.

Add Clockify on Kondado

Configure and save the connection

Paste your API key into the "API key" field, name your data source, and click SAVE to complete the setup.

Choose your destination and start syncing

Send your Clockify data to a destination like a data warehouse or BI tool. Note: this pipeline does not capture deletions unless you use the integral version.

Frequently asked questions

What permissions does my Clockify user need for Kondado integration?▼

The Clockify user must have WORKSPACE_OWN or WORKSPACE_ADMIN permissions for the workspaces you want to replicate. Without these permissions, Kondado cannot access the workspace data.

Where do I find my Clockify API key?▼

In your Clockify account, click your profile picture in the left sidebar, select "Profile settings", and look in the API section. If you don't have an API key yet, click "Generate" to create one.

Does the Clockify pipeline capture deleted records?▼

No, this pipeline does not capture deletions. If a record is deleted in Clockify, it will remain at the destination until the table undergoes advanced editing. Kondado provides an integral version that always reads all data if you need full synchronization.

What Clockify data entities are available through Kondado?▼

The pipeline includes Workspaces, Projects, Clients, Users (with memberships), User Groups, Tags, and Time Entries (with tags). Each entity has documented fields and data types as shown in the relationship chart.

Can I send Clockify data to BI tools or spreadsheets?▼

Yes, after adding the Clockify source, you can route data to various destinations. Explore data-to-dashboards options or connect to BI tools and spreadsheets for reporting and analysis.

Written by

Thassyo Pereira·Published 2023-07-18·Updated 2026-06-01