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 | 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 | UpdateMultipleRequest | |
Upsert | UpsertRequest | |
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
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