Data Import (Import) table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Status and ownership information for an import job.
Messages
Message | Web API Operation | SDK class or method |
---|---|---|
Create | POST /imports See Create |
CreateRequest or Create |
Delete | DELETE /imports(importid) See Delete |
DeleteRequest or Delete |
GrantAccess | GrantAccess | GrantAccessRequest |
ImportRecordsImport | ImportRecordsImport | ImportRecordsImportRequest |
ModifyAccess | ModifyAccess | ModifyAccessRequest |
ParseImport | ParseImport | ParseImportRequest |
Retrieve | GET /imports(importid) See Retrieve |
RetrieveRequest or Retrieve |
RetrieveMultiple | GET /imports See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
RetrievePrincipalAccess | RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccess | RevokeAccess | RevokeAccessRequest |
TransformImport | TransformImport | TransformImportRequest |
Update | PATCH /imports(importid) See Update |
UpdateRequest or Update |
Properties
Property | Value |
---|---|
CollectionSchemaName | Imports |
DisplayCollectionName | Data Imports |
DisplayName | Data Import |
EntitySetName | imports |
IsBPFEntity | False |
LogicalCollectionName | imports |
LogicalName | import |
OwnershipType | UserOwned |
PrimaryIdAttribute | importid |
PrimaryNameAttribute | name |
SchemaName | Import |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
EMailAddress
Property | Value |
---|---|
Description | Type the email address that the import completion notification must be sent to. |
DisplayName | |
FormatName | |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | emailaddress |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ImportId
Property | Value |
---|---|
Description | Unique identifier of the import job. |
DisplayName | Import |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | importid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
IsImport
Property | Value |
---|---|
Description | Information about whether the source of this import job is data import or data migration. |
DisplayName | Is Import |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | isimport |
RequiredLevel | SystemRequired |
Type | Boolean |
IsImport Choices/Options
Value | Label | Description |
---|---|---|
1 | Is Import | |
0 | Is Migration |
DefaultValue: 0
ModeCode
Property | Value |
---|---|
Description | Select whether to create or update records in Microsoft Dynamics 365 during the import job. |
DisplayName | Mode |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | modecode |
RequiredLevel | SystemRequired |
Type | Picklist |
ModeCode Choices/Options
Value | Label | Description |
---|---|---|
0 | Create | |
1 | Update |
Name
Property | Value |
---|---|
Description | Shows the name of the import job, based on the import file and the entity being imported. |
DisplayName | Import Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | name |
MaxLength | 256 |
RequiredLevel | None |
Type | String |
OwnerId
Property | Value |
---|---|
Description | Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. |
DisplayName | Owner |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | ownerid |
RequiredLevel | SystemRequired |
Targets | systemuser,team |
Type | Owner |
OwnerIdType
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | owneridtype |
RequiredLevel | SystemRequired |
Type | EntityName |
SendNotification
Property | Value |
---|---|
Description | Select whether to send a notification email message to a selected user after the import is completed. |
DisplayName | Send Notification |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | sendnotification |
RequiredLevel | SystemRequired |
Type | Boolean |
SendNotification Choices/Options
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
StatusCode
Property | Value |
---|---|
Description | Shows the reason code that explains the import job's status to identify the job's stage of the import processes, from transforming the data to completed. |
DisplayName | Status Reason |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statuscode |
RequiredLevel | SystemRequired |
Type | Status |
StatusCode Choices/Options
Value | Label | State |
---|---|---|
0 | Submitted | 0 |
1 | Parsing | 0 |
2 | Transforming | 0 |
3 | Importing | 0 |
4 | Completed | 0 |
5 | Failed | 0 |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningBusinessUnitName
- OwningTeam
- OwningUser
- Sequence
- StateCode
CreatedBy
Property | Value |
---|---|
Description | Shows who created the record. |
DisplayName | Created By |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
CreatedByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Shows the date and time when the import was initiated. |
DisplayName | Created On |
Format | DateAndTime |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdon |
RequiredLevel | SystemRequired |
Type | DateTime |
CreatedOnBehalfBy
Property | Value |
---|---|
Description | Shows who created the record on behalf of another user. |
DisplayName | Created By (Delegate) |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
CreatedOnBehalfByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedOnBehalfByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedBy
Property | Value |
---|---|
Description | Shows who last updated the record. |
DisplayName | Modified By |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
ModifiedByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. |
DisplayName | Modified On |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedon |
RequiredLevel | SystemRequired |
Type | DateTime |
ModifiedOnBehalfBy
Property | Value |
---|---|
Description | Shows who created the record on behalf of another user. |
DisplayName | Modified By (Delegate) |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
ModifiedOnBehalfByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedOnBehalfByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
OwnerIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
OwnerIdYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridyominame |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
OwningBusinessUnit
Property | Value |
---|---|
Description | Business unit that owns the import job. |
DisplayName | Owning Business Unit |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | owningbusinessunit |
RequiredLevel | None |
Targets | businessunit |
Type | Lookup |
OwningBusinessUnitName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningbusinessunitname |
MaxLength | 160 |
RequiredLevel | None |
Type | String |
OwningTeam
Property | Value |
---|---|
Description | Unique identifier of the team who owns the import. |
DisplayName | Owning Team |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningteam |
RequiredLevel | None |
Targets | team |
Type | Lookup |
OwningUser
Property | Value |
---|---|
Description | Unique identifier of the user who owns the import. |
DisplayName | Owning User |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owninguser |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Sequence
Property | Value |
---|---|
Description | Order in which the import was created. |
DisplayName | Sequence |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | sequence |
MaxValue | 2147483647 |
MinValue | -2147483648 |
RequiredLevel | SystemRequired |
Type | Integer |
StateCode
Property | Value |
---|---|
Description | Shows the status of the import job. By default, import jobs are active and can't be deactivated. |
DisplayName | Status |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statecode |
RequiredLevel | SystemRequired |
Type | State |
StateCode Choices/Options
Value | Label | DefaultStatus | InvariantName |
---|---|---|---|
0 | Active | 0 | Active |
One-To-Many Relationships
Listed by SchemaName.
Import_ImportFile
Same as the Import_ImportFile many-to-one relationship for the importfile table/entity.
Property | Value |
---|---|
ReferencingEntity | importfile |
ReferencingAttribute | importid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | Import_ImportFile |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Import_BulkDeleteFailures
Same as the Import_BulkDeleteFailures many-to-one relationship for the bulkdeletefailure table/entity.
Property | Value |
---|---|
ReferencingEntity | bulkdeletefailure |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | Import_BulkDeleteFailures |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Import_AsyncOperations
Same as the Import_AsyncOperations many-to-one relationship for the asyncoperation table/entity.
Property | Value |
---|---|
ReferencingEntity | asyncoperation |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | Import_AsyncOperations |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.
- lk_import_modifiedonbehalfby
- team_Imports
- lk_importbase_modifiedby
- BusinessUnit_Imports
- SystemUser_Imports
- lk_import_createdonbehalfby
- lk_importbase_createdby
lk_import_modifiedonbehalfby
See the lk_import_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
team_Imports
See the team_Imports one-to-many relationship for the team table/entity.
lk_importbase_modifiedby
See the lk_importbase_modifiedby one-to-many relationship for the systemuser table/entity.
BusinessUnit_Imports
See the BusinessUnit_Imports one-to-many relationship for the businessunit table/entity.
SystemUser_Imports
See the SystemUser_Imports one-to-many relationship for the systemuser table/entity.
lk_import_createdonbehalfby
See the lk_import_createdonbehalfby one-to-many relationship for the systemuser table/entity.
lk_importbase_createdby
See the lk_importbase_createdby one-to-many relationship for the systemuser table/entity.
See also
Dataverse table/entity reference
Web API Reference
import EntityType
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru