ImportLog table/entity reference
-
Article
-
- 3 minutes to read
-
Failure reason and other detailed information for a record that failed to import.
Messages
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
| 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
| 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 |
False |
| IsValidForRead |
True |
| LogicalName |
owningbusinessunit |
| RequiredLevel |
None |
| Targets |
businessunit |
| Type |
Lookup |
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
Same as bulkdeletefailure table ImportLog_BulkDeleteFailures Many-To-One relationship.
| 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 asyncoperation table ImportLog_AsyncOperations Many-To-One relationship.
| 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
See systemuser Table lk_importlog_createdonbehalfby One-To-Many relationship.
BusinessUnit_ImportLogs
See businessunit Table BusinessUnit_ImportLogs One-To-Many relationship.
SystemUser_ImportLogs
See systemuser Table SystemUser_ImportLogs One-To-Many relationship.
lk_importlogbase_modifiedby
See systemuser Table lk_importlogbase_modifiedby One-To-Many relationship.
lk_importlogbase_createdby
See systemuser Table lk_importlogbase_createdby One-To-Many relationship.
ImportLog_ImportFile
See importfile Table ImportLog_ImportFile One-To-Many relationship.
team_ImportLogs
See team Table team_ImportLogs One-To-Many relationship.
lk_importlog_modifiedonbehalfby
See systemuser Table lk_importlog_modifiedonbehalfby One-To-Many relationship.
See also
About the table reference
Web API Reference
importlog EntityType