RelationshipAttribute table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Stores relationship attributes mapping for Multi-predicate relationship
Added by: Metadata Extension Solution
Messages
| Message | Web API Operation | SDK Assembly |
|---|---|---|
| Retrieve | GET [org URI]/api/data/v9.0/relationshipattributes(relationshipattributeid) See Retrieve |
RetrieveRequest or Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/relationshipattributes See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
Properties
| Property | Value |
|---|---|
| CollectionSchemaName | RelationshipAttributes |
| DisplayCollectionName | Relationship Attributes |
| DisplayName | Relationship Attribute |
| EntitySetName | relationshipattributes |
| IsBPFEntity | False |
| LogicalCollectionName | relationshipattributes |
| LogicalName | relationshipattribute |
| OwnershipType | OrganizationOwned |
| PrimaryIdAttribute | relationshipattributeid |
| PrimaryNameAttribute | name |
| SchemaName | RelationshipAttribute |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- IsCustomizable
- Name
- ReferencedAttributeId
- ReferencingAttributeId
- RelationshipAttributeId
- RelationshipId
IsCustomizable
Added by: Basic Solution Solution
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Is Customizable |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | iscustomizable |
| RequiredLevel | SystemRequired |
| Type | ManagedProperty |
Name
| Property | Value |
|---|---|
| Description | Display Name |
| DisplayName | Display Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | name |
| MaxLength | 128 |
| RequiredLevel | None |
| Type | String |
ReferencedAttributeId
| Property | Value |
|---|---|
| Description | Referenced Attribute Id |
| DisplayName | Referenced Attribute Id |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | referencedattributeid |
| RequiredLevel | SystemRequired |
| Targets | attribute |
| Type | Lookup |
ReferencingAttributeId
| Property | Value |
|---|---|
| Description | Referencing Attribute Id |
| DisplayName | Referencing Attribute Id |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | referencingattributeid |
| RequiredLevel | SystemRequired |
| Targets | attribute |
| Type | Lookup |
RelationshipAttributeId
| Property | Value |
|---|---|
| Description | Unique identifier of the relationship attribute |
| DisplayName | Relationship Attribute Id |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | relationshipattributeid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
RelationshipId
| Property | Value |
|---|---|
| Description | Relationship Id |
| DisplayName | Relationship Id |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | relationshipid |
| RequiredLevel | SystemRequired |
| Targets | relationship |
| Type | Lookup |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- ComponentIdUnique
- ComponentState
- IsManaged
- OrganizationId
- OrganizationIdName
- OverwriteTime
- ReferencedAttributeIdName
- ReferencingAttributeIdName
- RelationshipIdName
- SolutionId
- SupportingSolutionId
ComponentIdUnique
Added by: Basic Solution Solution
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Row id unique |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | componentidunique |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
ComponentState
Added by: Basic Solution Solution
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Component State |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | componentstate |
| RequiredLevel | SystemRequired |
| Type | Picklist |
ComponentState Choices/Options
| Value | Label | Description |
|---|---|---|
| 0 | Published | |
| 1 | Unpublished | |
| 2 | Deleted | |
| 3 | Deleted Unpublished |
IsManaged
Added by: Basic Solution Solution
| Property | Value |
|---|---|
| Description | Indicates whether the solution component is part of a managed solution. |
| DisplayName | Is Managed |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | ismanaged |
| RequiredLevel | SystemRequired |
| Type | Boolean |
IsManaged Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Managed | |
| 0 | Unmanaged |
DefaultValue: False
OrganizationId
| Property | Value |
|---|---|
| Description | Unique identifier for the organization |
| DisplayName | Organization Id |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | organizationid |
| RequiredLevel | None |
| Targets | organization |
| Type | Lookup |
OrganizationIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | organizationidname |
| MaxLength | 160 |
| RequiredLevel | None |
| Type | String |
OverwriteTime
Added by: Basic Solution Solution
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | For internal use only. |
| DisplayName | Record Overwrite Time |
| Format | DateAndTime |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | overwritetime |
| RequiredLevel | SystemRequired |
| Type | DateTime |
ReferencedAttributeIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | referencedattributeidname |
| MaxLength | 128 |
| RequiredLevel | None |
| Type | String |
ReferencingAttributeIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | referencingattributeidname |
| MaxLength | 128 |
| RequiredLevel | None |
| Type | String |
RelationshipIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | relationshipidname |
| MaxLength | 255 |
| RequiredLevel | None |
| Type | String |
SolutionId
Added by: Basic Solution Solution
| Property | Value |
|---|---|
| Description | Unique identifier of the associated solution. |
| DisplayName | Solution |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | solutionid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
SupportingSolutionId
Added by: Basic Solution Solution
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Solution |
| IsValidForForm | False |
| IsValidForRead | False |
| LogicalName | supportingsolutionid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
One-To-Many Relationships
Listed by SchemaName.
- relationshipattribute_SyncErrors
- relationshipattribute_AsyncOperations
- relationshipattribute_MailboxTrackingFolders
- relationshipattribute_BulkDeleteFailures
- relationshipattribute_PrincipalObjectAttributeAccesses
relationshipattribute_SyncErrors
Added by: System Solution Solution
Same as syncerror table relationshipattribute_SyncErrors Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | relationshipattribute_SyncErrors |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
relationshipattribute_AsyncOperations
Added by: System Solution Solution
Same as asyncoperation table relationshipattribute_AsyncOperations Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | asyncoperation |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | relationshipattribute_AsyncOperations |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
relationshipattribute_MailboxTrackingFolders
Added by: System Solution Solution
Same as mailboxtrackingfolder table relationshipattribute_MailboxTrackingFolders Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | mailboxtrackingfolder |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | relationshipattribute_MailboxTrackingFolders |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
relationshipattribute_BulkDeleteFailures
Added by: System Solution Solution
Same as bulkdeletefailure table relationshipattribute_BulkDeleteFailures Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | bulkdeletefailure |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | relationshipattribute_BulkDeleteFailures |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
relationshipattribute_PrincipalObjectAttributeAccesses
Added by: System Solution Solution
Same as principalobjectattributeaccess table relationshipattribute_PrincipalObjectAttributeAccesses Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | principalobjectattributeaccess |
| ReferencingAttribute | objectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | relationshipattribute_PrincipalObjectAttributeAccesses |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.
- referencingattribute_relationshipattribute
- referencedattribute_relationshipattribute
- relationship_relationshipattribute
- organization_relationshipattribute
referencingattribute_relationshipattribute
Added by: System Solution Solution
See attribute Table referencingattribute_relationshipattribute One-To-Many relationship.
referencedattribute_relationshipattribute
Added by: System Solution Solution
See attribute Table referencedattribute_relationshipattribute One-To-Many relationship.
relationship_relationshipattribute
Added by: System Solution Solution
See relationship Table relationship_relationshipattribute One-To-Many relationship.
organization_relationshipattribute
Added by: System Solution Solution
See organization Table organization_relationshipattribute One-To-Many relationship.
See also
About the table reference
Web API Reference
relationshipattribute EntityType