LogoLogo
Daton
Daton
  • Daton Defined: From Web App Essentials to Advanced Integrations
  • Platform
    • Essentials
      • Billing
      • Integrate Facebook Ads on Daton
      • Integrate Shopify on Daton
      • Integrate Google Analytics on Daton
      • Access permissions for Daton
      • How to get started with Daton setup
      • Terminology in Daton
        • Source and Source_Table statuses
      • Various pages in Daton
    • Features
      • Navigating the pages in Daton
        • Notifications
        • Logs
        • Dashboard
        • My Account
        • Connectors
        • My Integrations
        • Integration Details
      • Templates
      • Account Management
        • My Account Page
      • Notifications
      • Monitoring
        • Logging and Log Retention
      • Manage Integrations
        • Handling Changes to Schema
        • Modifying an integration
      • Data
        • Handling Nested Data
        • Daton Metadata
        • Inserts, Updates, and Upserts
        • Data Type Mapping
        • Data Replication in Daton
          • Replication Fields
          • Replication Methods
            • Key-based Incremental Replication
      • Knowledge Base
        • What is ELT and how is it different from traditional ETL tools
          • Billing
      • Pipelines
        • Pipeline Jobs
        • Loading Behavior
      • Security
      • Feature Updates
        • Amazon Vendor Central
  • Connectors
    • Data Sources
      • Advertising
        • Adjust v1
        • Adjust v2
          • About Adjust v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Adjust v2 with Daton
          • Schema Information
        • Amazon Ads
          • Release Notes
        • Amazon Attribution
          • Release Notes
        • Amazon Brand Metrics
          • About Amazon Brand Metrics
          • Essential Attributes and Supported Tables
          • How to Integrate Amazon Brand Metrics with Daton
          • Schema Infomation
        • Amazon DSP V1
          • Release Notes
        • Amazon DSP V2
        • Amazon Marketing Cloud (AMC)
        • Amazon Marketing Streams
          • About Amazon Marketing Streams Connector
          • Essential Attributes
          • How to Integrate Amazon Marketing Streams with Daton
          • Release Notes
        • Amazon Sponsored Brand Ads
          • Release Notes
        • Amazon Sponsored Display Ads
          • Release Notes
        • Amazon Sponsored Product Ads
          • Release Notes
        • Amazon Sponsored TV Ads
        • Bing Ads
          • Release Notes
        • Bol Ads
          • Release Notes
        • Facebook Ads
          • Release Notes
        • Google Ads
          • Release Notes
        • Google My Business
        • Google My Business v2
          • About Google My Business v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Google Business Profile Account with Daton
          • Schema Information
        • Gorgias
        • Gorgias V2
        • HelpScout
        • HelpScout v2
          • About HelpScout Platform
          • Essential Attributes and Supported Tables
          • How to Integrate HelpScout with Daton
          • Schema Information
          • Release Notes
        • Outbrain
          • Release Notes
        • Outbrain v2
          • About Outbrain Platform
          • Essential Attributes & Supported Tables
          • How to Integrate Outbrain v2 with Daton
          • Schema Information
        • Pinterest v2
          • About Pinterest v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Pinterest v2 with Daton
          • Schema Information
        • Rakuten
          • About Rakuten Connector
          • Essential Attributes
          • How to Integrate Rakuten with Daton
        • StackAdapt
          • About StackAdapt Platform
          • Essential Attributes and Supported Tables
          • How to Integrate StackAdapt with Daton
          • Schema Information
        • Typeform
          • About Typeform Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Typeform with Daton
          • Schema Information
        • Upscribe
          • Release Notes
        • Upscribe V2
          • About Upscribe Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Upscribe v2 with Daton
          • Schema Information
      • Analytics Platforms
        • Appsflyer
        • GA4
          • About Google Analytics Platform
          • Essential Attributes and Table Selection
          • How to Integrate GA4 with Daton
          • Schema Information
        • Google Analytics
          • Release Notes
        • Jungle Scout
        • Northbeam
          • About Northbeam Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Northbeam with Daton
          • Schema Information
        • Prodco Analytics
          • About Prodco Analytics Platform
          • Essential Attributes and Table Selection
          • How to Integrate Prodco Analytics Account with Daton
          • Schema Information
        • Rainforest
          • About Rainforest Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Rainforest Account with Daton
          • Schema Information
        • Sprout Social
          • About Sprout Social Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Sprout Social with Daton
          • Schema Information
        • Taboola
        • Taboola v2
          • About Taboola v2
          • Essential Attributes and Supported Tables
          • How to Integrate Taboola v2 with Daton
          • Schema Information
        • Edge by Ascential
      • Business
        • ClickUp
          • About ClickUp Connector
          • Essential Attributes and Supported Tables
          • How to Integrate ClickUp with Daton
          • Schema Information
        • Bubble
        • Pipedrive
          • About Pipedrive Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Pipedrive with Daton
          • Schema Information
        • Teamwork
          • About Teamwork Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Teamwork with Daton
          • Schema Information
        • Teamwork v2
          • About Teamwork Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Teamwork v2 with Daton
          • Schema Information
        • TikTok Business
          • About TikTok Business Connector
          • Essential Attributes and Supported Tables
          • How to Integrate TikTok Business with Daton
          • Schema Information
        • Unbounce v2
          • About Unbounce v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Unbounce v2 with Daton
          • Schema Information
      • Call Center
        • Aircall
        • Callpage
        • JustCall
          • About JustCall Connector
          • Essential Attributes and Supported Tables
          • How to Integrate JustCall with Daton
          • Schema Information
      • Databases
        • Amazon Aurora MySQL
          • About Amazon Aurora Platform
          • Essential Attributes
          • How to Integrate Amazon Aurora with Daton
        • Amazon Redshift
          • About Amazon Redshift Platform
          • Essential Attributes
          • How to Integrate Amazon Redshift with Daton
        • GCP MySQL
          • About GCP MySQL Platform
          • Essential Attributes
          • How to Integrate GCP MySQL with Daton
        • GCP PostgreSQL
          • Setup Manual
        • Magento (DB)
          • About Magento Connector
          • Essential Attributes
          • How to Integrate Magento with Daton
        • MySQL
          • Release Notes
        • NetSuite
        • PostgreSQL
          • Release Notes
        • SQLServer
        • WooCommerce SQL
          • About WooCommerce SQL Platform
          • Essential Attributes
          • How to Integrate WooCommerce SQL with Daton
      • Daton Connector
        • Release Notes
      • Ecommerce Platforms
        • Amazon MWS
          • Release Notes
        • Amazon Selling Partner
          • All Report Types and Tables
          • Release Notes
        • Amazon Vendor Central
          • All Report Types and Tables
          • Real Time Reports
          • Daily Reports
          • Weekly Reports
          • Snapshot Reports
          • Monthly Reports
          • Raw Tables
          • Release Notes
        • Bigcommerce
        • BigCommerce v2
          • About BigCommerce Platform
          • Essential Attributes and Supported Tables
          • How to Integrate BigCommerce Account with Daton
          • Schema Information
          • Release Notes
        • Bol Retail v2
          • Release Notes
        • Capillary Martjack
          • Release Notes
        • Kaufland
          • About Kaufland Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Kaufland with Daton
          • Schema Information
        • Keepa
          • About Keepa Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Keepa with Daton
          • Schema Information
        • Lazada
        • Loopreturns
          • Release Notes
        • Magento
          • Release Notes
        • Magento 2 (APIs)
          • Release Notes
        • Mercado Libre
          • About Mercado Libre Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Mercado Libre with Daton
          • Schema Information
        • Shopify
          • Access tokens for Shopify
          • Release Notes
        • Shopify V2
        • Walmart
          • Release Notes
        • Walmart_v2
          • Release Notes
        • WooCommerce
      • Files
        • Amazon S3
          • Release Notes
        • Dropbox
          • Release Notes
        • Email Attachments
          • About Email Attachments Connector
          • Essential Attributes and Connector Guidelines
          • How to Integrate Email Attachments with Daton
        • Google Cloud Storage
          • Release Notes
        • Google Drive
        • Google Sheets
          • Release Notes
        • SFTP (SSH File Transfer Protocol)
      • OMS/WMS
        • Cin7
        • Goflow
          • About Goflow Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Goflow with Daton
          • Schema Information
        • Rippling
          • About Rippling Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Rippling with Daton
          • Schema Information
      • Payments
        • PayPal
          • About PayPal Connector
          • Essential Attributes and Supported Tables
          • How to Integrate PayPal with Daton
          • Schema Information
        • Razorpay
          • About Razorpay Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Razorpay with Daton
          • Schema Information
        • Razorpay v1
        • Stripe
      • Productivity Trackers
        • GitLab
          • Release Notes
        • Time Doctor
          • Release Notes
      • SaaS Integrations
        • Aftership
          • Release Notes
        • Aftership V2
        • Anvyl
        • Ascend
        • Awtomic
          • Release Notes
        • Braintree
          • About Braintree Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Braintree Account with Daton
          • Schema Information Braintree
        • Calendly
          • Release Notes
        • Calendly V2
        • Campaign Monitor
        • Capsule CRM
        • Chargebee
        • Freshworks CRM
        • Loop Subscription
        • Commission Junction
        • Constant Contact
        • Copper CRM
          • About Copper
          • Essential Attributes and Supported Tables
          • How to Integrate Copper Account with Daton
          • Schema Information
          • Release Notes
        • Criteo
        • Criteo Retail Media
        • Customer.io
        • DotDigital
        • dotdigital V2
        • Easyecom
        • EasyEcom V2
          • Release Notes
        • ePallet ERP
        • Etsy
        • Exchange Rates
          • About Exchange Rate Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Exchange Rates with Daton
          • Schema Information
          • Release Notes
        • Fairing (previously EnquireLabs)
          • Release Notes
        • FreshBooks
          • Release Notes
        • Freshdesk
          • Release Notes
        • Freshsales
          • Release Notes
        • Fulfil
        • Gladly
          • Release Notes
        • Google Search Console
          • Release Notes
        • HubSpot
          • Release Notes
        • HubSpot v2
          • About HubSpot v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate HubSpot v2 with Daton
          • Schema Information
        • Impact
          • Release Notes
        • Infusionsoft (now Keap Max Classic)
          • About Infusionsoft Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Infusionsoft with Daton
          • Schema Information
        • Insightly
        • Intercom
          • Release Notes
        • Intercom V2
          • Release Notes
        • Outbrain V2 (Old)
          • Release Notes
        • Inventory Planner
        • Jira
        • JudgeMe
          • Release Notes
        • Kibo Commerce
        • Klaviyo
          • Release Notes
        • Klaviyo V2
          • Release Notes
        • Kustomer
        • LeadSquared CRM
        • LeadSquared V2
        • LinkedIn Ads
        • LiveChat
        • LoyaltyLion
        • MailChimp
          • Release Notes
        • MNTN
        • Monday
        • NewRelic
        • Okendo Reviews
          • About Okendo Reviews Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Okendo Reviews with Daton
          • Schema Information
        • Optimove
          • Release Notes
        • Pingdom
        • Pinterest
        • Pipedrive
        • PushEngage
        • Quickbase
        • QuickBooks
        • Quickbooks v2
          • About Quickbooks Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Quickbooks v2 with Daton
          • Schema Information
        • Re:amaze
        • ReCharge Payments
          • Release Notes
        • ReCharge Payments v1
          • Setup Manual
          • Schema Information
        • Recharge Payments V2
          • Setup Manual
          • Schema Information
        • Reviewmonitoring
          • Release Notes
        • Salsify
          • Release Notes
        • SendGrid
          • Release Notes
        • Shiphero
        • Shippo
        • Shiprocket
          • Release Notes
        • Shiprocket v2
          • About Shiprocket Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Shiprocket with Daton
          • Schema Information
        • Shipstation
          • Release Notes
        • Skubana
        • SkuVault
          • About SkuVault Connector
          • Essential Attributes and Supported Tables
          • How to Integrate SkuVault with Daton
          • Schema Information
        • Smartrr
        • Smartrr v2
          • About Smartrr Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Smartrr v2 with Daton
          • Schema Information
        • Stamped.io
          • About Stamped.io Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Stamped.io with Daton
          • Schema Information
        • Stamped.io v1
        • Stay AI
        • Sticky.io
        • SugarCRM
          • Release Notes
        • Survey Monkey
        • Tune
        • Unbounce
        • Unicommerce
        • Unicommerce
          • About Unicommerce Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Unicommerce with Daton
          • Schema Information
          • Release Notes
        • When I Work
        • Xero
        • Xero V2
          • About Xero Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Xero V2 with Daton
          • Schema Information
        • Yahoo Gemini
        • Yotpo
        • Yotpo v2
          • About Yotpo Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Yotpo v2 with Daton
          • Schema Information
        • Zendesk Chat
        • Zendesk ETL
          • Release Notes
        • Zoho CRM
          • Release Notes
        • ZohoDesk
          • Release Notes
      • Surveys
        • Alchemer
          • About Alchemer Platform
          • Essential Attributes and Supported Tables Alchemer
          • How to Integrate Alchemer Account with Daton
          • Schema Information Alchemer
        • Fairing
          • About Fairing Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Fairing with Daton
          • Schema Information
        • Survicate
          • About Survicate Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Survicate with Daton
          • Schema Information
      • Shipping Platforms
        • 3PL Central
        • Byrd
        • Cin7
        • ClickPost
        • Dear
        • Easypost
        • Ohi
          • About Ohi Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Ohi with Daton
          • Schema Information
        • ShipBob
          • About ShipBob Connector
          • Essential Attributes and Supported Tables
          • How to Integrate ShipBob with Daton
          • Schema Information
      • Webhooks
    • Destinations
      • Amazon RDS PostgreSQL
        • Amazon RDS for PostgreSQL Integration with Daton
        • How to Set up RDS PostgreSQL Destination in Daton
      • Amazon RDS MySQL
        • About Integrating Amazon RDS for MySQL database with Daton
        • How to Set up RDS MySQL Destination in Daton
      • Amazon Redshift
        • Querying Daton created tables on RedShift
        • Release Notes
      • Amazon S3
        • Release Notes
      • Azure One Lake
        • About Azure One Lake as a connector in Daton
        • How to Set up an Azure One Lake Database for Integrating with Daton
        • How to Integrate your Azure One Lake Database as a Destination in Daton
      • Azure Data Lake Storage
        • About Azure Data Lake Storage as a connector in Daton
        • How to Set up an Azure Data Lake Storage for Integrating with Daton
        • How to Integrate Your Azure Data Lake Storage Database as a Destination in Daton
      • GCP PostgreSQL
        • About Google Cloud SQL for PostgreSQL Database with Daton
        • How to Set up GCP PostgreSQL Destination in Daton
      • Google BigQuery
        • Release Notes
      • GCS
      • MySQL
        • About Integrating MySQL with Daton
        • How to Set up a MySQL Database for Integrating with Daton
        • How to Set up Your MySQL Database as a Destination in Daton
      • Oracle Autonomous Data Warehouse
      • Snowflake
        • Release Notes
  • FAQs and Troubleshooting
    • Connector permissions and API Keys
      • Access tokens for Shopify
      • Amazon Ads Permissions
      • Where to find my Amazon MWS Merchant Token and Auth Token
      • How to create BigCommerce API Account and generate Client Id, Client Secret and Access tokens
      • How to create Client credentials for Bol Retail
      • How to create Developer application for Mercado Libre
      • How to create API Keys for SendGrid
      • Where to find API Keys for Freshsales
      • Where to find API Keys for Freshdesk
      • How to create REST API Keys for NewRelic
      • How to create API Keys for Chargebee
      • How to generate Access Token for Calendly
      • How to obtain Klaviyo API Key
      • Where to find API Keys for RazorPay
      • How to create API Keys for PushEngage
      • How to create Criteo API User and generate Client Id and Client Secret
      • How to find site-id/domain and create WooCommerce Consumer Key and Secret
    • Authentication Failure while connecting Database using SSH tunnel
    • Common Errors and Resolution
    • FAQs
      • How to get access to FB Ads Business Manager?
      • How to get access to Google Analytics?
      • Querying Daton created child tables for nested data
      • Google Analytics - FAQs
      • How does Lite Plan Work?
      • How do I upgrade my subscription?
      • How does loading behaviour impact billing?
      • What are the tables highlighted with the letter "F"?
      • Amazon Advertising FAQs
      • Amazon Business and Inventory Reports FAQs
      • Why don't I see my data?
      • How exactly do Business Reports work in Daton?
      • Steps to upload your own ASIN and SKU file in Amazon SP connectors
      • What are 'FATAL' and 'CANCELLED' report statuses in Amazon Selling Partner?
      • How to setup Google BigQuery Project
      • Amazon Selling Partner, Vendor Central - Access to resource denied error.
      • VendorSalesReportByManufacturing showing a FATAL report status?
      • How to Enable SSH Tunneling during a Database Source Authentication?
  • New Subscription Plans and Billing
    • Subscription Plans Overview
    • Find Your Perfect Data Integration Fit - Growth and Enterprise Plans Explored
    • Daton's Subscriptions Dashboard: Harness the Power of Your Data
    • How to Select and Subscribe to a Daton Subscription Plan?
    • Subscription Plan Upgrade and Downgrade
    • Changing Billing Cycle
  • Product Insights: Report, Roadmap, and Release Notes
    • Introduction to Product Insights
    • 2023 Recap and 2024 Roadmap
    • Release Notes
