msdyn_integrationjob EntityType

Staging table for integration data

Entity Set Path
[organization URI]/api/data/v9.0/msdyn_integrationjobs
Base Type
Display Name
Integration Job
Primary Key
Primary Key Attribute
Operations Supported


Properties represent fields of data stored in the entity.Some properties are read-only.

Name Type Details
createdon Edm.DateTimeOffset

Date and time when the record was created.

Display Name: Created On

Read Only
importsequencenumber Edm.Int32

Sequence number of the import that created this record.

Display Name: Import Sequence Number

modifiedon Edm.DateTimeOffset

Date and time when the record was modified.

Display Name: Modified On

Read Only
msdyn_integrationjobid Edm.Guid

Unique identifier for entity instances

Display Name: Integration Job

msdyn_name Edm.String

The name of the custom entity.

Display Name: Name

msdyn_numberofpackets Edm.Int32

The expected number of packets to be received.

Display Name: Number of packets

msdyn_regardingentity Edm.String

The logical name of entity related to the integration job

Display Name: Regarding Entity

msdyn_regardingentityid Edm.String

The primary id of entity related to the integration job

Display Name: Regarding Entity Id

msdyn_responsejson Edm.String

The response of the integration job in JSON format

Display Name: ResponseJSON

msdyn_status Edm.Int32

The status of the integration job.

Display Name: Status

Default Options
Value Label
192350000 Waiting
192350001 Ready
192350002 Skipped
192350003 Processing
192350004 Succeeded
192350005 Failed
msdyn_type Edm.Int32

The type of integration job

Display Name: Type

Default Options
Value Label
192350000 MS Project Client
overriddencreatedon Edm.DateTimeOffset

Date and time that the record was migrated.

Display Name: Record Created On

statecode Edm.Int32

Status of the Integration Job

Display Name: Status

Default Options
Value Label
0 Active
1 Inactive
statuscode Edm.Int32

Reason for the status of the Integration Job

Display Name: Status Reason

Default Options
Value Label
1 Active
2 Inactive
timezoneruleversionnumber Edm.Int32

For internal use only.

Display Name: Time Zone Rule Version Number

utcconversiontimezonecode Edm.Int32

Time zone code that was in use when the record was created.

Display Name: UTC Conversion Time Zone Code

versionnumber Edm.Int64

Version Number

Display Name: Version Number

Read Only

Lookup Properties

Lookup properties are read-only, computed properties which contain entity primary key Edm.Guid data for one or more corresponding single-valued navigation properties. More information: Lookup properties and Retrieve data about lookup properties.

Name Single-valued navigation property Description
_createdby_value createdby

Unique identifier of the user who created the record.

_createdonbehalfby_value createdonbehalfby

Unique identifier of the delegate user who created the record.

_modifiedby_value modifiedby

Unique identifier of the user who modified the record.

_modifiedonbehalfby_value modifiedonbehalfby

Unique identifier of the delegate user who modified the record.

_ownerid_value ownerid

Owner Id

_owningbusinessunit_value owningbusinessunit

Unique identifier for the business unit that owns the record

_owningteam_value owningteam

Unique identifier for the team that owns the record.

_owninguser_value owninguser

Unique identifier for the user that owns the record.

Single-valued navigation properties

Single-valued navigation properties represent lookup fields where a single entity can be referenced. Each single-valued navigation property has a corresponding partner collection-valued navigation property on the related entity.

Name Type Partner
createdby systemuser lk_msdyn_integrationjob_createdby
createdonbehalfby systemuser lk_msdyn_integrationjob_createdonbehalfby
modifiedby systemuser lk_msdyn_integrationjob_modifiedby
modifiedonbehalfby systemuser lk_msdyn_integrationjob_modifiedonbehalfby
ownerid principal owner_msdyn_integrationjob
owningbusinessunit businessunit business_unit_msdyn_integrationjob
owningteam team team_msdyn_integrationjob
owninguser systemuser user_msdyn_integrationjob

Collection-valued navigation properties

Collection-valued navigation properties represent collections of entities which may represent either a one-to-many (1:N) or many-to-many (N:N) relationship between the entities.

Name Type Partner
msdyn_integrationjob_AsyncOperations asyncoperation regardingobjectid_msdyn_integrationjob
msdyn_integrationjob_BulkDeleteFailures bulkdeletefailure regardingobjectid_msdyn_integrationjob
msdyn_integrationjob_MailboxTrackingFolders mailboxtrackingfolder regardingobjectid_msdyn_integrationjob
msdyn_integrationjob_PrincipalObjectAttributeAccesses principalobjectattributeaccess objectid_msdyn_integrationjob
msdyn_integrationjob_ProcessSession processsession regardingobjectid_msdyn_integrationjob
msdyn_integrationjob_SyncErrors syncerror regardingobjectid_msdyn_integrationjob
msdyn_msdyn_integrationjob_msdyn_integrationjob msdyn_integrationjobdetail msdyn_IntegrationJobHeader


The following operations can be used with the msdyn_integrationjob entity type.

Name Binding
GrantAccess Not Bound
IsValidStateTransition Not Bound
ModifyAccess Not Bound
msdyn_MarkIntegrationJobAsFailedAsync Entity
RetrievePrincipalAccess Not Bound
RetrieveSharedPrincipalsAndAccess Not Bound
RevokeAccess Not Bound


The following solutions include the msdyn_integrationjob entity type.

Name Description
Project Service Automation Microsoft Dynamics 365 for Project Service Automation is an end-to-end solution that helps sales and delivery teams engage customers and deliver billable projects on time and within budget. Project Service gives you the tools you need to: Estimate, quote, and contract work; Plan and assign resources; Enable team collaboration; Capture time, expense, and progress data for real-time insights and accurate invoicing.

See also