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

Activity_worklog

Description: activity_worklog table will help in tracking the number of hours the users have entered in their work time. The time is stored in seconds

Replication type: Incremental

Name	Data Type
start	TIMESTAMP
time	NUMERIC
mode	STRING
userId	STRING
taskId	STRING
projectId	STRING
deviceId	STRING
reason	STRING
editTimeId	STRING