Import Source File (ImportFile) table/entity reference

File name of file used for import.

Messages

The following table lists the messages for the Import Source File (ImportFile) 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
Assign Event: False	PATCH /importfiles(importfileid) Update the ownerid property.	AssignRequest
Create Event: False	POST /importfiles See Create	Create records
Delete Event: False	DELETE /importfiles(importfileid) See Delete	Delete records
GetDistinctValuesImportFile Event: False	GetDistinctValuesImportFile	GetDistinctValuesImportFileRequest
GetHeaderColumnsImportFile Event: False	GetHeaderColumnsImportFile	GetHeaderColumnsImportFileRequest
GrantAccess Event: False	GrantAccess	GrantAccessRequest
ModifyAccess Event: False	ModifyAccess	ModifyAccessRequest
Retrieve Event: False	GET /importfiles(importfileid) See Retrieve	Retrieve records
RetrieveMultiple Event: False	GET /importfiles See Query data	Query data
RetrieveParsedDataImportFile Event: False	RetrieveParsedDataImportFile	RetrieveParsedDataImportFileRequest
RetrievePrincipalAccess Event: False	RetrievePrincipalAccess	RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess Event: False	RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess Event: False	RevokeAccess	RevokeAccessRequest
Update Event: False	PATCH /importfiles(importfileid) See Update	Update records
Upsert Event: False	PATCH /importfiles(importfileid) See Upsert a table row	UpsertRequest

Properties

The following table lists selected properties for the Import Source File (ImportFile) table.

Property	Value
DisplayName	Import Source File
DisplayCollectionName	Imports
SchemaName	ImportFile
CollectionSchemaName	ImportFiles
EntitySetName	importfiles
LogicalName	importfile
LogicalCollectionName	importfiles
PrimaryIdAttribute	importfileid
PrimaryNameAttribute	name
TableType	Standard
OwnershipType	UserOwned

Writable columns/attributes

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

• Content
• DataDelimiterCode
• EnableDuplicateDetection
• EntityKeyId
• FieldDelimiterCode
• FileTypeCode
• ImportFileId
• ImportId
• ImportMapId
• IsFirstRowHeader
• Name
• OwnerId
• OwnerIdType
• ProcessCode
• RecordsOwnerId
• RecordsOwnerIdType
• RelatedEntityColumns
• Size
• Source
• SourceEntityName
• StateCode
• StatusCode
• TargetEntityName
• TimeZoneRuleVersionNumber
• UpsertModeCode
• UseSystemMap
• UTCConversionTimeZoneCode

Content

Property	Value
Description	Stores the content of the import file, stored as comma-separated values.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	content
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	1073741823

DataDelimiterCode

Property	Value
Description	Select the single-character data delimiter used in the import file. This is typically a single or double quotation mark.
DisplayName	Data Delimiter
IsValidForForm	True
IsValidForRead	True
LogicalName	datadelimitercode
RequiredLevel	SystemRequired
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	importfile_datadelimitercode

DataDelimiterCode Choices/Options

Value	Label
1	DoubleQuote
2	None
3	SingleQuote

EnableDuplicateDetection

Property	Value
Description	Select whether duplicate-detection rules should be run against the import job.
DisplayName	Enable Duplicate Detection
IsValidForForm	True
IsValidForRead	True
LogicalName	enableduplicatedetection
RequiredLevel	None
Type	Boolean
GlobalChoiceName	importfile_enableduplicatedetection
DefaultValue	False
True Label	Yes
False Label	No

EntityKeyId

Property	Value
Description	Unique identifier of the Alternate key Id
DisplayName	Entity Key ID
IsValidForForm	False
IsValidForRead	True
LogicalName	entitykeyid
RequiredLevel	None
Type	Uniqueidentifier

FieldDelimiterCode

Property	Value
Description	Select the character that is used to separate each field in the import file. Typically, it is a comma.
DisplayName	Field Delimiter
IsValidForForm	True
IsValidForRead	True
LogicalName	fielddelimitercode
RequiredLevel	SystemRequired
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	importfile_fielddelimitercode

