Website Language (mspp_websitelanguage) table/entity reference (Microsoft Dataverse)

Languages supported and publishing status for the portal

Messages

The following table lists the messages for the Website Language (mspp_websitelanguage) table. Messages represent operations that can be performed on the table. They may also be events.

Name Is Event?	Web API Operation	SDK for .NET
Associate Event: True	Associate records	Associate records
Create Event: True	POST /mspp_websitelanguages See Create	Create records
CreateMultiple Event: True	CreateMultiple	CreateMultipleRequest
Delete Event: True	DELETE /mspp_websitelanguages(mspp_websitelanguageid) See Delete	Delete records
Disassociate Event: True	Disassociate records	Disassociate records
Retrieve Event: True	GET /mspp_websitelanguages(mspp_websitelanguageid) See Retrieve	Retrieve records
RetrieveEntityChanges Event: True		RetrieveEntityChangesRequest
RetrieveMultiple Event: True	GET /mspp_websitelanguages See Query data	Query data
Update Event: True	PATCH /mspp_websitelanguages(mspp_websitelanguageid) See Update	Update records
UpdateMultiple Event: True	UpdateMultiple	UpdateMultipleRequest
Upsert Event: False	PATCH /mspp_websitelanguages(mspp_websitelanguageid) See Upsert a table row	UpsertRequest
UpsertMultiple Event: False	UpsertMultiple	UpsertMultipleRequest

Events

The following table lists the events for the Website Language (mspp_websitelanguage) table. Events are messages that exist so that you can subscribe to them. Unless you added the event, you shouldn't invoke the message, only subscribe to it.

Name	Web API Operation	SDK for .NET
BulkRetain	BulkRetain	Learn to use messages with the SDK for .NET
PurgeRetainedContent	PurgeRetainedContent	Learn to use messages with the SDK for .NET
Retain	Retain	Learn to use messages with the SDK for .NET
RollbackRetain	RollbackRetain	Learn to use messages with the SDK for .NET
ValidateRetentionConfig	ValidateRetentionConfig	Learn to use messages with the SDK for .NET

Properties

The following table lists selected properties for the Website Language (mspp_websitelanguage) table.

Property	Value
DisplayName	Website Language
DisplayCollectionName	Website Languages
SchemaName	mspp_websitelanguage
CollectionSchemaName	mspp_websitelanguages
EntitySetName	mspp_websitelanguages
LogicalName	mspp_websitelanguage
LogicalCollectionName	mspp_websitelanguages
PrimaryIdAttribute	mspp_websitelanguageid
PrimaryNameAttribute	mspp_name
TableType	Virtual
OwnershipType	OrganizationOwned

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

• mspp_createdby
• mspp_createdon
• mspp_description
• mspp_displayname
• mspp_languagecode
• mspp_lcid
• mspp_modifiedby
• mspp_modifiedon
• mspp_name
• mspp_publishingstate
• mspp_systemlanguage
• mspp_websiteid
• mspp_websitelanguageId
• mspp_websitelcid
• statecode
• statuscode

mspp_createdby

Property	Value
Description	Shows who created the record.
DisplayName	Created By
IsValidForForm	True
IsValidForRead	True
LogicalName	mspp_createdby
RequiredLevel	None
Type	Lookup
Targets	systemuser

mspp_createdon

Property	Value
Description	Shows the date and time when the record was created.
DisplayName	Created On
IsValidForForm	True
IsValidForRead	True
LogicalName	mspp_createdon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	True
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

mspp_description

Property	Value
Description
DisplayName	Description
IsValidForForm	True
IsValidForRead	True
LogicalName	mspp_description
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

mspp_displayname

Property	Value
Description	Localized display name of the portal language
DisplayName	Portal Display Name
IsValidForForm	True
IsValidForRead	True
LogicalName	mspp_displayname
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

mspp_languagecode

Property	Value
Description	Locale or language identifier that appears in the URL to indicate the portal language
DisplayName	Language Code
IsValidForForm	True
IsValidForRead	True
LogicalName	mspp_languagecode
RequiredLevel	ApplicationRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

mspp_lcid

Property	Value
Description	Locale ID that is assigned to the portal language
DisplayName	Language Code Identifier
IsValidForForm	True
IsValidForRead	True
LogicalName	mspp_lcid
RequiredLevel	ApplicationRequired
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

