Référence d’entité/de table ColumnMapping
Notes
Vous n’êtes pas sûr de la table par rapport à l’entité ? Voir Développeurs : Comprendre la terminologie dans Microsoft Dataverse.
Mapping for columns in a data map.
Messages
| Message | Opération de l'API web | Classe ou méthode SDK |
|---|---|---|
| Create | POST [org URI]/api/data/v9.0/columnmappings Voir Créer |
CreateRequest ou Create |
| Delete | DELETE [org URI]/api/data/v9.0/columnmappings(columnmappingid) Voir Supprimer |
DeleteRequest ou Delete |
| Retrieve | GET [org URI]/api/data/v9.0/columnmappings(columnmappingid) Voir Récupérer |
RetrieveRequest ou Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/columnmappings Voir Rechercher des données |
RetrieveMultipleRequest ou RetrieveMultiple |
Propriétés
| Propriété | Valeur |
|---|---|
| CollectionSchemaName | ColumnMappings |
| DisplayCollectionName | Column Mappings |
| DisplayName | Column Mapping |
| EntitySetName | columnmappings |
| IsBPFEntity | False |
| LogicalCollectionName | columnmappings |
| LogicalName | columnmapping |
| OwnershipType | None |
| PrimaryIdAttribute | columnmappingid |
| PrimaryNameAttribute | sourceattributename |
| SchemaName | ColumnMapping |
Colonnes/Attributs inscriptibles
Ces colonnes/attributs renvoient la valeur true pour IsValidForCreate ou IsValidForUpdate (généralement les deux). Répertorié par SchemaName.
- ColumnMappingId
- ImportMapId
- IntroducedVersion
- ProcessCode
- SourceAttributeName
- SourceEntityName
- StatusCode
- TargetAttributeName
- TargetEntityName
ColumnMappingId
| Propriété | Valeur |
|---|---|
| Description | Unique identifier of the column mapping. |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | columnmappingid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
ImportMapId
| Propriété | Valeur |
|---|---|
| Description | Unique identifier of the associated data map. |
| DisplayName | Data Map ID |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | importmapid |
| RequiredLevel | ApplicationRequired |
| Targets | importmap |
| Type | Lookup |
IntroducedVersion
| Propriété | Valeur |
|---|---|
| Description | Version in which the component is introduced. |
| DisplayName | Introduced Version |
| FormatName | VersionNumber |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | introducedversion |
| MaxLength | 48 |
| RequiredLevel | None |
| Type | String |
ProcessCode
| Propriété | Valeur |
|---|---|
| Description | Information about whether the column mapping needs to be processed. |
| DisplayName | Process Code |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | processcode |
| RequiredLevel | SystemRequired |
| Type | Picklist |
Choix/Options ProcessCode
| Valeur | Étiquette | Description |
|---|---|---|
| 1 | Process | |
| 2 | Ignore | |
| 3 | Internal |
SourceAttributeName
| Propriété | Valeur |
|---|---|
| Description | Name of the source attribute. |
| DisplayName | Source Attribute |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | sourceattributename |
| MaxLength | 160 |
| RequiredLevel | ApplicationRequired |
| Type | String |
SourceEntityName
| Propriété | Valeur |
|---|---|
| Description | Name of the source entity. |
| DisplayName | Source Entity Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | sourceentityname |
| MaxLength | 160 |
| RequiredLevel | ApplicationRequired |
| Type | String |
StatusCode
| Propriété | Valeur |
|---|---|
| Description | Reason for the status of the column mapping. |
| DisplayName | Status Reason |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statuscode |
| RequiredLevel | SystemRequired |
| Type | Status |
Choix/Options StatusCode
| Valeur | Étiquette | État |
|---|---|---|
| 1 | Active | 0 |
TargetAttributeName
| Propriété | Valeur |
|---|---|
| Description | Name of the Microsoft Dynamics 365 attribute. |
| DisplayName | Target Attribute |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | targetattributename |
| MaxLength | 160 |
| RequiredLevel | None |
| Type | String |
TargetEntityName
| Propriété | Valeur |
|---|---|
| Description | Name of the Microsoft Dynamics 365 entity. |
| DisplayName | Target Entity |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | targetentityname |
| MaxLength | 160 |
| RequiredLevel | None |
| Type | String |
Colonnes/Attributs en lecture seule
Ces colonnes/attributs renvoient la valeur false pour IsValidForCreate ou IsValidForUpdate. Répertorié par SchemaName.
- ColumnMappingIdUnique
- ComponentState
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ImportMapIdName
- IsManaged
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OverwriteTime
- SolutionId
- StateCode
- SupportingSolutionId
ColumnMappingIdUnique
| Propriété | Valeur |
|---|---|
| Description | Unique identifier of the Column Mapping. |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | columnmappingidunique |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
ComponentState
| Propriété | Valeur |
|---|---|
| Description | For internal use only. |
| DisplayName | Component State |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | componentstate |
| RequiredLevel | SystemRequired |
| Type | Picklist |
Choix/Options ComponentState
| Valeur | Étiquette | Description |
|---|---|---|
| 0 | Published | |
| 1 | Unpublished | |
| 2 | Deleted | |
| 3 | Deleted Unpublished |
CreatedBy
| Propriété | Valeur |
|---|---|
| Description | Unique identifier of the user who created the column mapping. |
| DisplayName | Created By |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedByName
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedByYomiName
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOn
| Propriété | Valeur |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time when the column mapping was created. |
| DisplayName | |
| Format | DateAndTime |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdon |
| RequiredLevel | SystemRequired |
| Type | DateTime |
CreatedOnBehalfBy
| Propriété | Valeur |
|---|---|
| Description | Unique identifier of the delegate user who created the columnmapping. |
| DisplayName | Created By (Delegate) |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedOnBehalfByName
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOnBehalfByYomiName
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ImportMapIdName
| Propriété | Valeur |
|---|---|
| Description | Name of the associated data map. |
| DisplayName | Data Map |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | importmapidname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
IsManaged
| Propriété | Valeur |
|---|---|
| Description | Information that specifies whether this component is managed. |
| DisplayName | State |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | ismanaged |
| RequiredLevel | SystemRequired |
| Type | Boolean |
Choix/Options IsManaged
| Valeur | Étiquette | Description |
|---|---|---|
| 1 | Managed | |
| 0 | Unmanaged |
Valeur par défaut : 0
ModifiedBy
| Propriété | Valeur |
|---|---|
| Description | Unique identifier of the user who last modified the column mapping. |
| DisplayName | Modified By |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedByName
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedByYomiName
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOn
| Propriété | Valeur |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time when the column mapping was last modified. |
| DisplayName | Modified On |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedon |
| RequiredLevel | SystemRequired |
| Type | DateTime |
ModifiedOnBehalfBy
| Propriété | Valeur |
|---|---|
| Description | Unique identifier of the delegate user who last modified the columnmapping. |
| DisplayName | Modified By (Delegate) |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedOnBehalfByName
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOnBehalfByYomiName
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
OverwriteTime
| Propriété | Valeur |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | For internal use only. |
| DisplayName | Record Overwrite Time |
| Format | DateOnly |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | overwritetime |
| RequiredLevel | SystemRequired |
| Type | DateTime |
SolutionId
| Propriété | Valeur |
|---|---|
| Description | Unique identifier of the associated solution. |
| DisplayName | Solution |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | solutionid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
StateCode
| Propriété | Valeur |
|---|---|
| Description | Status of the column mapping. |
| DisplayName | Status |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statecode |
| RequiredLevel | SystemRequired |
| Type | State |
Choix/Options StateCode
| Valeur | Étiquette | Statut par défaut | Nom invariant |
|---|---|---|---|
| 0 | Active | 1 | Active |
SupportingSolutionId
| Propriété | Valeur |
|---|---|
| Description | For internal use only. |
| DisplayName | Solution |
| IsValidForForm | False |
| IsValidForRead | False |
| LogicalName | supportingsolutionid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
Relations un-à-plusieurs
Répertorié par SchemaName.
PickListMapping_ColumnMapping
Identique à la relation plusieurs à un PickListMapping_ColumnMapping pour la table/entité picklistmapping.
| Propriété | Valeur |
|---|---|
| ReferencingEntity | picklistmapping |
| ReferencingAttribute | columnmappingid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | PickListMapping_ColumnMapping |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
LookUpMapping_ColumnMapping
Identique à la relation plusieurs à un LookUpMapping_ColumnMapping pour la table/entité lookupmapping.
| Propriété | Valeur |
|---|---|
| ReferencingEntity | lookupmapping |
| ReferencingAttribute | columnmappingid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | LookUpMapping_ColumnMapping |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Relations plusieurs-à-un
Chaque relation plusieurs-à-un est définie par une relation un-à-plusieurs correspondante avec la table associée. Répertorié par SchemaName.
- lk_columnmapping_createdonbehalfby
- lk_columnmapping_createdby
- ColumnMapping_ImportMap
- lk_columnmapping_modifiedonbehalfby
- lk_columnmapping_modifiedby
lk_columnmapping_createdonbehalfby
Voir la relation un à plusieurs lk_columnmapping_createdonbehalfby pour la table/entité systemuser.
lk_columnmapping_createdby
Voir la relation un à plusieurs lk_columnmapping_createdby pour la table/entité systemuser.
ColumnMapping_ImportMap
Voir la relation un à plusieurs ColumnMapping_ImportMap pour la table/entité importmap.
lk_columnmapping_modifiedonbehalfby
Voir la relation un à plusieurs lk_columnmapping_modifiedonbehalfby pour la table/entité systemuser.
lk_columnmapping_modifiedby
Voir la relation un à plusieurs lk_columnmapping_modifiedby pour la table/entité systemuser.
Voir aussi
Référence d’entité/de table Dataverse Référence d’API web columnmapping EntityType
Commentaires
Bientôt disponible : Tout au long de 2024, nous allons supprimer progressivement GitHub Issues comme mécanisme de commentaires pour le contenu et le remplacer par un nouveau système de commentaires. Pour plus d’informations, consultez https://aka.ms/ContentUserFeedback.
Envoyer et afficher des commentaires pour