Explore the Wrike data model

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

Background

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

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

ChildFolder

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

ChildTask

Column Type Relates to Notes
RemoteID string - -
ChildTaskRemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ChildID string Task → ID -
ParentID 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 -

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.

CustomFieldOption

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

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 -
Title string - -
Color string - -
Scope string - -
Space boolean - -
IsProject boolean - -

FolderCustomField

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

FolderMetaData

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

FolderTask

Column Type Relates to Notes
RemoteID string - -
FolderTaskRemoteID string - -
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 - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
AccountID string Account → ID -
Title string - -
AvatarUrl string - -

GroupMember

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

GroupMetaData

Column Type Relates to Notes
RemoteID string - -
GroupMetaDataRemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -

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

SpaceTask

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

TaskAssignee

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

TaskCustomField

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

TaskMetaData

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

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

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 - -
UserMetaDataRemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UserID string User → ID -
Key string - -
Value string - -

Workflow

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

Need more?

Why not check out our interactive Entity Relationship Diagram.