共用方式為


socialactivity EntityType

For internal use only.

Entity set path: 
[organization URI]/api/data/v9.2/socialactivities
Base type: 
activitypointer
Table type: 
Standard
Display name: 
Social Activity
Primary key: 
activityid
Primary name column: 
subject
Operations supported: 
POST GET PATCH DELETE

Properties

Properties represent fields of data stored in the entity. Some properties are read-only.

Name Type Details
activityadditionalparams Edm.String

Additional information provided by the external application as JSON. For internal use only.

Display name: Additional Parameters

Inherited from: activitypointer

activityid Edm.Guid

Unique identifier of the activity.

Display name: Activity

Inherited from: activitypointer

activitytypecode Edm.String

Type of activity.

Display name: Activity Type

Inherited from: activitypointer

Read only
actualdurationminutes Edm.Int32

Actual duration of the activity in minutes.

Display name: Actual Duration

Inherited from: activitypointer

actualend Edm.DateTimeOffset

Actual end time of the activity.

Display name: Actual End

Inherited from: activitypointer

actualstart Edm.DateTimeOffset

Actual start time of the activity.

Display name: Actual Start

Inherited from: activitypointer

community Edm.Int32

Shows how contact about the social activity originated, such as from Twitter or Facebook. This field is read-only.

Display name: Social Channel

Inherited from: activitypointer

Default options
Values Label
1 Facebook
2 Twitter
0 Other
createdon Edm.DateTimeOffset

Date and time when the activity was created.

Display name: Created Date

Inherited from: activitypointer

Read only
deliverylastattemptedon Edm.DateTimeOffset

Date and time when the delivery of the activity was last attempted.

Inherited from: activitypointer

Read only
deliveryprioritycode Edm.Int32

Priority of delivery of the activity to the email server.

Inherited from: activitypointer

description Edm.String

Description of the activity.

Display name: Post Description

Inherited from: activitypointer

descriptionblobid Edm.Binary

File that contains description content.

Inherited from: activitypointer

Read only
descriptionblobid_name Edm.String

Inherited from: activitypointer

Read only
directioncode Edm.Boolean

Select the direction of the post as incoming or outbound.

Display name: Direction

Inherited from: activitypointer

Default options
Values Label
1 Outgoing
0 Incoming
exchangeitemid Edm.String

The message id of activity which is returned from Exchange Server.

Inherited from: activitypointer

exchangerate Edm.Decimal

Exchange rate for the currency associated with the activitypointer with respect to the base currency.

Display name: Exchange Rate

Inherited from: activitypointer

Read only
exchangeweblink Edm.String

Shows the web link of Activity of type email.

Inherited from: activitypointer

formattedscheduledend Edm.DateTimeOffset

Formatted scheduled end time of the activity.

Inherited from: activitypointer

Read only
formattedscheduledstart Edm.DateTimeOffset

Formatted scheduled start time of the activity.

Inherited from: activitypointer

Read only
importsequencenumber Edm.Int32

Sequence number of the import that created this record.

Display name: Import Sequence Number

Inherited from: activitypointer

inresponseto Edm.String

Unique identifier for the responses to a post. For internal use only.

Display name: In Response To

Inherited from: activitypointer

instancetypecode Edm.Int32

Type of instance of a recurring series.

Inherited from: activitypointer

Read only
isbilled Edm.Boolean

Information regarding whether the activity was billed as part of resolving a case.

Display name: Is Billed

Inherited from: activitypointer

Default options
Values Label
1 Yes
0 No
ismapiprivate Edm.Boolean

For internal use only.

Inherited from: activitypointer

isregularactivity Edm.Boolean

Information regarding whether the activity is a regular activity type or event type.

Display name: Is Regular Activity

Inherited from: activitypointer

Read only
Default options
Values Label
1 Yes
0 No
isworkflowcreated Edm.Boolean

Information regarding whether the activity was created from a workflow rule.

Display name: Is Workflow Created

Inherited from: activitypointer

Default options
Values Label
1 Yes
0 No
lastonholdtime Edm.DateTimeOffset

Contains the date and time stamp of the last on hold time.

Display name: Last On Hold Time

Inherited from: activitypointer

leftvoicemail Edm.Boolean

Left the voice mail

Inherited from: activitypointer

modifiedon Edm.DateTimeOffset

Date and time when activity was last modified.

Display name: Last Updated

Inherited from: activitypointer

Read only
onholdtime Edm.Int32

