Snapshot

Tables/APIs supported

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

Replication: Full Replication

Replication Key: NA

Fields

Categories

Purpose: This API is used to fetch all the used categories in the company

Replication: Full Replication

Replication Key: NA

Fields

Companies

Purpose: This API is used to fetch all the companies in the account

Replication: Full Replication

Replication Key: NA

Fields

Files

Purpose: This API is used to fetch all the files uploaded in the company

Replication: Full Replication

Replication Key: NA

Fields

Notifications

Purpose: This API is used to fetch all the notifications

Replication: Full Replication

Replication Key: NA

Fields

Payroll

Purpose: This API is used to fetch payroll of all employees

Replication: Full Replication

Replication Key: NA

Fields

Projects

Purpose: This API is used to fetch all the projects in the company

Replication: Full Replication

Replication Key: NA

Fields

Tags

Purpose: This API is used to fetch all the tags

Replication: Full Replication

Replication Key: NA

Fields

Tasks

Purpose: This API is used to fetch all the tasks in the company

Replication: Full Replication

Replication Key: NA

Fields

Users

Purpose: This API is used to fetch all the users in the company

Replication: Full Replication

Replication Key: NA

Fields

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