Skip to main content
TimeDoctor API
SLINKY avatar
Written by SLINKY
Updated over 4 months ago

The Job Adder API syncs user activity data information into Airtable. Currently only available for STAFFLINK and Airtable.

Once implemented, please do not change the names of any tables used by the API. Consequently, please also do not change any of the fields that the API feeds data into for each record. If you change data in any of the fields, the API will overwrite it on the next run.

Not all data is available from TimeDoctor, only selected data that is provided by the TimeDoctor API.

The following jobs run to syncronise data.

Tasks

The Tasks job syncronises Tasks data from TimeDoctor into Airtable and runs every 60 minutes, updating all records

Fields For Tasks Table

TimeDoctor Data

Field Name

Field Type

Internal Record Id

Record_Id

Text

Name of task

Task_Name

Text

Internal Project Id

Project_Id

Text

Status of task

Status

Single Select

Internal Reporter Id

Reporter_Id

Text

Has it been deleted?

Deleted

Checkbox

Projects

The Projects job syncronises Projects data from TimeDoctor into Airtable and runs every 60 minutes, updating all records

Fields For Projects Table

TimeDoctor Data

Field Name

Field Type

Internal Record Id

Record_Id

Text

Name of project

Name

Text

Internal Creator Id

CreatorId

Text

Has it been deleted?

Deleted

Checkbox

Activities

The Activities job syncronises Activities data from TimeDoctor into Airtable and runs every 60 minutes, updating all records

Fields For Activities Table

TimeDoctor Data

Field Name

Field Type

Start time of activity

StartTime

Date

How long it went for

Duration

Number

What was the mode of the activity

Mode

Single Select

Internal User Id

UserId

Text

Internal Task Id

TaskId

Text

Internal Project Id

ProjectId

Text

Device Id Used

DeviceId

Text

Reason for the activity

Reason

Text

Internal Record Id

Record_Id

Text

Users

The user job syncronises TimeDoctor user data from TimeDoctor into Airtable and runs every 60 minutes, updating all records

Fields For Users Table

TimeDoctor Data

Field Name

Field Type

Role

Single Select

Hired_At

Date

LastSeen

Date

LastSeenOnline

Date

Timezone

Single Select

IsSilent

Checkbox

IsInteractive

Checkbox

TrackingMode

Single Select

Name

Text

Employee_Id

Text

Exists

Checkbox

Active

Checkbox

Screenshots

Checkbox

Videos

Checkbox

WorkCheckInterval

Checkbox

AllowEditTime

Checkbox

PoorTimeUsePopup

Checkbox

AllowDeleteScreenshots

Checkbox

TasksMode

Single Select

TrackingType

Single Select

ShowOnReports

Checkbox

BlurScreenshots

Checkbox

AllowNoBreak

Checkbox

TrackInternetConnectivity

Checkbox

PayrollAccess

Checkbox

BillingAccess

Checkbox

PayrollFeature

Checkbox

TrackConnectivity

Checkbox

AllowManagerTagCategories

Checkbox

AllowManagerProjectsTasks

Checkbox

AllowManagerInviteUsers

Checkbox

AllowManagerWorkSchedules

Checkbox

ForceAutostart

Checkbox

FirstDayOfWeek

Single Select

WebAndAppTracking

Checkbox

Record_Id

Text

Email

Text

CreatedAt

Date

Status

Single Select

Linking Jobs

Linking jobs link data between tables. There are four fields that are involved, two ID fields and two link fields. The API will match records based on the ID fields and link the data using the corresponding link fields for that record. The following links are available, defined by the link between Table A and (->) Table B. Linking threads run every five hours.

Users -> Activities

Data

Field Name

Field Type

Id of Table A

UserId

Text

Id of Table B

Record_Id

Text

Link in Table A

Activities

Link

Link in Table B

User

Link

Tasks -> Activities

Data

Field Name

Field Type

Id of Table A

TaskId

Text

Id of Table B

Record_Id

Text

Link in Table A

Activities

Link

Link in Table B

Task

Link

Projects -> Activities

Data

Field Name

Field Type

Id of Table A

ProjectId

Text

Id of Table B

Record_Id

Text

Link in Table A

Activities

Link

Link in Table B

Project

Link

Did this answer your question?