Powered by GitBook
On this page
  • Tables/APIs
  • Teamwork v1 APIs
  • Teamwork v2 APIs
  • Teamwork v3 APIs

Was this helpful?

  1. Connectors
  2. Data Sources
  3. Business
  4. Teamwork

Schema Information

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

PreviousHow to Integrate Teamwork with DatonNextTeamwork v2

Last updated 1 year ago

Was this helpful?

Tables/APIs

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

Teamwork v1 APIs

For more information, see .

Activity

Retrieves activity feeds or logs for projects or tasks.

FIELDS

Field Name
Data Type

project_id

STRING

project_name

STRING

company_id

STRING

company_name

STRING

id

STRING

activitytype

STRING

description

STRING

extradescription

STRING

isprivate

STRING

itemid

STRING

itemlink

STRING

latestActivityType

STRING

link

STRING

lockdownId

STRING

publicinfo

STRING

type

STRING

due_date

STRING

userid

STRING

datetime

STRING

foruserid

STRING

forusername

STRING

for_user_avatar_url

STRING

from_user_avatar_url

STRING

fromusername

STRING

AllLinks

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

FIELDS

Field Name
Data Type

links

RECORD

name

STRING

id

STRING

AllPeopleList

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

Field Name
Data Type

site_owner

BOOLEAN

