Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Teamwork connector and the associated fields and tables.
Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Teamwork connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Teamwork connector:
Teamwork v1 APIs
For more information, see Teamwork v1 API documentation.
- AllProjects_V1
- AllTags_V1
- LatestActivity_V1
- AllMilestones_V1
- AllTaskLists_V1
- AllPeople_V1
- TimeEntriesAcrossallProjects_V1
- TimeTotalAcrossProjects_V1
- CommentsAcrossAllType_V1
- ProjectCategories_V1
- AllExpenses_V1
- AllProjects_V1
- AllTags_V1
- LatestActivity_V1
- AllMilestones_V1
- AllTaskLists_V1
- AllPeople_V1
- TimeEntriesAcrossallProjects_V1
- TimeTotalAcrossProjects_V1
- CommentsAcrossAllType_V1
- ProjectCategories_V1
- AllExpenses_V1
AllProjects_V1
Retrieves a list of all projects in the Teamwork workspace.
FIELDS
| Field Name | Data Type |
announcement |
STRING |
announcementHTML |
STRING |
category |
RECORD |
company |
RECORD |
created-on |
TIMESTAMP |
defaultPrivacy |
STRING |
defaults |
RECORD |
description |
STRING |
endDate |
DATE |
filesAutoNewVersion |
BOOLEAN |
harvest-timers-enabled |
BOOLEAN |
id |
STRING |
integrations |
RECORD |
isBillable |
BOOLEAN |
isOnBoardingProject |
BOOLEAN |
isProjectAdmin |
BOOLEAN |
isSampleProject |
BOOLEAN |
last-changed-on |
TIMESTAMP |
logo |
STRING |
name |
STRING |
notifyeveryone |
BOOLEAN |
overview-start-page |
STRING |
privacyEnabled |
BOOLEAN |
replyByEmailEnabled |
BOOLEAN |
show-announcement |
BOOLEAN |
starred |
BOOLEAN |
startDate |
DATE |
start-page |
STRING |
status |
STRING |
subStatus |
STRING |
tasks-start-page |
STRING |
AllTags_V1
Provides access to all tags used in Teamwork projects, aiding in categorization and organization.
FIELDS
| Field Name | Data Type |
dateUpdated |
TIMESTAMP |
color |
STRING |
projectId |
STRING |
id |
STRING |
dateCreated |
TIMESTAMP |
name |
STRING |
LatestActivity_V1
Fetches the most recent activity updates and changes in the Teamwork workspace.
FIELDS
| Field Name | Data Type |
project-id |
STRING |
project-name |
STRING |
company-id |
STRING |
company-name |
STRING |
id |
STRING |
activitytype |
STRING |
description |
STRING |
extradescription |
STRING |
isprivate |
STRING |
itemid |
STRING |
itemlink |
STRING |
latestActivityType |
STRING |
link |
STRING |
lockdownId |
STRING |
publicinfo |
STRING |
type |
STRING |
due-date |
STRING |
userid |
STRING |
datetime |
TIMESTAMP |
foruserid |
STRING |
forusername |
STRING |
for-user-avatar-url |
STRING |
from-user-avatar-url |
STRING |
fromusername |
STRING |
AllMilestones_V1
Retrieves a list of milestones within Teamwork projects, helping to track project progress.
FIELDS
| Field Name | Data Type |
project-name |
STRING |
userFollowingComments |
BOOLEAN |
tasklists |
RECORD |
changeFollowerIds |
STRING |
last-changed-on |
TIMESTAMP |
completer-firstname |
STRING |
created-on |
TIMESTAMP |
reminder |
STRING |
project-id |
STRING |
completer-lastname |
STRING |
completed |
BOOLEAN |
status |
STRING |
completer-id |
STRING |
description |
STRING |
responsible-party-lastname |
STRING |
responsible-party-firstname |
STRING |
responsiblePartyNames |
STRING |
id |
STRING |
creator-id |
STRING |
responsiblePartyFullNames |
STRING |
commentFollowerIds |
STRING |
dueDateOffset |
STRING |
company-name |
STRING |
canEdit |
BOOLEAN |
isprivate |
STRING |
company-id |
STRING |
comments-count |
STRING |
responsible-party-type |
STRING |
canComplete |
BOOLEAN |
private |
BOOLEAN |
deadline |
DATE |
completed-on |
TIMESTAMP |
userFollowingChanges |
BOOLEAN |
title |
STRING |
AllTaskLists_V1
Offers access to all task lists within Teamwork projects for efficient task management.
FIELDS
| Field Name | Data Type |
id |
STRING |
name |
STRING |
description |
STRING |
position |
NUMERIC |
projectId |
STRING |
projectName |
STRING |
lastUpdated |
TIMESTAMP |
createdAt |
TIMESTAMP |
private |
BOOLEAN |
isTemplate |
BOOLEAN |
milestone-id |
STRING |
pinned |
BOOLEAN |
complete |
BOOLEAN |
uncompleted-count |
NUMERIC |
status |
STRING |
notifyTaskAssignee |
BOOLEAN |
AllPeople_V1
Retrieves a list of all users and team members in the Teamwork workspace.
FIELDS
| Field Name | Data Type |
permissions |
RECORD |
avatar-url |
STRING |
last-changed-on |
TIMESTAMP |
email-address |
STRING |
last-login |
TIMESTAMP |
address-country |
STRING |
user-invite-accepted-date |
TIMESTAMP |
textFormat |
STRING |
user-name |
STRING |
id |
STRING |
phone-number-fax |
STRING |
site-owner |
BOOLEAN |
address-city |
STRING |
company-name |
STRING |
user-invited-date |
TIMESTAMP |
phone-number-mobile |
STRING |
user-type |
STRING |
full-name |
STRING |
useShorthandDurations |
BOOLEAN |
address-zip |
STRING |
openId |
STRING |
address |
RECORD |
phone-number-office |
STRING |
im-handle |
STRING |
isClientUser |
BOOLEAN |
twoFactorAuthEnabled |
BOOLEAN |
has-access-to-new-projects |
BOOLEAN |
last-active |
TIMESTAMP |
im-service |
STRING |
deleted |
BOOLEAN |
notes |
STRING |
in-owner-company |
BOOLEAN |
user-invited-status |
STRING |
profile |
STRING |
userUUID |
STRING |
user-invited |
STRING |
created-at |
TIMESTAMP |
isServiceAccount |
BOOLEAN |
phone-number-home |
STRING |
profile-text |
STRING |
pid |
STRING |
phone-number-mobile-parts |
RECORD |
address-line-2 |
STRING |
address-state |
STRING |
login-count |
STRING |
address-line-1 |
STRING |
email-alt-1 |
STRING |
administrator |
BOOLEAN |
email-alt-2 |
STRING |
email-alt-3 |
STRING |
title |
STRING |
last-name |
STRING |
first-name |
STRING |
phone-number-office-ext |
STRING |
twitter |
STRING |
lengthOfDay |
STRING |
TimeEntriesAcrossallProjects_V1
Allows for the retrieval of time entries across all projects, aiding in time tracking and project management.
FIELDS
| Field Name | Data Type |
avatarUrl |
STRING |
canEdit |
BOOLEAN |
company-id |
STRING |
company-name |
STRING |
createdAt |
TIMESTAMP |
date |
TIMESTAMP |
dateUserPerspective |
TIMESTAMP |
description |
STRING |
has-start-time |
STRING |
hours |
STRING |
hoursDecimal |
NUMERIC |
id |
STRING |
invoiceNo |
STRING |
invoiceStatus |
STRING |
isbillable |
STRING |
isbilled |
STRING |
minutes |
STRING |
parentTaskId |
STRING |
parentTaskName |
STRING |
project-id |
STRING |
project-name |
STRING |
project-status |
STRING |
taskEstimatedTime |
STRING |
todo-item-id |
STRING |
taskIsPrivate |
STRING |
taskIsSubTask |
STRING |
todo-item-name |
STRING |
todo-list-id |
STRING |
tasklistId |
STRING |
todo-list-name |
STRING |
ticket-id |
STRING |
updated-date |
TIMESTAMP |
userDeleted |
BOOLEAN |
person-first-name |
STRING |
person-id |
STRING |
person-last-name |
STRING |
TimeTotalAcrossProjects_V1
Calculates and provides the total time spent across multiple projects.
FIELDS
| Field Name | Data Type |
totalBilledTime |
STRING |
totalNonBillableHours |
STRING |
company |
RECORD |
name |
STRING |
totalHours |
STRING |
totalBillableHours |
STRING |
totalNonBillableMins |
STRING |
totalNonBilledMins |
STRING |
totalBillableMins |
STRING |
totalBilledHours |
STRING |
id |
STRING |
totalNonBilledHours |
STRING |
totalMins |
STRING |
totalBilledMins |
STRING |
CommentsAcrossAllType_V1
Provides access to comments across all types of items within Teamwork, facilitating communication and collaboration.
FIELDS
| Field Name | Data Type |
project-name |
STRING |
nr-notified-people |
STRING |
comment-link |
STRING |
author_id |
STRING |
author-avatar-url |
STRING |
last-changed-on |
TIMESTAMP |
author-lastname |
STRING |
author-firstname |
STRING |
isRead |
STRING |
lockdown-id |
STRING |
author-company |
STRING |
commentable-id |
STRING |
project-id |
STRING |
author-id |
STRING |
attachments-count |
STRING |
content-type |
STRING |
id |
STRING |
canLike |
BOOLEAN |
_author_id |
RECORD |
type |
STRING |
company-name |
STRING |
canEdit |
BOOLEAN |
company-id |
STRING |
html-body |
STRING |
private |
STRING |
canDelete |
BOOLEAN |
commentable_type |
STRING |
datetime |
TIMESTAMP |
attachments_count |
STRING |
commentNo |
STRING |
emailed-from |
STRING |
body |
STRING |
item-name |
STRING |
ProjectCategories_V1
Retrieves a list of project categories, aiding in project organization.
FIELDS
| Field Name | Data Type |
elements_count |
STRING |
parent-id |
STRING |
color |
STRING |
count |
STRING |
id |
STRING |
elements-count |
STRING |
type |
STRING |
name |
STRING |
AllExpenses_V1
Offers access to all expenses recorded in Teamwork projects for financial tracking.
FIELDS
| Field Name | Data Type |
project-name |
STRING |
company-name |
STRING |
created-by-user-id |
STRING |
invoice-id |
STRING |
company-id |
STRING |
updated-date |
TIMESTAMP |
name |
STRING |
date |
DATE |
project-id |
STRING |
created-by-user-firstname |
STRING |
cost |
STRING |
description |
STRING |
id |
STRING |
created-by-user-lastname |
STRING |
UserStatuses_V1
This API provides information about the statuses of users, which can be helpful for tracking and managing user activities and availability.
FIELDS
| Field Name | Data Type |
geoipLocation |
STRING |
posted-on |
TIMESTAMP |
first-name |
STRING |
avatar-url |
STRING |
id |
STRING |
last-changed-on |
TIMESTAMP |
status |
STRING |
last-name |
STRING |
userId |
STRING |
isClockedIn |
STRING |
AllLinks_V1
The AllLinks API offers access to various types of links, which may include links to external resources, documents, or references within the Teamwork platform.
FIELDS
| Field Name | Data Type |
project-id |
STRING |
name |
STRING |
description |
STRING |
created-by-userfirstname |
STRING |
height |
STRING |
private |
STRING |
width |
STRING |
created-by-userId |
STRING |
created-by-userlastname |
STRING |
category-id |
STRING |
open-in-new-window |
STRING |
id |
STRING |
provider |
STRING |
created-date |
TIMESTAMP |
category-name |
STRING |
code |
STRING |
AllRunningTimers_V1
This API allows you to retrieve information about timers that are currently running, which can be useful for tracking time spent on tasks or projects in real-time.
FIELDS
| Field Name | Data Type |
running |
BOOLEAN |
dateDeleted |
STRING |
lastStartedAt |
TIMESTAMP |
deleted |
BOOLEAN |
taskName |
STRING |
dateUpdated |
TIMESTAMP |
taskId |
STRING |
billable |
BOOLEAN |
serverTime |
TIMESTAMP |
description |
STRING |
projectId |
STRING |
userId |
STRING |
intervals |
RECORD |
id |
STRING |
projectName |
STRING |
dateCreated |
TIMESTAMP |
duration |
STRING |
LatestMessages_V1
The LatestMessages API provides access to the most recent messages or communication within the Teamwork platform, enabling you to stay updated with the latest conversations.
FIELDS
| Field Name | Data Type |
user-display-posted-time |
STRING |
project-id |
STRING |
author-first-name |
STRING |
attachments-count |
STRING |
milestone-id |
STRING |
isRead |
STRING |
private |
STRING |
comments-count |
STRING |
author-avatar-url |
STRING |
category-id |
STRING |
author-last-name |
STRING |
posted-on |
TIMESTAMP |
body |
STRING |
id |
STRING |
last-changed-on |
TIMESTAMP |
content-type |
STRING |
last-comment-date |
TIMESTAMP |
user-display-posted-date |
STRING |
author-id |
STRING |
title |
STRING |
category-name |
STRING |
AllRisks_V1
This API provides insights into project or task risks, which can help with risk management and mitigation.
FIELDS
| Field Name | Data Type |
lastChangedByUserId |
STRING |
lastChangedOn |
TIMESTAMP |
deleted |
BOOLEAN |
status |
STRING |
projectId |
STRING |
impactPerformance |
STRING |
companyId |
STRING |
impactValue |
STRING |
id |
STRING |
projectName |
STRING |
canEdit |
BOOLEAN |
createdOn |
TIMESTAMP |
impactSchedule |
STRING |
lastChangedByUserFirstName |
STRING |
impact |
STRING |
probability |
STRING |
lastChangedByUserLastName |
STRING |
mitigationPlan |
STRING |
source |
STRING |
probabilityValue |
STRING |
createdByUserId |
STRING |
createdByUserFirstName |
STRING |
companyName |
STRING |
projectIsActive |
BOOLEAN |
result |
STRING |
impactCost |
STRING |
createdByUserLastName |
STRING |
AllTasksAcrossAllProjects_V1
It allows you to retrieve information about all tasks across multiple projects, making it easier to get a comprehensive view of task-related data.
FIELDS
| Field Name | Data Type |
id |
NUMERIC |
canComplete |
BOOLEAN |
comments-count |
NUMERIC |
description |
STRING |
descriptionContentType |
STRING |
has-reminders |
BOOLEAN |
has-unread-comments |
BOOLEAN |
private |
NUMERIC |
content |
STRING |
order |
NUMERIC |
decimalOrder |
NUMERIC |
project-id |
NUMERIC |
project-name |
STRING |
todo-list-id |
NUMERIC |
todo-list-name |
STRING |
tasklist-private |
BOOLEAN |
tasklist-isTemplate |
BOOLEAN |
status |
STRING |
company-name |
STRING |
company-id |
NUMERIC |
creator-id |
NUMERIC |
creator-firstname |
STRING |
creator-lastname |
STRING |
updater-id |
NUMERIC |
updater-firstname |
STRING |
updater-lastname |
STRING |
completed |
BOOLEAN |
start-date |
STRING |
due-date-base |
STRING |
due-date |
STRING |
created-on |
TIMESTAMP |
last-changed-on |
TIMESTAMP |
position |
NUMERIC |
decimal-position |
NUMERIC |
estimated-minutes |
NUMERIC |
priority |
STRING |
progress |
NUMERIC |
harvest-enabled |
BOOLEAN |
parentTaskId |
STRING |
lockdownId |
STRING |
tasklist-lockdownId |
STRING |
has-dependencies |
NUMERIC |
has-predecessors |
NUMERIC |
hasTickets |
BOOLEAN |
tags |
RECORD |
timeIsLogged |
STRING |
attachments-count |
NUMERIC |
canEdit |
BOOLEAN |
viewEstimatedTime |
BOOLEAN |
creator-avatar-url |
STRING |
canLogTime |
BOOLEAN |
commentFollowerIds |
STRING |
changeFollowerIds |
STRING |
userFollowingComments |
BOOLEAN |
userFollowingChanges |
BOOLEAN |
DLM |
NUMERIC |
ProjectUpdates_V1
The ProjectUpdates API offers access to updates and changes related to specific projects, ensuring that you are informed about project developments.
FIELDS
| Field Name | Data Type |
deletedDate |
STRING |
projectId |
STRING |
color |
STRING |
projectStatus |
STRING |
text |
STRING |
id |
STRING |
health |
STRING |
deleted |
BOOLEAN |
user |
RECORD |
projectName |
STRING |
dateCreated |
TIMESTAMP |
Teamwork v2 APIs
For more information, see Teamwork v2 API documentation.
ProjectsTemplates_V2
Provides templates for creating new projects, streamlining project setup.
FIELDS
| Field Name | Data Type |
activePages |
RECORD |
activeUserIsProjectAdmin |
BOOLEAN |
announcement |
STRING |
announcementHTML |
STRING |
category |
RECORD |
company |
RECORD |
createdOn |
TIMESTAMP |
defaultPrivacy |
STRING |
defaults |
RECORD |
description |
STRING |
directFileUploadsEnabled |
BOOLEAN |
filesAutoNewVersion |
BOOLEAN |
harvestTimersEnabled |
BOOLEAN |
id |
NUMERIC |
integrations |
RECORD |
isBillable |
BOOLEAN |
isOnBoardingProject |
BOOLEAN |
isProjectAdmin |
BOOLEAN |
isSampleProject |
BOOLEAN |
lastChangedOn |
TIMESTAMP |
logo |
STRING |
minMaxAvailableDates |
RECORD |
name |
STRING |
notifyEveryone |
BOOLEAN |
overviewStartPage |
STRING |
privacyEnabled |
BOOLEAN |
projectOwnerId |
NUMERIC |
replyByEmailEnabled |
BOOLEAN |
showAnnouncement |
BOOLEAN |
skipWeekends |
BOOLEAN |
starred |
BOOLEAN |
startPage |
STRING |
status |
STRING |
subStatus |
STRING |
tasksStartPage |
STRING |
templateDateTargetDefault |
STRING |
type |
STRING |
CustomFieldonTasks_V2
Allows for the addition of custom fields to tasks for more detailed task management.
FIELDS
| Field Name | Data Type |
id |
NUMERIC |
name |
STRING |
priority |
STRING |
status |
STRING |
parentTaskId |
NUMERIC |
isArchived |
BOOLEAN |
description |
STRING |
descriptionContentType |
STRING |
boardColumn |
RECORD |
canViewEstTime |
BOOLEAN |
updatedBy |
RECORD |
createdBy |
RECORD |
dateCreated |
TIMESTAMP |
dateChanged |
TIMESTAMP |
dateLastModified |
TIMESTAMP |
hasFollowers |
BOOLEAN |
hasLoggedTime |
BOOLEAN |
hasProofs |
BOOLEAN |
hasReminders |
BOOLEAN |
hasRemindersForUser |
BOOLEAN |
hasRelativeReminders |
BOOLEAN |
hasTemplateReminders |
BOOLEAN |
hasTickets |
BOOLEAN |
isPrivate |
BOOLEAN |
installationId |
NUMERIC |
privacyIsInherited |
BOOLEAN |
lockdownId |
NUMERIC |
numMinutesLogged |
NUMERIC |
numBillableMinutesLogged |
NUMERIC |
numTotalMinutesLogged |
NUMERIC |
numActiveSubTasks |
NUMERIC |
numAttachments |
NUMERIC |
numComments |
NUMERIC |
numCommentsRead |
NUMERIC |
numCompletedSubTasks |
NUMERIC |
numDependencies |
NUMERIC |
numEstMins |
NUMERIC |
numPredecessors |
NUMERIC |
position |
NUMERIC |
projectId |
NUMERIC |
startDate |
DATE |
tags |
RECORD |
assignedTo |
RECORD |
dueDate |
DATE |
dueDateFromMilestone |
BOOLEAN |
taskListId |
NUMERIC |
progress |
NUMERIC |
followingChanges |
BOOLEAN |
followingComments |
BOOLEAN |
changeFollowerIds |
STRING |
commentFollowerIds |
STRING |
cardId |
NUMERIC |
order |
NUMERIC |
canComplete |
BOOLEAN |
canEdit |
BOOLEAN |
canLogTime |
BOOLEAN |
canAddSubtasks |
BOOLEAN |
placeholder |
BOOLEAN |
DLM |
NUMERIC |
CustomFieldonProjects_V2
This API allows you to work with custom fields associated with projects, providing flexibility for data management and customization.
FIELDS
| Field Name | Data Type |
activePages |
RECORD |
activeUserIsProjectAdmin |
BOOLEAN |
announcement |
STRING |
announcementHTML |
STRING |
category |
RECORD |
company |
RECORD |
createdOn |
TIMESTAMP |
defaultPrivacy |
STRING |
defaults |
RECORD |
description |
STRING |
directFileUploadsEnabled |
BOOLEAN |
endDate |
DATE |
filesAutoNewVersion |
BOOLEAN |
harvestTimersEnabled |
BOOLEAN |
id |
NUMERIC |
integrations |
RECORD |
isBillable |
BOOLEAN |
isOnBoardingProject |
BOOLEAN |
isProjectAdmin |
BOOLEAN |
isSampleProject |
BOOLEAN |
lastChangedOn |
TIMESTAMP |
logo |
STRING |
name |
STRING |
notifyEveryone |
BOOLEAN |
overviewStartPage |
STRING |
privacyEnabled |
BOOLEAN |
projectOwnerId |
NUMERIC |
replyByEmailEnabled |
BOOLEAN |
showAnnouncement |
BOOLEAN |
skipWeekends |
BOOLEAN |
starred |
BOOLEAN |
startDate |
DATE |
startPage |
STRING |
status |
STRING |
subStatus |
STRING |
tasksStartPage |
STRING |
type |
STRING |
customField_id |
STRING |
customField |
RECORD |
Teamwork v3 APIs
For more information, see Teamwork v3 API documentation.
AllTimeEntries_V3
Retrieves all time entries in Teamwork, aiding in time tracking and reporting for tasks and projects.
FIELDS
| Field Name | Data Type |
id |
NUMERIC |
dateCreated |
TIMESTAMP |
createdAt |
TIMESTAMP |
minutes |
NUMERIC |
description |
STRING |
timeLogged |
TIMESTAMP |
billable |
BOOLEAN |
isBillable |
BOOLEAN |
deleted |
BOOLEAN |
hasStartTime |
BOOLEAN |
dateEdited |
TIMESTAMP |
updatedAt |
TIMESTAMP |
userId |
NUMERIC |
user |
RECORD |
taskId |
NUMERIC |
task |
RECORD |
projectId |
NUMERIC |
project |
RECORD |
loggedByUserId |
NUMERIC |
loggedBy |
NUMERIC |
editedByUserId |
NUMERIC |
updatedBy |
NUMERIC |
AllTasks_V3
It provides access to all tasks, which can help in tracking and managing tasks across different projects or teams.
FIELDS
| Field Name | Data Type |
id |
NUMERIC |
name |
STRING |
description |
STRING |
descriptionContentType |
STRING |
hasDeskTickets |
BOOLEAN |
progress |
NUMERIC |
displayOrder |
NUMERIC |
decimalDisplayOrder |
NUMERIC |
updatedAt |
TIMESTAMP |
updatedBy |
NUMERIC |
isPrivate |
NUMERIC |
status |
STRING |
tasklist |
RECORD |
dueDate |
TIMESTAMP |
estimateMinutes |
NUMERIC |
accumulatedEstimatedMinutes |
NUMERIC |
commentFollowers |
RECORD |
isArchived |
BOOLEAN |
userPermissions |
RECORD |
createdBy |
NUMERIC |
createdAt |
TIMESTAMP |
dateUpdated |
TIMESTAMP |
parentTaskId |
NUMERIC |
tasklistId |
NUMERIC |
createdByUserId |
NUMERIC |
