lookupmapping EntityType

In a data map, maps a lookup attribute in a source file to Microsoft Dynamics 365.

Entity set path: 
[organization URI]/api/data/v9.2/lookupmappings
Base type: 
crmbaseentity
Table type: 
Standard
Display name: 
Lookup Mapping
Primary key: 
lookupmappingid
Operations supported: 
POST GET DELETE

Properties

Properties represent fields of data stored in the entity. Some properties are read-only.

Name Type Details
componentstate Edm.Int32

For internal use only.

Display name: Component State

Read only
Default options
Values Label
0 Published
1 Unpublished
2 Deleted
3 Deleted Unpublished
createdon Edm.DateTimeOffset

Date and time when the lookup mapping was created.

Read only
introducedversion Edm.String

Version in which the component is introduced.

Display name: Introduced Version

ismanaged Edm.Boolean

Information that specifies whether this component is managed.

Display name: State

Read only
Default options
Values Label
1 Managed
0 Unmanaged
lookupattributename Edm.String

Name of the field with which the lookup is associated.

Display name: Lookup Field Name

lookupentityname Edm.String

Name of the entity with which the lookup is associated.

Display name: Lookup Entity Name

lookupmappingid Edm.Guid

Unique identifier of the lookup mapping.

lookupmappingidunique Edm.Guid

Unique identifier of the LookUp Mapping.

Read only
lookupsourcecode Edm.Int32

Lookup source code for lookup mapping.

Display name: Lookup Source

Default options
Values Label
0 Source
1 System
modifiedon Edm.DateTimeOffset

Date and time when the lookup mapping was last modified.

Display name: Modified On

Read only
overwritetime Edm.DateTimeOffset

For internal use only.

Display name: Record Overwrite Time

Read only
processcode Edm.Int32

Information about whether the lookup mapping has to be processed.

Display name: Process Code

Default options
Values Label
1 Process
2 Ignore
3 Internal
solutionid Edm.Guid

Unique identifier of the associated solution.

Display name: Solution

Read only
statecode Edm.Int32

Status of the lookup mapping.

Display name: Status

Read only
Default options
Values Label
0 Active
statuscode Edm.Int32

Reason for the status of the lookup mapping.

Display name: Status Reason

Default options
Values Label
0 Active

Lookup properties

Lookup properties are read-only, computed properties which contain entity primary key Edm.Guid data for one or more corresponding single-valued navigation properties. More information: Lookup properties and Lookup property data.

Name Single-valued navigation property Description
_columnmappingid_value columnmappingid

Unique identifier of the column mapping with which this lookup mapping is associated.

_createdby_value createdby

Unique identifier of the user who created the lookup mapping.

_createdonbehalfby_value createdonbehalfby

Unique identifier of the delegate user who created the lookupmapping.

_modifiedby_value modifiedby

Unique identifier of the user who last modified the lookup mapping.

_modifiedonbehalfby_value modifiedonbehalfby

Unique identifier of the delegate user who last modified the lookupmapping.

_transformationparametermappingid_value transformationparametermappingid

Unique identifier of the transformation parameter mapping with which this lookup mapping is associated.

Single-valued navigation properties

Single-valued navigation properties represent lookup fields where a single entity can be referenced. Each single-valued navigation property has a corresponding partner collection-valued navigation property on the related entity.

Name Type Partner
columnmappingid columnmapping LookUpMapping_ColumnMapping
createdby systemuser lk_lookupmapping_createdby
createdonbehalfby systemuser lk_lookupmapping_createdonbehalfby
modifiedby systemuser lk_lookupmapping_modifiedby
modifiedonbehalfby systemuser lk_lookupmapping_modifiedonbehalfby
transformationparametermappingid transformationparametermapping LookUpMapping_TransformationParameterMapping

See also