twitter

STRING

last_name

STRING

useShorthandDurations

BOOLEAN

profile

STRING

userUUID

STRING

user_name

STRING

id

STRING

phone_number_office

STRING

last_active

STRING

phone_number_mobile

STRING

first_name

STRING

user_type

STRING

im_service

STRING

im_handle

STRING

login_count

STRING

openId

STRING

phone_number_office_ext

STRING

twoFactorAuthEnabled

BOOLEAN

company_id

STRING

has_access_to_new_projects

BOOLEAN

address_zip

STRING

phone_number_fax

STRING

full_name

STRING

last_login

STRING

companyId

STRING

administrator

BOOLEAN

address_city

STRING

pid

STRING

profile_text

STRING

phone_number_home

STRING

email_address

STRING

lengthOfDay

STRING

tags

STRING

company_name

STRING

last_changed_on

STRING

deleted

BOOLEAN

address_state

STRING

address_country

STRING

notes

STRING

phone_number_mobile_parts

RECORD

permissions

RECORD

user_invited_status

STRING

address

RECORD

address_line_2

STRING

address_line_1

STRING

created_at

STRING

textFormat

STRING

user_invited_date

STRING

avatar_url

STRING

in_owner_company

BOOLEAN

user_invited

STRING

email_alt_1

STRING

