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.

Activity

Retrieves activity feeds or logs for projects or tasks.

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	STRING
foruserid	STRING
forusername	STRING
for_user_avatar_url	STRING
from_user_avatar_url	STRING
fromusername	STRING

AllLinks

Provides access to all links or hyperlinks associated with projects, tasks, or other items.

FIELDS

Field Name	Data Type
links	RECORD
name	STRING
id	STRING

AllPeopleList

Retrieves a list of all people (users) in your Teamwork organization.

Field Name	Data Type
site_owner	BOOLEAN
twitter	STRING
last_name	STRING
useShorthandDurations	BOOLEAN
profile	STRING
userUUID	STRING
user_name	STRING
id	STRING
phone_number_office	STRING
last_active	STRING
phone_number_mobile	STRING
first_name	STRING
user_type	STRING
im_service	STRING
im_handle	STRING
login_count	STRING
openId	STRING
phone_number_office_ext	STRING
twoFactorAuthEnabled	BOOLEAN
company_id	STRING
has_access_to_new_projects	BOOLEAN
address_zip	STRING
phone_number_fax	STRING
full_name	STRING
last_login	STRING
companyId	STRING
administrator	BOOLEAN
address_city	STRING
pid	STRING
profile_text	STRING
phone_number_home	STRING
email_address	STRING
lengthOfDay	STRING
tags	STRING
company_name	STRING
last_changed_on	STRING
deleted	BOOLEAN
address_state	STRING
address_country	STRING
notes	STRING
phone_number_mobile_parts	RECORD
permissions	RECORD
user_invited_status	STRING
address	RECORD
address_line_2	STRING
address_line_1	STRING
created_at	STRING
textFormat	STRING
user_invited_date	STRING
avatar_url	STRING
in_owner_company	BOOLEAN
user_invited	STRING
email_alt_1	STRING
email_alt_2	STRING
email_alt_3	STRING
title	STRING

AllRisks: Retrieves information about risks associated with projects or tasks.

FIELDS

Field Name	Data Type
lastChangedOn	STRING
createdByUserId	STRING
impact	STRING
impactSchedule	STRING
impactValue	STRING
projectId	STRING
status	STRING
probabilityValue	STRING
source	STRING
result	STRING
createdOn	STRING
id	STRING
lastChangedByUserId	STRING
deleted	BOOLEAN
createdByUserLastName	STRING
companyName	STRING
createdByUserFirstName	STRING
lastChangedByUserFirstName	STRING
projectName	STRING
projectIsActive	STRING
impactPerformance	STRING
mitigationPlan	STRING
probability	STRING
lastChangedByUserLastName	STRING
impactCost	STRING
companyId	STRING

AllRunningTimers

Allows you to access running timers for tasks.

FIELDS

Field Name	Data Type
dateDeleted	STRING
serverTime	STRING
intervals	RECORD
description	STRING
dateUpdated	STRING
projectName	STRING
projectId	STRING
billable	BOOLEAN
running	BOOLEAN
id	STRING
taskName	STRING
lastStartedAt	STRING
taskId	STRING
dateCreated	STRING
duration	STRING
deleted	BOOLEAN
userId	STRING

AllTaskAcrossAllProjects

Retrieves information about tasks across all projects.

FIELDS

Field Name	Data Type
id	NUMERIC
boardColumn	RECORD
canComplete	BOOLEAN
comments_count	NUMERIC
description	STRING
has_reminders	BOOLEAN
has_unread_comments	BOOLEAN
private	NUMERIC
content	STRING
order	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	STRING
last_changed_on	STRING
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
predecessors	STRING
canEdit	BOOLEAN
viewEstimatedTime	BOOLEAN
creator_avatar_url	STRING
canLogTime	BOOLEAN
commentFollowerSummary	STRING
commentFollowerIds	STRING
userFollowingComments	BOOLEAN
userFollowingChanges	BOOLEAN
DLM	NUMERIC
boardColumn.id	NUMERIC
boardColumn.name	STRING
boardColumn.color	STRING

AllTaskList: Retrieves a list of all tasks in your Teamwork projects.

FIELDS

Field Name	Data Type
id	STRING
name	STRING
description	STRING
position	NUMERIC
projectId	STRING
projectName	STRING
lastUpdated	STRING
private	BOOLEAN
isTemplate	BOOLEAN
tags	STRING
milestone_id	STRING
pinned	BOOLEAN
complete	BOOLEAN
uncompleted_count	NUMERIC
status	STRING
notifyTaskAssignee	BOOLEAN

CommentsAcrossAllTypes: Retrieves comments across various types of items in Teamwork, such as tasks or projects.

