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

• Teamwork v2 APIs

• Teamwork v3 APIs

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

• CustomFieldonTasks_V2

• CustomFieldonProjects_V2

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

• AllTasks_V3

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