> For the complete documentation index, see [llms.txt](https://daton-sarasanalytics.gitbook.io/daton/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/business/teamwork/schema-information.md).

# Schema Information

## Tables/APIs 

The following is the list of tables or APIs associated with the Teamwork connector:

* [Teamwork v1 APIs](#teamwork-v1-apis)
* [Teamwork v2 APIs](#teamwork-v2-apis)
* [Teamwork v3 APIs](#teamwork-v3-apis)

### Teamwork v1 APIs 

For more information, see [Teamwork v1 API documentation](https://apidocs.teamwork.com/docs/teamwork/b23e661859c0e-teamwork-api).

**Activity**

Retrieves activity feeds or logs for projects or tasks.

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>project_id</td><td>STRING</td></tr><tr><td>project_name</td><td>STRING</td></tr><tr><td>company_id</td><td>STRING</td></tr><tr><td>company_name</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>activitytype</td><td>STRING</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>extradescription</td><td>STRING</td></tr><tr><td>isprivate</td><td>STRING</td></tr><tr><td>itemid</td><td>STRING</td></tr><tr><td>itemlink</td><td>STRING</td></tr><tr><td>latestActivityType</td><td>STRING</td></tr><tr><td>link</td><td>STRING</td></tr><tr><td>lockdownId</td><td>STRING</td></tr><tr><td>publicinfo</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>due_date</td><td>STRING</td></tr><tr><td>userid</td><td>STRING</td></tr><tr><td>datetime</td><td>STRING</td></tr><tr><td>foruserid</td><td>STRING</td></tr><tr><td>forusername</td><td>STRING</td></tr><tr><td>for_user_avatar_url</td><td>STRING</td></tr><tr><td>from_user_avatar_url</td><td>STRING</td></tr><tr><td>fromusername</td><td>STRING</td></tr></tbody></table>

**AllLinks**

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

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>links</td><td>RECORD</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr></tbody></table>

**AllPeopleList**

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

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

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

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>lastChangedOn</td><td>STRING</td></tr><tr><td>createdByUserId</td><td>STRING</td></tr><tr><td>impact</td><td>STRING</td></tr><tr><td>impactSchedule</td><td>STRING</td></tr><tr><td>impactValue</td><td>STRING</td></tr><tr><td>projectId</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>probabilityValue</td><td>STRING</td></tr><tr><td>source</td><td>STRING</td></tr><tr><td>result</td><td>STRING</td></tr><tr><td>createdOn</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>lastChangedByUserId</td><td>STRING</td></tr><tr><td>deleted</td><td>BOOLEAN</td></tr><tr><td>createdByUserLastName</td><td>STRING</td></tr><tr><td>companyName</td><td>STRING</td></tr><tr><td>createdByUserFirstName</td><td>STRING</td></tr><tr><td>lastChangedByUserFirstName</td><td>STRING</td></tr><tr><td>projectName</td><td>STRING</td></tr><tr><td>projectIsActive</td><td>STRING</td></tr><tr><td>impactPerformance</td><td>STRING</td></tr><tr><td>mitigationPlan</td><td>STRING</td></tr><tr><td>probability</td><td>STRING</td></tr><tr><td>lastChangedByUserLastName</td><td>STRING</td></tr><tr><td>impactCost</td><td>STRING</td></tr><tr><td>companyId</td><td>STRING</td></tr></tbody></table>

**AllRunningTimers**

Allows you to access running timers for tasks.

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>dateDeleted</td><td>STRING</td></tr><tr><td>serverTime</td><td>STRING</td></tr><tr><td>intervals</td><td>RECORD</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>dateUpdated</td><td>STRING</td></tr><tr><td>projectName</td><td>STRING</td></tr><tr><td>projectId</td><td>STRING</td></tr><tr><td>billable</td><td>BOOLEAN</td></tr><tr><td>running</td><td>BOOLEAN</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>taskName</td><td>STRING</td></tr><tr><td>lastStartedAt</td><td>STRING</td></tr><tr><td>taskId</td><td>STRING</td></tr><tr><td>dateCreated</td><td>STRING</td></tr><tr><td>duration</td><td>STRING</td></tr><tr><td>deleted</td><td>BOOLEAN</td></tr><tr><td>userId</td><td>STRING</td></tr></tbody></table>

**AllTaskAcrossAllProjects**

Retrieves information about tasks across all projects.

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>boardColumn</td><td>RECORD</td></tr><tr><td>canComplete</td><td>BOOLEAN</td></tr><tr><td>comments_count</td><td>NUMERIC</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>has_reminders</td><td>BOOLEAN</td></tr><tr><td>has_unread_comments</td><td>BOOLEAN</td></tr><tr><td>private</td><td>NUMERIC</td></tr><tr><td>content</td><td>STRING</td></tr><tr><td>order</td><td>NUMERIC</td></tr><tr><td>project_id</td><td>NUMERIC</td></tr><tr><td>project_name</td><td>STRING</td></tr><tr><td>todo_list_id</td><td>NUMERIC</td></tr><tr><td>todo_list_name</td><td>STRING</td></tr><tr><td>tasklist_private</td><td>BOOLEAN</td></tr><tr><td>tasklist_isTemplate</td><td>BOOLEAN</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>company_name</td><td>STRING</td></tr><tr><td>company_id</td><td>NUMERIC</td></tr><tr><td>creator_id</td><td>NUMERIC</td></tr><tr><td>creator_firstname</td><td>STRING</td></tr><tr><td>creator_lastname</td><td>STRING</td></tr><tr><td>updater_id</td><td>NUMERIC</td></tr><tr><td>updater_firstname</td><td>STRING</td></tr><tr><td>updater_lastname</td><td>STRING</td></tr><tr><td>completed</td><td>BOOLEAN</td></tr><tr><td>start_date</td><td>STRING</td></tr><tr><td>due_date_base</td><td>STRING</td></tr><tr><td>due_date</td><td>STRING</td></tr><tr><td>created_on</td><td>STRING</td></tr><tr><td>last_changed_on</td><td>STRING</td></tr><tr><td>position</td><td>NUMERIC</td></tr><tr><td>estimated_minutes</td><td>NUMERIC</td></tr><tr><td>priority</td><td>STRING</td></tr><tr><td>progress</td><td>NUMERIC</td></tr><tr><td>harvest_enabled</td><td>BOOLEAN</td></tr><tr><td>parentTaskId</td><td>STRING</td></tr><tr><td>lockdownId</td><td>STRING</td></tr><tr><td>tasklist_lockdownId</td><td>STRING</td></tr><tr><td>has_dependencies</td><td>NUMERIC</td></tr><tr><td>has_predecessors</td><td>NUMERIC</td></tr><tr><td>hasTickets</td><td>BOOLEAN</td></tr><tr><td>tags</td><td>RECORD</td></tr><tr><td>timeIsLogged</td><td>STRING</td></tr><tr><td>attachments_count</td><td>NUMERIC</td></tr><tr><td>predecessors</td><td>STRING</td></tr><tr><td>canEdit</td><td>BOOLEAN</td></tr><tr><td>viewEstimatedTime</td><td>BOOLEAN</td></tr><tr><td>creator_avatar_url</td><td>STRING</td></tr><tr><td>canLogTime</td><td>BOOLEAN</td></tr><tr><td>commentFollowerSummary</td><td>STRING</td></tr><tr><td>commentFollowerIds</td><td>STRING</td></tr><tr><td>userFollowingComments</td><td>BOOLEAN</td></tr><tr><td>userFollowingChanges</td><td>BOOLEAN</td></tr><tr><td>DLM</td><td>NUMERIC</td></tr><tr><td>boardColumn.id</td><td>NUMERIC</td></tr><tr><td>boardColumn.name</td><td>STRING</td></tr><tr><td>boardColumn.color</td><td>STRING</td></tr></tbody></table>

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

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>position</td><td>NUMERIC</td></tr><tr><td>projectId</td><td>STRING</td></tr><tr><td>projectName</td><td>STRING</td></tr><tr><td>lastUpdated</td><td>STRING</td></tr><tr><td>private</td><td>BOOLEAN</td></tr><tr><td>isTemplate</td><td>BOOLEAN</td></tr><tr><td>tags</td><td>STRING</td></tr><tr><td>milestone_id</td><td>STRING</td></tr><tr><td>pinned</td><td>BOOLEAN</td></tr><tr><td>complete</td><td>BOOLEAN</td></tr><tr><td>uncompleted_count</td><td>NUMERIC</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>notifyTaskAssignee</td><td>BOOLEAN</td></tr></tbody></table>

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

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>project_id</td><td>STRING</td></tr><tr><td>author_lastname</td><td>STRING</td></tr><tr><td>commentable_id</td><td>STRING</td></tr><tr><td>commentable_type</td><td>STRING</td></tr><tr><td>emailed_from</td><td>STRING</td></tr><tr><td>isRead</td><td>STRING</td></tr><tr><td>private</td><td>STRING</td></tr><tr><td>lockdown_id</td><td>STRING</td></tr><tr><td>datetime</td><td>STRING</td></tr><tr><td>author_avatar_url</td><td>STRING</td></tr><tr><td>canEdit</td><td>BOOLEAN</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>company_name</td><td>STRING</td></tr><tr><td>last_changed_on</td><td>STRING</td></tr><tr><td>content_type</td><td>STRING</td></tr><tr><td>nr_notified_people</td><td>STRING</td></tr><tr><td>canDelete</td><td>BOOLEAN</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>item_name</td><td>STRING</td></tr><tr><td>attachments_count</td><td>STRING</td></tr><tr><td>_author_id</td><td>RECORD</td></tr><tr><td>company_id</td><td>STRING</td></tr><tr><td>canLike</td><td>BOOLEAN</td></tr><tr><td>html_body</td><td>STRING</td></tr><tr><td>project_name</td><td>STRING</td></tr><tr><td>body</td><td>STRING</td></tr><tr><td>commentNo</td><td>STRING</td></tr><tr><td>attachments</td><td>RECORD</td></tr><tr><td>author_firstname</td><td>STRING</td></tr><tr><td>author_company</td><td>STRING</td></tr><tr><td>comment_link</td><td>STRING</td></tr><tr><td>author_id</td><td>STRING</td></tr></tbody></table>

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

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>invoice_id</td><td>STRING</td></tr><tr><td>project_id</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>created_by_user_firstname</td><td>STRING</td></tr><tr><td>company_id</td><td>STRING</td></tr><tr><td>project_name</td><td>STRING</td></tr><tr><td>created_by_user_id</td><td>STRING</td></tr><tr><td>created_by_user_lastname</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>date</td><td>STRING</td></tr><tr><td>company_name</td><td>STRING</td></tr><tr><td>cost</td><td>STRING</td></tr></tbody></table>

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

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>project_id</td><td>STRING</td></tr><tr><td>author_first_name</td><td>STRING</td></tr><tr><td>milestone_id</td><td>STRING</td></tr><tr><td>contributingUsers</td><td>STRING</td></tr><tr><td>attachmentsCount</td><td>STRING</td></tr><tr><td>isRead</td><td>STRING</td></tr><tr><td>private</td><td>STRING</td></tr><tr><td>comments_count</td><td>STRING</td></tr><tr><td>author_avatar_url</td><td>STRING</td></tr><tr><td>author_last_name</td><td>STRING</td></tr><tr><td>tags</td><td>STRING</td></tr><tr><td>company_name</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>last_changed_on</td><td>STRING</td></tr><tr><td>content_type</td><td>STRING</td></tr><tr><td>isOriginal</td><td>STRING</td></tr><tr><td>user_display_posted_date</td><td>STRING</td></tr><tr><td>user_display_posted_time</td><td>STRING</td></tr><tr><td>attachments_count</td><td>STRING</td></tr><tr><td>category_color</td><td>STRING</td></tr><tr><td>post_id</td><td>STRING</td></tr><tr><td>userFollowing</td><td>BOOLEAN</td></tr><tr><td>category_id</td><td>STRING</td></tr><tr><td>followerIds</td><td>STRING</td></tr><tr><td>html_body</td><td>STRING</td></tr><tr><td>project_name</td><td>STRING</td></tr><tr><td>posted_on</td><td>STRING</td></tr><tr><td>body</td><td>STRING</td></tr><tr><td>attachments</td><td>STRING</td></tr><tr><td>last_comment_date</td><td>STRING</td></tr><tr><td>author_id</td><td>STRING</td></tr><tr><td>title</td><td>STRING</td></tr><tr><td>category_name</td><td>STRING</td></tr></tbody></table>

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

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>name</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>color</td><td>STRING</td></tr></tbody></table>

**Milestones:** Retrieves information related to project milestones.

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>projectType</td><td>STRING</td></tr><tr><td>canComplete</td><td>BOOLEAN</td></tr><tr><td>project_id</td><td>STRING</td></tr><tr><td>responsible_party_id</td><td>STRING</td></tr><tr><td>responsiblePartyFullNames</td><td>STRING</td></tr><tr><td>completed_on</td><td>STRING</td></tr><tr><td>private</td><td>BOOLEAN</td></tr><tr><td>userFollowingComments</td><td>BOOLEAN</td></tr><tr><td>comments_count</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>changeFollowerIds</td><td>STRING</td></tr><tr><td>created_on</td><td>STRING</td></tr><tr><td>tags</td><td>STRING</td></tr><tr><td>canEdit</td><td>BOOLEAN</td></tr><tr><td>responsible_party_type</td><td>STRING</td></tr><tr><td>isprivate</td><td>STRING</td></tr><tr><td>company_name</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>last_changed_on</td><td>STRING</td></tr><tr><td>commentFollowerIds</td><td>STRING</td></tr><tr><td>completed</td><td>BOOLEAN</td></tr><tr><td>reminder</td><td>STRING</td></tr><tr><td>tasklists</td><td>RECORD</td></tr><tr><td>userFollowingChanges</td><td>BOOLEAN</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>responsible_party_firstname</td><td>STRING</td></tr><tr><td>responsible_party_ids</td><td>STRING</td></tr><tr><td>responsible_party_names</td><td>STRING</td></tr><tr><td>responsible_party_lastname</td><td>STRING</td></tr><tr><td>company_id</td><td>STRING</td></tr><tr><td>creator_id</td><td>STRING</td></tr><tr><td>dueDateOffset</td><td>STRING</td></tr><tr><td>project_name</td><td>STRING</td></tr><tr><td>deadline</td><td>STRING</td></tr><tr><td>_isprivate</td><td>RECORD</td></tr><tr><td>title</td><td>STRING</td></tr></tbody></table>

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

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>announcement</td><td>STRING</td></tr><tr><td>announcementHTML</td><td>STRING</td></tr><tr><td>category</td><td>RECORD</td></tr><tr><td>company</td><td>RECORD</td></tr><tr><td>created_on</td><td>STRING</td></tr><tr><td>defaultPrivacy</td><td>STRING</td></tr><tr><td>defaults</td><td>RECORD</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>endDate</td><td>STRING</td></tr><tr><td>filesAutoNewVersion</td><td>BOOLEAN</td></tr><tr><td>harvest_timers_enabled</td><td>BOOLEAN</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>integrations</td><td>RECORD</td></tr><tr><td>isProjectAdmin</td><td>BOOLEAN</td></tr><tr><td>last_changed_on</td><td>STRING</td></tr><tr><td>logo</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>notifyeveryone</td><td>BOOLEAN</td></tr><tr><td>overview_start_page</td><td>STRING</td></tr><tr><td>privacyEnabled</td><td>BOOLEAN</td></tr><tr><td>replyByEmailEnabled</td><td>BOOLEAN</td></tr><tr><td>show_announcement</td><td>BOOLEAN</td></tr><tr><td>starred</td><td>BOOLEAN</td></tr><tr><td>startDate</td><td>STRING</td></tr><tr><td>start_page</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>subStatus</td><td>STRING</td></tr><tr><td>tags</td><td>STRING</td></tr><tr><td>tasks_start_page</td><td>STRING</td></tr></tbody></table>

**ProjectCategories:** Manages project categories or groupings.

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>parent_id</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>count</td><td>STRING</td></tr><tr><td>elements_count</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>color</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr></tbody></table>

**ProjectRole:** Deals with user roles and permissions within projects.

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>projectId</td><td>STRING</td></tr><tr><td>users</td><td>RECORD</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>id</td><td>INTEGER</td></tr></tbody></table>

**ProjectUpdates:** Retrieves updates and changes made to projects.

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>projectId</td><td>STRING</td></tr><tr><td>deletedDate</td><td>STRING</td></tr><tr><td>text</td><td>STRING</td></tr><tr><td>health</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>dateCreated</td><td>STRING</td></tr><tr><td>color</td><td>STRING</td></tr><tr><td>deleted</td><td>STRING</td></tr><tr><td>user</td><td>RECORD</td></tr></tbody></table>

**TimeEntriesAcrossAllProjects:** Retrieves time entries across all projects.

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>status</td><td>STRING</td></tr><tr><td>billableType</td><td>STRING</td></tr><tr><td>invoicedType</td><td>STRING</td></tr><tr><td>canEdit</td><td>BOOLEAN</td></tr><tr><td>company_id</td><td>STRING</td></tr><tr><td>company_name</td><td>STRING</td></tr><tr><td>createdAt</td><td>STRING</td></tr><tr><td>date</td><td>STRING</td></tr><tr><td>dateUserPerspective</td><td>STRING</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>has_start_time</td><td>STRING</td></tr><tr><td>hours</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>invoiceNo</td><td>STRING</td></tr><tr><td>invoiceStatus</td><td>STRING</td></tr><tr><td>isbillable</td><td>STRING</td></tr><tr><td>isbilled</td><td>STRING</td></tr><tr><td>minutes</td><td>STRING</td></tr><tr><td>parentTaskId</td><td>STRING</td></tr><tr><td>parentTaskName</td><td>STRING</td></tr><tr><td>project_id</td><td>STRING</td></tr><tr><td>project_name</td><td>STRING</td></tr><tr><td>project_status</td><td>STRING</td></tr><tr><td>tags</td><td>STRING</td></tr><tr><td>taskEstimatedTime</td><td>STRING</td></tr><tr><td>todo_item_id</td><td>STRING</td></tr><tr><td>taskIsPrivate</td><td>STRING</td></tr><tr><td>taskIsSubTask</td><td>STRING</td></tr><tr><td>todo_item_name</td><td>STRING</td></tr><tr><td>task_tags</td><td>STRING</td></tr><tr><td>todo_list_id</td><td>STRING</td></tr><tr><td>tasklistId</td><td>STRING</td></tr><tr><td>todo_list_name</td><td>STRING</td></tr><tr><td>ticket_id</td><td>STRING</td></tr><tr><td>updated_date</td><td>STRING</td></tr><tr><td>person_first_name</td><td>STRING</td></tr><tr><td>person_id</td><td>STRING</td></tr><tr><td>person_last_name</td><td>STRING</td></tr></tbody></table>

**TimeTotalAcrossProjects:** Calculates the total time spent across all projects.

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>company</td><td>RECORD</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>totalNonBilledMins</td><td>STRING</td></tr><tr><td>totalBillableHours</td><td>STRING</td></tr><tr><td>totalBillableMins</td><td>STRING</td></tr><tr><td>totalNonBillableMins</td><td>STRING</td></tr><tr><td>totalMins</td><td>STRING</td></tr><tr><td>totalNonBillableHours</td><td>STRING</td></tr><tr><td>totalBilledHours</td><td>STRING</td></tr><tr><td>totalHours</td><td>STRING</td></tr><tr><td>totalNonBilledHours</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>totalBilledTime</td><td>STRING</td></tr><tr><td>totalBilledMins</td><td>STRING</td></tr></tbody></table>

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

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>projectID</td><td>STRING</td></tr><tr><td>projectType</td><td>STRING</td></tr><tr><td>company</td><td>RECORD</td></tr><tr><td>time_estimates</td><td>RECORD</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>time_totals</td><td>RECORD</td></tr></tbody></table>

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

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>first_name</td><td>STRING</td></tr><tr><td>reset</td><td>BOOLEAN</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>neverUpdated</td><td>BOOLEAN</td></tr><tr><td>last_name</td><td>STRING</td></tr><tr><td>updated_date</td><td>STRING</td></tr><tr><td>statusHTML</td><td>STRING</td></tr><tr><td>geoipLocation</td><td>STRING</td></tr><tr><td>posted_on</td><td>STRING</td></tr><tr><td>avatar_url</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>last_changed_on</td><td>STRING</td></tr><tr><td>userId</td><td>STRING</td></tr><tr><td>isClockedIn</td><td>STRING</td></tr></tbody></table>

### Teamwork v2 APIs

For more information, see [Teamwork v2 API documentation](https://apidocs.teamwork.com/docs/teamwork/78ae9cf8b92bc-teamwork-api-v2).

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

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>id</td><td>INTEGER</td></tr><tr><td>entity</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>isPrivate</td><td>BOOLEAN</td></tr><tr><td>required</td><td>BOOLEAN</td></tr><tr><td>createdAt</td><td>TIMESTAMP</td></tr><tr><td>createdByUserId</td><td>INTEGER</td></tr><tr><td>createdBy</td><td>INTEGER</td></tr><tr><td>updatedAt</td><td>TIMESTAMP</td></tr><tr><td>updatedByUserId</td><td>INTEGER</td></tr><tr><td>updatedBy</td><td>INTEGER</td></tr><tr><td>deleted</td><td>BOOLEAN</td></tr></tbody></table>

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

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>id</td><td>INTEGER</td></tr><tr><td>entity</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>isPrivate</td><td>BOOLEAN</td></tr><tr><td>required</td><td>BOOLEAN</td></tr><tr><td>createdAt</td><td>TIMESTAMP</td></tr><tr><td>createdByUserId</td><td>INTEGER</td></tr><tr><td>createdBy</td><td>INTEGER</td></tr><tr><td>updatedAt</td><td>TIMESTAMP</td></tr><tr><td>updatedByUserId</td><td>INTEGER</td></tr><tr><td>updatedBy</td><td>INTEGER</td></tr><tr><td>deleted</td><td>BOOLEAN</td></tr></tbody></table>

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

**FIELDS**

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

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

**FIELDS**

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

### Teamwork v3 APIs

For more information, see [Teamwork v3 API documentation](https://apidocs.teamwork.com/docs/teamwork/1686380931896-teamwork-api-v3).

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

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>users</td><td>RECORD</td></tr><tr><td>tasks</td><td>RECORD</td></tr><tr><td>tasklists</td><td>RECORD</td></tr><tr><td>projects</td><td>RECORD</td></tr></tbody></table>

**V3\_AllRunningTimers:** Returns a list of all running timers but with basic information without details.

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>billable</td><td>BOOLEAN</td></tr><tr><td>createdAt</td><td>STRING</td></tr><tr><td>deleted</td><td>BOOLEAN</td></tr><tr><td>deletedAt</td><td>STRING</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>duration</td><td>INTEGER</td></tr><tr><td>id</td><td>INTEGER</td></tr><tr><td>intervals</td><td>RECORD</td></tr><tr><td>lastStartedAt</td><td>STRING</td></tr><tr><td>projectId</td><td>INTEGER</td></tr><tr><td>running</td><td>BOOLEAN</td></tr><tr><td>serverTime</td><td>STRING</td></tr><tr><td>taskId</td><td>INTEGER</td></tr><tr><td>timeLogId</td><td>INTEGER</td></tr><tr><td>timerLastIntervalEnd</td><td>STRING</td></tr><tr><td>updatedAt</td><td>STRING</td></tr><tr><td>userId</td><td>INTEGER</td></tr></tbody></table>

**V3\_AllTimeEntries:** Retrieves a list of all time entries recorded in Teamwork, possibly without additional details.

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>billable</td><td>BOOLEAN</td></tr><tr><td>dateCreated</td><td>STRING</td></tr><tr><td>dateDeleted</td><td>STRING</td></tr><tr><td>dateEdited</td><td>STRING</td></tr><tr><td>deleted</td><td>BOOLEAN</td></tr><tr><td>deletedByUserId</td><td>INTEGER</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>deskTicketId</td><td>INTEGER</td></tr><tr><td>editedByUserId</td><td>INTEGER</td></tr><tr><td>hasStartTime</td><td>BOOLEAN</td></tr><tr><td>id</td><td>INTEGER</td></tr><tr><td>invoiceNumber</td><td>STRING</td></tr><tr><td>loggedByUserId</td><td>INTEGER</td></tr><tr><td>minutes</td><td>INTEGER</td></tr><tr><td>projectBillingInvoiceId</td><td>INTEGER</td></tr><tr><td>projectId</td><td>INTEGER</td></tr><tr><td>taskId</td><td>INTEGER</td></tr><tr><td>taskIdPreMove</td><td>INTEGER</td></tr><tr><td>timeLogged</td><td>STRING</td></tr><tr><td>userId</td><td>INTEGER</td></tr></tbody></table>

**V3\_AllTimeEntriesWithDetails:** This API is similar to the above but with more detailed information included for each time entry.

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>users</td><td>RECORD</td></tr><tr><td>tasks</td><td>RECORD</td></tr><tr><td>tasklists</td><td>RECORD</td></tr><tr><td>projects</td><td>RECORD</td></tr></tbody></table>

**V3\_TimeLogTotals:** Provides totals or summaries of time logged for various tasks, projects, or users within a specified time period.

**FIELDS**

<table><thead><tr><th width="85">Field Name</th><th width="85">Data Type</th></tr></thead><tbody><tr><td>projectID</td><td>INTEGER</td></tr><tr><td>projectType</td><td>STRING</td></tr><tr><td>estimatedMinutesActive</td><td>INTEGER</td></tr><tr><td>estimatedMinutesCompleted</td><td>INTEGER</td></tr><tr><td>estimatedMinutesFiltered</td><td>INTEGER</td></tr><tr><td>estimatedMinutesWithLoggedTime</td><td>INTEGER</td></tr><tr><td>minutes</td><td>INTEGER</td></tr><tr><td>minutesBillable</td><td>INTEGER</td></tr><tr><td>minutesBilled</td><td>INTEGER</td></tr><tr><td>minutesNonBillable</td><td>INTEGER</td></tr><tr><td>minutesNonBilled</td><td>INTEGER</td></tr></tbody></table>