FIELDS

Field Name	Data Type
project_id	STRING
author_lastname	STRING
commentable_id	STRING
commentable_type	STRING
emailed_from	STRING
isRead	STRING
private	STRING
lockdown_id	STRING
datetime	STRING
author_avatar_url	STRING
canEdit	BOOLEAN
id	STRING
company_name	STRING
last_changed_on	STRING
content_type	STRING
nr_notified_people	STRING
canDelete	BOOLEAN
type	STRING
item_name	STRING
attachments_count	STRING
_author_id	RECORD
company_id	STRING
canLike	BOOLEAN
html_body	STRING
project_name	STRING
body	STRING
commentNo	STRING
attachments	RECORD
author_firstname	STRING
author_company	STRING
comment_link	STRING
author_id	STRING

GetAllExpenses: Retrieves expense-related information for projects or tasks.

FIELDS

Field Name	Data Type
invoice_id	STRING
project_id	STRING
name	STRING
description	STRING
created_by_user_firstname	STRING
company_id	STRING
project_name	STRING
created_by_user_id	STRING
created_by_user_lastname	STRING
id	STRING
date	STRING
company_name	STRING
cost	STRING

LatestMessages: Accesses the latest messages or communications within your Teamwork projects.

FIELDS

Field Name	Data Type
project_id	STRING
author_first_name	STRING
milestone_id	STRING
contributingUsers	STRING
attachmentsCount	STRING
isRead	STRING
private	STRING
comments_count	STRING
author_avatar_url	STRING
author_last_name	STRING
tags	STRING
company_name	STRING
id	STRING
last_changed_on	STRING
content_type	STRING
isOriginal	STRING
user_display_posted_date	STRING
user_display_posted_time	STRING
attachments_count	STRING
category_color	STRING
post_id	STRING
userFollowing	BOOLEAN
category_id	STRING
followerIds	STRING
html_body	STRING
project_name	STRING
posted_on	STRING
body	STRING
attachments	STRING
last_comment_date	STRING
author_id	STRING
title	STRING
category_name	STRING

ListAllTags: Retrieves a list of all tags used within your Teamwork projects.

FIELDS

Field Name	Data Type
name	STRING
id	STRING
color	STRING

Milestones: Retrieves information related to project milestones.

FIELDS

Field Name	Data Type
projectType	STRING
canComplete	BOOLEAN
project_id	STRING
responsible_party_id	STRING
responsiblePartyFullNames	STRING
completed_on	STRING
private	BOOLEAN
userFollowingComments	BOOLEAN
comments_count	STRING
status	STRING
changeFollowerIds	STRING
created_on	STRING
tags	STRING
canEdit	BOOLEAN
responsible_party_type	STRING
isprivate	STRING
company_name	STRING
id	STRING
last_changed_on	STRING
commentFollowerIds	STRING
completed	BOOLEAN
reminder	STRING
tasklists	RECORD
userFollowingChanges	BOOLEAN
description	STRING
responsible_party_firstname	STRING
responsible_party_ids	STRING
responsible_party_names	STRING
responsible_party_lastname	STRING
company_id	STRING
creator_id	STRING
dueDateOffset	STRING
project_name	STRING
deadline	STRING
_isprivate	RECORD
title	STRING

Project: Allows you to interact with project-related data, including creating, updating, or retrieving project details.

FIELDS

Field Name	Data Type
announcement	STRING
announcementHTML	STRING
category	RECORD
company	RECORD
created_on	STRING
defaultPrivacy	STRING
defaults	RECORD
description	STRING
endDate	STRING
filesAutoNewVersion	BOOLEAN
harvest_timers_enabled	BOOLEAN
id	STRING
integrations	RECORD
isProjectAdmin	BOOLEAN
last_changed_on	STRING
logo	STRING
name	STRING
notifyeveryone	BOOLEAN
overview_start_page	STRING
privacyEnabled	BOOLEAN
replyByEmailEnabled	BOOLEAN
show_announcement	BOOLEAN
starred	BOOLEAN
startDate	STRING
start_page	STRING
status	STRING
subStatus	STRING
tags	STRING
tasks_start_page	STRING

ProjectCategories: Manages project categories or groupings.

FIELDS

Field Name	Data Type
parent_id	STRING
name	STRING
count	STRING
elements_count	STRING
id	STRING
color	STRING
type	STRING

ProjectRole: Deals with user roles and permissions within projects.

FIELDS

Field Name	Data Type
projectId	STRING
users	RECORD
name	STRING
description	STRING
id	INTEGER

ProjectUpdates: Retrieves updates and changes made to projects.

