Explore the Teamwork API data model

See how the various Teamwork endpoints relate to each other, using our handy Entity Relationship Diagram

Try our interactive ERD Or, browse below

Pulling data from the Teamwork API is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.

At SyncHub, we not only sync your Teamwork API endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.

Endpoints

Allocation

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
InstallationID int - -
ProjectID long Project → ID -
Title string - -
StartedAt datetime - -
EndedAt datetime - -
Duration decimal - -
HoursPerDay decimal - -
Color string - -
Status string - -
DistributeType string - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -
CreatedBy long Person → ID -
UpdatedBy long Person → ID -
DeletedBy long Person → ID -
AssignedUserID long Person → ID -
RecurringRule string - -

Budget

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
ProjectID long Project → ID -
Type string - -
Status string - -
CapacityUsed int - -
Capacity int - -
IsRepeating boolean - -
RepeatPeriod int - -
RepeatUnit string - -
RepeatsRemaining int - -
SequenceNumber int - -
StartDateTime datetime - -
EndDateTime datetime - -
CurrencyCode string - -
TimelogType string - -
ExpenseType string - -
DefaultRate decimal - -
CreatedByUserID long Person → ID -
DateCreated datetime - -
UpdatedByUserID long Person → ID -
DateUpdated datetime - -

Company

Documentation: https://apidocs.teamwork.com/docs/teamwork/acfee1f502698-get-all-companies

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Accounts int - -
AddressOne string - -
AddressTwo string - -
CanSeePrivate boolean - -
Cid string - -
City string - -
Clients int - -
Collaborators int - -
CompanyNameUrl string - -
Contacts int - -
CountryCode string - -
CreatedAt datetime - -
EmailOne string - -
EmailThree string - -
EmailTwo string - -
Fax string - -
IndustryID int - -
IsOwner boolean - -
LogoUrl string - -
Phone string - -
PrivateNotes string - -
PrivateNotesText string - -
ProfileText string - -
State string - -
UpdatedAt datetime - -
Website string - -
Zip string - -

CustomField

Documentation: https://apidocs.teamwork.com/docs/teamwork/275ac473ca2eb-get-all-custom-fields

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
ProjectID int - -
Entity string - -
Type string - -
IsPrivate boolean - -
Required boolean - -
CreatedAt datetime - -
CreatedByUserID int - -
UpdatedAt datetime - -
UpdatedByUserID int - -
Deleted boolean - -
DeletedAt datetime - -
DeletedByUserID int - -

Event

Documentation: https://apidocs.teamwork.com/docs/teamwork/2714bb8ca5e74-get-events

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
Title string - -
Where string - -
SequenceID long - -
ProjectUsersCanEdit boolean - -
AttendeesCanEdit boolean - -
Status string - -
DateDeleted datetime - -
DeletedByUserID long Person → ID -
DeletedByUserFirstName string - -
DeletedByUserLastName string - -
Utc boolean - -
CanEdit boolean - -
AllDay boolean - -
IsUnavailable boolean - -
AttendingUserNames string - -
AttendingUserFirstNames string - -
AttendingUserLastNames string - -
AttendingUserCompanyIDs string - -
AttendingUserCompanyNames string - -
AttendingUserAvatarURLs string - -
NotifyUserNames string - -
NotifyUserFirstNames string - -
NotifyUserLastNames string - -
NotifyUserAvatarURLs string - -
ShowAsBusy boolean - -
LastChangedOn datetime - -
CreatedAt datetime - -
Start datetime - -
End datetime - -
OwnerID long Person → ID -
OwnerFirstName string - -
OwnerLastName string - -
OwnerAvatarURL string - -
TypeID long -
  • 16 Mar 2023 Foreign Key for EventTypes which is currently unimplemented
TypeColor string - -
TypeName string - -
RepeatFrequency string - -
RepeatEnds boolean - -
RepeatEndDate datetime - -

Invoice

Documentation: https://apidocs.teamwork.com/docs/teamwork/d7ff00359e06f-get-all-invoices-across-your-projects

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
ProjectID long Project → ID -
TimeCost decimal - -
FixedCost decimal - -
Status string - -
DateCreated datetime - -
Number string - -
PoNumber string - -
UpdateByUserID long Person → ID -
CreatedByUserID int - -
Pricing string - -
CompanyName string - -
TotalTimeDecimal decimal - -
TotalCost decimal - -
ExpensesCost decimal - -
CompanyID long Company → ID -
TotalTime decimal - -
DisplayDate string - -
DateUpdated datetime - -
CurrencyCode string - -

Milestone