Shows how long, in minutes, that the record was on hold.

Display name: On Hold Time (Minutes)

Inherited from: activitypointer

Read only
overriddencreatedon Edm.DateTimeOffset

Date and time that the record was migrated.

Display name: Record Created On

Inherited from: activitypointer

postedon Edm.DateTimeOffset

For internal use only.

Display name: Created On

Inherited from: activitypointer

postid Edm.String

Unique identifier of the post. For internal use only.

Display name: Post ID

Inherited from: activitypointer

postmessagetype Edm.Int32

Shows if the social post originated as a private or public message.

Display name: Received As

Inherited from: activitypointer

Default options
Values Label
0 Public Message
1 Private Message
postponeactivityprocessinguntil Edm.DateTimeOffset

For internal use only.

Inherited from: activitypointer

Read only
posttoprofileid Edm.String

Shows the recipients of the social post.

Display name: Posted To

Inherited from: activitypointer

posturl Edm.String

Shows the URL of the post.

Display name: Post URL

Inherited from: activitypointer

prioritycode Edm.Int32

Priority of the activity.

Display name: Priority

Inherited from: activitypointer

Default options
Values Label
0 Low
1 Normal
2 High
processid Edm.Guid

Unique identifier of the Process.

Display name: Process

Inherited from: activitypointer

scheduleddurationminutes Edm.Int32

Scheduled duration of the activity, specified in minutes.

Display name: Scheduled Duration

Inherited from: activitypointer

scheduledend Edm.DateTimeOffset

Scheduled end time of the activity.

Display name: Due Date

Inherited from: activitypointer

scheduledstart Edm.DateTimeOffset

Scheduled start time of the activity.

Display name: Start Date

Inherited from: activitypointer

sentimentvalue Edm.Double

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.

Display name: Sentiment Value

Inherited from: activitypointer

senton Edm.DateTimeOffset

Date and time when the activity was sent.

Inherited from: activitypointer

Read only
seriesid Edm.Guid

Uniqueidentifier specifying the id of recurring series of an instance.

Inherited from: activitypointer

Read only
socialadditionalparams Edm.String

For internal use only.

Display name: Social Additional Parameters

Inherited from: activitypointer

sortdate Edm.DateTimeOffset

Shows the date and time by which the activities are sorted.

Display name: Sort Date

Inherited from: activitypointer

stageid Edm.Guid

Unique identifier of the Stage.

Display name: (Deprecated) Process Stage

Inherited from: activitypointer

statecode Edm.Int32

Status of the activity.

Display name: Status

Inherited from: activitypointer

Default options
Values Label
0 Open
1 Completed
2 Canceled
statuscode Edm.Int32

Reason for the status of the activity.

Display name: Status Reason

Inherited from: activitypointer

Default options
Values Label
1 Completed
2 Failed
3 Processing
4 Open
5 Canceled
subject Edm.String

Subject associated with the activity.

Display name: Subject

Inherited from: activitypointer

threadid Edm.String

Unique identifier of the social conversation. For internal use only.

Display name: Thread ID

Inherited from: activitypointer

timezoneruleversionnumber Edm.Int32

For internal use only.

Display name: Time Zone Rule Version Number

Inherited from: activitypointer

traversedpath Edm.String

For internal use only.

Display name: (Deprecated) Traversed Path

Inherited from: activitypointer

utcconversiontimezonecode Edm.Int32

Time zone code that was in use when the record was created.

Display name: UTC Conversion Time Zone Code

Inherited from: activitypointer

versionnumber Edm.Int64

Version number of the activity.

Display name: Version Number

Inherited from: activitypointer

Read only

Lookup properties

Lookup properties are read-only, computed properties which contain entity primary key Edm.Guid data for one or more corresponding single-valued navigation properties. More information: Lookup properties and Lookup property data.

Name Single-valued navigation property Description
_createdby_value createdby

Unique identifier of the user who created the activity.

_createdonbehalfby_value createdonbehalfby

Unique identifier of the delegate user who created the activitypointer.

_modifiedby_value modifiedby

Unique identifier of user who last modified the activity.

_modifiedonbehalfby_value modifiedonbehalfby

Unique identifier of the delegate user who last modified the activitypointer.

_ownerid_value ownerid

Unique identifier of the user or team who owns the activity.

_owningbusinessunit_value owningbusinessunit

Unique identifier of the business unit that owns the activity.

_owningteam_value owningteam

Unique identifier of the team that owns the activity.

