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