Documentation: https://developer.teamwork.com/projects/api-v1/ref/milestones/get-milestones-json

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
Deadline string - -
Completed boolean - -
ProjectID long Project → ID -
CreatedOn datetime - -
LastChangedOn datetime - -
CreatorUserID long Person → ID -
Reminder string - -
IsPrivate boolean - -
Status string - -
UserFollowingComments boolean - -
UserFollowingChanges boolean - -
CanEdit boolean - -
CanComplete boolean - -
CommentsCount int - -

Person

Documentation: https://developer.teamwork.com/projects/api-v1/ref/people/get-people-json

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
CanAccessTemplatesPermission boolean - -
CanViewProjectTemplates boolean - -
CanAddProjectsPermission boolean - -
CanManageCustomFieldsPermission boolean - -
CanManageProjectTemplatesPermission boolean - -
CanAccessCalendarPermission boolean - -
CanViewSchedulePermission boolean - -
CanManagePeoplePermission boolean - -
CanManageScheudlePermission boolean - -
AvatarUrl string - -
CurrentFeatureAnnouncementID string CurrentFeatureAnnouncement → ID -
LastChangedOn datetime - -
EmailAddress string - -
LastLogin datetime - -
DocumentEditorInstalled boolean - -
UserName string - -
PhoneNumberFax string - -
SiteOwner boolean - -
CompanyName string - -
UserInvitedDate string - -
UserType string - -
PhoneNumberMobile string - -
HasFeatureUpdates boolean - -
OpenID string - -
PhoneNumberOffice string - -
ImHandle string - -
TwoFactorAuthEnabled boolean - -
IsClientUser boolean - -
HasAccessToNewProjects boolean - -
ImService string - -
Deleted boolean - -
Notes string - -
InOwnerCompany string - -
Profile string - -
UserInvitedStatus string - -
UserUUID string - -
UserInvited string - -
CreatedAt datetime - -
CompanyID string -
  • 28 Jul 2020 Foreign Key - References `Companies` (not implemented).
HasDeskAccount boolean - -
PhoneNumberHome string - -
ProfileText string - -
PrivateNotesText string - -
Pid string - -
PhoneNumberCountryCode string - -
PhoneNumberPrefix string - -
PhoneNumberPhone string - -
LoginCount string - -
PrivateNotes string - -
EmailAlt1 string - -
Administrator boolean - -
EmailAlt2 string - -
EmailAlt3 string - -
FeatureUpdatesCount string - -
LastName string - -
Title string - -
FirstName string - -
PhoneNumberOfficeExt string - -
Twitter string - -
LengthOfDay string - -

PortfolioBoard

Documentation: https://apidocs.teamwork.com/docs/teamwork/v1/portfolio-boards/get-portfolio-boards-json

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
CanEdit boolean - -
DisplayOrder decimal - -
DeletedDate string - -
DateCreated datetime - -
Color string - -
Projects string - -
Deleted boolean - -

PortfolioBoardColumn

Documentation: https://apidocs.teamwork.com/docs/teamwork/v1/portfolio-boards/get-portfolio-boards-board-id-columns-json

Column Type Relates to Notes
RemoteID string - -
PortfolioBoardRemoteID string PortfolioBoard → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
PortfolioBoardID long PortfolioBoard → ID -
DisplayOrder decimal - -
SortOrder string - -
DeletedDate string - -
DateUpdated datetime - -
CompanySetting boolean - -
CategorySetting boolean - -
StarredSetting boolean - -
TagsSetting boolean - -
NameSetting boolean - -
DescriptionSetting boolean - -
DatesSetting boolean - -
HasTriggers boolean - -
Sort string - -
CanEdit boolean - -
DateCreated datetime - -
Color string - -
Deleted boolean - -

PortfolioBoardColumnCard

Documentation: https://apidocs.teamwork.com/docs/teamwork/v1/portfolio-boards/get-portfolio-columns-column-id-cards-json

Column Type Relates to Notes
RemoteID string - -
PortfolioBoardColumnRemoteID string PortfolioBoardColumn → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
CompanyID long Company → ID -
OwnerID long Person → ID -
CategoryID long - -
Starred boolean - -
DisplayOrder decimal - -
Archived boolean - -
DeletedDate datetime - -
DateUpdated datetime - -
ProjectID long Project → ID -
Status string - -
CanEdit boolean - -
StartDate datetime - -
EndDate datetime - -
DateCreated datetime - -
Deleted boolean - -

Project