email_alt_2

STRING

email_alt_3

STRING

title

STRING

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

FIELDS

Field Name
Data Type

lastChangedOn

STRING

createdByUserId

STRING

impact

STRING

impactSchedule

STRING

impactValue

STRING

projectId

STRING

status

STRING

probabilityValue

STRING

source

STRING

result

STRING

createdOn

STRING

id

STRING

lastChangedByUserId

STRING

deleted

BOOLEAN

createdByUserLastName

STRING

companyName

STRING

createdByUserFirstName

STRING

lastChangedByUserFirstName

STRING

projectName

STRING

projectIsActive

STRING

impactPerformance

STRING

mitigationPlan

STRING

probability

STRING

lastChangedByUserLastName

STRING

impactCost

STRING

companyId

STRING

AllRunningTimers

Allows you to access running timers for tasks.

FIELDS

Field Name
Data Type

dateDeleted

STRING

serverTime

STRING

intervals

RECORD

description

STRING

dateUpdated

STRING

projectName

STRING

projectId

STRING

billable

BOOLEAN

running

BOOLEAN

id

STRING

taskName

STRING

lastStartedAt

STRING

taskId

STRING

dateCreated

STRING

duration

STRING

deleted

BOOLEAN

userId

STRING

AllTaskAcrossAllProjects