mspp_modifiedby

Property	Value
Description	Shows who last updated the record.
DisplayName	Modified By
IsValidForForm	True
IsValidForRead	True
LogicalName	mspp_modifiedby
RequiredLevel	None
Type	Lookup
Targets	systemuser

mspp_modifiedon

Property	Value
Description	Shows the date and time when the record was modified.
DisplayName	Modified On
IsValidForForm	True
IsValidForRead	True
LogicalName	mspp_modifiedon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	True
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

mspp_name

Property	Value
Description	Name of the portal language
DisplayName	Name
IsValidForForm	True
IsValidForRead	True
LogicalName	mspp_name
RequiredLevel	ApplicationRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

mspp_publishingstate

Property	Value
Description	Lookup to Publishing State - publishing state of this website/language instance (draft/published)
DisplayName	Publishing State
IsValidForForm	True
IsValidForRead	True
LogicalName	mspp_publishingstate
RequiredLevel	ApplicationRequired
Type	Lookup
Targets	mspp_publishingstate

mspp_systemlanguage

Property	Value
Description	The system language determines which portal languages are available
DisplayName	System Language
IsValidForForm	True
IsValidForRead	True
LogicalName	mspp_systemlanguage
RequiredLevel	ApplicationRequired
Type	Integer
MaxValue	2147483647
MinValue	0

mspp_websiteid

Property	Value
Description	Lookup to Website
DisplayName	Website
IsValidForForm	True
IsValidForRead	True
LogicalName	mspp_websiteid
RequiredLevel	ApplicationRequired
Type	Lookup
Targets	mspp_website

mspp_websitelanguageId

Property	Value
Description	Unique identifier for entity instances
DisplayName	Website Language
IsValidForForm	False
IsValidForRead	True
LogicalName	mspp_websitelanguageid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

mspp_websitelcid

Property	Value
Description	This attribute is used only in Power Pages Management App, and only for UI purpose. It's value is mapped to mspp_systemlanguage.
DisplayName	Power Pages Language
IsValidForForm	True
IsValidForRead	True
LogicalName	mspp_websitelcid
RequiredLevel	ApplicationRequired
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	powerpagelanguages

mspp_websitelcid Choices/Options

Value	Label
1025	Arabic
1026	Bulgarian - Bulgaria
1027	Catalan - Catalan
1028	Chinese - Traditional
1029	Czech - Czech Republic
1030	Danish - Denmark
1031	German - Germany
1032	Greek - Greece
1033	English
1035	Finnish - Finland
1036	French - France
1037	Hebrew
1038	Hungarian - Hungary
1040	Italian - Italy
1041	Japanese - Japan
1042	Korean - Korea
1043	Dutch - Netherlands
1044	Norwegian (Bokmål) - Norway
1045	Polish - Poland
1046	Portuguese - Brazil
1048	Romanian - Romania
1049	Russian - Russia
1050	Croatian - Croatia
1051	Slovak - Slovakia
1053	Swedish - Sweden
1054	Thai - Thailand
1055	Turkish - Türkiye
1057	Indonesian - Indonesia
1058	Ukrainian - Ukraine
1060	Slovenian - Slovenia
1061	Estonian - Estonia
1062	Latvian - Latvia
1063	Lithuanian - Lithuania
1066	Vietnamese - Vietnam
1069	Basque - Basque
1081	Hindi - India
1086	Malay - Malaysia
1087	Kazakh - Kazakhstan
1110	Galician - Spain
2052	Chinese - China
2070	Portuguese - Portugal
2074	Serbian (Latin) - Serbia
3076	Chinese - Hong Kong SAR
3082	Spanish (Traditional Sort) - Spain
3098	Serbian (Cyrillic) - Serbia

statecode

Property	Value
Description	Status of the Website Language
DisplayName	Status
IsValidForForm	True
IsValidForRead	True
LogicalName	statecode
RequiredLevel	SystemRequired
Type	State
DefaultFormValue
GlobalChoiceName	mspp_websitelanguage_statecode

statecode Choices/Options

