NL2SQ Registration Information (nlsqregistration) table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Org registration status, AllowedEntity list, and registration error message.
Added by: msdyn_RelevanceSearch Solution
Messages
| Message | Web API Operation | SDK class or method |
|---|---|---|
| Assign | PATCH /nlsqregistrations(nlsqregistrationid) Update ownerid property. |
AssignRequest |
| BulkRetain | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. | |
| Create | POST /nlsqregistrations See Create |
CreateRequest or Create |
| CreateMultiple | CreateMultiple | CreateMultipleRequest |
| Delete | DELETE /nlsqregistrations(nlsqregistrationid) 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 /nlsqregistrations(nlsqregistrationid) See Retrieve |
RetrieveRequest or Retrieve |
| RetrieveEntityChanges | RetrieveEntityChangesRequest | |
| RetrieveMultiple | GET /nlsqregistrations See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
| RetrievePrincipalAccess | RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
| RollbackRetain | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. | |
| Update | PATCH /nlsqregistrations(nlsqregistrationid) See Update |
UpdateRequest or Update |
| UpdateMultiple | UpdateMultiple | UpdateMultipleRequest |
| Upsert | UpsertRequest | |
| UpsertMultiple | UpsertMultiple | UpsertMultipleRequest |
| ValidateRetentionConfig | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. |
Properties
| Property | Value |
|---|---|
| CollectionSchemaName | nlsqregistrations |
| DisplayCollectionName | NL2SQ Registration Information |
| DisplayName | NL2SQ Registration Information |
| EntitySetName | nlsqregistrations |
| IsBPFEntity | False |
| LogicalCollectionName | nlsqregistrations |
| LogicalName | nlsqregistration |
| OwnershipType | UserOwned |
| PrimaryIdAttribute | nlsqregistrationid |
| PrimaryNameAttribute | name |
| SchemaName | nlsqregistration |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- AllowedEntityList
- EntityList
- ErrorMessage
- ImportSequenceNumber
- Name
- nlsqregistrationId
- ObjectId
- ObjectPartitionId
- ObjectType
- ObjectTypeDisplayName
- ObjectTypeId
- OverriddenCreatedOn
- OwnerId
- OwnerIdType
- PartitionId
- RegistrationStatus
- TTLInSeconds
AllowedEntityList
| Property | Value |
|---|---|
| Description | The NL2SQ service allowed entity list to be fetched for this organization. (Deprecated) |
| DisplayName | AllowedEntityList |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | allowedentitylist |
| MaxLength | 100 |
| RequiredLevel | ApplicationRequired |
| Type | String |
EntityList
| Property | Value |
|---|---|
| Description | The NL2SQ service allowed entity list to be fetched for this organization. |
| DisplayName | EntityList |
| Format | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | entitylist |
| MaxLength | 50000 |
| RequiredLevel | ApplicationRequired |
| Type | Memo |
ErrorMessage
| Property | Value |
|---|---|
| Description | The NL2SQ service registration failure error message for this organization. |
| DisplayName | ErrorMessage |
| Format | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | errormessage |
| MaxLength | 20000 |
| RequiredLevel | ApplicationRequired |
| Type | Memo |
ImportSequenceNumber
| Property | Value |
|---|---|
| Description | Sequence number of the import 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 |
Name
| Property | Value |
|---|---|
| Description | The name of the custom entity. |
| DisplayName | Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | name |
| MaxLength | 100 |
| RequiredLevel | ApplicationRequired |
| Type | String |
nlsqregistrationId
| Property | Value |
|---|---|
| Description | Unique identifier for nlsqregistration instances |
| DisplayName | NL2SQ Registration Information Id |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | nlsqregistrationid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
ObjectId
| Property | Value |
|---|---|
| Description | Object instance Identifier |
| DisplayName | Object Identifier |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | objectid |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ObjectPartitionId
| Property | Value |
|---|---|
| Description | Logical object partition id to be used by an elastic table row. |
| DisplayName | Object Partition Id |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | objectpartitionid |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ObjectType
| Property | Value |
|---|---|
| Description | Identifies the type of entity |
| DisplayName | Object Type |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | objecttype |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
ObjectTypeDisplayName
| Property | Value |
|---|---|
| Description | Friendly name for the object |
| DisplayName | Object Type Display Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | objecttypedisplayname |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
ObjectTypeId
| Property | Value |
|---|---|
| Description | Object Type Identifier (OTC) |
| DisplayName | Object Type Identifier |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | objecttypeid |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
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
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | Owner Id |
| DisplayName | Owner |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | ownerid |
| RequiredLevel | SystemRequired |
| Targets | systemuser,team |
| Type | Owner |
OwnerIdType
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | Owner Id Type |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridtype |
| RequiredLevel | SystemRequired |
| Type | EntityName |
PartitionId
| Property | Value |
|---|---|
| Description | Logical partition id. A logical partition consists of a set of records with same partition id. |
| DisplayName | Partition Id |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | partitionid |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
RegistrationStatus
| Property | Value |
|---|---|
| Description | The NL2SQ service registration status for this organization. Default is NotRegistered |
| DisplayName | Registration Status |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | registrationstatus |
| RequiredLevel | ApplicationRequired |
| Type | Picklist |
RegistrationStatus Choices/Options
| Value | Label | Description |
|---|---|---|
| 0 | NotRegistered | |
| 1 | Registered | |
| 2 | InProgress | |
| 3 | Failed |
TTLInSeconds
| Property | Value |
|---|---|
| Description | Time to live in seconds. |
| DisplayName | Time to live |
| Format | None |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | ttlinseconds |
| 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
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningBusinessUnitName
- OwningTeam
- OwningUser
- VersionNumber
CreatedBy
Added by: Active Solution Solution
| 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 |
CreatedByName
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedByYomiName
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
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
Added by: Active Solution Solution
| 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
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOnBehalfByYomiName
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
ModifiedBy
Added by: Active Solution Solution
| 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 |
ModifiedByName
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedByYomiName
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
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
Added by: Active Solution Solution
| 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
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOnBehalfByYomiName
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwnerIdName
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | Name of the owner |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwnerIdYomiName
Added by: Active Solution Solution
| 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
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | Unique identifier for the business unit that owns the record |
| DisplayName | Owning Business Unit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | owningbusinessunit |
| RequiredLevel | SystemRequired |
| Targets | businessunit |
| Type | Lookup |
OwningBusinessUnitName
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningbusinessunitname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwningTeam
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | Unique identifier for the team that owns the record. |
| DisplayName | Owning Team |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningteam |
| RequiredLevel | None |
| Targets | team |
| Type | Lookup |
OwningUser
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | Unique identifier for the user that owns the record. |
| DisplayName | Owning User |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owninguser |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
VersionNumber
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | Version Number |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
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.
- lk_nlsqregistration_createdby
- lk_nlsqregistration_createdonbehalfby
- lk_nlsqregistration_modifiedby
- lk_nlsqregistration_modifiedonbehalfby
- user_nlsqregistration
- team_nlsqregistration
- business_unit_nlsqregistration
lk_nlsqregistration_createdby
Added by: System Solution Solution
See the lk_nlsqregistration_createdby one-to-many relationship for the systemuser table/entity.
lk_nlsqregistration_createdonbehalfby
Added by: System Solution Solution
See the lk_nlsqregistration_createdonbehalfby one-to-many relationship for the systemuser table/entity.
lk_nlsqregistration_modifiedby
Added by: System Solution Solution
See the lk_nlsqregistration_modifiedby one-to-many relationship for the systemuser table/entity.
lk_nlsqregistration_modifiedonbehalfby
Added by: System Solution Solution
See the lk_nlsqregistration_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
user_nlsqregistration
Added by: System Solution Solution
See the user_nlsqregistration one-to-many relationship for the systemuser table/entity.
team_nlsqregistration
Added by: System Solution Solution
See the team_nlsqregistration one-to-many relationship for the team table/entity.
business_unit_nlsqregistration
Added by: System Solution Solution
See the business_unit_nlsqregistration one-to-many relationship for the businessunit table/entity.
See also
Dataverse table/entity reference
Web API Reference
nlsqregistration EntityType
피드백
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요. https://aka.ms/ContentUserFeedback
다음에 대한 사용자 의견 제출 및 보기