Import Job (ImportJob) table/entity reference

Artikel
08/31/2024

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`

Dela via