Retrieves information about tasks across all projects.

FIELDS

Field Name
Data Type

id

NUMERIC

boardColumn

RECORD

canComplete

BOOLEAN

comments_count

NUMERIC

description

STRING

has_reminders

BOOLEAN

has_unread_comments

BOOLEAN

private

NUMERIC

content

STRING

order

NUMERIC

project_id

NUMERIC

project_name

STRING

todo_list_id

NUMERIC

todo_list_name

STRING

tasklist_private

BOOLEAN

tasklist_isTemplate

BOOLEAN

status

STRING

company_name

STRING

company_id

NUMERIC

creator_id

NUMERIC

creator_firstname

STRING

creator_lastname

STRING

updater_id

NUMERIC

updater_firstname

STRING

updater_lastname

STRING

completed

BOOLEAN

start_date

STRING

due_date_base

STRING

due_date

STRING

created_on

STRING

last_changed_on

STRING

position

NUMERIC

estimated_minutes

NUMERIC

priority

STRING

progress

NUMERIC

harvest_enabled

BOOLEAN

parentTaskId

STRING

lockdownId

STRING

tasklist_lockdownId

STRING

has_dependencies

NUMERIC

has_predecessors

NUMERIC

hasTickets

BOOLEAN

tags

RECORD

timeIsLogged

STRING

attachments_count

NUMERIC

predecessors

STRING

canEdit

BOOLEAN

viewEstimatedTime

BOOLEAN

creator_avatar_url

STRING

canLogTime

BOOLEAN

commentFollowerSummary

STRING

commentFollowerIds

STRING

userFollowingComments