Value	Details
0	Label: Active DefaultStatus: 1 InvariantName: Active
1	Label: Inactive DefaultStatus: 2 InvariantName: Inactive

statuscode

Property	Value
Description	Reason for the status of the Website Language
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	statuscode
RequiredLevel	None
Type	Status
DefaultFormValue
GlobalChoiceName	mspp_websitelanguage_statuscode

statuscode Choices/Options

Value	Details
1	Label: Active State:0 TransitionData: None
2	Label: Inactive State:1 TransitionData: None

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

• mspp_mspp_publishingstate_mspp_websitelanguage_PublishingState
• mspp_mspp_website_mspp_websitelanguage
• mspp_systemuser_mspp_websitelanguage_createdby
• mspp_systemuser_mspp_websitelanguage_modifiedby

mspp_mspp_publishingstate_mspp_websitelanguage_PublishingState

One-To-Many Relationship: mspp_publishingstate mspp_mspp_publishingstate_mspp_websitelanguage_PublishingState

Property	Value
ReferencedEntity	mspp_publishingstate
ReferencedAttribute	mspp_publishingstateid
ReferencingAttribute	mspp_publishingstate
ReferencingEntityNavigationPropertyName	mspp_PublishingState
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

mspp_mspp_website_mspp_websitelanguage

One-To-Many Relationship: mspp_website mspp_mspp_website_mspp_websitelanguage

Property	Value
ReferencedEntity	mspp_website
ReferencedAttribute	mspp_websiteid
ReferencingAttribute	mspp_websiteid
ReferencingEntityNavigationPropertyName	mspp_WebsiteId
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

mspp_systemuser_mspp_websitelanguage_createdby

One-To-Many Relationship: systemuser mspp_systemuser_mspp_websitelanguage_createdby

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	mspp_createdby
ReferencingEntityNavigationPropertyName	mspp_createdby
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

mspp_systemuser_mspp_websitelanguage_modifiedby

One-To-Many Relationship: systemuser mspp_systemuser_mspp_websitelanguage_modifiedby

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	mspp_modifiedby
ReferencingEntityNavigationPropertyName	mspp_modifiedby
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

• mspp_mspp_websitelanguage_mspp_website_DefaultLanguage
• mspp_websitelanguage_contentsnippet_contentsnippetlanguageid
• mspp_websitelanguage_weblinkset
• mspp_websitelanguage_webpage_webpagelanguageid

mspp_mspp_websitelanguage_mspp_website_DefaultLanguage

Many-To-One Relationship: mspp_website mspp_mspp_websitelanguage_mspp_website_DefaultLanguage

Property	Value
ReferencingEntity	mspp_website
ReferencingAttribute	mspp_defaultlanguage
ReferencedEntityNavigationPropertyName	mspp_mspp_websitelanguage_mspp_website_DefaultLanguage
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: UseCollectionName Group: Details Label: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

mspp_websitelanguage_contentsnippet_contentsnippetlanguageid

Many-To-One Relationship: mspp_contentsnippet mspp_websitelanguage_contentsnippet_contentsnippetlanguageid

Property	Value
ReferencingEntity	mspp_contentsnippet
ReferencingAttribute	mspp_contentsnippetlanguageid
ReferencedEntityNavigationPropertyName	mspp_websitelanguage_contentsnippet_contentsnippetlanguageid
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: UseCollectionName Group: Details Label: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

mspp_websitelanguage_weblinkset

Many-To-One Relationship: mspp_weblinkset mspp_websitelanguage_weblinkset

Property	Value
ReferencingEntity	mspp_weblinkset
ReferencingAttribute	mspp_websitelanguageid
ReferencedEntityNavigationPropertyName	mspp_websitelanguage_weblinkset
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: UseCollectionName Group: Details Label: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

mspp_websitelanguage_webpage_webpagelanguageid

Many-To-One Relationship: mspp_webpage mspp_websitelanguage_webpage_webpagelanguageid

Property	Value
ReferencingEntity	mspp_webpage
ReferencingAttribute	mspp_webpagelanguageid
ReferencedEntityNavigationPropertyName	mspp_websitelanguage_webpage_webpagelanguageid
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: UseCollectionName Group: Details Label: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

See also

Dataverse table/entity reference
Dataverse Web API Reference
mspp_websitelanguage