Time Doctor

Time Doctor ETL connector for data replication

Snapshot
Features
Details
Release Status
Beta version released
Source API Version
1.0
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
Time Doctor User email
Time Doctor Password
Replication Type
Full Replication
Replication Key
NA
Suggested Replication Frequency
1 hour
Tables/APIs supported
Breaks
Categories
Companies
Files
Notifications
Payroll
Projects
Tags
Tasks
Users
Integrate Time Doctor with Daton
1.Sign in to Daton 
2.Select Time Doctor V2 from the list of Integrations 
3.Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later 
4.Provide your Time Doctor user email and password
5.Post successful authentication, you will be prompted to choose from the list of available tables
6.Then select all required fields for each table
7.Submit the integration
Workflow
1.Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
2.Users would be able to edit/pause/re-activate/delete integration anytime
3.Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Time Doctor Data
Breaks
Purpose: This API is used to fetch all the breaks
Source API Documentation: https://api2.timedoctor.com/#/Breaks/getBreaks​
Replication: Full Replication
Replication Key: NA
Fields
Name
Data Type
_id
STRING
name
STRING
type
STRING
active
BOOLEAN
public
BOOLEAN
access
STRING
scope
STRING
Categories
Purpose: This API is used to fetch all the used categories in the company
Source API Documentation: https://api2.timedoctor.com/#/Categories/categories​
Replication: Full Replication
Replication Key: NA
Fields
Name
Data Type
scope
STRING
id
STRING
entity
STRING
name
STRING
score
NUMERIC
Companies
Purpose: This API is used to fetch all the companies in the account
Source API Documentation: https://api2.timedoctor.com/#/Companies/companies​
Replication: Full Replication
Replication Key: NA
Fields
Name
Data Type
role
STRING
hiredAt
STRING
lastSeen
RECORD
tagIds
STRING
onlyProjectIds
STRING
name
STRING
company
RECORD
custom
RECORD
isSilent
BOOLEAN
isInteractive
BOOLEAN
allowManual
BOOLEAN
Files
Purpose: This API is used to fetch all the files uploaded in the company
Source API Documentation: https://api2.timedoctor.com/#/Files/getFiles​
Replication: Full Replication
Replication Key: NA
Fields
Name
Data Type
userId
STRING
date
TIMESTAMP
deviceId
STRING
numbers
RECORD
Notifications
Purpose: This API is used to fetch all the notifications
Source API Documentation: https://api2.timedoctor.com/#/Notifications/getUserNotifications​
Replication: Full Replication
Replication Key: NA
Fields
Name
Data Type
_id
STRING
name
STRING
notifyType
STRING
condType
STRING
condValue
STRING
scope
STRING
dataIds
STRING
daysApplicable
STRING
Payroll
Purpose: This API is used to fetch payroll of all employees
Source API Documentation: https://api2.timedoctor.com/#/Payroll/payrolls​
Replication: Full Replication
Replication Key: NA
Fields
Name
Data Type
id
STRING
name
STRING
email
STRING
role
STRING
currency
STRING
adjustment
NUMERIC
payRate
NUMERIC
payMethod
STRING
payIdentifier
STRING
hourlyLimit
NUMERIC
hourlyLimitRange
STRING
Projects
Purpose: This API is used to fetch all the projects in the company
Source API Documentation: https://api2.timedoctor.com/#/Projects/projects​
Replication: Full Replication
Replication Key: NA
Fields
Name
Data Type
id
STRING
integration
RECORD
name
STRING
description
STRING
deleted
BOOLEAN
weight
NUMERIC
Tags
Purpose: This API is used to fetch all the tags 
Source API Documentation: https://api2.timedoctor.com/#/Groups%20(Tags)/tags​
Replication: Full Replication
Replication Key: NA
Fields
Name
Data Type
special
STRING
users
NUMERIC
usersOnReports
NUMERIC
selfUser
NUMERIC
managedUsers
NUMERIC
managedUsersOnReports
NUMERIC
id
STRING
name
STRING
creatorId
STRING
deleted
BOOLEAN
readOnly
BOOLEAN
managers
STRING
createdAt
TIMESTAMP
modifiedAt
TIMESTAMP
Tasks
Purpose: This API is used to fetch all the tasks in the company 
Source API Documentation: https://api2.timedoctor.com/#/Tasks/tasks​
Replication: Full Replication
Replication Key: NA
Fields
Name
Data Type
id
STRING
status
STRING
reporterId
STRING
deleted
BOOLEAN
deletedAt
STRING
project
RECORD
name
STRING
description
STRING
integration
RECORD
Users
Purpose: This API is used to fetch all the users in the company 
Source API Documentation: https://api2.timedoctor.com/#/Users/getUsers​
Replication: Full Replication
Replication Key: NA
Fields
Name
Data Type
id
STRING
status
STRING
reporterId
STRING
deleted
BOOLEAN
deletedAt
STRING
project
RECORD
name
STRING
description
STRING
integration
RECORD

Features	Details
Release Status	Beta version released
Source API Version	1.0
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Time Doctor User email Time Doctor Password
Replication Type	Full Replication
Replication Key	NA
Suggested Replication Frequency	1 hour

Name	Data Type
_id	STRING
name	STRING
type	STRING
active	BOOLEAN
public	BOOLEAN
access	STRING
scope	STRING

Name	Data Type
scope	STRING
id	STRING
entity	STRING
name	STRING
score	NUMERIC

Name	Data Type
role	STRING
hiredAt	STRING
lastSeen	RECORD
tagIds	STRING
onlyProjectIds	STRING
name	STRING
company	RECORD
custom	RECORD
isSilent	BOOLEAN
isInteractive	BOOLEAN
allowManual	BOOLEAN

Name	Data Type
userId	STRING
date	TIMESTAMP
deviceId	STRING
numbers	RECORD

Name	Data Type
_id	STRING
name	STRING
notifyType	STRING
condType	STRING
condValue	STRING
scope	STRING
dataIds	STRING
daysApplicable	STRING

Name	Data Type
id	STRING
name	STRING
email	STRING
role	STRING
currency	STRING
adjustment	NUMERIC
payRate	NUMERIC
payMethod	STRING
payIdentifier	STRING
hourlyLimit	NUMERIC
hourlyLimitRange	STRING

Name	Data Type
id	STRING
integration	RECORD
name	STRING
description	STRING
deleted	BOOLEAN
weight	NUMERIC

Name	Data Type
special	STRING
users	NUMERIC
usersOnReports	NUMERIC
selfUser	NUMERIC
managedUsers	NUMERIC
managedUsersOnReports	NUMERIC
id	STRING
name	STRING
creatorId	STRING
deleted	BOOLEAN
readOnly	BOOLEAN
managers	STRING
createdAt	TIMESTAMP
modifiedAt	TIMESTAMP

Name	Data Type
id	STRING
status	STRING
reporterId	STRING
deleted	BOOLEAN
deletedAt	STRING
project	RECORD
name	STRING
description	STRING
integration	RECORD

Name	Data Type
id	STRING
status	STRING
reporterId	STRING
deleted	BOOLEAN
deletedAt	STRING
project	RECORD
name	STRING
description	STRING
integration	RECORD

Release Notes

Last modified 6mo ago

Breaks	Categories
Companies	Files
Notifications	Payroll
Projects	Tags
Tasks	Users