Transformation Parameter Mapping (TransformationParameterMapping) table/entity reference (Microsoft Dataverse)

2025-08-28

In a data map, defines parameters for a transformation.

Messages

The following table lists the messages for the Transformation Parameter Mapping (TransformationParameterMapping) 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` /transformationparametermappings See Create	Create records
`Delete` Event: False	`DELETE` /transformationparametermappings(transformationparametermappingid) See Delete	Delete records
`Disassociate` Event: True	Disassociate records	Disassociate records
`Retrieve` Event: False	`GET` /transformationparametermappings(transformationparametermappingid) See Retrieve	Retrieve records
`RetrieveMultiple` Event: False	`GET` /transformationparametermappings See Query data	Query data

Properties

The following table lists selected properties for the Transformation Parameter Mapping (TransformationParameterMapping) table.

Property	Value
DisplayName	Transformation Parameter Mapping
DisplayCollectionName	Transformation Parameter Mappings
SchemaName	`TransformationParameterMapping`
CollectionSchemaName	`TransformationParameterMappings`
EntitySetName	`transformationparametermappings`
LogicalName	`transformationparametermapping`
LogicalCollectionName	`transformationparametermappings`
PrimaryIdAttribute	`transformationparametermappingid`
PrimaryNameAttribute	`data`
TableType	`Standard`
OwnershipType	`None`

Writable columns/attributes

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

Data
DataTypeCode
IntroducedVersion
ParameterArrayIndex
ParameterSequence
ParameterTypeCode
TransformationMappingId
TransformationParameterMappingId

Data

Property	Value
Description	Transformation data for transformation parameter
DisplayName	Data
IsValidForForm	True
IsValidForRead	True
LogicalName	`data`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	500

DataTypeCode

Property	Value
Description	Data type of the transformation parameter.
DisplayName	Parameter Data Type
IsValidForForm	True
IsValidForRead	True
LogicalName	`datatypecode`
RequiredLevel	None
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`transformationparametermapping_datatypecode`

DataTypeCode Choices/Options

Value	Label
0	Reference
1	Value

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

ParameterArrayIndex

Property	Value
Description	Index of the array if the input parameter is an array.
DisplayName	Parameter Array Index
IsValidForForm	True
IsValidForRead	True
LogicalName	`parameterarrayindex`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

ParameterSequence

Property	Value
Description	Parameter sequence number.
DisplayName	Parameter Sequence
IsValidForForm	True
IsValidForRead	True
LogicalName	`parametersequence`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	1

ParameterTypeCode

Property	Value
Description	Type of transformation parameter.
DisplayName	Parameter Type
IsValidForForm	True
IsValidForRead	True
LogicalName	`parametertypecode`
RequiredLevel	None
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`transformationparametermapping_parametertypecode`

ParameterTypeCode Choices/Options

Value	Label
0	Input
1	Output

TransformationMappingId

Property	Value
Description	Unique identifier of the transformation with which the parameter is associated.
DisplayName	Transformation Mapping Id
IsValidForForm	True
IsValidForRead	True
LogicalName	`transformationmappingid`
RequiredLevel	None
Type	Lookup
Targets	transformationmapping

TransformationParameterMappingId

Property	Value
Description	Unique identifier of the transformation parameter mapping.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`transformationparametermappingid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

Read-only columns/attributes

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

ComponentState
CreatedBy
CreatedOn
CreatedOnBehalfBy
IsManaged
ModifiedBy
ModifiedOn
ModifiedOnBehalfBy
OverwriteTime
SolutionId
SupportingSolutionId
TransformationParameterMappingIdUnique

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 parameter 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 transformation parameter mapping was created.
DisplayName	Created On
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 transformationparametermapping.
DisplayName	Created By (Delegate)
IsValidForForm	False
IsValidForRead	True
LogicalName	`createdonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

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 transformation parameter 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 transformation parameter 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 transformationparametermapping.
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

SupportingSolutionId

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

TransformationParameterMappingIdUnique

Property	Value
Description	Unique identifier of the Transformation Parameter Mapping.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`transformationparametermappingidunique`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

Many-to-One relationships

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

lk_transformationparametermapping_createdby
lk_transformationparametermapping_createdonbehalfby
lk_transformationparametermapping_modifiedby
lk_transformationparametermapping_modifiedonbehalfby
TransformationParameterMapping_TransformationMapping

lk_transformationparametermapping_createdby

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

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

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

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

TransformationParameterMapping_TransformationMapping

One-To-Many Relationship: transformationmapping TransformationParameterMapping_TransformationMapping

Property	Value
ReferencedEntity	`transformationmapping`
ReferencedAttribute	`transformationmappingid`
ReferencingAttribute	`transformationmappingid`
ReferencingEntityNavigationPropertyName	`transformationmappingid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

One-to-Many relationships

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

LookUpMapping_TransformationParameterMapping

Many-To-One Relationship: lookupmapping LookUpMapping_TransformationParameterMapping

Property	Value
ReferencingEntity	`lookupmapping`
ReferencingAttribute	`transformationparametermappingid`
ReferencedEntityNavigationPropertyName	`LookUpMapping_TransformationParameterMapping`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Feedback

Was this page helpful?