---
description: >-
  This subtopic provides a structured reference to assist you in working with
  Daton's Teamwork connector and the associated fields and tables.
---

# Schema Information

## Tables/APIs&#x20;

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&#x20;

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

* [AllProjects\_V1](#allprojects_v1)&#x20;
* [AllTags\_V1](#alltags_v1)&#x20;
* [LatestActivity\_V1](#latestactivity_v1)&#x20;
* [AllMilestones\_V1](#allmilestones_v1)&#x20;
* [AllTaskLists\_V1](#alltasklists_v1)&#x20;
* [AllPeople\_V1](#allpeople_v1)&#x20;
* [TimeEntriesAcrossallProjects\_V1 ](#timeentriesacrossallprojects_v1)
* [TimeTotalAcrossProjects\_V1](#timetotalacrossprojects_v1)&#x20;
* [CommentsAcrossAllType\_V1](#commentsacrossalltype_v1)&#x20;
* [ProjectCategories\_V1](#projectcategories_v1)&#x20;
* [AllExpenses\_V1](#allexpenses_v1)&#x20;
* [AllProjects\_V1](#allprojects_v1)&#x20;
* [AllTags\_V1](#alltags_v1)&#x20;
* [LatestActivity\_V1](#latestactivity_v1)&#x20;
* [AllMilestones\_V1](#allmilestones_v1)&#x20;
* [AllTaskLists\_V1](#alltasklists_v1)&#x20;
* [AllPeople\_V1](#allpeople_v1)&#x20;
* [TimeEntriesAcrossallProjects\_V1](#timeentriesacrossallprojects_v1)&#x20;
* [TimeTotalAcrossProjects\_V1](#timetotalacrossprojects_v1)&#x20;
* [CommentsAcrossAllType\_V1](#commentsacrossalltype_v1)&#x20;
* [ProjectCategories\_V1](#projectcategories_v1)&#x20;
* [AllExpenses\_V1](#allexpenses_v1)&#x20;

#### AllProjects\_V1&#x20;

Retrieves a list of all projects in the Teamwork workspace.

**FIELDS**

<table><thead><tr><th width="104">Field Name</th><th width="104">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>TIMESTAMP</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>DATE</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>isBillable</td><td>BOOLEAN</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>last-changed-on</td><td>TIMESTAMP</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>DATE</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>tasks-start-page</td><td>STRING</td></tr></tbody></table>

#### AllTags\_V1&#x20;

Provides access to all tags used in Teamwork projects, aiding in categorization and organization.

**FIELDS**

<table><thead><tr><th width="104">Field Name</th><th width="104">Data Type</th></tr></thead><tbody><tr><td>dateUpdated</td><td>TIMESTAMP</td></tr><tr><td>color</td><td>STRING</td></tr><tr><td>projectId</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>dateCreated</td><td>TIMESTAMP</td></tr><tr><td>name</td><td>STRING</td></tr></tbody></table>

#### LatestActivity\_V1&#x20;

Fetches the most recent activity updates and changes in the Teamwork workspace.

**FIELDS**

<table><thead><tr><th width="104">Field Name</th><th width="104">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>TIMESTAMP</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>

#### AllMilestones\_V1&#x20;

Retrieves a list of milestones within Teamwork projects, helping to track project progress.

**FIELDS**

<table><thead><tr><th width="104">Field Name</th><th width="104">Data Type</th></tr></thead><tbody><tr><td>project-name</td><td>STRING</td></tr><tr><td>userFollowingComments</td><td>BOOLEAN</td></tr><tr><td>tasklists</td><td>RECORD</td></tr><tr><td>changeFollowerIds</td><td>STRING</td></tr><tr><td>last-changed-on</td><td>TIMESTAMP</td></tr><tr><td>completer-firstname</td><td>STRING</td></tr><tr><td>created-on</td><td>TIMESTAMP</td></tr><tr><td>reminder</td><td>STRING</td></tr><tr><td>project-id</td><td>STRING</td></tr><tr><td>completer-lastname</td><td>STRING</td></tr><tr><td>completed</td><td>BOOLEAN</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>completer-id</td><td>STRING</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>responsible-party-lastname</td><td>STRING</td></tr><tr><td>responsible-party-firstname</td><td>STRING</td></tr><tr><td>responsiblePartyNames</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>creator-id</td><td>STRING</td></tr><tr><td>responsiblePartyFullNames</td><td>STRING</td></tr><tr><td>commentFollowerIds</td><td>STRING</td></tr><tr><td>dueDateOffset</td><td>STRING</td></tr><tr><td>company-name</td><td>STRING</td></tr><tr><td>canEdit</td><td>BOOLEAN</td></tr><tr><td>isprivate</td><td>STRING</td></tr><tr><td>company-id</td><td>STRING</td></tr><tr><td>comments-count</td><td>STRING</td></tr><tr><td>responsible-party-type</td><td>STRING</td></tr><tr><td>canComplete</td><td>BOOLEAN</td></tr><tr><td>private</td><td>BOOLEAN</td></tr><tr><td>deadline</td><td>DATE</td></tr><tr><td>completed-on</td><td>TIMESTAMP</td></tr><tr><td>userFollowingChanges</td><td>BOOLEAN</td></tr><tr><td>title</td><td>STRING</td></tr></tbody></table>

#### AllTaskLists\_V1&#x20;

Offers access to all task lists within Teamwork projects for efficient task management.

**FIELDS**

<table><thead><tr><th width="104">Field Name</th><th width="104">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>TIMESTAMP</td></tr><tr><td>createdAt</td><td>TIMESTAMP</td></tr><tr><td>private</td><td>BOOLEAN</td></tr><tr><td>isTemplate</td><td>BOOLEAN</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>

#### AllPeople\_V1&#x20;

Retrieves a list of all users and team members in the Teamwork workspace.

**FIELDS**

<table><thead><tr><th width="104">Field Name</th><th width="104">Data Type</th></tr></thead><tbody><tr><td>permissions</td><td>RECORD</td></tr><tr><td>avatar-url</td><td>STRING</td></tr><tr><td>last-changed-on</td><td>TIMESTAMP</td></tr><tr><td>email-address</td><td>STRING</td></tr><tr><td>last-login</td><td>TIMESTAMP</td></tr><tr><td>address-country</td><td>STRING</td></tr><tr><td>user-invite-accepted-date</td><td>TIMESTAMP</td></tr><tr><td>textFormat</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-fax</td><td>STRING</td></tr><tr><td>site-owner</td><td>BOOLEAN</td></tr><tr><td>address-city</td><td>STRING</td></tr><tr><td>company-name</td><td>STRING</td></tr><tr><td>user-invited-date</td><td>TIMESTAMP</td></tr><tr><td>phone-number-mobile</td><td>STRING</td></tr><tr><td>user-type</td><td>STRING</td></tr><tr><td>full-name</td><td>STRING</td></tr><tr><td>useShorthandDurations</td><td>BOOLEAN</td></tr><tr><td>address-zip</td><td>STRING</td></tr><tr><td>openId</td><td>STRING</td></tr><tr><td>address</td><td>RECORD</td></tr><tr><td>phone-number-office</td><td>STRING</td></tr><tr><td>im-handle</td><td>STRING</td></tr><tr><td>isClientUser</td><td>BOOLEAN</td></tr><tr><td>twoFactorAuthEnabled</td><td>BOOLEAN</td></tr><tr><td>has-access-to-new-projects</td><td>BOOLEAN</td></tr><tr><td>last-active</td><td>TIMESTAMP</td></tr><tr><td>im-service</td><td>STRING</td></tr><tr><td>deleted</td><td>BOOLEAN</td></tr><tr><td>notes</td><td>STRING</td></tr><tr><td>in-owner-company</td><td>BOOLEAN</td></tr><tr><td>user-invited-status</td><td>STRING</td></tr><tr><td>profile</td><td>STRING</td></tr><tr><td>userUUID</td><td>STRING</td></tr><tr><td>user-invited</td><td>STRING</td></tr><tr><td>created-at</td><td>TIMESTAMP</td></tr><tr><td>isServiceAccount</td><td>BOOLEAN</td></tr><tr><td>phone-number-home</td><td>STRING</td></tr><tr><td>profile-text</td><td>STRING</td></tr><tr><td>pid</td><td>STRING</td></tr><tr><td>phone-number-mobile-parts</td><td>RECORD</td></tr><tr><td>address-line-2</td><td>STRING</td></tr><tr><td>address-state</td><td>STRING</td></tr><tr><td>login-count</td><td>STRING</td></tr><tr><td>address-line-1</td><td>STRING</td></tr><tr><td>email-alt-1</td><td>STRING</td></tr><tr><td>administrator</td><td>BOOLEAN</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><tr><td>last-name</td><td>STRING</td></tr><tr><td>first-name</td><td>STRING</td></tr><tr><td>phone-number-office-ext</td><td>STRING</td></tr><tr><td>twitter</td><td>STRING</td></tr><tr><td>lengthOfDay</td><td>STRING</td></tr></tbody></table>

#### TimeEntriesAcrossallProjects\_V1&#x20;

Allows for the retrieval of time entries across all projects, aiding in time tracking and project management.

**FIELDS**

<table><thead><tr><th width="104">Field Name</th><th width="104">Data Type</th></tr></thead><tbody><tr><td>avatarUrl</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>TIMESTAMP</td></tr><tr><td>date</td><td>TIMESTAMP</td></tr><tr><td>dateUserPerspective</td><td>TIMESTAMP</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>hoursDecimal</td><td>NUMERIC</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>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>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>TIMESTAMP</td></tr><tr><td>userDeleted</td><td>BOOLEAN</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\_V1&#x20;

Calculates and provides the total time spent across multiple projects.

**FIELDS**

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

#### CommentsAcrossAllType\_V1&#x20;

Provides access to comments across all types of items within Teamwork, facilitating communication and collaboration.

**FIELDS**

<table><thead><tr><th width="104">Field Name</th><th width="104">Data Type</th></tr></thead><tbody><tr><td>project-name</td><td>STRING</td></tr><tr><td>nr-notified-people</td><td>STRING</td></tr><tr><td>comment-link</td><td>STRING</td></tr><tr><td>author_id</td><td>STRING</td></tr><tr><td>author-avatar-url</td><td>STRING</td></tr><tr><td>last-changed-on</td><td>TIMESTAMP</td></tr><tr><td>author-lastname</td><td>STRING</td></tr><tr><td>author-firstname</td><td>STRING</td></tr><tr><td>isRead</td><td>STRING</td></tr><tr><td>lockdown-id</td><td>STRING</td></tr><tr><td>author-company</td><td>STRING</td></tr><tr><td>commentable-id</td><td>STRING</td></tr><tr><td>project-id</td><td>STRING</td></tr><tr><td>author-id</td><td>STRING</td></tr><tr><td>attachments-count</td><td>STRING</td></tr><tr><td>content-type</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>canLike</td><td>BOOLEAN</td></tr><tr><td>_author_id</td><td>RECORD</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>company-name</td><td>STRING</td></tr><tr><td>canEdit</td><td>BOOLEAN</td></tr><tr><td>company-id</td><td>STRING</td></tr><tr><td>html-body</td><td>STRING</td></tr><tr><td>private</td><td>STRING</td></tr><tr><td>canDelete</td><td>BOOLEAN</td></tr><tr><td>commentable_type</td><td>STRING</td></tr><tr><td>datetime</td><td>TIMESTAMP</td></tr><tr><td>attachments_count</td><td>STRING</td></tr><tr><td>commentNo</td><td>STRING</td></tr><tr><td>emailed-from</td><td>STRING</td></tr><tr><td>body</td><td>STRING</td></tr><tr><td>item-name</td><td>STRING</td></tr></tbody></table>

#### ProjectCategories\_V1&#x20;

Retrieves a list of project categories, aiding in project organization.

**FIELDS**

<table><thead><tr><th width="104">Field Name</th><th width="104">Data Type</th></tr></thead><tbody><tr><td>elements_count</td><td>STRING</td></tr><tr><td>parent-id</td><td>STRING</td></tr><tr><td>color</td><td>STRING</td></tr><tr><td>count</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>elements-count</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr></tbody></table>

#### AllExpenses\_V1&#x20;

Offers access to all expenses recorded in Teamwork projects for financial tracking.

**FIELDS**

<table><thead><tr><th width="104">Field Name</th><th width="104">Data Type</th></tr></thead><tbody><tr><td>project-name</td><td>STRING</td></tr><tr><td>company-name</td><td>STRING</td></tr><tr><td>created-by-user-id</td><td>STRING</td></tr><tr><td>invoice-id</td><td>STRING</td></tr><tr><td>company-id</td><td>STRING</td></tr><tr><td>updated-date</td><td>TIMESTAMP</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>date</td><td>DATE</td></tr><tr><td>project-id</td><td>STRING</td></tr><tr><td>created-by-user-firstname</td><td>STRING</td></tr><tr><td>cost</td><td>STRING</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>created-by-user-lastname</td><td>STRING</td></tr></tbody></table>

#### UserStatuses\_V1

This API provides information about the statuses of users, which can be helpful for tracking and managing user activities and availability.

**FIELDS**

<table><thead><tr><th width="104">Field Name</th><th width="104">Data Type</th></tr></thead><tbody><tr><td>geoipLocation</td><td>STRING</td></tr><tr><td>posted-on</td><td>TIMESTAMP</td></tr><tr><td>first-name</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>TIMESTAMP</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>last-name</td><td>STRING</td></tr><tr><td>userId</td><td>STRING</td></tr><tr><td>isClockedIn</td><td>STRING</td></tr></tbody></table>

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

<table><thead><tr><th width="104">Field Name</th><th width="104">Data Type</th></tr></thead><tbody><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-userfirstname</td><td>STRING</td></tr><tr><td>height</td><td>STRING</td></tr><tr><td>private</td><td>STRING</td></tr><tr><td>width</td><td>STRING</td></tr><tr><td>created-by-userId</td><td>STRING</td></tr><tr><td>created-by-userlastname</td><td>STRING</td></tr><tr><td>category-id</td><td>STRING</td></tr><tr><td>open-in-new-window</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>provider</td><td>STRING</td></tr><tr><td>created-date</td><td>TIMESTAMP</td></tr><tr><td>category-name</td><td>STRING</td></tr><tr><td>code</td><td>STRING</td></tr></tbody></table>

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

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

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

<table><thead><tr><th width="104">Field Name</th><th width="104">Data Type</th></tr></thead><tbody><tr><td>user-display-posted-time</td><td>STRING</td></tr><tr><td>project-id</td><td>STRING</td></tr><tr><td>author-first-name</td><td>STRING</td></tr><tr><td>attachments-count</td><td>STRING</td></tr><tr><td>milestone-id</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>category-id</td><td>STRING</td></tr><tr><td>author-last-name</td><td>STRING</td></tr><tr><td>posted-on</td><td>TIMESTAMP</td></tr><tr><td>body</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>last-changed-on</td><td>TIMESTAMP</td></tr><tr><td>content-type</td><td>STRING</td></tr><tr><td>last-comment-date</td><td>TIMESTAMP</td></tr><tr><td>user-display-posted-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>

#### AllRisks\_V1

This API provides insights into project or task risks, which can help with risk management and mitigation.

**FIELDS**

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

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

<table><thead><tr><th width="104">Field Name</th><th width="104">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</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>descriptionContentType</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>decimalOrder</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>TIMESTAMP</td></tr><tr><td>last-changed-on</td><td>TIMESTAMP</td></tr><tr><td>position</td><td>NUMERIC</td></tr><tr><td>decimal-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>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>commentFollowerIds</td><td>STRING</td></tr><tr><td>changeFollowerIds</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></tbody></table>

#### ProjectUpdates\_V1

The ProjectUpdates API offers access to updates and changes related to specific projects, ensuring that you are informed about project developments.

**FIELDS**

<table><thead><tr><th width="104">Field Name</th><th width="104">Data Type</th></tr></thead><tbody><tr><td>deletedDate</td><td>STRING</td></tr><tr><td>projectId</td><td>STRING</td></tr><tr><td>color</td><td>STRING</td></tr><tr><td>projectStatus</td><td>STRING</td></tr><tr><td>text</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>health</td><td>STRING</td></tr><tr><td>deleted</td><td>BOOLEAN</td></tr><tr><td>user</td><td>RECORD</td></tr><tr><td>projectName</td><td>STRING</td></tr><tr><td>dateCreated</td><td>TIMESTAMP</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).

* [ProjectsTemplates\_V2](#projectstemplates_v2)&#x20;
* [CustomFieldonTasks\_V2](#customfieldontasks_v2)
* [CustomFieldonProjects\_V2](#customfieldontasks_v2)

#### ProjectsTemplates\_V2 &#x20;

Provides templates for creating new projects, streamlining project setup.

**FIELDS**

<table><thead><tr><th width="104">Field Name</th><th width="104">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>category</td><td>RECORD</td></tr><tr><td>company</td><td>RECORD</td></tr><tr><td>createdOn</td><td>TIMESTAMP</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>NUMERIC</td></tr><tr><td>integrations</td><td>RECORD</td></tr><tr><td>isBillable</td><td>BOOLEAN</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>TIMESTAMP</td></tr><tr><td>logo</td><td>STRING</td></tr><tr><td>minMaxAvailableDates</td><td>RECORD</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>NUMERIC</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>templateDateTargetDefault</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr></tbody></table>

#### CustomFieldonTasks\_V2&#x20;

Allows for the addition of custom fields to tasks for more detailed task management.

**FIELDS**

<table><thead><tr><th width="104">Field Name</th><th width="104">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</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>NUMERIC</td></tr><tr><td>isArchived</td><td>BOOLEAN</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>descriptionContentType</td><td>STRING</td></tr><tr><td>boardColumn</td><td>RECORD</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>TIMESTAMP</td></tr><tr><td>dateChanged</td><td>TIMESTAMP</td></tr><tr><td>dateLastModified</td><td>TIMESTAMP</td></tr><tr><td>hasFollowers</td><td>BOOLEAN</td></tr><tr><td>hasLoggedTime</td><td>BOOLEAN</td></tr><tr><td>hasProofs</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>NUMERIC</td></tr><tr><td>privacyIsInherited</td><td>BOOLEAN</td></tr><tr><td>lockdownId</td><td>NUMERIC</td></tr><tr><td>numMinutesLogged</td><td>NUMERIC</td></tr><tr><td>numBillableMinutesLogged</td><td>NUMERIC</td></tr><tr><td>numTotalMinutesLogged</td><td>NUMERIC</td></tr><tr><td>numActiveSubTasks</td><td>NUMERIC</td></tr><tr><td>numAttachments</td><td>NUMERIC</td></tr><tr><td>numComments</td><td>NUMERIC</td></tr><tr><td>numCommentsRead</td><td>NUMERIC</td></tr><tr><td>numCompletedSubTasks</td><td>NUMERIC</td></tr><tr><td>numDependencies</td><td>NUMERIC</td></tr><tr><td>numEstMins</td><td>NUMERIC</td></tr><tr><td>numPredecessors</td><td>NUMERIC</td></tr><tr><td>position</td><td>NUMERIC</td></tr><tr><td>projectId</td><td>NUMERIC</td></tr><tr><td>startDate</td><td>DATE</td></tr><tr><td>tags</td><td>RECORD</td></tr><tr><td>assignedTo</td><td>RECORD</td></tr><tr><td>dueDate</td><td>DATE</td></tr><tr><td>dueDateFromMilestone</td><td>BOOLEAN</td></tr><tr><td>taskListId</td><td>NUMERIC</td></tr><tr><td>progress</td><td>NUMERIC</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>cardId</td><td>NUMERIC</td></tr><tr><td>order</td><td>NUMERIC</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>NUMERIC</td></tr></tbody></table>

#### CustomFieldonProjects\_V2

This API allows you to work with custom fields associated with projects, providing flexibility for data management and customization.

**FIELDS**

<table><thead><tr><th width="104">Field Name</th><th width="104">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>category</td><td>RECORD</td></tr><tr><td>company</td><td>RECORD</td></tr><tr><td>createdOn</td><td>TIMESTAMP</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>endDate</td><td>DATE</td></tr><tr><td>filesAutoNewVersion</td><td>BOOLEAN</td></tr><tr><td>harvestTimersEnabled</td><td>BOOLEAN</td></tr><tr><td>id</td><td>NUMERIC</td></tr><tr><td>integrations</td><td>RECORD</td></tr><tr><td>isBillable</td><td>BOOLEAN</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>TIMESTAMP</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>NUMERIC</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>startDate</td><td>DATE</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>customField_id</td><td>STRING</td></tr><tr><td>customField</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).

* [AllTimeEntries\_V3](#alltimeentries_v3)&#x20;
* [AllTasks\_V3](#alltags_v1)

#### AllTimeEntries\_V3

Retrieves all time entries in Teamwork, aiding in time tracking and reporting for tasks and projects.

**FIELDS**

<table><thead><tr><th width="104">Field Name</th><th width="104">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>dateCreated</td><td>TIMESTAMP</td></tr><tr><td>createdAt</td><td>TIMESTAMP</td></tr><tr><td>minutes</td><td>NUMERIC</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>timeLogged</td><td>TIMESTAMP</td></tr><tr><td>billable</td><td>BOOLEAN</td></tr><tr><td>isBillable</td><td>BOOLEAN</td></tr><tr><td>deleted</td><td>BOOLEAN</td></tr><tr><td>hasStartTime</td><td>BOOLEAN</td></tr><tr><td>dateEdited</td><td>TIMESTAMP</td></tr><tr><td>updatedAt</td><td>TIMESTAMP</td></tr><tr><td>userId</td><td>NUMERIC</td></tr><tr><td>user</td><td>RECORD</td></tr><tr><td>taskId</td><td>NUMERIC</td></tr><tr><td>task</td><td>RECORD</td></tr><tr><td>projectId</td><td>NUMERIC</td></tr><tr><td>project</td><td>RECORD</td></tr><tr><td>loggedByUserId</td><td>NUMERIC</td></tr><tr><td>loggedBy</td><td>NUMERIC</td></tr><tr><td>editedByUserId</td><td>NUMERIC</td></tr><tr><td>updatedBy</td><td>NUMERIC</td></tr></tbody></table>

#### AllTasks\_V3

It provides access to all tasks, which can help in tracking and managing tasks across different projects or teams.

**FIELDS**

<table><thead><tr><th width="104">Field Name</th><th width="104">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>descriptionContentType</td><td>STRING</td></tr><tr><td>hasDeskTickets</td><td>BOOLEAN</td></tr><tr><td>progress</td><td>NUMERIC</td></tr><tr><td>displayOrder</td><td>NUMERIC</td></tr><tr><td>decimalDisplayOrder</td><td>NUMERIC</td></tr><tr><td>updatedAt</td><td>TIMESTAMP</td></tr><tr><td>updatedBy</td><td>NUMERIC</td></tr><tr><td>isPrivate</td><td>NUMERIC</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>tasklist</td><td>RECORD</td></tr><tr><td>dueDate</td><td>TIMESTAMP</td></tr><tr><td>estimateMinutes</td><td>NUMERIC</td></tr><tr><td>accumulatedEstimatedMinutes</td><td>NUMERIC</td></tr><tr><td>commentFollowers</td><td>RECORD</td></tr><tr><td>isArchived</td><td>BOOLEAN</td></tr><tr><td>userPermissions</td><td>RECORD</td></tr><tr><td>createdBy</td><td>NUMERIC</td></tr><tr><td>createdAt</td><td>TIMESTAMP</td></tr><tr><td>dateUpdated</td><td>TIMESTAMP</td></tr><tr><td>parentTaskId</td><td>NUMERIC</td></tr><tr><td>tasklistId</td><td>NUMERIC</td></tr><tr><td>createdByUserId</td><td>NUMERIC</td></tr></tbody></table>
