Redigera

Dela via


Data import tables

The Microsoft Dataverse data import tables are used to create data maps, configure and run data imports, and log failure information.

The following table lists the tables that are used to configure, run, and log failures for import operations.

Table Description
Data Import (Import) Status and ownership information for the import job.
Import Source File (ImportFile) Logical source file.
ImportLog Failure reason and other detailed information for a record that failed to import.

The following table lists the tables that are used for creating data maps.

Table Description
Data Map (ImportMap) Data map that is used for import.
ColumnMapping Mapping between a column in the source file and a target column in Dataverse.
LookUpMapping Mapping between a column in the source file, or an output of a complex transformation and a target column of type EntityReference. Used in conjunction with column mapping or complex transformation mapping.
OwnerMapping Mapping between a user specified in the source file and a user in Dataverse.
List Value Mapping (PickListMapping) Mapping between a column in the source file and a target column of OptionSetValue, Boolean, state, or status type in Dataverse. Used in conjunction with column mapping.
TransformationMapping Complex transformation mapping.
TransformationParameterMapping Parameter mapping that is used in complex transformation mapping.

See also

Import data
Create data maps for import
Add transformation mappings for import
Configure data import
Run data import
Sample: Export and import a data map
Sample: Import data using complex data map