BOOLEAN

userFollowingChanges

BOOLEAN

DLM

NUMERIC

boardColumn.id

NUMERIC

boardColumn.name

STRING

boardColumn.color

STRING

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

FIELDS

Field Name
Data Type

id

STRING

name

STRING

description

STRING

position

NUMERIC

projectId

STRING

projectName

STRING

lastUpdated

STRING

private

BOOLEAN

isTemplate

BOOLEAN

tags

STRING

milestone_id

STRING

pinned

BOOLEAN

complete

BOOLEAN

uncompleted_count

NUMERIC

status

STRING

notifyTaskAssignee

BOOLEAN

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

FIELDS

Field Name
Data Type

project_id

STRING

author_lastname

STRING

commentable_id

STRING

commentable_type

STRING

emailed_from

STRING

isRead

STRING

private

STRING

lockdown_id

STRING

datetime

STRING

author_avatar_url

STRING

canEdit

BOOLEAN

id

STRING

company_name

STRING

last_changed_on

STRING

content_type

STRING

nr_notified_people

STRING

canDelete

BOOLEAN

type

STRING

item_name

STRING

attachments_count

STRING

_author_id

RECORD

company_id

STRING

canLike

BOOLEAN

html_body

STRING

project_name

STRING

body

STRING

commentNo

STRING

attachments

RECORD

author_firstname

STRING

author_company

STRING

comment_link

STRING

author_id

STRING

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

FIELDS

Field Name
Data Type

invoice_id

STRING

project_id

STRING

name

STRING

description

STRING

created_by_user_firstname

STRING

company_id

STRING

project_name

STRING

created_by_user_id

STRING

created_by_user_lastname

STRING

id

STRING

date

STRING

company_name

STRING

cost

STRING

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

FIELDS

Field Name
Data Type

project_id

STRING

author_first_name

STRING

milestone_id

STRING

contributingUsers

STRING

attachmentsCount

STRING

isRead

STRING

private

STRING

comments_count

STRING

author_avatar_url

STRING

author_last_name

STRING

tags

STRING

company_name

STRING

id

STRING

last_changed_on

STRING

content_type

STRING

isOriginal

STRING

user_display_posted_date

STRING

user_display_posted_time

STRING

attachments_count

STRING

category_color

STRING

post_id

STRING

userFollowing

BOOLEAN

category_id

STRING

followerIds

STRING

html_body

STRING

project_name

STRING

posted_on

STRING

body

STRING

attachments

STRING

last_comment_date

STRING

author_id

STRING

title

STRING

category_name

STRING

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

FIELDS

Field Name
Data Type

name

STRING

id

STRING

color

STRING

Milestones: Retrieves information related to project milestones.

FIELDS

Field Name
Data Type

projectType

STRING

canComplete

BOOLEAN

project_id

STRING

responsible_party_id

STRING

responsiblePartyFullNames

STRING

completed_on

STRING

private

BOOLEAN

userFollowingComments

BOOLEAN

comments_count

STRING

status

STRING

changeFollowerIds

STRING

created_on

STRING

tags

STRING

canEdit

BOOLEAN

responsible_party_type

STRING

isprivate

STRING

company_name

STRING

id

STRING

last_changed_on

STRING

commentFollowerIds

STRING

completed

BOOLEAN

reminder

STRING

tasklists

RECORD

userFollowingChanges

BOOLEAN

description

STRING

responsible_party_firstname

STRING

responsible_party_ids

STRING

responsible_party_names

STRING

responsible_party_lastname

STRING

company_id

STRING

creator_id

STRING

dueDateOffset

STRING

project_name

STRING

deadline

STRING

_isprivate

RECORD

title

STRING

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

FIELDS

Field Name
Data Type

announcement

STRING

announcementHTML

STRING

category

RECORD

company

RECORD

created_on

STRING

defaultPrivacy

STRING

defaults

RECORD

description

STRING

endDate

STRING

filesAutoNewVersion

BOOLEAN

harvest_timers_enabled

BOOLEAN

id

STRING

integrations

RECORD

isProjectAdmin

BOOLEAN

last_changed_on

STRING

logo

STRING

name

STRING

notifyeveryone

BOOLEAN

overview_start_page

STRING

privacyEnabled

BOOLEAN

replyByEmailEnabled

BOOLEAN

show_announcement

BOOLEAN

starred

BOOLEAN

startDate

STRING

start_page

STRING

status

STRING

subStatus

STRING

tags

STRING

tasks_start_page

STRING

ProjectCategories: Manages project categories or groupings.

FIELDS

Field Name
Data Type

parent_id

STRING

name

STRING

count

STRING

elements_count

STRING

id

STRING