_owninguser_value owninguser

Unique identifier of the user that owns the activity.

_postauthor_value postauthor_account
postauthor_contact

Shows the contact or account that authored the post.

_postauthoraccount_value postauthoraccount_account
postauthoraccount_contact

Shows the parent account of the author of the post.

_postfromprofileid_value postfromprofileid

Shows the author of the post on the corresponding social channel.

_regardingobjectid_value regardingobjectid_account
regardingobjectid_adx_invitation
regardingobjectid_contact
regardingobjectid_knowledgearticle
regardingobjectid_knowledgebaserecord
regardingobjectid_mspp_adplacement
regardingobjectid_mspp_pollplacement
regardingobjectid_mspp_publishingstatetransitionrule
regardingobjectid_mspp_redirect
regardingobjectid_mspp_shortcut
regardingobjectid_mspp_website
regardingobjectid_new_interactionforemail

Unique identifier of the object with which the activity is associated.

_sendermailboxid_value sendermailboxid

Unique identifier of the mailbox associated with the sender of the email message.

_slaid_value sla_activitypointer_sla

Choose the service level agreement (SLA) that you want to apply to the case record.

_slainvokedid_value slainvokedid_activitypointer_sla

Last SLA that was applied to this case. This field is for internal use only.

_transactioncurrencyid_value transactioncurrencyid

Unique identifier of the currency associated with the activitypointer.

Single-valued navigation properties

Single-valued navigation properties represent lookup fields where a single entity can be referenced. Each single-valued navigation property has a corresponding partner collection-valued navigation property on the related entity.

Name Type Partner
activityid_activitypointer activitypointer activity_pointer_socialactivity
createdby systemuser lk_activitypointer_createdby
createdby_socialactivity systemuser lk_socialactivity_createdby
createdonbehalfby systemuser lk_activitypointer_createdonbehalfby
createdonbehalfby_socialactivity systemuser lk_socialactivitybase_createdonbehalfby
modifiedby systemuser lk_activitypointer_modifiedby
modifiedby_socialactivity systemuser lk_socialactivity_modifiedby
modifiedonbehalfby systemuser lk_activitypointer_modifiedonbehalfby
modifiedonbehalfby_socialactivity systemuser lk_socialactivitybase_modifiedonbehalfby
ownerid principal owner_activitypointers
ownerid_socialactivity principal owner_socialactivities
owningbusinessunit businessunit business_unit_activitypointer
owningbusinessunit_socialactivity businessunit business_unit_socialactivity
owningteam team team_activity
owningteam_socialactivity team team_socialactivity
owninguser systemuser user_activity
owninguser_socialactivity systemuser user_socialactivity
postauthor_account account SocialActivity_PostAuthor_accounts
postauthor_contact contact socialactivity_postauthor_contacts
postauthoraccount_account account SocialActivity_PostAuthorAccount_accounts
postauthoraccount_contact contact socialactivity_postauthoraccount_contacts
postfromprofileid socialprofile Socialprofile_SocialActivities
regardingobjectid_account account Account_ActivityPointers
regardingobjectid_account_socialactivity account Account_SocialActivities
regardingobjectid_adx_invitation adx_invitation adx_invitation_ActivityPointers
regardingobjectid_adx_invitation_socialactivity adx_invitation adx_invitation_SocialActivities
regardingobjectid_asyncoperation asyncoperation AsyncOperation_SocialActivities
regardingobjectid_contact contact Contact_ActivityPointers
regardingobjectid_contact_socialactivity contact Contact_SocialActivities
regardingobjectid_knowledgearticle knowledgearticle KnowledgeArticle_ActivityPointers
regardingobjectid_knowledgearticle_socialactivity knowledgearticle KnowledgeArticle_SocialActivities
regardingobjectid_knowledgebaserecord knowledgebaserecord KnowledgeBaseRecord_ActivityPointers
regardingobjectid_knowledgebaserecord_socialactivity knowledgebaserecord KnowledgeBaseRecord_SocialActivities
regardingobjectid_mspp_adplacement mspp_adplacement mspp_adplacement_ActivityPointers
regardingobjectid_mspp_adplacement_socialactivity mspp_adplacement mspp_adplacement_SocialActivities
regardingobjectid_mspp_pollplacement mspp_pollplacement mspp_pollplacement_ActivityPointers
regardingobjectid_mspp_pollplacement_socialactivity mspp_pollplacement mspp_pollplacement_SocialActivities
regardingobjectid_mspp_publishingstatetransitionrule mspp_publishingstatetransitionrule mspp_publishingstatetransitionrule_ActivityPointers
regardingobjectid_mspp_publishingstatetransitionrule_socialactivity mspp_publishingstatetransitionrule mspp_publishingstatetransitionrule_SocialActivities
regardingobjectid_mspp_redirect mspp_redirect mspp_redirect_ActivityPointers
regardingobjectid_mspp_redirect_socialactivity mspp_redirect mspp_redirect_SocialActivities
regardingobjectid_mspp_shortcut mspp_shortcut mspp_shortcut_ActivityPointers
regardingobjectid_mspp_shortcut_socialactivity mspp_shortcut mspp_shortcut_SocialActivities
regardingobjectid_mspp_website mspp_website mspp_website_ActivityPointers
regardingobjectid_mspp_website_socialactivity mspp_website mspp_website_SocialActivities
regardingobjectid_new_interactionforemail interactionforemail new_interactionforemail_ActivityPointers
sendermailboxid mailbox activitypointer_sendermailboxid_mailbox
sla_activitypointer_sla sla manualsla_activitypointer
sla_socialactivity_sla sla manualsla_socialactivity
slainvokedid_activitypointer_sla sla sla_activitypointer
slainvokedid_socialactivity_sla sla sla_socialactivity
transactioncurrencyid transactioncurrency TransactionCurrency_ActivityPointer
transactioncurrencyid_socialactivity transactioncurrency transactioncurrency_socialactivity

