2024 is the year of the connector - vote here

Explore the Asana API data model

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

Try our interactive ERD Or, browse below

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

CustomField

Documentation: https://developers.asana.com/reference/custom-fields

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Description string - -
ResourceType string - -
AsanaCreatedField string - -
CreatedByUserGID string User → Gid -
CurrencyCode string - -
CustomLabel string - -
CustomLabelPosition string - -
Format string - -
HasNotificationsEnabled boolean - -
IdPrefix string - -
IsFormulaField boolean - -
IsGlobalToWorkspace boolean - -
IsValueReadOnly boolean - -
Precision int - -
RepresentationType string - -
ResourceSubtype string - -
Type string - -
Gid string - -

Project

Documentation: https://developers.asana.com/reference/projects

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Archived boolean - -
Color string - -
DefaultAccessLevel string - -
DefaultView string - -
DueDate datetime - -
DueOn datetime - -
HtmlNotes string - -
ResourceType string - -
Notes string - -
Public boolean - -
StartOn datetime - -
WorkspaceGID string Workspace → Gid -
Completed boolean - -
CompletedAt datetime - -
CompletedByUserGID string User → Gid -
CreatedFromProjectTemplateGID string ProjectTemplate → Gid -
ModifiedAt datetime - -
CreatedAt datetime - -
Icon string - -
OwnerUserGID string User → Gid -
PermalinkUrl string - -
TeamGID string Team → Gid -
Gid string - -

ProjectTemplate

Documentation: https://developers.asana.com/reference/project-templates

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Description string - -
ResourceType string - -
Color string - -
HtmlDescription string - -
OwnerUserGID string User → Gid -
Public boolean - -
TeamGID string Team → Gid -
Gid string - -

Tag

Documentation: https://developers.asana.com/reference/tags

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
ResourceType string - -
Color string - -
Notes string - -
CreatedAt datetime - -
WorkspaceID string - -
PermalinkUrl string - -
Gid string - -

Task

Documentation: https://developers.asana.com/reference/tasks

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
ResourceType string - -
ActualTimeMinutes decimal - -
ApprovalStatus string - -
AssigneeStatus string - -
Completed boolean - -
CompletedAt datetime - -
CompletedByUserGID string User → Gid -
CreatedAt datetime - -
ModifiedAt datetime - -
DueAt datetime - -
DueOn datetime - -
HtmlNotes string - -
IsRenderedAsSeparator boolean - -
Liked boolean - -
Notes string - -
NumHearts int - -
NumLikes int - -
NumSubtasks int - -
ResourceSubtype string - -
StartAt datetime - -
StartOn datetime - -
AssigneeUserGID string User → Gid -
PermalinkUrl string - -
Gid string - -

Team

Documentation: https://developers.asana.com/reference/teams

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Description string - -
ResourceType string - -
EditTeamNameOrDescriptionAccessLevel string - -
EditTeamVisibilityOrTrashTeamAccessLevel string - -
GuestInviteManagementAccessLevel string - -
JoinRequestManagementAccessLevel string - -
MemberInviteManagementAccessLevel string - -
TeamMemberRemovalAccessLevel string - -
HtmlDescription string - -
WorkspaceGID string Workspace → Gid -
PermalinkUrl string - -
Visibility string - -
Gid string - -

TeamMembership

Documentation: https://developers.asana.com/reference/team-memberships

Column Type Relates to Notes
RemoteID string - -
TeamRemoteID string Team → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ResourceType string - -
IsAdmin boolean - -
IsGuest boolean - -
IsLimitedAccess boolean - -
TeamGID string Team → Gid -
UserGID string User → Gid -
Gid string - -

User

Documentation: https://developers.asana.com/reference/users

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
ResourceType string - -
Email string - -
Photo1024x1024 string - -
Photo128x128 string - -
Photo60x60 string - -
Photo36x36 string - -
Photo27x27 string - -
Photo21x21 string - -
Gid string - -

Workspace

Documentation: https://developers.asana.com/reference/workspaces

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
ResourceType string - -
IsOrganization boolean - -
TenantID string - -
Gid string - -

CustomFieldSelectOption

Column Type Relates to Notes
RemoteID string - -
CustomFieldRemoteID string CustomField → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
CustomFieldGID string CustomField → Gid -
CustomFieldSelectOptionGID string - -
ResourceType string - -
Color string - -
Enabled boolean - -

PortfolioMember

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PortfolioGID string Portfolio → Gid -
UserGID string User → Gid -

PortfolioCustomFieldSetting

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PortfolioGID string Portfolio → Gid -
PortfolioCustomFieldSettingGID string - -
ResourceType string - -
AsanaCreatedField string - -
IsImportant boolean - -
CustomFieldGID string CustomField → Gid -

ProjectMember

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProjectGID string Project → Gid -
UserGID string User → Gid -

ProjectCustomFieldSetting

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProjectGID string Project → Gid -
CustomFieldSettingGID string - -
ResourceType string - -
AsanaCreatedField string - -
IsImportant boolean - -
CustomFieldGID string CustomField → Gid -

TagFollower

Column Type Relates to Notes
RemoteID string - -
TagRemoteID string Tag → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TagGID string Tag → Gid -
UserGID string User → Gid -

TaskCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Description string - -
TaskGID string Task → Gid -
CustomFieldGID string CustomField → Gid -
DateValueDateTime datetime -
  • 16 Aug 2024 Will be NULL if no time component was provided (in this case, refer to the DateValueDate field)
DateValueDate datetime -
  • 16 Aug 2024 Format is YYYY-MM-DD
DisplayValue string - -
Enabled boolean - -
SelectValueGID string CustomFieldSelectOption → Gid -
NumberValue decimal - -
TextValue string - -

TaskFollower

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskGID string Task → Gid -
UserGID string User → Gid -

TaskTag

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskGID string Task → Gid -
TagGID string Tag → Gid -

UserWorkspace

Column Type Relates to Notes
RemoteID string - -
UserRemoteID string User → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UserGID string User → Gid -
WorkspaceGID string Workspace → Gid -

TaskCustomFieldMultiSelectValue

Column Type Relates to Notes
RemoteID string - -
TaskCustomFieldValueRemoteID string TaskCustomFieldValue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomFieldSelectOptionGID string CustomFieldSelectOption → Gid -

TaskCustomFieldPersonValue

Column Type Relates to Notes
RemoteID string - -
TaskCustomFieldValueRemoteID string TaskCustomFieldValue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UserGID string User → Gid -

Need more?

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

Connect your own Asana data Querying Asana using regular SQL