color

STRING

type

STRING

ProjectRole: Deals with user roles and permissions within projects.

FIELDS

Field Name
Data Type

projectId

STRING

users

RECORD

name

STRING

description

STRING

id

INTEGER

ProjectUpdates: Retrieves updates and changes made to projects.

FIELDS

Field Name
Data Type

projectId

STRING

deletedDate

STRING

text

STRING

health

STRING

id

STRING

dateCreated

STRING

color

STRING

deleted

STRING

user

RECORD

TimeEntriesAcrossAllProjects: Retrieves time entries across all projects.

FIELDS

Field Name
Data Type

status

STRING

billableType

STRING

invoicedType

STRING

canEdit

BOOLEAN

company_id

STRING

company_name

STRING

createdAt

STRING

date

STRING

dateUserPerspective

STRING

description

STRING

has_start_time

STRING

hours

STRING

id

STRING

invoiceNo

STRING

invoiceStatus

STRING

isbillable

STRING

isbilled

STRING

minutes

STRING

parentTaskId

STRING

parentTaskName

STRING

project_id

STRING

project_name

STRING

project_status

STRING

tags

STRING

taskEstimatedTime

STRING

todo_item_id

STRING

taskIsPrivate

STRING

taskIsSubTask

STRING

todo_item_name

STRING

task_tags

STRING

todo_list_id

STRING

tasklistId

STRING

todo_list_name

STRING

ticket_id

STRING

updated_date

STRING

person_first_name

STRING

person_id

STRING

person_last_name

STRING

TimeTotalAcrossProjects: Calculates the total time spent across all projects.

FIELDS

Field Name
Data Type

company

RECORD

name

STRING

totalNonBilledMins

STRING

totalBillableHours

STRING

totalBillableMins

STRING

totalNonBillableMins

STRING

totalMins

STRING

totalNonBillableHours

STRING

totalBilledHours

STRING

totalHours

STRING

totalNonBilledHours

STRING

id

STRING

totalBilledTime

STRING

totalBilledMins

STRING

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

FIELDS

Field Name
Data Type

projectID

STRING

projectType

STRING

company

RECORD

time_estimates

RECORD

name

STRING

id

STRING

time_totals

RECORD

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

FIELDS

Field Name
Data Type

first_name

STRING

reset

BOOLEAN

status

STRING

neverUpdated

BOOLEAN

last_name

STRING

updated_date

STRING

statusHTML

STRING

geoipLocation

STRING

posted_on

STRING

avatar_url

STRING

id

STRING

last_changed_on

STRING

userId

STRING

isClockedIn

STRING

Teamwork v2 APIs

CustomFieldsForV2Projects: Deals with custom fields associated with projects in Teamwork, allowing you to create, retrieve, update, or delete custom fields for project-related data.

FIELDS

Field Name
Data Type

id

INTEGER

entity

STRING

name

STRING

description

STRING

type

STRING

isPrivate

BOOLEAN

required

BOOLEAN

createdAt

TIMESTAMP

createdByUserId

INTEGER

createdBy

INTEGER

updatedAt

TIMESTAMP

updatedByUserId

INTEGER

updatedBy

INTEGER

deleted

BOOLEAN

CustomFieldsForV2Tasks: Deals with custom fields associated with tasks in Teamwork, enabling you to work with custom data fields specific to tasks within your projects.

FIELDS

Field Name
Data Type

id

INTEGER

entity

STRING

name

STRING

description

STRING

type

STRING

isPrivate

BOOLEAN

required

BOOLEAN

createdAt

TIMESTAMP

createdByUserId

INTEGER

createdBy

INTEGER

updatedAt

TIMESTAMP

updatedByUserId

INTEGER

updatedBy

INTEGER

deleted

BOOLEAN

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

FIELDS

Field Name
Data Type

activePages

RECORD

activeUserIsProjectAdmin

BOOLEAN

announcement

STRING

announcementHTML

STRING

company

RECORD

createdOn

STRING

defaultPrivacy

STRING

defaults

RECORD

description

STRING

directFileUploadsEnabled

BOOLEAN

filesAutoNewVersion

BOOLEAN

harvestTimersEnabled

BOOLEAN

id

INTEGER

integrations

RECORD

isOnBoardingProject

BOOLEAN

isProjectAdmin

BOOLEAN

isSampleProject

BOOLEAN

lastChangedOn

STRING

lastWorkedOn

STRING

logo

STRING

name

STRING

notifyEveryone

BOOLEAN

overviewStartPage

STRING

privacyEnabled

BOOLEAN

projectOwnerId

INTEGER

replyByEmailEnabled

BOOLEAN

showAnnouncement

BOOLEAN

