columnmapping EntityType

Mapping for columns in a data map.

Entity set path:
[organization URI]/api/data/v9.2/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
Values 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
Values 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
Values 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
Values Label
0 Active
statuscode Edm.Int32

Reason for the status of the column mapping.

Display name: Status Reason

Default options
Values 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 Lookup property data.

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

See also