Import Job (ImportJob) table/entity reference

For internal use only.

Messages

The following table lists the messages for the Import Job (ImportJob) 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
Create Event: False	POST /importjobs See Create	Create records
Delete Event: False	DELETE /importjobs(importjobid) See Delete	Delete records
Retrieve Event: False	GET /importjobs(importjobid) See Retrieve	Retrieve records
RetrieveMultiple Event: False	GET /importjobs See Query data	Query data
Update Event: False	PATCH /importjobs(importjobid) See Update	Update records
Upsert Event: False	PATCH /importjobs(importjobid) See Upsert a table row	UpsertRequest

Properties

The following table lists selected properties for the Import Job (ImportJob) table.

Property	Value
DisplayName	Import Job
DisplayCollectionName	Import Jobs
SchemaName	ImportJob
CollectionSchemaName	ImportJobs
EntitySetName	importjobs
LogicalName	importjob
LogicalCollectionName	importjobs
PrimaryIdAttribute	importjobid
TableType	Standard
OwnershipType	OrganizationOwned

Writable columns/attributes

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

• Data
• ImportContext
• ImportJobId
• Name
• OperationContext
• Progress
• SolutionName
• TimeZoneRuleVersionNumber
• UTCConversionTimeZoneCode

Data

Property	Value
Description	Unstructured data associated with the import job.
DisplayName	Data
IsValidForForm	True
IsValidForRead	True
LogicalName	data
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	1073741823

ImportContext

Property	Value
Description	The context of the import
DisplayName	Import Context
IsValidForForm	True
IsValidForRead	True
LogicalName	importcontext
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	110

ImportJobId

Property	Value
Description	Unique identifier of the import job.
DisplayName	Import Job
IsValidForForm	True
IsValidForRead	True
LogicalName	importjobid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

Name

Property	Value
Description	Name of the import job.
DisplayName	Import Job Name
IsValidForForm	True
IsValidForRead	True
LogicalName	name
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	256

OperationContext

Property	Value
Description	The context of the solution operation
DisplayName	Solution Operation Context
IsValidForForm	True
IsValidForRead	True
LogicalName	operationcontext
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	50

Progress

Property	Value
Description	Import Progress Percentage.
DisplayName	Progress
IsValidForForm	True
IsValidForRead	True
LogicalName	progress
RequiredLevel	None
Type	Double
ImeMode	Disabled
MaxValue	100
MinValue	0
Precision	2

SolutionName

Property	Value
Description	Unique identifier of the solution.
DisplayName	SolutionName
IsValidForForm	True
IsValidForRead	True
LogicalName	solutionname
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	256

TimeZoneRuleVersionNumber

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

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.

• CompletedOn
• CreatedBy
• CreatedOn
• CreatedOnBehalfBy
• ModifiedBy
• ModifiedOn
• ModifiedOnBehalfBy
• OrganizationId
• SolutionId
• StartedOn

CompletedOn

Property	Value
Description	Date and time when the import job was completed.
DisplayName	Completed On
IsValidForForm	True
IsValidForRead	True
LogicalName	completedon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

CreatedBy

Property	Value
Description	Unique identifier of the user who created the importJob.
DisplayName	Created By
IsValidForForm	True
IsValidForRead	True
LogicalName	createdby
RequiredLevel	None
Type	Lookup
Targets	systemuser

CreatedOn

Property	Value
Description	Date and time when the import job record was created.
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	Unique identifier of the delegate user who created the import job record.
DisplayName	Created By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	createdonbehalfby
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedBy

Property	Value
Description	Unique identifier of the user who modified the importJob.
DisplayName	Modified By
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedby
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedOn

Property	Value
Description	Date and time when the import job was last modified.
DisplayName	Modified On
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

ModifiedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who modified the import job record.
DisplayName	Created By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedonbehalfby
RequiredLevel	None
Type	Lookup
Targets	systemuser

OrganizationId

Property	Value
Description	Unique identifier of the organization associated with the importjob.
DisplayName	Organization
IsValidForForm	False
IsValidForRead	True
LogicalName	organizationid
RequiredLevel	SystemRequired
Type	Lookup
Targets	organization

SolutionId

Property	Value
Description	Unique identifier of the associated solution.
DisplayName	Solution
IsValidForForm	False
IsValidForRead	True
LogicalName	solutionid
RequiredLevel	None
Type	Uniqueidentifier

StartedOn

Property	Value
Description	Date and time when the import job was started.
DisplayName	Started On
IsValidForForm	True
IsValidForRead	True
LogicalName	startedon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

Many-to-One relationships

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

• lk_importjobbase_createdby
• lk_importjobbase_createdonbehalfby
• lk_importjobbase_modifiedby
• lk_importjobbase_modifiedonbehalfby
• organization_importjob

lk_importjobbase_createdby

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

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

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

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

organization_importjob

One-To-Many Relationship: organization organization_importjob

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

See also

Dataverse table/entity reference
Dataverse Web API Reference
importjob