columnmapping EntityType

Mapping for columns in a data map.

Entity Set Path
[organization URI]/api/data/v9.0/columnmappings
Base Type
crmbaseentity
Display Name
Column Mapping
Primary Key
columnmappingid
Primary Key Attribute
sourceattributename
Operations Supported
POST GET DELETE

Properties

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

Name Type Details
columnmappingid Edm.Guid

Unique identifier of the column mapping.

columnmappingidunique Edm.Guid

Unique identifier of the Column Mapping.

Read Only
componentstate Edm.Int32

For internal use only.

Display Name: Component State

Read Only
Default Options
Value Label
0 Published
1 Unpublished
2 Deleted
3 Deleted Unpublished
createdon Edm.DateTimeOffset

Date and time when the column 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
Value Label
1 Managed
0 Unmanaged
modifiedon Edm.DateTimeOffset

Date and time when the column 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 column mapping needs to be processed.

Display Name: Process Code

Default Options
Value Label
1 Process
2 Ignore
3 Internal
solutionid Edm.Guid

Unique identifier of the associated solution.

Display Name: Solution

Read Only
sourceattributename Edm.String

Name of the source attribute.

Display Name: Source Attribute

sourceentityname Edm.String

Name of the source entity.

Display Name: Source Entity Name

statecode Edm.Int32

Status of the column mapping.

Display Name: Status

Read Only
Default Options
Value Label
0 Active
statuscode Edm.Int32

Reason for the status of the column mapping.

Display Name: Status Reason

Default Options
Value Label
1 Active
targetattributename Edm.String

Name of the Microsoft Dynamics 365 attribute.

Display Name: Target Attribute

targetentityname Edm.String

Name of the Microsoft Dynamics 365 entity.

Display Name: Target Entity

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 Retrieve data about lookup properties.

Name Single-valued navigation property Description
_createdby_value createdby

Unique identifier of the user who created the column mapping.

_createdonbehalfby_value createdonbehalfby

Unique identifier of the delegate user who created the columnmapping.

_importmapid_value importmapid

Unique identifier of the associated data map.

_modifiedby_value modifiedby

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

_modifiedonbehalfby_value modifiedonbehalfby

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

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
createdby systemuser lk_columnmapping_createdby
createdonbehalfby systemuser lk_columnmapping_createdonbehalfby
importmapid importmap ColumnMapping_ImportMap
modifiedby systemuser lk_columnmapping_modifiedby
modifiedonbehalfby systemuser lk_columnmapping_modifiedonbehalfby

Collection-valued navigation properties

Collection-valued navigation properties represent collections of entities which may represent either a one-to-many (1:N) or many-to-many (N:N) relationship between the entities.

Name Type Partner
LookUpMapping_ColumnMapping lookupmapping columnmappingid
PickListMapping_ColumnMapping picklistmapping columnmappingid

Solutions

The following solutions include the columnmapping entity type.

Name Description
System Solution Internal CRM System Solution

See also