FIELDS

Field Name	Data Type
projectId	STRING
deletedDate	STRING
text	STRING
health	STRING
id	STRING
dateCreated	STRING
color	STRING
deleted	STRING
user	RECORD

TimeEntriesAcrossAllProjects: Retrieves time entries across all projects.

FIELDS

Field Name	Data Type
status	STRING
billableType	STRING
invoicedType	STRING
canEdit	BOOLEAN
company_id	STRING
company_name	STRING
createdAt	STRING
date	STRING
dateUserPerspective	STRING
description	STRING
has_start_time	STRING
hours	STRING
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
tags	STRING
taskEstimatedTime	STRING
todo_item_id	STRING
taskIsPrivate	STRING
taskIsSubTask	STRING
todo_item_name	STRING
task_tags	STRING
todo_list_id	STRING
tasklistId	STRING
todo_list_name	STRING
ticket_id	STRING
updated_date	STRING
person_first_name	STRING
person_id	STRING
person_last_name	STRING

TimeTotalAcrossProjects: Calculates the total time spent across all projects.

FIELDS

Field Name	Data Type
company	RECORD
name	STRING
totalNonBilledMins	STRING
totalBillableHours	STRING
totalBillableMins	STRING
totalNonBillableMins	STRING
totalMins	STRING
totalNonBillableHours	STRING
totalBilledHours	STRING
totalHours	STRING
totalNonBilledHours	STRING
id	STRING
totalBilledTime	STRING
totalBilledMins	STRING

TimeTotalOnAProject: Calculates the total time spent on a specific project.

FIELDS

Field Name	Data Type
projectID	STRING
projectType	STRING
company	RECORD
time_estimates	RECORD
name	STRING
id	STRING
time_totals	RECORD

UserStatuses: Retrieves information about user statuses or presence within Teamwork.

FIELDS

Field Name	Data Type
first_name	STRING
reset	BOOLEAN
status	STRING
neverUpdated	BOOLEAN
last_name	STRING
updated_date	STRING
statusHTML	STRING
geoipLocation	STRING
posted_on	STRING
avatar_url	STRING
id	STRING
last_changed_on	STRING
userId	STRING
isClockedIn	STRING

Teamwork v2 APIs

For more information, see Teamwork v2 API documentation.

CustomFieldsForV2Projects: Deals with custom fields associated with projects in Teamwork, allowing you to create, retrieve, update, or delete custom fields for project-related data.

FIELDS

Field Name	Data Type
id	INTEGER
entity	STRING
name	STRING
description	STRING
type	STRING
isPrivate	BOOLEAN
required	BOOLEAN
createdAt	TIMESTAMP
createdByUserId	INTEGER
createdBy	INTEGER
updatedAt	TIMESTAMP
updatedByUserId	INTEGER
updatedBy	INTEGER
deleted	BOOLEAN

CustomFieldsForV2Tasks: Deals with custom fields associated with tasks in Teamwork, enabling you to work with custom data fields specific to tasks within your projects.

FIELDS

Field Name	Data Type
id	INTEGER
entity	STRING
name	STRING
description	STRING
type	STRING
isPrivate	BOOLEAN
required	BOOLEAN
createdAt	TIMESTAMP
createdByUserId	INTEGER
createdBy	INTEGER
updatedAt	TIMESTAMP
updatedByUserId	INTEGER
updatedBy	INTEGER
deleted	BOOLEAN

ProjectsV2: Manages projects within Teamwork, providing functionality for creating, updating, retrieving, or managing project-related data.

FIELDS

Field Name	Data Type
activePages	RECORD
activeUserIsProjectAdmin	BOOLEAN
announcement	STRING
announcementHTML	STRING
company	RECORD
createdOn	STRING
defaultPrivacy	STRING
defaults	RECORD
description	STRING
directFileUploadsEnabled	BOOLEAN
filesAutoNewVersion	BOOLEAN
harvestTimersEnabled	BOOLEAN
id	INTEGER
integrations	RECORD
isOnBoardingProject	BOOLEAN
isProjectAdmin	BOOLEAN
isSampleProject	BOOLEAN
lastChangedOn	STRING
lastWorkedOn	STRING
logo	STRING
name	STRING
notifyEveryone	BOOLEAN
overviewStartPage	STRING
privacyEnabled	BOOLEAN
projectOwnerId	INTEGER
replyByEmailEnabled	BOOLEAN
showAnnouncement	BOOLEAN
skipWeekends	BOOLEAN
starred	BOOLEAN
startPage	STRING
status	STRING
subStatus	STRING
tasksStartPage	STRING
type	STRING
customFields	RECORD
category	RECORD
endDate	DATE
isBillable	BOOLEAN
people	STRING
startDate	DATE
tags	RECORD
boardData	RECORD
portfolioBoards	RECORD
completedByUserFirstName	STRING
completedByUserId	INTEGER
completedByUserLastName	STRING
completedOn	TIMESTAMP
archivedByUserId	INTEGER
archivedByUserName	STRING
dateArchived	TIMESTAMP