skipWeekends

BOOLEAN

starred

BOOLEAN

startPage

STRING

status

STRING

subStatus

STRING

tasksStartPage

STRING

type

STRING

customFields

RECORD

category

RECORD

endDate

DATE

isBillable

BOOLEAN

people

STRING

startDate

DATE

tags

RECORD

boardData

RECORD

portfolioBoards

RECORD

completedByUserFirstName

STRING

completedByUserId

INTEGER

completedByUserLastName

STRING

completedOn

TIMESTAMP

archivedByUserId

INTEGER

archivedByUserName

STRING

dateArchived

TIMESTAMP

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

FIELDS

Field Name
Data Type

id

INTEGER

name

STRING

priority

STRING

status

STRING

parentTaskId

INTEGER

description

STRING

canViewEstTime

BOOLEAN

updatedBy

RECORD

createdBy

RECORD

dateCreated

STRING

dateChanged

STRING

dateLastModified

STRING

hasFollowers

BOOLEAN

hasLoggedTime

BOOLEAN

hasReminders

BOOLEAN

hasRemindersForUser

BOOLEAN

hasRelativeReminders

BOOLEAN

hasTemplateReminders

BOOLEAN

hasTickets

BOOLEAN

isPrivate

BOOLEAN

installationId

INTEGER

privacyIsInherited

BOOLEAN

lockdownId

INTEGER

numMinutesLogged

INTEGER

numActiveSubTasks

INTEGER

numAttachments

INTEGER

numComments

INTEGER

numCommentsRead

INTEGER

numCompletedSubTasks

INTEGER

numDependencies

INTEGER

numEstMins

INTEGER

numPredecessors

INTEGER

position

INTEGER

projectId

INTEGER

dueDateFromMilestone

BOOLEAN

taskListId

INTEGER

progress

INTEGER

followingChanges

BOOLEAN

followingComments

BOOLEAN

changeFollowerIds

STRING

commentFollowerIds

STRING

order

INTEGER

canComplete

BOOLEAN

canEdit

BOOLEAN

canLogTime

BOOLEAN

canAddSubtasks

BOOLEAN

placeholder

BOOLEAN

DLM

INTEGER

customFields

RECORD

assignedTo

RECORD

Teamwork v3 APIs

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

FIELDS

Field Name
Data Type

users

RECORD

tasks

RECORD

tasklists

RECORD

projects

RECORD

V3_AllRunningTimers: Returns a list of all running timers but with basic information without details.

FIELDS

Field Name
Data Type

billable

BOOLEAN

createdAt

STRING

deleted

BOOLEAN

deletedAt

STRING

description

STRING

duration

INTEGER

id

INTEGER

intervals

RECORD

lastStartedAt

STRING

projectId

INTEGER

running

BOOLEAN

serverTime

STRING

taskId

INTEGER

timeLogId

INTEGER

timerLastIntervalEnd

STRING

updatedAt

STRING

userId

INTEGER

V3_AllTimeEntries: Retrieves a list of all time entries recorded in Teamwork, possibly without additional details.

FIELDS

Field Name
Data Type

billable

BOOLEAN

dateCreated

STRING

dateDeleted

STRING

dateEdited

STRING

deleted

BOOLEAN

deletedByUserId

INTEGER

description

STRING

deskTicketId

INTEGER

editedByUserId

INTEGER

hasStartTime

BOOLEAN

id

INTEGER

invoiceNumber

STRING

loggedByUserId

INTEGER

minutes

INTEGER

projectBillingInvoiceId

INTEGER

projectId

INTEGER

taskId

INTEGER

taskIdPreMove

INTEGER

timeLogged

STRING

userId

INTEGER

V3_AllTimeEntriesWithDetails: This API is similar to the above but with more detailed information included for each time entry.

FIELDS

Field Name
Data Type

users

RECORD

tasks

RECORD

tasklists

RECORD

projects

RECORD

V3_TimeLogTotals: Provides totals or summaries of time logged for various tasks, projects, or users within a specified time period.

FIELDS

Field Name
Data Type

projectID

INTEGER

projectType

STRING

estimatedMinutesActive

INTEGER

estimatedMinutesCompleted

INTEGER

estimatedMinutesFiltered

INTEGER

estimatedMinutesWithLoggedTime

INTEGER

minutes

INTEGER

minutesBillable

INTEGER

minutesBilled

INTEGER

minutesNonBillable

INTEGER

minutesNonBilled

INTEGER

For more information, see .

For more information, see .

Teamwork v2 API documentation
Teamwork v3 API documentation
Teamwork v1 API documentation
Teamwork v1 APIs
Teamwork v2 APIs
Teamwork v3 APIs