Time Doctor
Time Doctor ETL connector for data replication
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 |
Breaks | Categories |
Companies | Files |
Notifications | Payroll |
Projects | Tags |
Tasks | Users |
- 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
- 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
Purpose: This API is used to fetch all the breaks
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
_id | STRING |
name | STRING |
type | STRING |
active | BOOLEAN |
public | BOOLEAN |
access | STRING |
scope | STRING |
Purpose: This API is used to fetch all the used categories in the company
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
scope | STRING |
id | STRING |
entity | STRING |
name | STRING |
score | NUMERIC |
Purpose: This API is used to fetch all the companies in the account
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 |
Purpose: This API is used to fetch all the files uploaded in the company
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
userId | STRING |
date | TIMESTAMP |
deviceId | STRING |
numbers | RECORD |
Purpose: This API is used to fetch all the notifications
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 |
Purpose: This API is used to fetch payroll of all employees
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 |
Purpose: This API is used to fetch all the projects in the company
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
id | STRING |
integration | RECORD |
name | STRING |
description | STRING |
deleted | BOOLEAN |
weight | NUMERIC |
Purpose: This API is used to fetch all the 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 |
Purpose: This API is used to fetch all the tasks in the company
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 |
Purpose: This API is used to fetch all the users in the company
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 |
Last modified 6mo ago