Documentation: https://developer.teamwork.com/projects/api-v2/ref/custom-fields/getprojectsapiv2projectsjson

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
ReplyByEmailEnabled boolean - -
Starred boolean - -
ShowAnnouncement boolean - -
HarvestTimersEnabled boolean - -
SubStatus string - -
Status string - -
DefaultPrivacy string - -
CreatedOn datetime - -
FilesAutoNewVersion boolean - -
CategoryID long ProjectCategory → ID -
OverviewStartPage string - -
Logo string - -
StartDate string - -
Type string - -
EndDate string - -
CompanyID string -
  • 28 Jul 2020 Foreign Key - References `Companies` (not implemented).
TasksStartPage string - -
PrivacyEnabled boolean - -
Announcement string - -
StartPage string - -
Notifyeveryone boolean - -
AnnouncementHTML string - -
LastChangedOn datetime -
  • 4 Jul 2023 Teamwork returns lastChangedOn when querying for multiple projects, and lastChangeOn for a single project. Note the difference in spelling. So here, we coalesce the two values
ProjectOwnerID long Person → ID -

ProjectCategory

Documentation: https://apidocs.teamwork.com/docs/teamwork/v1/project-categories/get-project-categories-json

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
ParentID long ProjectCategory → ID -
Color string - -
Type string - -
Count int - -
ElementsCount int - -

ProjectLatestActivity

Documentation: https://developer.teamwork.com/projects/api-v3/ref/activity/get-projects-api-v3-projects-projectid-latestactivity

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Description string - -
UserID long Person → ID -
ProjectID long Project → ID -
CompanyID long Company → ID -
ActivityType string - -
DateTime datetime - -
ExtraDescription string - -
DueDate string - -
ForUserID int - -
ForUserName string - -
IsPrivate int - -
ItemID int - -
ItemLink string - -
LatestActivityType string - -
Link string - -
LockdownID int - -
PublicInfo string - -
Type string - -

ProjectRate

Documentation: https://apidocs.teamwork.com/docs/teamwork/v1/projects/get-projects-id-rates-json

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProjectID long Project → ID -
AccountDefault decimal - -
ProjectDefault decimal - -

ProjectUpdate

Documentation: https://apidocs.teamwork.com/docs/teamwork/2e4f8bf140cab-get-all-project-updates

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Text string - -
Health int - -
Color string - -
CreatedAt datetime - -
UpdatedAt datetime - -
Deleted boolean - -
ProjectID long Project → ID -
CreatedBy long Person → ID -
ReactionsCountLike int - -
ReactionsCountDislike int - -
ReactionsCountJoy int - -
ReactionsCountFrown int - -
ReactionsCountHeart int - -

Proof

Documentation: https://apidocs.teamwork.com/docs/teamwork/cd449cb1e17cb-proof

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Due datetime - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -
Product string - -
FeedbackCount int - -
Status string - -
State string - -
InstallationID int - -
TaskID long Task → ID -
ProjectID long Project → ID -
CompanyID long Company → ID -
CreatedByID long Person → ID -
UpdatedByID long Person → ID -
DeletedByID long Person → ID -

Risk

Documentation: https://developer.teamwork.com/projects/api-v3/ref/risks/get-projects-api-v3-risksjson

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
ProjectID long Project → ID -
Source string - -
Probability string - -
ProbabilityValue decimal - -
Impact string - -
ImpactValue decimal - -
ImpactCost boolean - -
ImpactSchedule boolean - -
ImpactPerformance boolean - -
CreatedAt datetime - -
CreatedBy long Person → ID -
UpdatedAt datetime - -
UpdatedBy long Person → ID -
Result decimal - -
MitigationPlan string - -
Status string - -
Deleted boolean - -
CanEdit boolean - -

Tag

Documentation: https://developer.teamwork.com/projects/api-v3/ref/tags/get-projects-api-v3-tagsjson

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
ProjectID long Project → ID -
Color string - -

Task

Documentation: https://apidocs.teamwork.com/docs/teamwork/54bdf625aa2f3-get-all-tasks-across-all-projects

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
BoardColumnID int - -
BoardColumnName string - -
BoardColumnColor string - -
CardID int - -
CanComplete boolean - -
CommentsCount int - -
HasReminders boolean - -
HasUnreadComments boolean - -
PrivateInt int - -
CompleterID long Person → ID
  • 24 Jan 2024 This field is only available once the task has been completed
CompletedOn datetime -
  • 24 Jan 2024 This field is only available once the task has been completed
Content string - -
Order int - -
ProjectID long Project → ID -
ProjectName string - -
TaskListID long TaskList → ID -
TodoListID long - -
TodoListName string - -
TasklistPrivate boolean - -
TasklistIsTemplate boolean - -
Status string - -
CompanyName string - -
CompanyID int -
  • 28 Jul 2020 Foreign Key - References `Companies` (not implemented).
