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


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/business/teamwork/schema-information.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.