SocialProfile table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
This entity is used to store social profile information of its associated account and contacts on different social channels.
Messages
Message | Web API Operation | SDK class or method |
---|---|---|
Assign | PATCH /socialprofiles(socialprofileid) Update ownerid property. |
AssignRequest |
Create | POST /socialprofiles See Create |
CreateRequest or Create |
Delete | DELETE /socialprofiles(socialprofileid) See Delete |
DeleteRequest or Delete |
GenerateSocialProfile | GenerateSocialProfile | GenerateSocialProfileRequest |
GrantAccess | GrantAccess | GrantAccessRequest |
ModifyAccess | ModifyAccess | ModifyAccessRequest |
Retrieve | GET /socialprofiles(socialprofileid) See Retrieve |
RetrieveRequest or Retrieve |
RetrieveMultiple | GET /socialprofiles See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
RetrievePrincipalAccess | RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccess | RevokeAccess | RevokeAccessRequest |
SetState | PATCH /socialprofiles(socialprofileid) Update statecode and statuscode properties. |
SetStateRequest |
Update | PATCH /socialprofiles(socialprofileid) See Update |
UpdateRequest or Update |
Properties
Property | Value |
---|---|
CollectionSchemaName | SocialProfiles |
DisplayCollectionName | Social Profiles |
DisplayName | Social Profile |
EntitySetName | socialprofiles |
IsBPFEntity | False |
LogicalCollectionName | socialprofiles |
LogicalName | socialprofile |
OwnershipType | UserOwned |
PrimaryIdAttribute | socialprofileid |
PrimaryNameAttribute | profilename |
SchemaName | SocialProfile |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- Blocked
- Community
- CustomerId
- CustomerIdName
- CustomerIdType
- CustomerIdYomiName
- ImportSequenceNumber
- InfluenceScore
- OverriddenCreatedOn
- OwnerId
- OwnerIdName
- OwnerIdType
- ProfileFullName
- ProfileLink
- ProfileName
- SocialProfileId
- StateCode
- StatusCode
- TimeZoneRuleVersionNumber
- TransactionCurrencyId
- UniqueProfileID
- UTCConversionTimeZoneCode
Blocked
Property | Value |
---|---|
Description | Identifies if the social profile has been blocked. |
DisplayName | Blocked |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | blocked |
RequiredLevel | None |
Type | Boolean |
Blocked Choices/Options
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
Community
Property | Value |
---|---|
Description | Identifies where the social profile originated from, such as Twitter, or Facebook. |
DisplayName | Social Channel |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | community |
RequiredLevel | None |
Type | Picklist |
Community Choices/Options
Value | Label | Description |
---|---|---|
0 | Other | Other default |
1 | Facebook item. | |
2 | Twitter. |
CustomerId
Property | Value |
---|---|
Description | Shows the customer that this social profile belongs to. |
DisplayName | Customer |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | customerid |
RequiredLevel | None |
Targets | account,contact |
Type | Customer |
CustomerIdName
Property | Value |
---|---|
Description | Select the parent account or parent contact for the contact to provide a quick link to additional details, such as financial information, activities, and opportunities. |
DisplayName | Parent Customer Type |
FormatName | Text |
IsLocalizable | False |
IsValidForCreate | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | customeridname |
MaxLength | 160 |
RequiredLevel | None |
Type | String |
CustomerIdType
Property | Value |
---|---|
Description | Select the parent account or parent contact for the contact |
DisplayName | Parent Customer Type |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | customeridtype |
RequiredLevel | None |
Type | EntityName |
CustomerIdYomiName
Property | Value |
---|---|
Description | Select the parent account or parent contact for the contact |
DisplayName | Parent Customer Type |
FormatName | Text |
IsLocalizable | False |
IsValidForCreate | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | customeridyominame |
MaxLength | 450 |
RequiredLevel | None |
Type | String |
ImportSequenceNumber
Property | Value |
---|---|
Description | Unique identifier of the data import or data migration 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 |
InfluenceScore
Property | Value |
---|---|
Description | Shows the score that determines the online social influence of the social profile. |
DisplayName | Influence Score |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | influencescore |
MaxValue | 1000000000 |
MinValue | 0 |
Precision | 2 |
RequiredLevel | None |
Type | Double |
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 | Shows the user or team that is assigned to manage the record. This field is updated every time the record is assigned to a different user. |
DisplayName | Owner |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | ownerid |
RequiredLevel | SystemRequired |
Targets | systemuser,team |
Type | Owner |
OwnerIdName
Property | Value |
---|---|
Description | Name of the owner |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForCreate | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
OwnerIdType
Property | Value |
---|---|
Description | Owner Id Type |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridtype |
RequiredLevel | SystemRequired |
Type | EntityName |
ProfileFullName
Property | Value |
---|---|
Description | Shows the display name of the customer on this social profile. |
DisplayName | Full Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | profilefullname |
MaxLength | 160 |
RequiredLevel | None |
Type | String |
ProfileLink
Property | Value |
---|---|
Description | Shows the customer that this social profile belongs to. |
DisplayName | Profile Link |
FormatName | Url |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | profilelink |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ProfileName
Property | Value |
---|---|
Description | Shows the name of the social profile on the corresponding social channel. |
DisplayName | Profile Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | profilename |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
SocialProfileId
Property | Value |
---|---|
Description | Unique Identifier of the social profile name. |
DisplayName | Social Profile ID |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | socialprofileid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
StateCode
Property | Value |
---|---|
Description | Status of the Social Profile |
DisplayName | Status |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statecode |
RequiredLevel | SystemRequired |
Type | State |
StateCode Choices/Options
Value | Label | DefaultStatus | InvariantName |
---|---|---|---|
0 | Active | 1 | Active |
1 | Inactive | 2 | Inactive |
StatusCode
Property | Value |
---|---|
Description | Reason for the status of the Social Profile |
DisplayName | Status Reason |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statuscode |
RequiredLevel | None |
Type | Status |
StatusCode Choices/Options
Value | Label | State |
---|---|---|
1 | Active | 0 |
2 | Inactive | 1 |
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 |
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 |
UniqueProfileID
Property | Value |
---|---|
Description | Unique ID of the Profile ID |
DisplayName | Unique Profile ID |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | uniqueprofileid |
MaxLength | 100 |
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.
- CreatedBy
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ExchangeRate
- ModifiedBy
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningBusinessUnitName
- OwningTeam
- OwningUser
- TransactionCurrencyIdName
- VersionNumber
CreatedBy
Property | Value |
---|---|
Description | Unique identifier of the user who created the record. |
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 record was created. |
DisplayName | Created On |
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 record. |
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 |
ModifiedBy
Property | Value |
---|---|
Description | Unique identifier of the user who modified the record. |
DisplayName | Modified By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
ModifiedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time when the record was modified. |
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 | 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 |
OwnerIdYomiName
Property | Value |
---|---|
Description | Yomi name of the owner |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridyominame |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
OwningBusinessUnit
Property | Value |
---|---|
Description | Unique identifier for the business unit that owns the record |
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 who owns the contact. |
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 contact. |
DisplayName | Owning User |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owninguser |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
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 profile. |
DisplayName | Version Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | versionnumber |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
One-To-Many Relationships
Listed by SchemaName.
- SocialProfile_ProcessSessions
- SocialProfile_DuplicateBaseRecord
- SocialProfile_DuplicateMatchingRecord
- Socialprofile_SocialActivities
- socialprofile_principalobjectattributeaccess
- SocialProfile_SyncErrors
- socialprofile_connections2
- SocialProfile_AsyncOperations
- socialprofile_connections1
SocialProfile_ProcessSessions
Same as the SocialProfile_ProcessSessions many-to-one relationship for the processsession table/entity.
Property | Value |
---|---|
ReferencingEntity | processsession |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | SocialProfile_ProcessSessions |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 110 |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SocialProfile_DuplicateBaseRecord
Same as the SocialProfile_DuplicateBaseRecord many-to-one relationship for the duplicaterecord table/entity.
Property | Value |
---|---|
ReferencingEntity | duplicaterecord |
ReferencingAttribute | baserecordid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | SocialProfile_DuplicateBaseRecord |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SocialProfile_DuplicateMatchingRecord
Same as the SocialProfile_DuplicateMatchingRecord many-to-one relationship for the duplicaterecord table/entity.
Property | Value |
---|---|
ReferencingEntity | duplicaterecord |
ReferencingAttribute | duplicaterecordid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | SocialProfile_DuplicateMatchingRecord |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Socialprofile_SocialActivities
Same as the Socialprofile_SocialActivities many-to-one relationship for the socialactivity table/entity.
Property | Value |
---|---|
ReferencingEntity | socialactivity |
ReferencingAttribute | postfromprofileid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | Socialprofile_SocialActivities |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
socialprofile_principalobjectattributeaccess
Same as the socialprofile_principalobjectattributeaccess many-to-one relationship for the principalobjectattributeaccess table/entity.
Property | Value |
---|---|
ReferencingEntity | principalobjectattributeaccess |
ReferencingAttribute | objectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | socialprofile_principalobjectattributeaccess |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SocialProfile_SyncErrors
Same as the SocialProfile_SyncErrors many-to-one relationship for the syncerror table/entity.
Property | Value |
---|---|
ReferencingEntity | syncerror |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | SocialProfile_SyncErrors |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
socialprofile_connections2
Same as the socialprofile_connections2 many-to-one relationship for the connection table/entity.
Property | Value |
---|---|
ReferencingEntity | connection |
ReferencingAttribute | record2id |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | socialprofile_connections2 |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: 100 |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: Cascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SocialProfile_AsyncOperations
Same as the SocialProfile_AsyncOperations many-to-one relationship for the asyncoperation table/entity.
Property | Value |
---|---|
ReferencingEntity | asyncoperation |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | SocialProfile_AsyncOperations |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
socialprofile_connections1
Same as the socialprofile_connections1 many-to-one relationship for the connection table/entity.
Property | Value |
---|---|
ReferencingEntity | connection |
ReferencingAttribute | record1id |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | socialprofile_connections1 |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 100 |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: Cascade 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.
- transactioncurrency_SocialProfile
- business_unit_socialprofiles
- Socialprofile_customer_contacts
- lk_SocialProfile_createdonbehalfby
- socialProfile_owning_user
- lk_SocialProfile_modifiedonbehalfby
- Socialprofile_customer_accounts
transactioncurrency_SocialProfile
See the transactioncurrency_SocialProfile one-to-many relationship for the transactioncurrency table/entity.
business_unit_socialprofiles
See the business_unit_socialprofiles one-to-many relationship for the businessunit table/entity.
Socialprofile_customer_contacts
See the Socialprofile_customer_contacts one-to-many relationship for the contact table/entity.
lk_SocialProfile_createdonbehalfby
See the lk_SocialProfile_createdonbehalfby one-to-many relationship for the systemuser table/entity.
socialProfile_owning_user
See the socialProfile_owning_user one-to-many relationship for the systemuser table/entity.
lk_SocialProfile_modifiedonbehalfby
See the lk_SocialProfile_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
Socialprofile_customer_accounts
See the Socialprofile_customer_accounts one-to-many relationship for the account table/entity.
See also
Dataverse table/entity reference
Web API Reference
socialprofile EntityType
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru