Explore the Wrike API data model

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

Try our interactive ERD Or, browse below

Pulling data from the Wrike 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 Wrike 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

Account

Documentation: https://developers.wrike.com/api/v4/account/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
DateFormat string - -
FirstDayOfWeek string - -
RootFolderID string -
  • 3 Aug 2020 I suspected that this might be a foreign key for folder, but testing proved otherwise.
RecycleBinID string - -
CreatedDate datetime - -

Approval

Documentation: https://developers.wrike.com/api/v4/approvals/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
TaskID string Task → ID -
FolderID string Folder → ID -
AuthorID string User → ID -
Title string - -
UpdatedDate datetime - -
DueDate datetime - -
Type string -
  • 22 Jun 2022 One of 'Regular' or 'FileOnly'
AutomationCustomStatusID string - -
AutoFinishOnApprove boolean - -
AutoFinishOnReject boolean - -
Finished boolean - -
FinisherID string User → ID -
Status string - -

Attachment

Documentation: https://developers.wrike.com/api/v4/attachments/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
TaskID string Task → ID -
FolderID string Folder → ID -
AuthorID string User → ID -
CreatedDate datetime - -
Version decimal - -
Type string - -
ContentType string - -
Size decimal - -
CommentID string Comment → ID -
CurrentAttachmentID string Attachment → ID
  • 22 Jun 2022 The ID of the current attachment version
PreviewUrl string - -
Width decimal - -
Height decimal - -

Comment

Documentation: https://developers.wrike.com/api/v4/comments/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
AuthorID string - -
Text string - -
UpdatedDate datetime - -
CreatedDate datetime - -
TaskID string Task → ID -
FolderID string Folder → ID -

CustomField

Documentation: https://developers.wrike.com/api/v4/custom-fields/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
AccountID string Account → ID -
Title string - -
Type string -
  • 3 Aug 2020 MediaTypeNames.Text/DropDown/Numeric etc.
InheritanceType string - -

Folder

Documentation: https://developers.wrike.com/api/v4/folders-projects/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
CreatedDate datetime - -
UpdatedDate datetime - -
HasAttachments boolean - -
Permalink string - -
WorkflowID string Workflow → ID -
WorkflowStatusID string WorkflowStatus → ID -
AuthorID string Contact → ID -
ProjectStatus string - -
Title string - -
Color string - -
Scope string - -
Space boolean - -
IsProject boolean - -

FolderTask

Column Type Relates to Notes
RemoteID string - -
FolderRemoteID string Folder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
FolderID string Folder → ID -
TaskID string Task → ID -

Group

Documentation: https://developers.wrike.com/api/v4/groups/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
AccountID string Account → ID -
Title string - -
AvatarUrl string - -

Space

Documentation: https://developers.wrike.com/api/v4/spaces/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Title string - -
AvatarUrl string - -
AccessType string - -
Archived boolean - -

SpaceFolder

Column Type Relates to Notes
RemoteID string - -
SpaceRemoteID string Space → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
SpaceID string Space → ID -
FolderID string Folder → ID -

SpaceTask

Column Type Relates to Notes
RemoteID string - -
SpaceRemoteID string Space → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
SpaceID string Space → ID -
TaskID string Task → ID -

Task

Documentation: https://developers.wrike.com/api/v4/tasks/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
BriefDescription string - -
Status string - -
CompletedDate datetime - -
HasAttachments boolean - -
AttachmentCount int - -
Recurrent boolean - -
TaskType string - -
TaskDuration int - -
TaskStart datetime - -
TaskDue datetime - -
TaskWorkOnWeekends boolean - -
AccountID string Account → ID -
Title string - -
Scope string - -
CustomStatusID string - -
Permalink string - -
Priority string - -
Importance string - -
CreatedDate datetime - -
UpdatedDate datetime - -

TimeLog

Documentation: https://developers.wrike.com/api/v4/timelogs/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
TaskID string Task → ID -
UserID string User → ID -
CategoryID string TimeLogCategory → ID -
Hours decimal - -
CreatedDate datetime - -
UpdatedDate datetime - -
TrackedDate string -
  • 19 May 2021 Note this is a string description, not a full UTC-formatted time
Comment string - -

TimeLogCategory

Documentation: https://developers.wrike.com/api/v4/timelog-categories/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
Order int - -
Hidden boolean - -

User

Documentation: https://developers.wrike.com/api/v4/users/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
Title string - -
CompanyName string - -
Phone string - -
Location string - -
FirstName string - -
LastName string - -
Type string - -
AvatarUrl string - -
Timezone string - -
Locale string - -
Deleted boolean - -
Me boolean - -
MyTeam boolean - -
Email string - -
FullName string - -

Workflow

Documentation: https://developers.wrike.com/api/v4/workflows/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
Stsandard boolean - -
Hidden boolean - -

WorkflowStatus

Documentation: https://developers.wrike.com/api/v4/workflows/

Column Type Relates to Notes
RemoteID string - -
WorkflowRemoteID string Workflow → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
StandardName boolean - -
Color string - -
Standard boolean - -
Group string - -
Hidden boolean - -
WorkflowID string Workflow → ID -

ApprovalDecision

Column Type Relates to Notes
RemoteID string - -
ApprovalRemoteID string Approval → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ApprovalID string Approval → ID -
ApproverID string User → ID -
Comment string - -
Status string - -
UpdatedDate datetime - -

ApprovalAttachment

Column Type Relates to Notes
RemoteID string - -
ApprovalRemoteID string Approval → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ApprovalID string Approval → ID -
AttachmentID string Attachment → ID -

CustomFieldOption

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

FolderOwner

Column Type Relates to Notes
RemoteID string - -
FolderRemoteID string Folder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID string User → ID -
FolderID string Folder → ID -

FolderMetaData

Column Type Relates to Notes
RemoteID string - -
FolderRemoteID string Folder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Key string - -
Value string - -
FolderID string Folder → ID -

ChildFolder

Column Type Relates to Notes
RemoteID string - -
FolderRemoteID string Folder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ChildID string Folder → ID -
ParentID string Folder → ID -

FolderCustomField

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

GroupMember

Column Type Relates to Notes
RemoteID string - -
GroupRemoteID string Group → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
GroupID string Group → ID -
UserID string User → ID -

TaskAssignee

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

ChildTask

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ChildID string Task → ID -
ParentID string Task → ID -

TaskCustomField

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

TaskMetaData

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

UserMetaData

Column Type Relates to Notes
RemoteID string - -
UserRemoteID string User → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UserID string User → ID -
Key string - -
Value string - -

Need more?

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

Connect your own Wrike data Querying Wrike using regular SQL