Edit

Share via

Import Entity Mapping (ImportEntityMapping) table/entity reference (Microsoft Dataverse)

Mapping for entities in a data map.

Messages

The following table lists the messages for the Import Entity Mapping (ImportEntityMapping) 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: False		 POST /importentitymappings
See Create		 Create records
Delete
Event: False		 DELETE /importentitymappings(importentitymappingid)
See Delete		 Delete records
Disassociate
Event: True		 Disassociate records Disassociate records
Retrieve
Event: False		 GET /importentitymappings(importentitymappingid)
See Retrieve		 Retrieve records
RetrieveMultiple
Event: False		 GET /importentitymappings
See Query data		 Query data

Properties

The following table lists selected properties for the Import Entity Mapping (ImportEntityMapping) table.

Property Value
DisplayName Import Entity Mapping
DisplayCollectionName Import Entity Mappings
SchemaName ImportEntityMapping
CollectionSchemaName ImportEntityMappings
EntitySetName importentitymappings
LogicalName importentitymapping
LogicalCollectionName importentitymappings
PrimaryIdAttribute importentitymappingid
TableType Standard
OwnershipType None

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

DeDupe

Property Value
Description Information about whether the entity needs to be processed to find and delete duplicate records.
DisplayName Remove Duplicates
IsValidForForm True
IsValidForRead True
LogicalName dedupe
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue -1
GlobalChoiceName importentitymapping_dedupe

DeDupe Choices/Options

Value Label
1 Ignore
2 Eliminate

ImportEntityMappingId

Property Value
Description Unique identifier of the import entity mapping.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName importentitymappingid
RequiredLevel SystemRequired
Type Uniqueidentifier

ImportMapId

Property Value
Description Unique identifier of the associated data map.
DisplayName Data Map ID
IsValidForForm True
IsValidForRead True
LogicalName importmapid
RequiredLevel ApplicationRequired
Type Lookup
Targets importmap

IntroducedVersion

Property Value
Description Version in which the component is introduced.
DisplayName Introduced Version
IsValidForForm False
IsValidForRead True
LogicalName introducedversion
RequiredLevel None
Type String
Format VersionNumber
FormatName VersionNumber
ImeMode Auto
IsLocalizable False
MaxLength 48

ProcessCode

Property Value
Description Information about whether the import entity mapping needs to be processed.
DisplayName Process Code
IsValidForForm True
IsValidForRead True
LogicalName processcode
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue -1
GlobalChoiceName importentitymapping_processcode

ProcessCode Choices/Options

Value Label
1 Process
2 Ignore
3 Internal

SourceEntityName

Property Value
Description Name of the source entity.
DisplayName Source Entity Name
IsValidForForm True
IsValidForRead True
LogicalName sourceentityname
RequiredLevel ApplicationRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 160

StatusCode

Property Value
Description Reason for the status of the import entity mapping.
DisplayName Status Reason
IsValidForForm True
IsValidForRead True
LogicalName statuscode
RequiredLevel SystemRequired
Type Status
DefaultFormValue -1
GlobalChoiceName importentitymapping_statuscode

StatusCode Choices/Options

Value Details
1 Label: Active
State:0
TransitionData: None

TargetEntityName

Property Value
Description Name of the Microsoft Dynamics 365 entity.
DisplayName Target Entity
IsValidForForm True
IsValidForRead True
LogicalName targetentityname
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 160

Read-only columns/attributes

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

ComponentState

Property Value
Description For internal use only.
DisplayName Component State
IsValidForForm False
IsValidForRead True
LogicalName componentstate
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue -1
GlobalChoiceName componentstate

ComponentState Choices/Options

Value Label
0 Published
1 Unpublished
2 Deleted
3 Deleted Unpublished

CreatedBy

Property Value
Description Unique identifier of the user who created the import entity mapping.
DisplayName Created By
IsValidForForm False
IsValidForRead True
LogicalName createdby
RequiredLevel None
Type Lookup
Targets systemuser

CreatedOn

Property Value
Description Date and time when the import entity mapping was created.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName createdon
RequiredLevel SystemRequired
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

CreatedOnBehalfBy

Property Value
Description Unique identifier of the delegate user who created the importentitymapping.
DisplayName Created By (Delegate)
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfby
RequiredLevel None
Type Lookup
Targets systemuser

ImportEntityMappingIdUnique

Property Value
Description Unique identifier of the Import Entity Mapping.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName importentitymappingidunique
RequiredLevel SystemRequired
Type Uniqueidentifier

IsManaged

Property Value
Description Information that specifies whether this component is managed.
DisplayName State
IsValidForForm False
IsValidForRead True
LogicalName ismanaged
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName ismanaged
DefaultValue False
True Label Managed
False Label Unmanaged

ModifiedBy

Property Value
Description Unique identifier of the user who last modified the import entity mapping.
DisplayName Modified By
IsValidForForm False
IsValidForRead True
LogicalName modifiedby
RequiredLevel None
Type Lookup
Targets systemuser

ModifiedOn

Property Value
Description Date and time when the import entity mapping was last modified.
DisplayName Modified On
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel SystemRequired
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

ModifiedOnBehalfBy

Property Value
Description Unique identifier of the delegate user who last modified the importentitymapping.
DisplayName Modified By (Delegate)
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfby
RequiredLevel None
Type Lookup
Targets systemuser

OverwriteTime

Property Value
Description For internal use only.
DisplayName Record Overwrite Time
IsValidForForm False
IsValidForRead True
LogicalName overwritetime
RequiredLevel SystemRequired
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateOnly
ImeMode Inactive
SourceTypeMask 0

SolutionId

Property Value
Description Unique identifier of the associated solution.
DisplayName Solution
IsValidForForm False
IsValidForRead True
LogicalName solutionid
RequiredLevel SystemRequired
Type Uniqueidentifier

StateCode

Property Value
Description Status of the import entity mapping.
DisplayName Status
IsValidForForm True
IsValidForRead True
LogicalName statecode
RequiredLevel SystemRequired
Type State
DefaultFormValue 0
GlobalChoiceName importentitymapping_statecode

StateCode Choices/Options

Value Details
0 Label: Active
DefaultStatus: 1
InvariantName: Active

SupportingSolutionId

Property Value
Description For internal use only.
DisplayName Solution
IsValidForForm False
IsValidForRead False
LogicalName supportingsolutionid
RequiredLevel None
Type Uniqueidentifier

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

ImportEntityMapping_ImportMap

One-To-Many Relationship: importmap ImportEntityMapping_ImportMap

Property Value
ReferencedEntity importmap
ReferencedAttribute importmapid
ReferencingAttribute importmapid
ReferencingEntityNavigationPropertyName importmapid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_importentitymapping_createdby

One-To-Many Relationship: systemuser lk_importentitymapping_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

lk_importentitymapping_createdonbehalfby

One-To-Many Relationship: systemuser lk_importentitymapping_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

lk_importentitymapping_modifiedby

One-To-Many Relationship: systemuser lk_importentitymapping_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

lk_importentitymapping_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_importentitymapping_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

See also

Dataverse table/entity reference
Dataverse Web API Reference
importentitymapping