CreatorID long Person → ID -
CreatorFirstname string - -
CreatorLastname string - -
UpdaterID long Person → ID -
UpdaterFirstname string - -
UpdaterLastname string - -
Completed boolean - -
StartDate string - -
DueDateBase string - -
DueDate string -
  • 21 Jul 2020 Format is yyyyMMdd
CreatedOn datetime - -
Position int - -
EstimatedMinutes int - -
Priority string - -
Progress int - -
HarvestEnabled boolean - -
ParentTaskID long Task → ID -
LockdownID string - -
TasklistLockdownID string - -
HasDependencies int - -
HasPredecessors int - -
HasTickets boolean - -
TimeIsLogged int - -
MinutesLogged decimal - -
BillableMinutesLogged decimal - -
AttachmentsCount int - -
ResponsiblePartyIds string - -
ResponsiblePartyID string - -
ResponsiblePartyNames string - -
ResponsiblePartyType string - -
ResponsiblePartyFirstname string - -
ResponsiblePartyLastname string - -
ResponsiblePartySummary string - -
CanEdit boolean - -
ViewEstimatedTime boolean - -
CreatorAvatarUrl string - -
CanLogTime boolean - -
UserFollowingComments boolean - -
UserFollowingChanges boolean - -
DLM int - -
LastChangedOn datetime - -

TaskCustomField

Documentation: https://developer.teamwork.com/projects/api/v3/tasks.json?includeCustomFields=true

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomfieldID long CustomField → ID -
TaskID long Task → ID -
Value string - -
CreatedAt datetime - -
CreatedBy long Person → ID -

TaskDependent

Documentation: https://apidocs.teamwork.com/docs/teamwork/c2736f23bca8c-retrieve-task-dependencies

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PredecessorTaskID long Task → ID -
DependentTaskID long Task → ID -
DependentCant string - -
CanSeeTask boolean - -
PredecessorMust string - -
Hardness string - -

TaskList

Documentation: https://developer.teamwork.com/projects/api-v3/ref/task-lists/get-projects-api-v3-projects-projectid-tasklists

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
DisplayOrder decimal - -
ProjectID long Project → ID -
MilestoneID long Milestone → ID -
IsPinned boolean - -
IsPrivate boolean - -
LockdownID boolean - -
Status string - -
DefaultTaskID long Task → ID -

Team

Documentation: https://apidocs.teamwork.com/docs/teamwork/d1979017754ec-get-all-teams

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
CreatedByUserID long Person → ID -
LogoIcon string - -
DeletedDate datetime - -
Handle string - -
DateUpdated datetime - -
NumMembers int - -
LogoUrl string - -
LogoColor string - -
NumDirectChildren int - -
CanEdit boolean - -
UpdatedByUserID int - -
IsPrivate boolean - -
DateCreated datetime - -
Deleted boolean - -
NumSubteams int - -

TimeLog

Documentation: https://developer.teamwork.com/projects/api-v3/ref/time-tracking/get-projects-api-v3-timejson

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
CreatedAt datetime - -
Minutes decimal - -
TimeLogged datetime - -
Billable boolean - -
Deleted boolean - -
DeletedAt datetime - -
HasStartTime boolean - -
UpdatedAt datetime - -
DeskTicketID int - -
InvoiceNumber string - -
UserID long Person → ID -
TaskID long Task → ID -
ProjectID long Project → ID -
LoggedByUserID long Person → ID -
DeletedByUserID long Person → ID -
EditedByUserID long Person → ID -
TaskIdPreMove int - -
ProjectBillingInvoiceID int - -

Workflow

Documentation: https://apidocs.teamwork.com/docs/teamwork/endpoints-by-object/workflows/get-projects-api-v3-workflows-json

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
UpdatedAt datetime - -
CreatedAt datetime - -
CreatedBy long - -
UpdatedBy long - -
Status string - -
ProjectSpecific boolean - -
DefaultWorkflow boolean - -

CustomFieldVisibility

Column Type Relates to Notes
RemoteID string - -
CustomFieldRemoteID string CustomField → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomFieldID long CustomField → ID -
Value string - -

CustomFieldOption

Column Type Relates to Notes
RemoteID string - -
CustomFieldRemoteID string CustomField → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Value string - -
Color string - -
Position int - -
CustomFieldID long CustomField → ID -

EventReminder

Column Type Relates to Notes
RemoteID string - -
EventRemoteID string Event → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Iterator int - -
EventID long Event → ID -
Before int - -
Period string - -
Type string - -

EventAttendingUser

