Clockify

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

Gráfico de relacionamento entre tabelas

Field	Type
id	text
canseetimesheet	boolean
automaticlock__firstday	text
automaticlock__olderthanvalue	float
automaticlock__changeday	text
automaticlock__olderthanperiod	text
automaticlock__type	text
automaticlock__dayofmonth	float
isprojectpublicbydefault	boolean
projectfavorites	boolean
onlyadminscreatetag	boolean
forcetags	boolean
onlyadminscreateproject	boolean
tracktimedowntosecond	boolean
timeroundinginreports	boolean
hourlyrate__currency	text
hourlyrate__amount	float
timetrackingmode	text
onlyadminsseebillablerates	boolean
onlyadminsseepublicprojectsentries	boolean
onlyadminscreatetask	boolean
projectpickerspecialfilter	boolean
forceprojects	boolean
canseetracker	boolean
projectgroupinglabel	text
forcetasks	boolean
forcedescription	boolean
defaultbillableprojects	boolean
name	text
imageurl	text
locktimeentries	timestamp
onlyadminsseealltimeentries	boolean
onlyadminsseedashboard	boolean
round__minutes	float
round__round	text
featuresubscriptiontype	text

Main Object

Field	Type
id	text
status	text
profilepicture	text
name	text
activeworkspace	text
settings__timetrackingmanual	boolean
settings__groupsimilarentriesdisabled	boolean
settings__dashboardviewtype	text
settings__dateformat	text
settings__weekstart	text
settings__iscompactviewon	boolean
settings__longrunning	boolean
summaryreportsettingsgroup	text
summaryreportsettingssubgroup	text
settings__dashboardpintotop	boolean
settings__weeklyupdates	boolean
settings__sendnewsletter	boolean
settings__mystartofday	text
settings__timeformat	text
settings__timezone	text
settings__dashboardselection	text
settings__projectlistcollapse	float
settings__collapseallprojectlists	boolean
defaultworkspace	text
email	text

memberships

Main Object