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

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