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