Explore the Wrike data model

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

Try our interactive ERD Or, read the docs below

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

User

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

Column Type Relates to Notes
RemoteID string - -
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 - -

UserMetaData

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

Group

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

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

GroupMetaData

Column Type Relates to Notes
RemoteID string - -
GroupRemoteID string Group → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -

TimeLog

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

Column Type Relates to Notes
RemoteID string - -
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 - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
Order int - -
Hidden boolean - -

Folder

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

Column Type Relates to Notes
RemoteID string - -
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 - -

FolderMetaData

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

FolderCustomField

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

ChildFolder

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

Task

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

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean -
  • 16 Jun 2022 Based on task scope being RbTask (Recycling Bin)
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 - -

TaskMetaData

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

TaskCustomField

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

ChildTask

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

TaskAssignee

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

Comment

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

Column Type Relates to Notes
RemoteID string - -
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 -

Space

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

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

Workflow

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

Account

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

Column Type Relates to Notes
RemoteID string - -
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 - -

WorkflowStatus

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

Column Type Relates to Notes
RemoteID string - -
WorkflowRemoteID string Workflow → RemoteID -
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 -

CustomField

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

Column Type Relates to Notes
RemoteID string - -
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 - -

FolderTask

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

SpaceTask

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

CustomFieldOption

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

GroupMember

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

FolderOwner

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

Approval

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

Column Type Relates to Notes
RemoteID string - -
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 - -

ApprovalDecision

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

Attachment

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

Column Type Relates to Notes
RemoteID string - -
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 - -

ApprovalAttachment

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

SpaceFolder

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

Need more?

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

Connect your own Wrike data Interactive ERD Querying Wrike using regular SQL