TasksV2: Retrieves tasks within Teamwork projects, allowing you to interact with tasks, create or update tasks, and retrieve task-related information.

FIELDS

Field Name	Data Type
id	INTEGER
name	STRING
priority	STRING
status	STRING
parentTaskId	INTEGER
description	STRING
canViewEstTime	BOOLEAN
updatedBy	RECORD
createdBy	RECORD
dateCreated	STRING
dateChanged	STRING
dateLastModified	STRING
hasFollowers	BOOLEAN
hasLoggedTime	BOOLEAN
hasReminders	BOOLEAN
hasRemindersForUser	BOOLEAN
hasRelativeReminders	BOOLEAN
hasTemplateReminders	BOOLEAN
hasTickets	BOOLEAN
isPrivate	BOOLEAN
installationId	INTEGER
privacyIsInherited	BOOLEAN
lockdownId	INTEGER
numMinutesLogged	INTEGER
numActiveSubTasks	INTEGER
numAttachments	INTEGER
numComments	INTEGER
numCommentsRead	INTEGER
numCompletedSubTasks	INTEGER
numDependencies	INTEGER
numEstMins	INTEGER
numPredecessors	INTEGER
position	INTEGER
projectId	INTEGER
dueDateFromMilestone	BOOLEAN
taskListId	INTEGER
progress	INTEGER
followingChanges	BOOLEAN
followingComments	BOOLEAN
changeFollowerIds	STRING
commentFollowerIds	STRING
order	INTEGER
canComplete	BOOLEAN
canEdit	BOOLEAN
canLogTime	BOOLEAN
canAddSubtasks	BOOLEAN
placeholder	BOOLEAN
DLM	INTEGER
customFields	RECORD
assignedTo	RECORD

Teamwork v3 APIs

For more information, see Teamwork v3 API documentation.

V3_ALLRunningTimersWithDetails: Provides a list of all running timers with detailed information, such as the task or project associated with each timer.

FIELDS

Field Name	Data Type
users	RECORD
tasks	RECORD
tasklists	RECORD
projects	RECORD

V3_AllRunningTimers: Returns a list of all running timers but with basic information without details.

FIELDS

Field Name	Data Type
billable	BOOLEAN
createdAt	STRING
deleted	BOOLEAN
deletedAt	STRING
description	STRING
duration	INTEGER
id	INTEGER
intervals	RECORD
lastStartedAt	STRING
projectId	INTEGER
running	BOOLEAN
serverTime	STRING
taskId	INTEGER
timeLogId	INTEGER
timerLastIntervalEnd	STRING
updatedAt	STRING
userId	INTEGER

V3_AllTimeEntries: Retrieves a list of all time entries recorded in Teamwork, possibly without additional details.

FIELDS

Field Name	Data Type
billable	BOOLEAN
dateCreated	STRING
dateDeleted	STRING
dateEdited	STRING
deleted	BOOLEAN
deletedByUserId	INTEGER
description	STRING
deskTicketId	INTEGER
editedByUserId	INTEGER
hasStartTime	BOOLEAN
id	INTEGER
invoiceNumber	STRING
loggedByUserId	INTEGER
minutes	INTEGER
projectBillingInvoiceId	INTEGER
projectId	INTEGER
taskId	INTEGER
taskIdPreMove	INTEGER
timeLogged	STRING
userId	INTEGER

V3_AllTimeEntriesWithDetails: This API is similar to the above but with more detailed information included for each time entry.

FIELDS

Field Name	Data Type
users	RECORD
tasks	RECORD
tasklists	RECORD
projects	RECORD

V3_TimeLogTotals: Provides totals or summaries of time logged for various tasks, projects, or users within a specified time period.

FIELDS

Field Name	Data Type
projectID	INTEGER
projectType	STRING
estimatedMinutesActive	INTEGER
estimatedMinutesCompleted	INTEGER
estimatedMinutesFiltered	INTEGER
estimatedMinutesWithLoggedTime	INTEGER
minutes	INTEGER
minutesBillable	INTEGER
minutesBilled	INTEGER
minutesNonBillable	INTEGER
minutesNonBilled	INTEGER