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 |
| 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 |