Site Setting (mspp_sitesetting) table/entity reference

Note

Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.

Site specific settings or variables refferenced by the web site code files.

Added by: Power Pages Apps Solution

Messages

Message	Web API Operation	SDK class or method
BulkRetain	This message is to be executed only by Dataverse to trigger registered plug-ins and flows.
Create	POST /mspp_sitesettings See Create	CreateRequest or Create
CreateMultiple	CreateMultiple	CreateMultipleRequest
Delete	DELETE /mspp_sitesettings(mspp_sitesettingid) See Delete	DeleteRequest or Delete
PurgeRetainedContent	This message is to be executed only by Dataverse to trigger registered plug-ins and flows.
Retain	This message is to be executed only by Dataverse to trigger registered plug-ins and flows.
Retrieve	GET /mspp_sitesettings(mspp_sitesettingid) See Retrieve	RetrieveRequest or Retrieve
RetrieveEntityChanges		RetrieveEntityChangesRequest
RetrieveMultiple	GET /mspp_sitesettings See Query Data	RetrieveMultipleRequest or RetrieveMultiple
RollbackRetain	This message is to be executed only by Dataverse to trigger registered plug-ins and flows.
Update	PATCH /mspp_sitesettings(mspp_sitesettingid) See Update	UpdateRequest or Update
UpdateMultiple	UpdateMultiple	UpdateMultipleRequest
ValidateRetentionConfig	This message is to be executed only by Dataverse to trigger registered plug-ins and flows.

Properties

Property	Value
CollectionSchemaName	mspp_sitesettings
DisplayCollectionName	Site Settings
DisplayName	Site Setting
EntitySetName	mspp_sitesettings
IsBPFEntity	False
LogicalCollectionName	mspp_sitesettings
LogicalName	mspp_sitesetting
OwnershipType	OrganizationOwned
PrimaryIdAttribute	mspp_sitesettingid
PrimaryNameAttribute	mspp_name
SchemaName	mspp_sitesetting

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_modifiedby
• mspp_modifiedon
• mspp_name
• mspp_sitesettingId
• mspp_value
• mspp_websiteid
• statecode
• statuscode

mspp_createdby

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

mspp_createdon

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

mspp_description

Property	Value
Description
DisplayName	Description
Format	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	mspp_description
MaxLength	4096
RequiredLevel	None
Type	Memo

mspp_modifiedby

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

mspp_modifiedon

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

mspp_name

Property	Value
Description	The name of the custom entity.
DisplayName	Name
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	mspp_name
MaxLength	100
RequiredLevel	ApplicationRequired
Type	String

mspp_sitesettingId

Property	Value
Description	Unique identifier for entity instances
DisplayName	Site Setting
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	mspp_sitesettingid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

mspp_value

Property	Value
Description
DisplayName	Value
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	mspp_value
MaxLength	4000
RequiredLevel	None
Type	String

mspp_websiteid

Property	Value
Description	Unique identifier for Website associated with Site Setting.
DisplayName	Website
IsValidForForm	True
IsValidForRead	True
LogicalName	mspp_websiteid
RequiredLevel	ApplicationRequired
Targets	mspp_website
Type	Lookup

statecode

Property	Value
Description	Status of the Site Setting
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 Site Setting
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

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.

• mspp_createdbyName
• mspp_createdbyYomiName
• mspp_modifiedbyName
• mspp_modifiedbyYomiName
• mspp_websiteidName

mspp_createdbyName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	mspp_createdbyname
MaxLength	200
RequiredLevel	None
Type	String

mspp_createdbyYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	mspp_createdbyyominame
MaxLength	200
RequiredLevel	None
Type	String

mspp_modifiedbyName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	mspp_modifiedbyname
MaxLength	200
RequiredLevel	None
Type	String

mspp_modifiedbyYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	mspp_modifiedbyyominame
MaxLength	200
RequiredLevel	None
Type	String

mspp_websiteidName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	mspp_websiteidname
MaxLength	100
RequiredLevel	None
Type	String

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.

• mspp_systemuser_mspp_sitesetting_createdby
• mspp_systemuser_mspp_sitesetting_modifiedby
• mspp_website_sitesetting

mspp_systemuser_mspp_sitesetting_createdby

Added by: System Solution Solution

See the mspp_systemuser_mspp_sitesetting_createdby one-to-many relationship for the systemuser table/entity.

mspp_systemuser_mspp_sitesetting_modifiedby

Added by: System Solution Solution

See the mspp_systemuser_mspp_sitesetting_modifiedby one-to-many relationship for the systemuser table/entity.

mspp_website_sitesetting

See the mspp_website_sitesetting one-to-many relationship for the mspp_website table/entity.

See also

Dataverse table/entity reference
Web API Reference
mspp_sitesetting EntityType