FieldDelimiterCode Choices/Options

Value	Label
1	Colon
2	Comma
3	Tab
4	Semicolon

FileTypeCode

Property	Value
Description	Shows the type of source file that is uploaded for import.
DisplayName	File Type
IsValidForForm	True
IsValidForRead	True
LogicalName	filetypecode
RequiredLevel	SystemRequired
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	importfile_filetypecode

FileTypeCode Choices/Options

Value	Label
0	CSV
1	XML Spreadsheet 2003
2	Attachment
3	XLSX

ImportFileId

Property	Value
Description	Unique identifier of the import file.
DisplayName	Import
IsValidForForm	False
IsValidForRead	True
LogicalName	importfileid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

ImportId

Property	Value
Description	Choose the import job that the file was uploaded for.
DisplayName	Import Job ID
IsValidForForm	True
IsValidForRead	True
LogicalName	importid
RequiredLevel	SystemRequired
Type	Lookup
Targets	import

ImportMapId

Property	Value
Description	Choose a data map to match the import file and its column headers with the record types and fields in Microsoft Dynamics 365. If the column headers in the file match the display names of the target fields in Microsoft Dynamics 365, we import the data automatically. If not, you can manually define matches during import.
DisplayName	Data Map
IsValidForForm	True
IsValidForRead	True
LogicalName	importmapid
RequiredLevel	None
Type	Lookup
Targets	importmap

IsFirstRowHeader

Property	Value
Description	Select whether the first row of the import file contains column headings, which are used for data mapping during the import job.
DisplayName	Is First Row Header
IsValidForForm	True
IsValidForRead	True
LogicalName	isfirstrowheader
RequiredLevel	SystemRequired
Type	Boolean
GlobalChoiceName	importfile_isfirstrowheader
DefaultValue	False
True Label	Yes
False Label	No

Name

Property	Value
Description	Shows the name of the import file. This name is based on the name of the uploaded file.
DisplayName	Import Name
IsValidForForm	True
IsValidForRead	True
LogicalName	name
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	256

OwnerId

Property	Value
Description	Enter the user who is assigned to follow up with or manage the import file. This field is updated every time the import file is assigned to a different user.
DisplayName	Owner
IsValidForForm	True
IsValidForRead	True
LogicalName	ownerid
RequiredLevel	SystemRequired
Type	Owner
Targets	systemuser, team

OwnerIdType

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	owneridtype
RequiredLevel	SystemRequired
Type	EntityName

ProcessCode

Property	Value
Description	Tells whether the import file should be ignored or processed during the import.
DisplayName	Process Code
IsValidForForm	True
IsValidForRead	True
LogicalName	processcode
RequiredLevel	SystemRequired
Type	Picklist
DefaultFormValue	1
GlobalChoiceName	importfile_processcode

ProcessCode Choices/Options

Value	Label
1	Process
2	Ignore
3	Internal

RecordsOwnerId

Property	Value
Description	Choose the user that the records created during the import job should be assigned to.
DisplayName	Records Owner
IsValidForForm	True
IsValidForRead	True
LogicalName	recordsownerid
RequiredLevel	None
Type	Lookup
Targets	systemuser, team

RecordsOwnerIdType

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	recordsowneridtype
RequiredLevel	SystemRequired
Type	EntityName

RelatedEntityColumns

Property	Value
Description	Shows the columns that are mapped to a related record type (entity) of the primary record type (entity) included in the import file.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	relatedentitycolumns
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	1073741823

Size

Property	Value
Description	Shows the size of the import file, in kilobytes.
DisplayName	Size
IsValidForForm	True
IsValidForRead	True
LogicalName	size
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

Source

Property	Value
Description	Shows the name of the data source file uploaded in the import job.
DisplayName	Source
IsValidForForm	True
IsValidForRead	True
LogicalName	source
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	256

SourceEntityName

Property	Value
Description	Shows the record type (entity) of the source data.
DisplayName	Source Entity
IsValidForForm	True
IsValidForRead	True
LogicalName	sourceentityname
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

StateCode

Property	Value
Description	Shows the status of the import file record. By default, all records are active and can't be deactivated.
DisplayName	Status
IsValidForForm	True
IsValidForRead	True
LogicalName	statecode
RequiredLevel	SystemRequired
Type	State
DefaultFormValue	0
GlobalChoiceName	importfile_statecode

StateCode Choices/Options

Value	Details
0	Label: Active DefaultStatus: 0 InvariantName: Active

StatusCode

Property	Value
Description	Shows the reason code that explains the import file's status to identify the stage of the import process, from parsing the data to completed.
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	statuscode
RequiredLevel	None
Type	Status
DefaultFormValue	-1
GlobalChoiceName	importfile_statuscode

StatusCode Choices/Options

Value	Details
0	Label: Submitted State:0 TransitionData: None
1	Label: Parsing State:0 TransitionData: None
2	Label: Transforming State:0 TransitionData: None
3	Label: Importing State:0 TransitionData: None
4	Label: Completed State:0 TransitionData: None
5	Label: Failed State:0 TransitionData: None

TargetEntityName

Property	Value
Description	Select the target record type (entity) for the records that will be created during the import job.
DisplayName	Target Entity
IsValidForForm	True
IsValidForRead	True
LogicalName	targetentityname
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

TimeZoneRuleVersionNumber

Property	Value
Description	For internal use only.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	timezoneruleversionnumber
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

UpsertModeCode

Property	Value
Description	Select the value which is used for identify the upsert mode. By Default, it is a Create.
DisplayName	Upsert Mode
IsValidForForm	True
IsValidForRead	True
LogicalName	upsertmodecode
RequiredLevel	None
Type	Picklist
DefaultFormValue	0
GlobalChoiceName	importfile_upsertmodecode

UpsertModeCode Choices/Options

Value	Label
0	Create
1	Update
2	Ignore

UseSystemMap

Property	Value
Description	Tells whether an automatic system map was applied to the import file, which automatically maps the import data to the target entity in Microsoft Dynamics 365.
DisplayName	Use System Map
IsValidForForm	True
IsValidForRead	True
LogicalName	usesystemmap
RequiredLevel	SystemRequired
Type	Boolean
GlobalChoiceName	importfile_usesystemmap
DefaultValue	False
True Label	Yes
False Label	No

UTCConversionTimeZoneCode

Property	Value
Description	Time zone code that was in use when the record was created.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	utcconversiontimezonecode
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

Read-only columns/attributes

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

• AdditionalHeaderRow
• CompletedOn
• CreatedBy
• CreatedOn
• CreatedOnBehalfBy
• FailureCount
• HeaderRow
• ModifiedBy
• ModifiedOn
• ModifiedOnBehalfBy
• OwnerIdName
• OwnerIdYomiName
• OwningBusinessUnit
• OwningTeam
• OwningUser
• ParsedTableColumnPrefix
• ParsedTableColumnsNumber
• ParsedTableName
• PartialFailureCount
• ProcessingStatus
• ProgressCounter
• SuccessCount
• TotalCount

AdditionalHeaderRow

Property	Value
Description	Shows the secondary column headers. The additional headers are used during the process of transforming the import file into import data records.
DisplayName	Additional Header
IsValidForForm	True
IsValidForRead	True
LogicalName	additionalheaderrow
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100000

CompletedOn

Property	Value
Description	Shows the date and time when the import associated with the import file was completed.
DisplayName	Completed On
IsValidForForm	False
IsValidForRead	True
LogicalName	completedon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

CreatedBy

Property	Value
Description	Shows who created the record.
DisplayName	Created By
IsValidForForm	False
IsValidForRead	True
LogicalName	createdby
RequiredLevel	None
Type	Lookup
Targets	systemuser

CreatedOn

Property	Value
Description	Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName	Created On
IsValidForForm	True
IsValidForRead	True
LogicalName	createdon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

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
Type	Lookup
Targets	systemuser

FailureCount

Property	Value
Description	Shows the number of records in the import file that cannot be imported.
DisplayName	Errors
IsValidForForm	True
IsValidForRead	True
LogicalName	failurecount
RequiredLevel	None
Type	Integer
MaxValue	1000000000
MinValue	0

HeaderRow

Property	Value
Description	Shows a list of each column header in the import file separated by a comma. The header is used for parsing the file during the import job.
DisplayName	Header
IsValidForForm	True
IsValidForRead	True
LogicalName	headerrow
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	1073741823

ModifiedBy

Property	Value
Description	Shows who last updated the record.
DisplayName	Modified By
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedby
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedOn

Property	Value
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
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedon
RequiredLevel	SystemRequired
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

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
Type	Lookup
Targets	systemuser

OwnerIdName

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	owneridname
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

OwnerIdYomiName

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	owneridyominame
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

OwningBusinessUnit

Property	Value
Description	Shows the business unit that the record owner belongs to.
DisplayName
IsValidForForm	True
IsValidForRead	True
LogicalName	owningbusinessunit
RequiredLevel	None
Type	Lookup
Targets	businessunit

OwningTeam

Property	Value
Description	Unique identifier of the team who owns the import file.
DisplayName	Owning Team
IsValidForForm	False
IsValidForRead	True
LogicalName	owningteam
RequiredLevel	None
Type	Lookup
Targets	team

OwningUser

Property	Value
Description	Unique identifier of the user who owns the import file.
DisplayName	Owning User
IsValidForForm	False
IsValidForRead	True
LogicalName	owninguser
RequiredLevel	None
Type	Lookup
Targets	systemuser

ParsedTableColumnPrefix

Property	Value
Description	Shows the prefix applied to each column after the import file is parsed.
DisplayName	Parse Table Column Prefix
IsValidForForm	False
IsValidForRead	True
LogicalName	parsedtablecolumnprefix
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

ParsedTableColumnsNumber

Property	Value
Description	Shows the number of columns included in the parsed import file.
DisplayName	Parse Table Column Number
IsValidForForm	False
IsValidForRead	True
LogicalName	parsedtablecolumnsnumber
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

ParsedTableName

Property	Value
Description	Shows the name of the table that contains the parsed data from the import file.
DisplayName	Parse Table
IsValidForForm	False
IsValidForRead	True
LogicalName	parsedtablename
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

PartialFailureCount

Property	Value
Description	Shows the number of records in this file that had failures during the import.
DisplayName	Partial Failures
IsValidForForm	True
IsValidForRead	True
LogicalName	partialfailurecount
RequiredLevel	None
Type	Integer
MaxValue	1000000000
MinValue	0

ProcessingStatus

Property	Value
Description	Shows the import file's processing status code. This indicates whether the data in the import file has been parsed, transformed, or imported.
DisplayName	Processing Status
IsValidForForm	False
IsValidForRead	True
LogicalName	processingstatus
RequiredLevel	SystemRequired
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	importfile_processingstatus

ProcessingStatus Choices/Options

Value	Label
1	Not Started
2	Parsing
3	Parsing Complete
4	Complex Transformation
5	Lookup Transformation
6	Picklist Transformation
7	Owner Transformation
8	Transformation Complete
9	Import Pass 1
10	Import Pass 2
11	Import Complete
12	Primary Key Transformation

ProgressCounter

Property	Value
Description	Shows the progress code for the processing of the import file. This field is used when a paused import job is resumed.
DisplayName	Progress Counter
IsValidForForm	False
IsValidForRead	True
LogicalName	progresscounter
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

SuccessCount

Property	Value
Description	Shows the number of records in the import file that are imported successfully.
DisplayName	Successes
IsValidForForm	True
IsValidForRead	True
LogicalName	successcount
RequiredLevel	None
Type	Integer
MaxValue	1000000000
MinValue	0

TotalCount

Property	Value
Description	Shows the total number of records in the import file.
DisplayName	Total Processed
IsValidForForm	True
IsValidForRead	True
LogicalName	totalcount
RequiredLevel	None
Type	Integer
MaxValue	1000000000
MinValue	0

Many-to-One relationships

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

