List Operation (listoperation) table/entity reference (Microsoft Dynamics 365)
System operation used to perform lengthy and asynchronous list operations on large data sets, such as adding members to a list.
The following table lists the messages for the List Operation (listoperation) 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 |
---|---|---|
Assign Event: True |
PATCH /listoperations(listoperationid)Update the ownerid property. |
AssignRequest |
Associate Event: True |
Associate records | Associate records |
BulkRetain Event: True |
BulkRetain | Learn to use messages with the SDK for .NET |
Create Event: True |
POST /listoperationsSee Create |
Create records |
CreateMultiple Event: True |
CreateMultiple | CreateMultipleRequest |
Delete Event: True |
DELETE /listoperations(listoperationid)See Delete |
Delete records |
Disassociate Event: True |
Disassociate records | Disassociate records |
GrantAccess Event: True |
GrantAccess | GrantAccessRequest |
IsValidStateTransition Event: False |
IsValidStateTransition | IsValidStateTransitionRequest |
ModifyAccess Event: True |
ModifyAccess | ModifyAccessRequest |
PurgeRetainedContent Event: True |
PurgeRetainedContent | Learn to use messages with the SDK for .NET |
Restore Event: True |
Restore | Learn to use messages with the SDK for .NET |
Retain Event: True |
Retain | Learn to use messages with the SDK for .NET |
Retrieve Event: True |
GET /listoperations(listoperationid)See Retrieve |
Retrieve records |
RetrieveMultiple Event: True |
GET /listoperationsSee Query data |
Query data |
RetrievePrincipalAccess Event: True |
RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccess Event: True |
RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccess Event: True |
RevokeAccess | RevokeAccessRequest |
RollbackRetain Event: True |
RollbackRetain | Learn to use messages with the SDK for .NET |
SetState Event: True |
PATCH /listoperations(listoperationid)Update the statecode and statuscode properties. |
SetStateRequest |
Update Event: True |
PATCH /listoperations(listoperationid)See Update |
Update records |
UpdateMultiple Event: True |
UpdateMultiple | UpdateMultipleRequest |
Upsert Event: False |
PATCH /listoperations(listoperationid)See Upsert a table row |
UpsertRequest |
UpsertMultiple Event: False |
UpsertMultiple | UpsertMultipleRequest |
ValidateRetentionConfig Event: True |
ValidateRetentionConfig | Learn to use messages with the SDK for .NET |
The following table lists selected properties for the List Operation (listoperation) table.
Property | Value |
---|---|
DisplayName | List Operation |
DisplayCollectionName | List Operations |
SchemaName | listoperation |
CollectionSchemaName | listoperations |
EntitySetName | listoperations |
LogicalName | listoperation |
LogicalCollectionName | listoperations |
PrimaryIdAttribute | listoperationid |
PrimaryNameAttribute | listoperationprimaryname |
TableType | Standard |
OwnershipType | UserOwned |
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- Added
- BatchInput
- ErrorCode
- ErrorDescription
- ImportSequenceNumber
- Input
- ListId
- listoperationId
- ListOperationName
- ListOperationPrimaryName
- Log
- OverriddenCreatedOn
- OwnerId
- OwnerIdType
- Processed
- statecode
- statuscode
- TimeZoneRuleVersionNumber
- Type
- UTCConversionTimeZoneCode
Property | Value |
---|---|
Description | Number of items added in the list operation. |
DisplayName | Added |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | added |
RequiredLevel | None |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -2147483648 |
Property | Value |
---|---|
Description | Input data required by the list operation on every processing batch. Used by asynchronous list operations only. |
DisplayName | BatchInput |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | batchinput |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 1073741823 |
Property | Value |
---|---|
Description | List operation error code. Populated when the list operation does not complete successfully. |
DisplayName | ErrorCode |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | errorcode |
RequiredLevel | None |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -2147483648 |
Property | Value |
---|---|
Description | List operation error description. Populated when the list operation does not complete successfully. |
DisplayName | ErrorDescription |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | errordescription |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Disabled |
IsLocalizable | False |
MaxLength | 4000 |
Property | Value |
---|---|
Description | Sequence number of the import that created this record. |
DisplayName | Import Sequence Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | importsequencenumber |
RequiredLevel | None |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -2147483648 |
Property | Value |
---|---|
Description | List operation input data. |
DisplayName | Input |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | input |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Disabled |
IsLocalizable | False |
MaxLength | 1073741823 |
Property | Value |
---|---|
Description | Associated list identifier |
DisplayName | List Id |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | listid |
RequiredLevel | None |
Type | Lookup |
Targets | list |
Property | Value |
---|---|
Description | Unique identifier for entity instances |
DisplayName | List Operation |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | listoperationid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
Property | Value |
---|---|
Description | The name of the custom entity. |
DisplayName | List Operation Name |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | listoperationname |
RequiredLevel | ApplicationRequired |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 256 |
Property | Value |
---|---|
Description | The primary name of the custom entity. |
DisplayName | List Operation Primary Name |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | listoperationprimaryname |
RequiredLevel | ApplicationRequired |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 256 |
Property | Value |
---|---|
Description | List operation log. |
DisplayName | Log |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | log |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 1073741823 |
Property | Value |
---|---|
Description | Date and time that the record was migrated. |
DisplayName | Record Created On |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | overriddencreatedon |
RequiredLevel | None |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateOnly |
ImeMode | Inactive |
SourceTypeMask | 0 |
Property | Value |
---|---|
Description | Owner Id |
DisplayName | Owner |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | ownerid |
RequiredLevel | SystemRequired |
Type | Owner |
Targets | systemuser, team |
Property | Value |
---|---|
Description | Owner Id Type |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridtype |
RequiredLevel | SystemRequired |
Type | EntityName |
Property | Value |
---|---|
Description | Number of items processed in the list operation. |
DisplayName | Processed |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | processed |
RequiredLevel | None |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -2147483648 |
Property | Value |
---|---|
Description | Status of the List Operation |
DisplayName | Status |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statecode |
RequiredLevel | SystemRequired |
Type | State |
DefaultFormValue | |
GlobalChoiceName | listoperation_statecode |
Value | Details |
---|---|
0 | Label: Active DefaultStatus: 100000001 InvariantName: Active |
1 | Label: Inactive DefaultStatus: 2 InvariantName: Inactive |
Property | Value |
---|---|
Description | Reason for the status of the List Operation |
DisplayName | Status Reason |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statuscode |
RequiredLevel | None |
Type | Status |
DefaultFormValue | |
GlobalChoiceName | listoperation_statuscode |
Value | Details |
---|---|
2 | Label: Inactive State:1 TransitionData: None |
100000000 | Label: In Progress State:0 TransitionData: None |
100000001 | Label: Created State:0 TransitionData: None |
100000002 | Label: Completed State:0 TransitionData: None |
100000003 | Label: Failed State:0 TransitionData: None |
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Time Zone Rule Version Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | timezoneruleversionnumber |
RequiredLevel | None |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -1 |
Property | Value |
---|---|
Description | List operation type. |
DisplayName | Type |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | type |
RequiredLevel | ApplicationRequired |
Type | Picklist |
DefaultFormValue | 100000000 |
GlobalChoiceName | listoperation_type |
Value | Label |
---|---|
100000000 | Add members by query |
100000001 | Add members by id |
100000002 | Remove members by query |
100000003 | Remove members by id |
Property | Value |
---|---|
Description | Time zone code that was in use when the record was created. |
DisplayName | UTC Conversion Time Zone Code |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | utcconversiontimezonecode |
RequiredLevel | None |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -1 |
These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.
- CreatedBy
- CreatedOn
- CreatedOnBehalfBy
- ModifiedBy
- ModifiedOn
- ModifiedOnBehalfBy
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningTeam
- OwningUser
- VersionNumber
Property | Value |
---|---|
Description | Unique identifier of the user who created the record. |
DisplayName | Created By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
Property | Value |
---|---|
Description | Date and time when the record was created. |
DisplayName | Created On |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdon |
RequiredLevel | None |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateAndTime |
ImeMode | Inactive |
SourceTypeMask | 0 |
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 |
Type | Lookup |
Targets | systemuser |
Property | Value |
---|---|
Description | Unique identifier of the user who modified the record. |
DisplayName | Modified By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
Property | Value |
---|---|
Description | Date and time when the record was modified. |
DisplayName | Modified On |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedon |
RequiredLevel | None |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateAndTime |
ImeMode | Inactive |
SourceTypeMask | 0 |
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 |
Type | Lookup |
Targets | systemuser |
Property | Value |
---|---|
Description | Name of the owner |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridname |
RequiredLevel | SystemRequired |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 100 |
Property | Value |
---|---|
Description | Yomi name of the owner |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridyominame |
RequiredLevel | SystemRequired |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 100 |
Property | Value |
---|---|
Description | Unique identifier for the business unit that owns the record |
DisplayName | Owning Business Unit |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | owningbusinessunit |
RequiredLevel | None |
Type | Lookup |
Targets | businessunit |
Property | Value |
---|---|
Description | Unique identifier for the team that owns the record. |
DisplayName | Owning Team |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningteam |
RequiredLevel | None |
Type | Lookup |
Targets | team |
Property | Value |
---|---|
Description | Unique identifier for the user that owns the record. |
DisplayName | Owning User |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owninguser |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
Property | Value |
---|---|
Description | Version Number |
DisplayName | Version Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | versionnumber |
RequiredLevel | None |
Type | BigInt |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
These relationships are many-to-one. Listed by SchemaName.
- business_unit_listoperation
- list_listoperation_ListId
- lk_listoperation_createdby
- lk_listoperation_createdonbehalfby
- lk_listoperation_modifiedby
- lk_listoperation_modifiedonbehalfby
- owner_listoperation
- team_listoperation
- user_listoperation
One-To-Many Relationship: businessunit business_unit_listoperation
Property | Value |
---|---|
ReferencedEntity | businessunit |
ReferencedAttribute | businessunitid |
ReferencingAttribute | owningbusinessunit |
ReferencingEntityNavigationPropertyName | owningbusinessunit |
IsHierarchical | |
CascadeConfiguration | Archive: Restrict Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
One-To-Many Relationship: list list_listoperation_ListId
Property | Value |
---|---|
ReferencedEntity | list |
ReferencedAttribute | listid |
ReferencingAttribute | listid |
ReferencingEntityNavigationPropertyName | ListId |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
One-To-Many Relationship: systemuser lk_listoperation_createdby
Property | Value |
---|---|
ReferencedEntity | systemuser |
ReferencedAttribute | systemuserid |
ReferencingAttribute | createdby |
ReferencingEntityNavigationPropertyName | createdby |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
One-To-Many Relationship: systemuser lk_listoperation_createdonbehalfby
Property | Value |
---|---|
ReferencedEntity | systemuser |
ReferencedAttribute | systemuserid |
ReferencingAttribute | createdonbehalfby |
ReferencingEntityNavigationPropertyName | createdonbehalfby |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
One-To-Many Relationship: systemuser lk_listoperation_modifiedby
Property | Value |
---|---|
ReferencedEntity | systemuser |
ReferencedAttribute | systemuserid |
ReferencingAttribute | modifiedby |
ReferencingEntityNavigationPropertyName | modifiedby |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
One-To-Many Relationship: systemuser lk_listoperation_modifiedonbehalfby
Property | Value |
---|---|
ReferencedEntity | systemuser |
ReferencedAttribute | systemuserid |
ReferencingAttribute | modifiedonbehalfby |
ReferencingEntityNavigationPropertyName | modifiedonbehalfby |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
One-To-Many Relationship: owner owner_listoperation
Property | Value |
---|---|
ReferencedEntity | owner |
ReferencedAttribute | ownerid |
ReferencingAttribute | ownerid |
ReferencingEntityNavigationPropertyName | ownerid |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
One-To-Many Relationship: team team_listoperation
Property | Value |
---|---|
ReferencedEntity | team |
ReferencedAttribute | teamid |
ReferencingAttribute | owningteam |
ReferencingEntityNavigationPropertyName | owningteam |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
One-To-Many Relationship: systemuser user_listoperation
Property | Value |
---|---|
ReferencedEntity | systemuser |
ReferencedAttribute | systemuserid |
ReferencingAttribute | owninguser |
ReferencingEntityNavigationPropertyName | owninguser |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
These relationships are one-to-many. Listed by SchemaName.
- listoperation_AsyncOperations
- listoperation_BulkDeleteFailures
- listoperation_MailboxTrackingFolders
- listoperation_PrincipalObjectAttributeAccesses
- listoperation_ProcessSession
- listoperation_SyncErrors
Many-To-One Relationship: asyncoperation listoperation_AsyncOperations
Property | Value |
---|---|
ReferencingEntity | asyncoperation |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | listoperation_AsyncOperations |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Many-To-One Relationship: bulkdeletefailure listoperation_BulkDeleteFailures
Property | Value |
---|---|
ReferencingEntity | bulkdeletefailure |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | listoperation_BulkDeleteFailures |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Many-To-One Relationship: mailboxtrackingfolder listoperation_MailboxTrackingFolders
Property | Value |
---|---|
ReferencingEntity | mailboxtrackingfolder |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | listoperation_MailboxTrackingFolders |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Many-To-One Relationship: principalobjectattributeaccess listoperation_PrincipalObjectAttributeAccesses
Property | Value |
---|---|
ReferencingEntity | principalobjectattributeaccess |
ReferencingAttribute | objectid |
ReferencedEntityNavigationPropertyName | listoperation_PrincipalObjectAttributeAccesses |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Many-To-One Relationship: processsession listoperation_ProcessSession
Property | Value |
---|---|
ReferencingEntity | processsession |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | listoperation_ProcessSession |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Many-To-One Relationship: syncerror listoperation_SyncErrors
Property | Value |
---|---|
ReferencingEntity | syncerror |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | listoperation_SyncErrors |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Dataverse table/entity reference
Dataverse Web API Reference