Schema Information of Teamwork Connector

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

Table of Contents

Tables/APIs Teamwork v1 APIs

Schema Information of Teamwork Connector

Saras Pulse

Saras Daton

Saras IQ