• BusinessUnit_ImportFiles
• Import_ImportFile
• ImportFile_SystemUser
• ImportFile_Team
• ImportMap_ImportFile
• lk_importfilebase_createdby
• lk_importfilebase_createdonbehalfby
• lk_importfilebase_modifiedby
• lk_importfilebase_modifiedonbehalfby
• owner_importfiles
• SystemUser_ImportFiles
• team_ImportFiles

BusinessUnit_ImportFiles

One-To-Many Relationship: businessunit BusinessUnit_ImportFiles

Property	Value
ReferencedEntity	businessunit
ReferencedAttribute	businessunitid
ReferencingAttribute	owningbusinessunit
ReferencingEntityNavigationPropertyName	owningbusinessunit
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

Import_ImportFile

One-To-Many Relationship: import Import_ImportFile

Property	Value
ReferencedEntity	import
ReferencedAttribute	importid
ReferencingAttribute	importid
ReferencingEntityNavigationPropertyName	importid
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

ImportFile_SystemUser

One-To-Many Relationship: systemuser ImportFile_SystemUser

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	recordsownerid
ReferencingEntityNavigationPropertyName	recordsownerid_systemuser
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

ImportFile_Team

One-To-Many Relationship: team ImportFile_Team

Property	Value
ReferencedEntity	team
ReferencedAttribute	teamid
ReferencingAttribute	recordsownerid
ReferencingEntityNavigationPropertyName	recordsownerid_team
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

ImportMap_ImportFile

One-To-Many Relationship: importmap ImportMap_ImportFile

Property	Value
ReferencedEntity	importmap
ReferencedAttribute	importmapid
ReferencingAttribute	importmapid
ReferencingEntityNavigationPropertyName	importmapid
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

lk_importfilebase_createdby

One-To-Many Relationship: systemuser lk_importfilebase_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_importfilebase_createdonbehalfby

One-To-Many Relationship: systemuser lk_importfilebase_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_importfilebase_modifiedby

One-To-Many Relationship: systemuser lk_importfilebase_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_importfilebase_modifiedonbehalfby

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

owner_importfiles

One-To-Many Relationship: owner owner_importfiles

Property	Value
ReferencedEntity	owner
ReferencedAttribute	ownerid
ReferencingAttribute	ownerid
ReferencingEntityNavigationPropertyName	ownerid
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

SystemUser_ImportFiles

One-To-Many Relationship: systemuser SystemUser_ImportFiles

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	owninguser
ReferencingEntityNavigationPropertyName	owninguser
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

team_ImportFiles

One-To-Many Relationship: team team_ImportFiles

Property	Value
ReferencedEntity	team
ReferencedAttribute	teamid
ReferencingAttribute	owningteam
ReferencingEntityNavigationPropertyName	owningteam
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

One-to-Many relationships

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

• ImportFile_AsyncOperations
• ImportFile_BulkDeleteFailures
• ImportFile_ImportData
• ImportLog_ImportFile

ImportFile_AsyncOperations

Many-To-One Relationship: asyncoperation ImportFile_AsyncOperations

Property	Value
ReferencingEntity	asyncoperation
ReferencingAttribute	regardingobjectid
ReferencedEntityNavigationPropertyName	ImportFile_AsyncOperations
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

ImportFile_BulkDeleteFailures

Many-To-One Relationship: bulkdeletefailure ImportFile_BulkDeleteFailures

Property	Value
ReferencingEntity	bulkdeletefailure
ReferencingAttribute	regardingobjectid
ReferencedEntityNavigationPropertyName	ImportFile_BulkDeleteFailures
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

ImportFile_ImportData

Many-To-One Relationship: importdata ImportFile_ImportData

Property	Value
ReferencingEntity	importdata
ReferencingAttribute	importfileid
ReferencedEntityNavigationPropertyName	ImportFile_ImportData
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

ImportLog_ImportFile

Many-To-One Relationship: importlog ImportLog_ImportFile

Property	Value
ReferencingEntity	importlog
ReferencingAttribute	importfileid
ReferencedEntityNavigationPropertyName	ImportLog_ImportFile
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

See also

Dataverse table/entity reference
Dataverse Web API Reference
importfile