ImportLog table/entity reference

Article
02/22/2024

Note

Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.

Failure reason and other detailed information for a record that failed to import.

Messages

Message	Web API Operation	SDK class or method
Retrieve	GET /importlogs(importlogid) See Retrieve	RetrieveRequest or Retrieve
RetrieveMultiple	GET /importlogs See Query Data	RetrieveMultipleRequest or RetrieveMultiple

Properties

Property	Value
CollectionSchemaName	ImportLogs
DisplayCollectionName	ImportLogs
DisplayName	Import Log
EntitySetName	importlogs
IsBPFEntity	False
LogicalCollectionName	importlogs
LogicalName	importlog
OwnershipType	UserOwned
PrimaryIdAttribute	importlogid
PrimaryNameAttribute
SchemaName	ImportLog

Writable columns/attributes

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

AdditionalInfo
ColumnValue
ErrorDescription
ErrorNumber
HeaderColumn
ImportDataId
ImportFileId
ImportLogId
LineNumber
LogPhaseCode
OwnerId
OwnerIdType
StatusCode

AdditionalInfo

Property	Value
Description	Additional information related to the error.
DisplayName	More Information
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	additionalinfo
MaxLength	5000
RequiredLevel	None
Type	String

ColumnValue

Property	Value
Description	Value in the column.
DisplayName	Column Value
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	columnvalue
MaxLength	160
RequiredLevel	None
Type	String

ErrorDescription

Property	Value
Description	Description of an error.
DisplayName	Description
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	errordescription
MaxLength	512
RequiredLevel	None
Type	String

ErrorNumber

Property	Value
Description	Error code of an error.
DisplayName	Error Code
Format	None
IsValidForForm	True
IsValidForRead	True
LogicalName	errornumber
MaxValue	10000000
MinValue	0
RequiredLevel	None
Type	Integer

HeaderColumn

Property	Value
Description	Name of the column heading.
DisplayName	Column Heading
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	headercolumn
MaxLength	1073741823
RequiredLevel	None
Type	String

ImportDataId

Property	Value
Description	Unique identifier of the import data for this import log.
DisplayName	Source Row
IsValidForForm	True
IsValidForRead	True
LogicalName	importdataid
RequiredLevel	None
Targets	importdata
Type	Lookup

ImportFileId

Property	Value
Description	Unique identifier of the import file for this import log.
DisplayName	Import File Id
IsValidForForm	True
IsValidForRead	True
LogicalName	importfileid
RequiredLevel	None
Targets	importfile
Type	Lookup

ImportLogId

Property	Value
Description	Unique identifier of the import log.
DisplayName
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	importlogid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

LineNumber

Property	Value
Description	Original line number of the data used in this log.
DisplayName	Original Row Number
Format	None
IsValidForForm	True
IsValidForRead	True
LogicalName	linenumber
MaxValue	10000000
MinValue	0
RequiredLevel	None
Type	Integer

LogPhaseCode

Property	Value
Description	Phase for which the log is recorded.
DisplayName	Log Phase
IsValidForForm	True
IsValidForRead	True
LogicalName	logphasecode
RequiredLevel	None
Type	Picklist

LogPhaseCode Choices/Options

Value	Label	Description
0	Parse
1	Transform
2	Import Create
3	Import Update

OwnerId

Property	Value
Description	Unique identifier of the user or team who owns the import log.
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

StatusCode

Property	Value
Description	Reason for the status of the import log.
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	statuscode
RequiredLevel	SystemRequired
Type	Status

StatusCode Choices/Options

Value	Label	State
0	Active	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
ImportDataIdName
ImportFileIdName
ModifiedBy
ModifiedByName
ModifiedByYomiName
ModifiedOn
ModifiedOnBehalfBy
ModifiedOnBehalfByName
ModifiedOnBehalfByYomiName
OwnerIdName
OwnerIdYomiName
OwningBusinessUnit
OwningBusinessUnitName
OwningTeam
OwningUser
SequenceNumber
StateCode

CreatedBy

Property	Value
Description	Unique identifier of the user who created the import log.
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	Date and time when the import log was created.
DisplayName	Created On
Format	DateAndTime
IsValidForForm	False
IsValidForRead	True
LogicalName	createdon
RequiredLevel	SystemRequired
Type	DateTime

CreatedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who created the importlog.
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

ImportDataIdName

Property	Value
Description	Name of the import data.
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	importdataidname
MaxLength	100
RequiredLevel	SystemRequired
Type	String

ImportFileIdName

Property	Value
Description	Name of the import file.
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	importfileidname
MaxLength	100
RequiredLevel	SystemRequired
Type	String

ModifiedBy

Property	Value
Description	Unique identifier of the user who last modified the import log.
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	Date and time when the import log was last modified.
DisplayName	Modified On
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedon
RequiredLevel	SystemRequired
Type	DateTime

ModifiedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who last modified the importlog.
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 log.
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 log.
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 log.
DisplayName	Owning User
IsValidForForm	False
IsValidForRead	True
LogicalName	owninguser
RequiredLevel	None
Targets	systemuser
Type	Lookup

SequenceNumber

Property	Value
Description	Sequence number of the error in this log.
DisplayName	Sequence Number
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	sequencenumber
MaxValue	10000000
MinValue	0
RequiredLevel	SystemRequired
Type	Integer

StateCode

Property	Value
Description	Status of the import log.
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.

ImportLog_BulkDeleteFailures
ImportLog_AsyncOperations

ImportLog_BulkDeleteFailures

Same as the ImportLog_BulkDeleteFailures many-to-one relationship for the bulkdeletefailure table/entity.

Property	Value
ReferencingEntity	bulkdeletefailure
ReferencingAttribute	regardingobjectid
IsHierarchical	False
IsCustomizable	False
ReferencedEntityNavigationPropertyName	ImportLog_BulkDeleteFailures
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

ImportLog_AsyncOperations

Same as the ImportLog_AsyncOperations many-to-one relationship for the asyncoperation table/entity.

Property	Value
ReferencingEntity	asyncoperation
ReferencingAttribute	regardingobjectid
IsHierarchical	False
IsCustomizable	False
ReferencedEntityNavigationPropertyName	ImportLog_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_importlog_createdonbehalfby
BusinessUnit_ImportLogs
SystemUser_ImportLogs
lk_importlogbase_modifiedby
lk_importlogbase_createdby
ImportLog_ImportFile
team_ImportLogs
lk_importlog_modifiedonbehalfby

lk_importlog_createdonbehalfby

See the lk_importlog_createdonbehalfby one-to-many relationship for the systemuser table/entity.

BusinessUnit_ImportLogs

See the BusinessUnit_ImportLogs one-to-many relationship for the businessunit table/entity.

SystemUser_ImportLogs

See the SystemUser_ImportLogs one-to-many relationship for the systemuser table/entity.

lk_importlogbase_modifiedby

See the lk_importlogbase_modifiedby one-to-many relationship for the systemuser table/entity.

lk_importlogbase_createdby

See the lk_importlogbase_createdby one-to-many relationship for the systemuser table/entity.

ImportLog_ImportFile

See the ImportLog_ImportFile one-to-many relationship for the importfile table/entity.

team_ImportLogs

See the team_ImportLogs one-to-many relationship for the team table/entity.

lk_importlog_modifiedonbehalfby

See the lk_importlog_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.