Post table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
An activity feed post.
Messages
| Message | Web API Operation | SDK Assembly |
|---|---|---|
| Create | POST [org URI]/api/data/v9.0/posts See Create |
CreateRequest or Create |
| Delete | DELETE [org URI]/api/data/v9.0/posts(postid) See Delete |
DeleteRequest or Delete |
| Retrieve | GET [org URI]/api/data/v9.0/posts(postid) See Retrieve |
RetrieveRequest or Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/posts See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
Properties
| Property | Value |
|---|---|
| CollectionSchemaName | Posts |
| DisplayCollectionName | Posts |
| DisplayName | Post |
| EntitySetName | posts |
| IsBPFEntity | False |
| LogicalCollectionName | posts |
| LogicalName | post |
| OwnershipType | OrganizationOwned |
| PrimaryIdAttribute | postid |
| PrimaryNameAttribute | text |
| SchemaName | Post |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- LargeText
- PostId
- RegardingObjectId
- RegardingObjectIdName
- RegardingObjectTypeCode
- Source
- Text
- TimeZoneRuleVersionNumber
- Type
- UTCConversionTimeZoneCode
LargeText
Added by: Activities Patch Solution
| Property | Value |
|---|---|
| Description | Shows the text of a post. |
| DisplayName | Text |
| Format | |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | largetext |
| MaxLength | 1073741823 |
| RequiredLevel | ApplicationRequired |
| Type | Memo |
PostId
| Property | Value |
|---|---|
| Description | Unique identifier for entity instances |
| DisplayName | Post |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | postid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
RegardingObjectId
| Property | Value |
|---|---|
| Description | Choose the parent record for the post to identify the customer, opportunity, case, or other record that the post most closely relates to. |
| DisplayName | Regarding |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | regardingobjectid |
| RequiredLevel | SystemRequired |
| Targets | |
| Type | Lookup |
RegardingObjectIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | regardingobjectidname |
| MaxLength | 4000 |
| RequiredLevel | None |
| Type | String |
RegardingObjectTypeCode
| Property | Value |
|---|---|
| Description | Type of the RegardingObject |
| DisplayName | RegardingObjectTypeCode |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | regardingobjecttypecode |
| RequiredLevel | None |
| Type | EntityName |
Source
| Property | Value |
|---|---|
| Description | Select whether the post was created manually or automatically. |
| DisplayName | Source |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | source |
| RequiredLevel | ApplicationRequired |
| Type | Picklist |
Source Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Auto Post | |
| 2 | Manual Post | |
| 3 | ActionHub Post |
Text
| Property | Value |
|---|---|
| Description | Shows the text of a post. If this is a manual post, it appears in plain text. If this is an auto post, it appears in XML. |
| DisplayName | Text |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | text |
| MaxLength | 2000 |
| RequiredLevel | ApplicationRequired |
| Type | String |
TimeZoneRuleVersionNumber
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Time Zone Rule Version Number |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | timezoneruleversionnumber |
| MaxValue | 2147483647 |
| MinValue | -1 |
| RequiredLevel | None |
| Type | Integer |
Type
| Property | Value |
|---|---|
| Description | Select the post type. |
| DisplayName | Type |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | type |
| RequiredLevel | ApplicationRequired |
| Type | Picklist |
Type Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Check-in | |
| 2 | Idea | |
| 3 | News | |
| 4 | Private Message | |
| 5 | Question | |
| 6 | Re-post | |
| 7 | Status |
UTCConversionTimeZoneCode
| Property | Value |
|---|---|
| Description | Time zone code that was in use when the record was created. |
| DisplayName | UTC Conversion Time Zone Code |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | utcconversiontimezonecode |
| MaxValue | 2147483647 |
| MinValue | -1 |
| RequiredLevel | None |
| Type | Integer |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ModifiedBy
- ModifiedByName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OrganizationId
- OrganizationIdName
- PostRegardingId
- PostToYammer
- RegardingObjectIdYomiName
- RegardingObjectOwnerId
- RegardingObjectOwnerIdType
- RegardingObjectOwningBusinessUnit
- YammerPostState
- YammerRetryCount
CreatedBy
| Property | Value |
|---|---|
| Description | Shows who created the record. |
| DisplayName | Created By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | SystemRequired |
| Targets | systemuser |
| Type | Lookup |
CreatedByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. |
| DisplayName | Created On |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdon |
| RequiredLevel | None |
| Type | DateTime |
CreatedOnBehalfBy
| Property | Value |
|---|---|
| Description | Shows who created the record on behalf of another user. |
| DisplayName | Created By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdonbehalfby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedOnBehalfByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOnBehalfByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedBy
| Property | Value |
|---|---|
| Description | Unique identifier of the user who modified the record. |
| DisplayName | Modified By |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. |
| DisplayName | Modified On |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedon |
| RequiredLevel | None |
| Type | DateTime |
ModifiedOnBehalfBy
| Property | Value |
|---|---|
| Description | Unique identifier of the delegate user who modified the record. |
| DisplayName | Modified By (Delegate) |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedOnBehalfByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOnBehalfByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
OrganizationId
| Property | Value |
|---|---|
| Description | Unique identifier of the organization associated with the solution. |
| DisplayName | Organization |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | organizationid |
| RequiredLevel | SystemRequired |
| Targets | organization |
| Type | Lookup |
OrganizationIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | organizationidname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
PostRegardingId
| Property | Value |
|---|---|
| Description | Unique identifier of the post regarding with which the post is associated. |
| DisplayName | Post Regarding |
| IsValidForForm | False |
| IsValidForRead | False |
| LogicalName | postregardingid |
| RequiredLevel | SystemRequired |
| Targets | postregarding |
| Type | Lookup |
PostToYammer
| Property | Value |
|---|---|
| Description | Internal use only. |
| DisplayName | post to yammer |
| IsValidForForm | False |
| IsValidForRead | False |
| LogicalName | posttoyammer |
| RequiredLevel | None |
| Type | Boolean |
PostToYammer Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: False
RegardingObjectIdYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | regardingobjectidyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
RegardingObjectOwnerId
| Property | Value |
|---|---|
| Description | Unique identifier of the user or team who owns the regarding object. |
| DisplayName | Owner |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | regardingobjectownerid |
| RequiredLevel | SystemRequired |
| Targets | systemuser,team |
| Type | Owner |
RegardingObjectOwnerIdType
| Property | Value |
|---|---|
| Description | Type of the RegardingObjectOwnerId |
| DisplayName | RegardingObjectOwnerIdType |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | regardingobjectowneridtype |
| RequiredLevel | None |
| Type | EntityName |
RegardingObjectOwningBusinessUnit
| Property | Value |
|---|---|
| Description | Unique identifier of the business unit that owns the regarding object. |
| DisplayName | Regarding object owning Business Unit |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | regardingobjectowningbusinessunit |
| RequiredLevel | None |
| Targets | businessunit |
| Type | Lookup |
YammerPostState
| Property | Value |
|---|---|
| Description | Internal use only. |
| DisplayName | Yammer Post State |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | False |
| LogicalName | yammerpoststate |
| MaxValue | 5 |
| MinValue | 0 |
| RequiredLevel | None |
| Type | Integer |
YammerRetryCount
| Property | Value |
|---|---|
| Description | Internal use only. |
| DisplayName | Yammer Retry Count |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | False |
| LogicalName | yammerretrycount |
| MaxValue | 2147483647 |
| MinValue | 0 |
| RequiredLevel | None |
| Type | Integer |
One-To-Many Relationships
Listed by SchemaName.
post_AsyncOperations
Same as asyncoperation table post_AsyncOperations Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | asyncoperation |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | post_AsyncOperations |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
post_BulkDeleteFailures
Same as bulkdeletefailure table post_BulkDeleteFailures Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | bulkdeletefailure |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | post_BulkDeleteFailures |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Post_Comments
Same as postcomment table Post_Comments Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | postcomment |
| ReferencingAttribute | postid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | Post_Comments |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Post_Likes
Same as postlike table Post_Likes Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | postlike |
| ReferencingAttribute | postid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | Post_Likes |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
post_activity_file_attachment
Added by: Activities Patch Solution
Same as activityfileattachment table post_activity_file_attachment Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | activityfileattachment |
| ReferencingAttribute | parentid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | post_activity_file_attachment |
| 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.
- lk_post_createdby
- lk_post_createdonbehalfby
- lk_post_modifiedby
- lk_post_modifiedonbehalfby
- organization_post
lk_post_createdby
See systemuser Table lk_post_createdby One-To-Many relationship.
lk_post_createdonbehalfby
See systemuser Table lk_post_createdonbehalfby One-To-Many relationship.
lk_post_modifiedby
See systemuser Table lk_post_modifiedby One-To-Many relationship.
lk_post_modifiedonbehalfby
See systemuser Table lk_post_modifiedonbehalfby One-To-Many relationship.
organization_post
See organization Table organization_post One-To-Many relationship.