Collection-valued navigation properties

Collection-valued navigation properties represent collections of entities which may represent either a one-to-many (1:N) or many-to-many (N:N) relationship between the entities.

Name Type Partner
activity_pointer_activity_mime_attachment activitymimeattachment objectid_activitypointer
activity_pointer_adx_inviteredemption adx_inviteredemption activityid_adx_inviteredemption
activity_pointer_adx_portalcomment adx_portalcomment activityid_adx_portalcomment
activity_pointer_appointment appointment activityid_activitypointer
activity_pointer_chat chat activityid_chat
activity_pointer_email email activityid_activitypointer
activity_pointer_fax fax activityid_activitypointer
activity_pointer_letter letter activityid_activitypointer
activity_pointer_phonecall phonecall activityid_activitypointer
activity_pointer_recurrencerule recurrencerule objectid
activity_pointer_recurringappointmentmaster recurringappointmentmaster activityid_activitypointer
activity_pointer_socialactivity socialactivity activityid_activitypointer
activity_pointer_task task activityid_activitypointer
activitypointer_activity_parties activityparty activityid_activitypointer
ActivityPointer_AsyncOperations asyncoperation regardingobjectid_activitypointer
ActivityPointer_BulkDeleteFailures bulkdeletefailure regardingobjectid_activitypointer
activitypointer_connections1 connection record1id_activitypointer
activitypointer_connections2 connection record2id_activitypointer
activitypointer_FileAttachments fileattachment objectid_activitypointer
ActivityPointer_QueueItem queueitem objectid_activitypointer
slakpiinstance_activitypointer slakpiinstance regarding_activitypointer
slakpiinstance_socialactivity slakpiinstance regarding_socialactivity
socialactivity_activity_parties activityparty activityid_socialactivity
SocialActivity_Annotation annotation objectid_socialactivity
SocialActivity_AsyncOperations asyncoperation regardingobjectid_socialactivity
SocialActivity_BulkDeleteFailures bulkdeletefailure regardingobjectid_socialactivity
socialactivity_connections1 connection record1id_socialactivity
socialactivity_connections2 connection record2id_socialactivity
SocialActivity_DuplicateBaseRecord duplicaterecord baserecordid_socialactivity
SocialActivity_DuplicateMatchingRecord duplicaterecord duplicaterecordid_socialactivity
socialactivity_principalobjectattributeaccess principalobjectattributeaccess objectid_socialactivity
SocialActivity_ProcessSessions processsession regardingobjectid_socialactivity
SocialActivity_QueueItem queueitem objectid_socialactivity
SocialActivity_SyncErrors syncerror regardingobjectid_socialactivity_syncerror

Operations

The following operations can be used with the socialactivity entity type.

Name Binding
GrantAccess Not Bound
ModifyAccess Not Bound
RetrievePrincipalAccess Not Bound
RetrieveSharedPrincipalsAndAccess Not Bound
RevokeAccess Not Bound

See also