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

Article
2025-01-21

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`

Share via