Import Source File (ImportFile) table/entity reference
File name of file used for import.
Messages
The following table lists the messages for the Import Source File (ImportFile) 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 |
---|---|---|
Assign Event: False |
PATCH /importfiles(importfileid)Update the ownerid property. |
AssignRequest |
Create Event: False |
POST /importfilesSee Create |
Create records |
Delete Event: False |
DELETE /importfiles(importfileid)See Delete |
Delete records |
GetDistinctValuesImportFile Event: False |
GetDistinctValuesImportFile | GetDistinctValuesImportFileRequest |
GetHeaderColumnsImportFile Event: False |
GetHeaderColumnsImportFile | GetHeaderColumnsImportFileRequest |
GrantAccess Event: False |
GrantAccess | GrantAccessRequest |
ModifyAccess Event: False |
ModifyAccess | ModifyAccessRequest |
Retrieve Event: False |
GET /importfiles(importfileid)See Retrieve |
Retrieve records |
RetrieveMultiple Event: False |
GET /importfilesSee Query data |
Query data |
RetrieveParsedDataImportFile Event: False |
RetrieveParsedDataImportFile | RetrieveParsedDataImportFileRequest |
RetrievePrincipalAccess Event: False |
RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccess Event: False |
RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccess Event: False |
RevokeAccess | RevokeAccessRequest |
Update Event: False |
PATCH /importfiles(importfileid)See Update |
Update records |
Upsert Event: False |
PATCH /importfiles(importfileid)See Upsert a table row |
UpsertRequest |
Properties
The following table lists selected properties for the Import Source File (ImportFile) table.
Property | Value |
---|---|
DisplayName | Import Source File |
DisplayCollectionName | Imports |
SchemaName | ImportFile |
CollectionSchemaName | ImportFiles |
EntitySetName | importfiles |
LogicalName | importfile |
LogicalCollectionName | importfiles |
PrimaryIdAttribute | importfileid |
PrimaryNameAttribute | name |
TableType | Standard |
OwnershipType | UserOwned |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- Content
- DataDelimiterCode
- EnableDuplicateDetection
- EntityKeyId
- FieldDelimiterCode
- FileTypeCode
- ImportFileId
- ImportId
- ImportMapId
- IsFirstRowHeader
- Name
- OwnerId
- OwnerIdType
- ProcessCode
- RecordsOwnerId
- RecordsOwnerIdType
- RelatedEntityColumns
- Size
- Source
- SourceEntityName
- StateCode
- StatusCode
- TargetEntityName
- TimeZoneRuleVersionNumber
- UpsertModeCode
- UseSystemMap
- UTCConversionTimeZoneCode
Content
Property | Value |
---|---|
Description | Stores the content of the import file, stored as comma-separated values. |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | content |
RequiredLevel | SystemRequired |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 1073741823 |
DataDelimiterCode
Property | Value |
---|---|
Description | Select the single-character data delimiter used in the import file. This is typically a single or double quotation mark. |
DisplayName | Data Delimiter |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | datadelimitercode |
RequiredLevel | SystemRequired |
Type | Picklist |
DefaultFormValue | -1 |
GlobalChoiceName | importfile_datadelimitercode |
DataDelimiterCode Choices/Options
Value | Label |
---|---|
1 | DoubleQuote |
2 | None |
3 | SingleQuote |
EnableDuplicateDetection
Property | Value |
---|---|
Description | Select whether duplicate-detection rules should be run against the import job. |
DisplayName | Enable Duplicate Detection |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | enableduplicatedetection |
RequiredLevel | None |
Type | Boolean |
GlobalChoiceName | importfile_enableduplicatedetection |
DefaultValue | False |
True Label | Yes |
False Label | No |
EntityKeyId
Property | Value |
---|---|
Description | Unique identifier of the Alternate key Id |
DisplayName | Entity Key ID |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | entitykeyid |
RequiredLevel | None |
Type | Uniqueidentifier |
FieldDelimiterCode
Property | Value |
---|---|
Description | Select the character that is used to separate each field in the import file. Typically, it is a comma. |
DisplayName | Field Delimiter |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | fielddelimitercode |
RequiredLevel | SystemRequired |
Type | Picklist |
DefaultFormValue | -1 |
GlobalChoiceName | importfile_fielddelimitercode |
FieldDelimiterCode Choices/Options
Value | Label |
---|---|
1 | Colon |
2 | Comma |
3 | Tab |
4 | Semicolon |
FileTypeCode
Property | Value |
---|---|
Description | Shows the type of source file that is uploaded for import. |
DisplayName | File Type |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | filetypecode |
RequiredLevel | SystemRequired |
Type | Picklist |
DefaultFormValue | -1 |
GlobalChoiceName | importfile_filetypecode |
FileTypeCode Choices/Options
Value | Label |
---|---|
0 | CSV |
1 | XML Spreadsheet 2003 |
2 | Attachment |
3 | XLSX |
ImportFileId
Property | Value |
---|---|
Description | Unique identifier of the import file. |
DisplayName | Import |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | importfileid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
ImportId
Property | Value |
---|---|
Description | Choose the import job that the file was uploaded for. |
DisplayName | Import Job ID |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | importid |
RequiredLevel | SystemRequired |
Type | Lookup |
Targets | import |
ImportMapId
Property | Value |
---|---|
Description | Choose a data map to match the import file and its column headers with the record types and fields in Microsoft Dynamics 365. If the column headers in the file match the display names of the target fields in Microsoft Dynamics 365, we import the data automatically. If not, you can manually define matches during import. |
DisplayName | Data Map |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | importmapid |
RequiredLevel | None |
Type | Lookup |
Targets | importmap |
IsFirstRowHeader
Property | Value |
---|---|
Description | Select whether the first row of the import file contains column headings, which are used for data mapping during the import job. |
DisplayName | Is First Row Header |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | isfirstrowheader |
RequiredLevel | SystemRequired |
Type | Boolean |
GlobalChoiceName | importfile_isfirstrowheader |
DefaultValue | False |
True Label | Yes |
False Label | No |
Name
Property | Value |
---|---|
Description | Shows the name of the import file. This name is based on the name of the uploaded file. |
DisplayName | Import Name |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | name |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 256 |
OwnerId
Property | Value |
---|---|
Description | Enter the user who is assigned to follow up with or manage the import file. This field is updated every time the import file is assigned to a different user. |
DisplayName | Owner |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | ownerid |
RequiredLevel | SystemRequired |
Type | Owner |
Targets | systemuser, team |
OwnerIdType
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridtype |
RequiredLevel | SystemRequired |
Type | EntityName |
ProcessCode
Property | Value |
---|---|
Description | Tells whether the import file should be ignored or processed during the import. |
DisplayName | Process Code |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | processcode |
RequiredLevel | SystemRequired |
Type | Picklist |
DefaultFormValue | 1 |
GlobalChoiceName | importfile_processcode |
ProcessCode Choices/Options
Value | Label |
---|---|
1 | Process |
2 | Ignore |
3 | Internal |
RecordsOwnerId
Property | Value |
---|---|
Description | Choose the user that the records created during the import job should be assigned to. |
DisplayName | Records Owner |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | recordsownerid |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser, team |
RecordsOwnerIdType
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | recordsowneridtype |
RequiredLevel | SystemRequired |
Type | EntityName |
RelatedEntityColumns
Property | Value |
---|---|
Description | Shows the columns that are mapped to a related record type (entity) of the primary record type (entity) included in the import file. |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | relatedentitycolumns |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 1073741823 |
Size
Property | Value |
---|---|
Description | Shows the size of the import file, in kilobytes. |
DisplayName | Size |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | size |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 160 |
Source
Property | Value |
---|---|
Description | Shows the name of the data source file uploaded in the import job. |
DisplayName | Source |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | source |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 256 |
SourceEntityName
Property | Value |
---|---|
Description | Shows the record type (entity) of the source data. |
DisplayName | Source Entity |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | sourceentityname |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 160 |
StateCode
Property | Value |
---|---|
Description | Shows the status of the import file record. By default, all records are active and can't be deactivated. |
DisplayName | Status |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statecode |
RequiredLevel | SystemRequired |
Type | State |
DefaultFormValue | 0 |
GlobalChoiceName | importfile_statecode |
StateCode Choices/Options
Value | Details |
---|---|
0 | Label: Active DefaultStatus: 0 InvariantName: Active |
StatusCode
Property | Value |
---|---|
Description | Shows the reason code that explains the import file's status to identify the stage of the import process, from parsing the data to completed. |
DisplayName | Status Reason |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statuscode |
RequiredLevel | None |
Type | Status |
DefaultFormValue | -1 |
GlobalChoiceName | importfile_statuscode |
StatusCode Choices/Options
Value | Details |
---|---|
0 | Label: Submitted State:0 TransitionData: None |
1 | Label: Parsing State:0 TransitionData: None |
2 | Label: Transforming State:0 TransitionData: None |
3 | Label: Importing State:0 TransitionData: None |
4 | Label: Completed State:0 TransitionData: None |
5 | Label: Failed State:0 TransitionData: None |
TargetEntityName
Property | Value |
---|---|
Description | Select the target record type (entity) for the records that will be created during the import job. |
DisplayName | Target Entity |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | targetentityname |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 160 |
TimeZoneRuleVersionNumber
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | timezoneruleversionnumber |
RequiredLevel | None |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -1 |
UpsertModeCode
Property | Value |
---|---|
Description | Select the value which is used for identify the upsert mode. By Default, it is a Create. |
DisplayName | Upsert Mode |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | upsertmodecode |
RequiredLevel | None |
Type | Picklist |
DefaultFormValue | 0 |
GlobalChoiceName | importfile_upsertmodecode |
UpsertModeCode Choices/Options
Value | Label |
---|---|
0 | Create |
1 | Update |
2 | Ignore |
UseSystemMap
Property | Value |
---|---|
Description | Tells whether an automatic system map was applied to the import file, which automatically maps the import data to the target entity in Microsoft Dynamics 365. |
DisplayName | Use System Map |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | usesystemmap |
RequiredLevel | SystemRequired |
Type | Boolean |
GlobalChoiceName | importfile_usesystemmap |
DefaultValue | False |
True Label | Yes |
False Label | No |
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.
- AdditionalHeaderRow
- CompletedOn
- CreatedBy
- CreatedOn
- CreatedOnBehalfBy
- FailureCount
- HeaderRow
- ModifiedBy
- ModifiedOn
- ModifiedOnBehalfBy
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningTeam
- OwningUser
- ParsedTableColumnPrefix
- ParsedTableColumnsNumber
- ParsedTableName
- PartialFailureCount
- ProcessingStatus
- ProgressCounter
- SuccessCount
- TotalCount
AdditionalHeaderRow
Property | Value |
---|---|
Description | Shows the secondary column headers. The additional headers are used during the process of transforming the import file into import data records. |
DisplayName | Additional Header |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | additionalheaderrow |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 100000 |
CompletedOn
Property | Value |
---|---|
Description | Shows the date and time when the import associated with the import file was completed. |
DisplayName | Completed On |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | completedon |
RequiredLevel | None |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateOnly |
ImeMode | Inactive |
SourceTypeMask | 0 |
CreatedBy
Property | Value |
---|---|
Description | Shows who created the record. |
DisplayName | Created By |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
CreatedOn
Property | Value |
---|---|
Description | Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. |
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 | Shows who created the record on behalf of another user. |
DisplayName | Created By (Delegate) |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
FailureCount
Property | Value |
---|---|
Description | Shows the number of records in the import file that cannot be imported. |
DisplayName | Errors |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | failurecount |
RequiredLevel | None |
Type | Integer |
MaxValue | 1000000000 |
MinValue | 0 |
HeaderRow
Property | Value |
---|---|
Description | Shows a list of each column header in the import file separated by a comma. The header is used for parsing the file during the import job. |
DisplayName | Header |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | headerrow |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 1073741823 |
ModifiedBy
Property | Value |
---|---|
Description | Shows who last updated the record. |
DisplayName | Modified By |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
ModifiedOn
Property | Value |
---|---|
Description | Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. |
DisplayName | Modified On |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedon |
RequiredLevel | SystemRequired |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateAndTime |
ImeMode | Inactive |
SourceTypeMask | 0 |
ModifiedOnBehalfBy
Property | Value |
---|---|
Description | Shows who created the record on behalf of another user. |
DisplayName | Modified By (Delegate) |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
OwnerIdName
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridname |
RequiredLevel | SystemRequired |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 100 |
OwnerIdYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridyominame |
RequiredLevel | SystemRequired |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 100 |
OwningBusinessUnit
Property | Value |
---|---|
Description | Shows the business unit that the record owner belongs to. |
DisplayName | |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | owningbusinessunit |
RequiredLevel | None |
Type | Lookup |
Targets | businessunit |
OwningTeam
Property | Value |
---|---|
Description | Unique identifier of the team who owns the import file. |
DisplayName | Owning Team |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningteam |
RequiredLevel | None |
Type | Lookup |
Targets | team |
OwningUser
Property | Value |
---|---|
Description | Unique identifier of the user who owns the import file. |
DisplayName | Owning User |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owninguser |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
ParsedTableColumnPrefix
Property | Value |
---|---|
Description | Shows the prefix applied to each column after the import file is parsed. |
DisplayName | Parse Table Column Prefix |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | parsedtablecolumnprefix |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 160 |
ParsedTableColumnsNumber
Property | Value |
---|---|
Description | Shows the number of columns included in the parsed import file. |
DisplayName | Parse Table Column Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | parsedtablecolumnsnumber |
RequiredLevel | None |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -2147483648 |
ParsedTableName
Property | Value |
---|---|
Description | Shows the name of the table that contains the parsed data from the import file. |
DisplayName | Parse Table |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | parsedtablename |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 160 |
PartialFailureCount
Property | Value |
---|---|
Description | Shows the number of records in this file that had failures during the import. |
DisplayName | Partial Failures |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | partialfailurecount |
RequiredLevel | None |
Type | Integer |
MaxValue | 1000000000 |
MinValue | 0 |
ProcessingStatus
Property | Value |
---|---|
Description | Shows the import file's processing status code. This indicates whether the data in the import file has been parsed, transformed, or imported. |
DisplayName | Processing Status |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | processingstatus |
RequiredLevel | SystemRequired |
Type | Picklist |
DefaultFormValue | -1 |
GlobalChoiceName | importfile_processingstatus |
ProcessingStatus Choices/Options
Value | Label |
---|---|
1 | Not Started |
2 | Parsing |
3 | Parsing Complete |
4 | Complex Transformation |
5 | Lookup Transformation |
6 | Picklist Transformation |
7 | Owner Transformation |
8 | Transformation Complete |
9 | Import Pass 1 |
10 | Import Pass 2 |
11 | Import Complete |
12 | Primary Key Transformation |
ProgressCounter
Property | Value |
---|---|
Description | Shows the progress code for the processing of the import file. This field is used when a paused import job is resumed. |
DisplayName | Progress Counter |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | progresscounter |
RequiredLevel | None |
Type | Integer |
MaxValue | 2147483647 |
MinValue | 0 |
SuccessCount
Property | Value |
---|---|
Description | Shows the number of records in the import file that are imported successfully. |
DisplayName | Successes |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | successcount |
RequiredLevel | None |
Type | Integer |
MaxValue | 1000000000 |
MinValue | 0 |
TotalCount
Property | Value |
---|---|
Description | Shows the total number of records in the import file. |
DisplayName | Total Processed |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totalcount |
RequiredLevel | None |
Type | Integer |
MaxValue | 1000000000 |
MinValue | 0 |
Many-to-One relationships
These relationships are many-to-one. Listed by SchemaName.
- BusinessUnit_ImportFiles
- Import_ImportFile
- ImportFile_SystemUser
- ImportFile_Team
- ImportMap_ImportFile
- lk_importfilebase_createdby
- lk_importfilebase_createdonbehalfby
- lk_importfilebase_modifiedby
- lk_importfilebase_modifiedonbehalfby
- owner_importfiles
- SystemUser_ImportFiles
- team_ImportFiles
BusinessUnit_ImportFiles
One-To-Many Relationship: businessunit BusinessUnit_ImportFiles
Property | Value |
---|---|
ReferencedEntity | businessunit |
ReferencedAttribute | businessunitid |
ReferencingAttribute | owningbusinessunit |
ReferencingEntityNavigationPropertyName | owningbusinessunit |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
Import_ImportFile
One-To-Many Relationship: import Import_ImportFile
Property | Value |
---|---|
ReferencedEntity | import |
ReferencedAttribute | importid |
ReferencingAttribute | importid |
ReferencingEntityNavigationPropertyName | importid |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
ImportFile_SystemUser
One-To-Many Relationship: systemuser ImportFile_SystemUser
Property | Value |
---|---|
ReferencedEntity | systemuser |
ReferencedAttribute | systemuserid |
ReferencingAttribute | recordsownerid |
ReferencingEntityNavigationPropertyName | recordsownerid_systemuser |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
ImportFile_Team
One-To-Many Relationship: team ImportFile_Team
Property | Value |
---|---|
ReferencedEntity | team |
ReferencedAttribute | teamid |
ReferencingAttribute | recordsownerid |
ReferencingEntityNavigationPropertyName | recordsownerid_team |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
ImportMap_ImportFile
One-To-Many Relationship: importmap ImportMap_ImportFile
Property | Value |
---|---|
ReferencedEntity | importmap |
ReferencedAttribute | importmapid |
ReferencingAttribute | importmapid |
ReferencingEntityNavigationPropertyName | importmapid |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
lk_importfilebase_createdby
One-To-Many Relationship: systemuser lk_importfilebase_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_importfilebase_createdonbehalfby
One-To-Many Relationship: systemuser lk_importfilebase_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_importfilebase_modifiedby
One-To-Many Relationship: systemuser lk_importfilebase_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_importfilebase_modifiedonbehalfby
One-To-Many Relationship: systemuser lk_importfilebase_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 |
owner_importfiles
One-To-Many Relationship: owner owner_importfiles
Property | Value |
---|---|
ReferencedEntity | owner |
ReferencedAttribute | ownerid |
ReferencingAttribute | ownerid |
ReferencingEntityNavigationPropertyName | ownerid |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
SystemUser_ImportFiles
One-To-Many Relationship: systemuser SystemUser_ImportFiles
Property | Value |
---|---|
ReferencedEntity | systemuser |
ReferencedAttribute | systemuserid |
ReferencingAttribute | owninguser |
ReferencingEntityNavigationPropertyName | owninguser |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
team_ImportFiles
One-To-Many Relationship: team team_ImportFiles
Property | Value |
---|---|
ReferencedEntity | team |
ReferencedAttribute | teamid |
ReferencingAttribute | owningteam |
ReferencingEntityNavigationPropertyName | owningteam |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
One-to-Many relationships
These relationships are one-to-many. Listed by SchemaName.
ImportFile_AsyncOperations
Many-To-One Relationship: asyncoperation ImportFile_AsyncOperations
Property | Value |
---|---|
ReferencingEntity | asyncoperation |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | ImportFile_AsyncOperations |
IsCustomizable | False |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
ImportFile_BulkDeleteFailures
Many-To-One Relationship: bulkdeletefailure ImportFile_BulkDeleteFailures
Property | Value |
---|---|
ReferencingEntity | bulkdeletefailure |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | ImportFile_BulkDeleteFailures |
IsCustomizable | False |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
ImportFile_ImportData
Many-To-One Relationship: importdata ImportFile_ImportData
Property | Value |
---|---|
ReferencingEntity | importdata |
ReferencingAttribute | importfileid |
ReferencedEntityNavigationPropertyName | ImportFile_ImportData |
IsCustomizable | False |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
ImportLog_ImportFile
Many-To-One Relationship: importlog ImportLog_ImportFile
Property | Value |
---|---|
ReferencingEntity | importlog |
ReferencingAttribute | importfileid |
ReferencedEntityNavigationPropertyName | ImportLog_ImportFile |
IsCustomizable | False |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
See also
Dataverse table/entity reference
Dataverse Web API Reference
importfile