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.

Activity

Retrieves activity feeds or logs for projects or tasks.

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

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

links

RECORD

name

STRING

id

STRING

AllPeopleList

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

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

name

STRING

id

STRING

color

STRING

Milestones: Retrieves information related to project milestones.

FIELDS

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

projectId

STRING

users

RECORD

name

STRING

description

STRING

id

INTEGER

ProjectUpdates: Retrieves updates and changes made to projects.

FIELDS

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

billable

BOOLEAN

dateCreated

STRING

dateDeleted

STRING

dateEdited

STRING

deleted

BOOLEAN

deletedByUserId

INTEGER

des