Column Type Relates to Notes
RemoteID string - -
EventRemoteID string Event → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EventID long Event → ID -
PersonID long Person → ID -

EventNotifyUser

Column Type Relates to Notes
RemoteID string - -
EventRemoteID string Event → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EventID long Event → ID -
PersonID long Person → ID -

InvoiceLine

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Description string - -
InvoiceID long Invoice → ID -
Minutes decimal - -
DateLoggedUTC datetime - -
Rate decimal - -
DecimalHours decimal - -
Billable int - -
UserID long Person → ID -
TaskID long Task → ID -
Date datetime - -
Cost decimal - -
Hours decimal - -

MilestoneAssignee

Column Type Relates to Notes
RemoteID string - -
MilestoneRemoteID string Milestone → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MileStoneID long Milestone → ID -
PersonID long Person → ID -

MilestoneTaskList

Column Type Relates to Notes
RemoteID string - -
MilestoneRemoteID string Milestone → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MileStoneID long Milestone → ID -
TaskListID long TaskList → ID -

CurrentFeatureAnnouncement

Column Type Relates to Notes
RemoteID string - -
PersonRemoteID string Person → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
PersonID long Person → ID -
Date datetime - -
Code string - -
LinkText string - -
CalloutImage string - -
Link string - -
IsRead boolean - -
Title string - -
Text string - -
HTML string - -
Type string - -

PortfolioBoardColumnCardTag

Column Type Relates to Notes
RemoteID string - -
PortfolioBoardColumnCardRemoteID string PortfolioBoardColumnCard → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Color string - -
ProjectID long Project → ID -

ProjectCustomField

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
CustomFieldID long CustomField → ID -
Value string - -
ProjectID long Project → ID -

ProjectPerson

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PersonID long Person → ID -
ProjectID long Project → ID -

ProjectTag

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TagID long Tag → ID
  • 29 Jul 2020 This is the globally unique tag-id, it is not the ProjectTag relationship
ProjectID long Project → ID -

ProjectRateUser

Column Type Relates to Notes
RemoteID string - -
ProjectRateRemoteID string ProjectRate → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProjectRateID long ProjectRate → ProjectID -
UserID long Person → ID -
DefaultRate decimal - -
Rate decimal - -
Source string - -

ProofObject

Column Type Relates to Notes
RemoteID string - -
ProofRemoteID string Proof → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
ProofID long Proof → ID -
Version int - -
ApprovalStatus string - -
State string - -
StateMessage string - -
Title string - -
Type string - -
URL string - -
Format string - -
SourceFormat string - -
TotalChunks int - -
Size int - -
Thumbnail string - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -
InstallationID int - -
CreatedByID long Person → ID -
UpdatedByID long Person → ID -
DeletedByID long Person → ID -

ProofAssignee

Column Type Relates to Notes
RemoteID string - -
ProofRemoteID string Proof → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
ProofID long Proof → ID -
UserID long Person → ID -
Decision string - -
Role string - -
IsExternal boolean - -

TaskTag

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TagID long Tag → ID
  • 29 Jul 2020 This is the globally unique tag-id, it is not the TaskTag relationship
TaskID long Task → ID -

TaskAssignee

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PersonID long Person → ID -
TaskID long Task → ID -

TaskTeam

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TeamID long Team → ID -
TaskID long Task → ID -

TeamMember

Column Type Relates to Notes
RemoteID string - -
TeamRemoteID string Team → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PersonID long Person → ID -
TeamID long Team → ID -

TimeLogTag

Column Type Relates to Notes
RemoteID string - -
TimeLogRemoteID string TimeLog → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TimeLogID long TimeLog → ID -
TagID long Tag → ID -

WorkflowStage

Column Type Relates to Notes
RemoteID string - -
WorkflowRemoteID string Workflow → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
WorkflowID long Workflow → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -
CreatedBy long - -
UpdatedBy long - -
DeletedBy long Workflow → ID -
Color string - -
ShowCompletedTasks boolean - -
DisplayOrder int - -

WorkflowProject

Column Type Relates to Notes
RemoteID string - -
WorkflowRemoteID string Workflow → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long Project → ID -
WorkflowID long Workflow → ID -

WorkflowCompany

Column Type Relates to Notes
RemoteID string - -
WorkflowRemoteID string Workflow → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long Company → ID -
WorkflowID long Workflow → ID -

WorkflowStageTask

Column Type Relates to Notes
RemoteID string - -
WorkflowStageRemoteID string WorkflowStage → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskID long Task → ID -

Need more?

SyncHub lives and breathes APIs and data. Keep exploring using the links below.

Connect your own Teamwork data Querying Teamwork using regular SQL