SocialActivity table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
For internal use only.
Messages
| Message | Web API Operation | SDK class or method |
|---|---|---|
| Assign | PATCH /socialactivities(activityid) Update ownerid property. |
AssignRequest |
| Create | POST /socialactivities See Create |
CreateRequest or Create |
| Delete | DELETE /socialactivities(activityid) See Delete |
DeleteRequest or Delete |
| GrantAccess | GrantAccess | GrantAccessRequest |
| ModifyAccess | ModifyAccess | ModifyAccessRequest |
| Retrieve | GET /socialactivities(activityid) See Retrieve |
RetrieveRequest or Retrieve |
| RetrieveMultiple | GET /socialactivities See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
| RetrievePrincipalAccess | RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
| RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
| RevokeAccess | RevokeAccess | RevokeAccessRequest |
| SetState | PATCH /socialactivities(activityid) Update statecode and statuscode properties. |
SetStateRequest |
| Update | PATCH /socialactivities(activityid) See Update |
UpdateRequest or Update |
Properties
| Property | Value |
|---|---|
| CollectionSchemaName | SocialActivities |
| DisplayCollectionName | Social Activities |
| DisplayName | Social Activity |
| EntitySetName | socialactivities |
| IsBPFEntity | False |
| LogicalCollectionName | socialactivities |
| LogicalName | socialactivity |
| OwnershipType | UserOwned |
| PrimaryIdAttribute | activityid |
| PrimaryNameAttribute | subject |
| SchemaName | SocialActivity |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- ActivityAdditionalParams
- ActivityId
- ActualDurationMinutes
- ActualEnd
- ActualStart
- Community
- Description
- DirectionCode
- From
- ImportSequenceNumber
- InResponseTo
- IsBilled
- IsWorkflowCreated
- LastOnHoldTime
- OverriddenCreatedOn
- OwnerId
- OwnerIdType
- PostAuthor
- PostAuthorAccount
- PostAuthorAccountType
- PostAuthorType
- PostedOn
- PostFromProfileId
- PostId
- PostMessageType
- PostToProfileId
- PostURL
- PriorityCode
- ProcessId
- RegardingObjectId
- RegardingObjectIdName
- RegardingObjectIdYomiName
- RegardingObjectTypeCode
- Resources
- ScheduledDurationMinutes
- ScheduledEnd
- ScheduledStart
- SentimentValue
- SLAId
- SocialAdditionalParams
- SortDate
- StageId
- StateCode
- StatusCode
- Subject
- ThreadId
- TimeZoneRuleVersionNumber
- To
- TransactionCurrencyId
- TraversedPath
- UTCConversionTimeZoneCode
ActivityAdditionalParams
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Additional Parameters |
| Format | TextArea |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | activityadditionalparams |
| MaxLength | 8192 |
| RequiredLevel | None |
| Type | Memo |
ActivityId
| Property | Value |
|---|---|
| Description | Unique identifier of the activity. |
| DisplayName | Activity |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | activityid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
ActualDurationMinutes
| Property | Value |
|---|---|
| Description | Actual duration of the activity in minutes. |
| DisplayName | Actual Duration |
| Format | Duration |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | actualdurationminutes |
| MaxValue | 2147483647 |
| MinValue | 0 |
| RequiredLevel | None |
| Type | Integer |
ActualEnd
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Actual end time of the activity. |
| DisplayName | Actual End |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | actualend |
| RequiredLevel | None |
| Type | DateTime |
ActualStart
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Actual start time of the activity. |
| DisplayName | Actual Start |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | actualstart |
| RequiredLevel | None |
| Type | DateTime |
Community
| Property | Value |
|---|---|
| Description | Shows how contact about the social activity originated, such as from Twitter or Facebook. This field is read-only. |
| DisplayName | Social Channel |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | community |
| RequiredLevel | None |
| Type | Picklist |
Community Choices/Options
| Value | Label | Description |
|---|---|---|
| 0 | Other | Other default |
| 1 | Facebook item. | |
| 2 | Twitter. |
Description
| Property | Value |
|---|---|
| Description | Shows information about the social post content. This field is read-only. |
| DisplayName | Post Description |
| Format | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | description |
| MaxLength | 2000 |
| RequiredLevel | None |
| Type | Memo |
DirectionCode
| Property | Value |
|---|---|
| Description | Select the direction of the post as incoming or outbound. |
| DisplayName | Direction |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | directioncode |
| RequiredLevel | None |
| Type | Boolean |
DirectionCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Outgoing | |
| 0 | Incoming |
DefaultValue: 0
From
| Property | Value |
|---|---|
| Description | Person who the activity is from. |
| DisplayName | From |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | from |
| RequiredLevel | None |
| Targets | account,contact,systemuser |
| Type | PartyList |
ImportSequenceNumber
| Property | Value |
|---|---|
| Description | Sequence number of the import that created this record. |
| DisplayName | Import Sequence Number |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | importsequencenumber |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
| RequiredLevel | None |
| Type | Integer |
InResponseTo
| Property | Value |
|---|---|
| Description | Unique identifier for the responses to a post. For internal use only. |
| DisplayName | In Response To |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | inresponseto |
| MaxLength | 160 |
| RequiredLevel | None |
| Type | String |
IsBilled
| Property | Value |
|---|---|
| Description | Information regarding whether the activity was billed as part of resolving a case. |
| DisplayName | Is Billed |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | isbilled |
| RequiredLevel | None |
| Type | Boolean |
IsBilled Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
IsWorkflowCreated
| Property | Value |
|---|---|
| Description | Information regarding whether the activity was created from a workflow rule. |
| DisplayName | Is Workflow Created |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | isworkflowcreated |
| RequiredLevel | None |
| Type | Boolean |
IsWorkflowCreated Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
LastOnHoldTime
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Contains the date and time stamp of the last on hold time. |
| DisplayName | Last On Hold Time |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | lastonholdtime |
| RequiredLevel | None |
| Type | DateTime |
OverriddenCreatedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time that the record was migrated. |
| DisplayName | Record Created On |
| Format | DateOnly |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | overriddencreatedon |
| RequiredLevel | None |
| Type | DateTime |
OwnerId
| Property | Value |
|---|---|
| Description | Unique identifier of the user or team who owns the activity. |
| DisplayName | Owner |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | ownerid |
| RequiredLevel | SystemRequired |
| Targets | systemuser,team |
| Type | Owner |
OwnerIdType
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridtype |
| RequiredLevel | SystemRequired |
| Type | EntityName |
PostAuthor
| Property | Value |
|---|---|
| Description | Shows the contact or account that authored the post. |
| DisplayName | Post Author |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | postauthor |
| RequiredLevel | None |
| Targets | account,contact |
| Type | Customer |
PostAuthorAccount
| Property | Value |
|---|---|
| Description | Shows the parent account of the author of the post. |
| DisplayName | Post Author Account |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | postauthoraccount |
| RequiredLevel | ApplicationRequired |
| Targets | account,contact |
| Type | Customer |
PostAuthorAccountType
| Property | Value |
|---|---|
| Description | Select the parent account or parent contact for the post author |
| DisplayName | Post author parent |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | postauthoraccounttype |
| RequiredLevel | None |
| Type | EntityName |
PostAuthorType
| Property | Value |
|---|---|
| Description | Select the parent account or parent contact for the social profile of the social activity |
| DisplayName | Post Author Type |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | postauthortype |
| RequiredLevel | None |
| Type | EntityName |
PostedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | For internal use only. |
| DisplayName | Created On |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | postedon |
| RequiredLevel | None |
| Type | DateTime |
PostFromProfileId
| Property | Value |
|---|---|
| Description | Shows the author of the post on the corresponding social channel. |
| DisplayName | Posted By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | postfromprofileid |
| RequiredLevel | None |
| Targets | socialprofile |
| Type | Lookup |
PostId
| Property | Value |
|---|---|
| Description | Unique identifier of the post. For internal use only. |
| DisplayName | Post ID |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | postid |
| MaxLength | 160 |
| RequiredLevel | None |
| Type | String |
PostMessageType
| Property | Value |
|---|---|
| Description | Shows if the social post originated as a private or public message. |
| DisplayName | Received As |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | postmessagetype |
| RequiredLevel | None |
| Type | Picklist |
PostMessageType Choices/Options
| Value | Label | Description |
|---|---|---|
| 0 | Public Message | |
| 1 | Private Message |
PostToProfileId
| Property | Value |
|---|---|
| Description | Shows the recipients of the social post. |
| DisplayName | Posted To |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | posttoprofileid |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
PostURL
| Property | Value |
|---|---|
| Description | Shows the URL of the post. |
| DisplayName | Post URL |
| FormatName | Url |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | posturl |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
PriorityCode
| Property | Value |
|---|---|
| Description | Shows the priority so that preferred customers or critical issues are handled quickly. |
| DisplayName | Priority |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | prioritycode |
| RequiredLevel | None |
| Type | Picklist |
PriorityCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 0 | Low | |
| 1 | Normal | |
| 2 | High |
ProcessId
| Property | Value |
|---|---|
| Description | Unique identifier of the Process. |
| DisplayName | Process |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | processid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
RegardingObjectId
| Property | Value |
|---|---|
| Description | Shows the record that the social activity relates to. |
| DisplayName | Regarding |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | regardingobjectid |
| RequiredLevel | None |
| Targets | account,adx_invitation,asyncoperation,contact,knowledgearticle,knowledgebaserecord,mspp_adplacement,mspp_pollplacement,mspp_publishingstatetransitionrule,mspp_redirect,mspp_shortcut,mspp_website |
| Type | Lookup |
RegardingObjectIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | regardingobjectidname |
| MaxLength | 400 |
| RequiredLevel | None |
| Type | String |
RegardingObjectIdYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | regardingobjectidyominame |
| MaxLength | 400 |
| RequiredLevel | None |
| Type | String |
RegardingObjectTypeCode
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | regardingobjecttypecode |
| RequiredLevel | None |
| Type | EntityName |
Resources
| Property | Value |
|---|---|
| Description | Users or facility/equipment that are required for the activity. |
| DisplayName | Resources |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | resources |
| RequiredLevel | None |
| Targets | systemuser |
| Type | PartyList |
ScheduledDurationMinutes
| Property | Value |
|---|---|
| Description | Scheduled duration of the activity, specified in minutes. |
| DisplayName | Scheduled Duration |
| Format | Duration |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | scheduleddurationminutes |
| MaxValue | 2147483647 |
| MinValue | 0 |
| RequiredLevel | None |
| Type | Integer |
ScheduledEnd
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Scheduled end time of the activity. |
| DisplayName | Due Date |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | scheduledend |
| RequiredLevel | None |
| Type | DateTime |
ScheduledStart
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Scheduled start time of the activity. |
| DisplayName | Start Date |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | scheduledstart |
| RequiredLevel | None |
| Type | DateTime |
SentimentValue
| Property | Value |
|---|---|
| Description | Value derived after assessing words commonly associated with a negative, neutral, or positive sentiment that occurs in a social post. Sentiment information can also be reported as numeric values. |
| DisplayName | Sentiment Value |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | sentimentvalue |
| MaxValue | 100000000000 |
| MinValue | -100000000000 |
| Precision | 2 |
| RequiredLevel | None |
| Type | Double |
SLAId
| Property | Value |
|---|---|
| Description | Choose the service level agreement (SLA) that you want to apply to the Social Activity record. |
| DisplayName | SLA |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | slaid |
| RequiredLevel | None |
| Targets | sla |
| Type | Lookup |
SocialAdditionalParams
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Social Additional Parameters |
| Format | TextArea |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | socialadditionalparams |
| MaxLength | 8192 |
| RequiredLevel | None |
| Type | Memo |
SortDate
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Shows the date and time by which the activities are sorted. |
| DisplayName | Sort Date |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | sortdate |
| RequiredLevel | None |
| Type | DateTime |
StageId
| Property | Value |
|---|---|
| Description | Unique identifier of the Stage. |
| DisplayName | (Deprecated) Process Stage |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | stageid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
StateCode
| Property | Value |
|---|---|
| Description | Shows whether the social activity completed. This field is read-only. |
| DisplayName | Status |
| IsValidForCreate | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statecode |
| RequiredLevel | SystemRequired |
| Type | State |
StateCode Choices/Options
| Value | Label | DefaultStatus | InvariantName |
|---|---|---|---|
| 0 | Open | 4 | Open |
| 1 | Completed | 3 | Completed |
| 2 | Canceled | 5 | Canceled |
StatusCode
| Property | Value |
|---|---|
| Description | Shows whether the social activity is completed, failed, or processing. This field is read-only. |
| DisplayName | Status Reason |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statuscode |
| RequiredLevel | None |
| Type | Status |
StatusCode Choices/Options
| Value | Label | State |
|---|---|---|
| 1 | Completed | 1 |
| 2 | Failed | 1 |
| 3 | Processing | 1 |
| 4 | Open | 0 |
| 5 | Canceled | 2 |
Subject
| Property | Value |
|---|---|
| Description | Subject associated with the activity. |
| DisplayName | Subject |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | subject |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
ThreadId
| Property | Value |
|---|---|
| Description | Unique identifier of the social conversation. For internal use only. |
| DisplayName | Thread ID |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | threadid |
| MaxLength | 160 |
| RequiredLevel | None |
| 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 |
To
| Property | Value |
|---|---|
| Description | Person who is the receiver of the activity. |
| DisplayName | To |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | to |
| RequiredLevel | None |
| Targets | account,contact,systemuser |
| Type | PartyList |
TransactionCurrencyId
| Property | Value |
|---|---|
| Description | Choose the local currency for the record to make sure budgets are reported in the correct currency. |
| DisplayName | Currency |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | transactioncurrencyid |
| RequiredLevel | None |
| Targets | transactioncurrency |
| Type | Lookup |
TraversedPath
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | (Deprecated) Traversed Path |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | traversedpath |
| MaxLength | 1250 |
| RequiredLevel | None |
| Type | String |
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.
- ActivityTypeCode
- CreatedBy
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ExchangeRate
- IsRegularActivity
- ModifiedBy
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OnHoldTime
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningBusinessUnitName
- OwningTeam
- OwningUser
- PostAuthorAccountName
- PostAuthorAccountYomiName
- PostAuthorName
- PostAuthorYomiName
- PostFromProfileIdName
- SLAInvokedId
- SLAInvokedIdName
- SLAName
- TransactionCurrencyIdName
- VersionNumber
ActivityTypeCode
| Property | Value |
|---|---|
| Description | Type of activity. |
| DisplayName | Activity Type |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | activitytypecode |
| RequiredLevel | SystemRequired |
| Type | EntityName |
CreatedBy
| Property | Value |
|---|---|
| Description | Unique identifier of the user who created the activity. |
| DisplayName | Created By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time when the activity was created. |
| DisplayName | Created Date |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdon |
| RequiredLevel | None |
| Type | DateTime |
CreatedOnBehalfBy
| Property | Value |
|---|---|
| Description | Unique identifier of the delegate user who created the activitypointer. |
| 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 |
ExchangeRate
| Property | Value |
|---|---|
| Description | Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency. |
| DisplayName | Exchange Rate |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | exchangerate |
| MaxValue | 100000000000 |
| MinValue | 0.000000000001 |
| Precision | 12 |
| RequiredLevel | None |
| Type | Decimal |
IsRegularActivity
| Property | Value |
|---|---|
| Description | Information regarding whether the activity is a regular activity type or event type. |
| DisplayName | Is Regular Activity |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | isregularactivity |
| RequiredLevel | SystemRequired |
| Type | Boolean |
IsRegularActivity Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 1
ModifiedBy
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Modified By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
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 | Last Updated |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedon |
| RequiredLevel | None |
| Type | DateTime |
ModifiedOnBehalfBy
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Modified By (Delegate) |
| IsValidForForm | True |
| 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 |
OnHoldTime
| Property | Value |
|---|---|
| Description | Shows how long, in minutes, that the record was on hold. |
| DisplayName | On Hold Time (Minutes) |
| Format | None |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | onholdtime |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
| RequiredLevel | None |
| Type | Integer |
OwnerIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwnerIdYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwningBusinessUnit
| Property | Value |
|---|---|
| Description | Unique identifier of the business unit that owns the activity. |
| DisplayName | Owning Business Unit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | owningbusinessunit |
| RequiredLevel | None |
| Targets | businessunit |
| Type | Lookup |
OwningBusinessUnitName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningbusinessunitname |
| MaxLength | 160 |
| RequiredLevel | None |
| Type | String |
OwningTeam
| Property | Value |
|---|---|
| Description | Unique identifier of the team that owns the activity. |
| DisplayName | Owning Team |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningteam |
| RequiredLevel | None |
| Targets | team |
| Type | Lookup |
OwningUser
| Property | Value |
|---|---|
| Description | Unique identifier of the user who owns the Activity. |
| DisplayName | Owning User |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owninguser |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
PostAuthorAccountName
| Property | Value |
|---|---|
| Description | Select the parent account or parent contact for post author. |
| DisplayName | Post author parent |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | postauthoraccountname |
| MaxLength | 160 |
| RequiredLevel | ApplicationRequired |
| Type | String |
PostAuthorAccountYomiName
| Property | Value |
|---|---|
| Description | Select the parent account or parent contact for the post author |
| DisplayName | Post author parent |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | postauthoraccountyominame |
| MaxLength | 450 |
| RequiredLevel | ApplicationRequired |
| Type | String |
PostAuthorName
| Property | Value |
|---|---|
| Description | Account or contact associated with the social profile or author of the post. |
| DisplayName | Post Author Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | postauthorname |
| MaxLength | 160 |
| RequiredLevel | ApplicationRequired |
| Type | String |
PostAuthorYomiName
| Property | Value |
|---|---|
| Description | Parent account or parent contact for the social profile of the social activity |
| DisplayName | Post Author Yomi Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | postauthoryominame |
| MaxLength | 450 |
| RequiredLevel | ApplicationRequired |
| Type | String |
PostFromProfileIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | postedbyname |
| MaxLength | 100 |
| RequiredLevel | ApplicationRequired |
| Type | String |
SLAInvokedId
| Property | Value |
|---|---|
| Description | Last SLA that was applied to this Social Activity. This field is for internal use only. |
| DisplayName | Last SLA applied |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | slainvokedid |
| RequiredLevel | None |
| Targets | sla |
| Type | Lookup |
SLAInvokedIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | slainvokedidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
SLAName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | slaname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
TransactionCurrencyIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | transactioncurrencyidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
VersionNumber
| Property | Value |
|---|---|
| Description | Version number of the social activity. |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
One-To-Many Relationships
Listed by SchemaName.
- socialactivity_principalobjectattributeaccess
- socialactivity_activity_parties
- SocialActivity_BulkDeleteFailures
- SocialActivity_QueueItem
- SocialActivity_SyncErrors
- slakpiinstance_socialactivity
- SocialActivity_DuplicateBaseRecord
- SocialActivity_AsyncOperations
- SocialActivity_ProcessSessions
- SocialActivity_DuplicateMatchingRecord
- socialactivity_connections1
- SocialActivity_Annotation
- socialactivity_connections2
socialactivity_principalobjectattributeaccess
Same as the socialactivity_principalobjectattributeaccess many-to-one relationship for the principalobjectattributeaccess table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | principalobjectattributeaccess |
| ReferencingAttribute | objectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | socialactivity_principalobjectattributeaccess |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
socialactivity_activity_parties
Same as the socialactivity_activity_parties many-to-one relationship for the activityparty table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | activityparty |
| ReferencingAttribute | activityid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | socialactivity_activity_parties |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SocialActivity_BulkDeleteFailures
Same as the SocialActivity_BulkDeleteFailures many-to-one relationship for the bulkdeletefailure table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | bulkdeletefailure |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | SocialActivity_BulkDeleteFailures |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SocialActivity_QueueItem
Same as the SocialActivity_QueueItem many-to-one relationship for the queueitem table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | queueitem |
| ReferencingAttribute | objectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | SocialActivity_QueueItem |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SocialActivity_SyncErrors
Same as the SocialActivity_SyncErrors many-to-one relationship for the syncerror table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | SocialActivity_SyncErrors |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
slakpiinstance_socialactivity
Same as the slakpiinstance_socialactivity many-to-one relationship for the slakpiinstance table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | slakpiinstance |
| ReferencingAttribute | regarding |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | slakpiinstance_socialactivity |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SocialActivity_DuplicateBaseRecord
Same as the SocialActivity_DuplicateBaseRecord many-to-one relationship for the duplicaterecord table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | duplicaterecord |
| ReferencingAttribute | baserecordid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | SocialActivity_DuplicateBaseRecord |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SocialActivity_AsyncOperations
Same as the SocialActivity_AsyncOperations many-to-one relationship for the asyncoperation table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | asyncoperation |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | SocialActivity_AsyncOperations |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SocialActivity_ProcessSessions
Same as the SocialActivity_ProcessSessions many-to-one relationship for the processsession table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | processsession |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | SocialActivity_ProcessSessions |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 110 |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SocialActivity_DuplicateMatchingRecord
Same as the SocialActivity_DuplicateMatchingRecord many-to-one relationship for the duplicaterecord table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | duplicaterecord |
| ReferencingAttribute | duplicaterecordid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | SocialActivity_DuplicateMatchingRecord |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
socialactivity_connections1
Same as the socialactivity_connections1 many-to-one relationship for the connection table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | connection |
| ReferencingAttribute | record1id |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | socialactivity_connections1 |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 100 |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SocialActivity_Annotation
Same as the SocialActivity_Annotation many-to-one relationship for the annotation table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | annotation |
| ReferencingAttribute | objectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | SocialActivity_Annotation |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
socialactivity_connections2
Same as the socialactivity_connections2 many-to-one relationship for the connection table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | connection |
| ReferencingAttribute | record2id |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | socialactivity_connections2 |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: 100 |
| 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.
- KnowledgeBaseRecord_SocialActivities
- socialactivity_postauthoraccount_contacts
- KnowledgeArticle_SocialActivities
- activity_pointer_socialactivity
- SocialActivity_PostAuthorAccount_accounts
- lk_socialactivity_createdby
- Account_SocialActivities
- transactioncurrency_socialactivity
- sla_socialactivity
- user_socialactivity
- business_unit_socialactivity
- socialactivity_postauthor_contacts
- team_socialactivity
- manualsla_socialactivity
- SocialActivity_PostAuthor_accounts
- Socialprofile_SocialActivities
- AsyncOperation_SocialActivities
- lk_socialactivity_modifiedby
- lk_socialactivitybase_createdonbehalfby
- lk_socialactivitybase_modifiedonbehalfby
- Contact_SocialActivities
- adx_invitation_SocialActivities
- mspp_adplacement_SocialActivities
- mspp_pollplacement_SocialActivities
- mspp_publishingstatetransitionrule_SocialActivities
- mspp_redirect_SocialActivities
- mspp_shortcut_SocialActivities
- mspp_website_SocialActivities
KnowledgeBaseRecord_SocialActivities
See the KnowledgeBaseRecord_SocialActivities one-to-many relationship for the knowledgebaserecord table/entity.
socialactivity_postauthoraccount_contacts
See the socialactivity_postauthoraccount_contacts one-to-many relationship for the contact table/entity.
KnowledgeArticle_SocialActivities
See the KnowledgeArticle_SocialActivities one-to-many relationship for the knowledgearticle table/entity.
activity_pointer_socialactivity
See the activity_pointer_socialactivity one-to-many relationship for the activitypointer table/entity.
SocialActivity_PostAuthorAccount_accounts
See the SocialActivity_PostAuthorAccount_accounts one-to-many relationship for the account table/entity.
lk_socialactivity_createdby
See the lk_socialactivity_createdby one-to-many relationship for the systemuser table/entity.
Account_SocialActivities
See the Account_SocialActivities one-to-many relationship for the account table/entity.
transactioncurrency_socialactivity
See the transactioncurrency_socialactivity one-to-many relationship for the transactioncurrency table/entity.
sla_socialactivity
See the sla_socialactivity one-to-many relationship for the sla table/entity.
user_socialactivity
See the user_socialactivity one-to-many relationship for the systemuser table/entity.
business_unit_socialactivity
See the business_unit_socialactivity one-to-many relationship for the businessunit table/entity.
socialactivity_postauthor_contacts
See the socialactivity_postauthor_contacts one-to-many relationship for the contact table/entity.
team_socialactivity
See the team_socialactivity one-to-many relationship for the team table/entity.
manualsla_socialactivity
See the manualsla_socialactivity one-to-many relationship for the sla table/entity.
SocialActivity_PostAuthor_accounts
See the SocialActivity_PostAuthor_accounts one-to-many relationship for the account table/entity.
Socialprofile_SocialActivities
See the Socialprofile_SocialActivities one-to-many relationship for the socialprofile table/entity.
AsyncOperation_SocialActivities
See the AsyncOperation_SocialActivities one-to-many relationship for the asyncoperation table/entity.
lk_socialactivity_modifiedby
See the lk_socialactivity_modifiedby one-to-many relationship for the systemuser table/entity.
lk_socialactivitybase_createdonbehalfby
See the lk_socialactivitybase_createdonbehalfby one-to-many relationship for the systemuser table/entity.
lk_socialactivitybase_modifiedonbehalfby
See the lk_socialactivitybase_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
Contact_SocialActivities
See the Contact_SocialActivities one-to-many relationship for the contact table/entity.
adx_invitation_SocialActivities
Added by: Power Pages Runtime Core Solution
See the adx_invitation_SocialActivities one-to-many relationship for the adx_invitation table/entity.
mspp_adplacement_SocialActivities
Added by: Power Pages Apps Solution
See the mspp_adplacement_SocialActivities one-to-many relationship for the mspp_adplacement table/entity.
mspp_pollplacement_SocialActivities
Added by: Power Pages Apps Solution
See the mspp_pollplacement_SocialActivities one-to-many relationship for the mspp_pollplacement table/entity.
mspp_publishingstatetransitionrule_SocialActivities
Added by: Power Pages Apps Solution
See the mspp_publishingstatetransitionrule_SocialActivities one-to-many relationship for the mspp_publishingstatetransitionrule table/entity.
mspp_redirect_SocialActivities
Added by: Power Pages Apps Solution
See the mspp_redirect_SocialActivities one-to-many relationship for the mspp_redirect table/entity.
mspp_shortcut_SocialActivities
Added by: Power Pages Apps Solution
See the mspp_shortcut_SocialActivities one-to-many relationship for the mspp_shortcut table/entity.
mspp_website_SocialActivities
Added by: Power Pages Apps Solution
See the mspp_website_SocialActivities one-to-many relationship for the mspp_website table/entity.
See also
Dataverse table/entity reference
Web API Reference
socialactivity EntityType
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for