Partager via

Référence d’entité/de table Import Source File (ImportFile)

  • Article

Notes

Vous n’êtes pas sûr de la table par rapport à l’entité ? Voir Développeurs : Comprendre la terminologie dans Microsoft Dataverse.

File name of file used for import.

Messages

Message Opération de l'API web Classe ou méthode SDK
Assign PATCH [org URI]/api/data/v9.0/importfiles(importfileid)
Mettre à jour la propriété ownerid.		 AssignRequest
Create POST [org URI]/api/data/v9.0/importfiles
Voir Créer		 CreateRequest ou
Create
Delete DELETE [org URI]/api/data/v9.0/importfiles(importfileid)
Voir Supprimer		 DeleteRequest ou
Delete
GetDistinctValuesImportFile GetDistinctValuesImportFile Function GetDistinctValuesImportFileRequest
GetHeaderColumnsImportFile GetHeaderColumnsImportFile Function GetHeaderColumnsImportFileRequest
GrantAccess GrantAccess Action GrantAccessRequest
ModifyAccess ModifyAccess Action ModifyAccessRequest
Retrieve GET [org URI]/api/data/v9.0/importfiles(importfileid)
Voir Récupérer		 RetrieveRequest ou
Retrieve
RetrieveMultiple GET [org URI]/api/data/v9.0/importfiles
Voir Rechercher des données		 RetrieveMultipleRequest ou
RetrieveMultiple
RetrieveParsedDataImportFile RetrieveParsedDataImportFile Function RetrieveParsedDataImportFileRequest
RetrievePrincipalAccess RetrievePrincipalAccess Function RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccess Function RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess RevokeAccess Action RevokeAccessRequest
Update PATCH [org URI]/api/data/v9.0/importfiles(importfileid)
Voir Mettre à jour		 UpdateRequest ou
Update

Propriétés

Propriété Valeur
CollectionSchemaName ImportFiles
DisplayCollectionName Imports
DisplayName Import Source File
EntitySetName importfiles
IsBPFEntity False
LogicalCollectionName importfiles
LogicalName importfile
OwnershipType UserOwned
PrimaryIdAttribute importfileid
PrimaryNameAttribute name
SchemaName ImportFile

Colonnes/Attributs inscriptibles

Ces colonnes/attributs renvoient la valeur true pour IsValidForCreate ou IsValidForUpdate (généralement les deux). Répertorié par SchemaName.

Content

Propriété Valeur
Description Stores the content of the import file, stored as comma-separated values.
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName content
MaxLength 1073741823
RequiredLevel SystemRequired
Type String

DataDelimiterCode

Propriété Valeur
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

Choix/Options DataDelimiterCode

Valeur Étiquette Description
1 DoubleQuote
2 None
3 SingleQuote

EnableDuplicateDetection

Propriété Valeur
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

Choix/Options EnableDuplicateDetection

Valeur Étiquette Description
1 Yes
0 No

Valeur par défaut : 0

EntityKeyId

Propriété Valeur
Description Unique identifier of the Alternate key Id
DisplayName Entity Key ID
IsValidForForm False
IsValidForRead True
LogicalName entitykeyid
RequiredLevel None
Type Uniqueidentifier

FieldDelimiterCode

Propriété Valeur
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

Choix/Options FieldDelimiterCode

Valeur Étiquette Description
1 Colon
2 Comma
3 Tab
4 Semicolon

FileTypeCode

Propriété Valeur
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

Choix/Options FileTypeCode

Valeur Étiquette Description
0 CSV
1 XML Spreadsheet 2003
2 Attachment
3 XLSX

ImportFileId

Propriété Valeur
Description Unique identifier of the import file.
DisplayName Import
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName importfileid
RequiredLevel SystemRequired
Type Uniqueidentifier

ImportId

Propriété Valeur
Description Choose the import job that the file was uploaded for.
DisplayName Import Job ID
IsValidForForm True
IsValidForRead True
LogicalName importid
RequiredLevel SystemRequired
Targets import
Type Lookup

ImportMapId

Propriété Valeur
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
Targets importmap
Type Lookup

IsFirstRowHeader

Propriété Valeur
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

Choix/Options IsFirstRowHeader

Valeur Étiquette Description
1 Yes
0 No

Valeur par défaut : 0

Name

Propriété Valeur
Description Shows the name of the import file. This name is based on the name of the uploaded file.
DisplayName Import Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName name
MaxLength 256
RequiredLevel None
Type String

OwnerId

Propriété Valeur
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
Targets systemuser,team
Type Owner

OwnerIdType

Propriété Valeur
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName owneridtype
RequiredLevel SystemRequired
Type EntityName

ProcessCode

Propriété Valeur
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

Choix/Options ProcessCode

Valeur Étiquette Description
1 Process
2 Ignore
3 Internal

RecordsOwnerId

Propriété Valeur
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
Targets systemuser,team
Type Lookup

RecordsOwnerIdType

Propriété Valeur
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName recordsowneridtype
RequiredLevel SystemRequired
Type EntityName

RelatedEntityColumns

Propriété Valeur
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
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName relatedentitycolumns
MaxLength 1073741823
RequiredLevel None
Type String

Size

Propriété Valeur
Description Shows the size of the import file, in kilobytes.
DisplayName Size
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
IsValidForUpdate False
LogicalName size
MaxLength 160
RequiredLevel None
Type String

Source

Propriété Valeur
Description Shows the name of the data source file uploaded in the import job.
DisplayName Source
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName source
MaxLength 256
RequiredLevel None
Type String

SourceEntityName

Propriété Valeur
Description Shows the record type (entity) of the source data.
DisplayName Source Entity
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName sourceentityname
MaxLength 160
RequiredLevel None
Type String

StateCode

Propriété Valeur
Description Shows the status of the import file record. By default, all records are active and can't be deactivated.
DisplayName Status
IsValidForCreate False
IsValidForForm True
IsValidForRead True
LogicalName statecode
RequiredLevel SystemRequired
Type State

Choix/Options StateCode

Valeur Étiquette Statut par défaut Nom invariant
0 Active 0 Active

StatusCode

Propriété Valeur
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

Choix/Options StatusCode

Valeur Étiquette État
0 Submitted 0
1 Parsing 0
2 Transforming 0
3 Importing 0
4 Completed 0
5 Failed 0

TargetEntityName

Propriété Valeur
Description Select the target record type (entity) for the records that will be created during the import job.
DisplayName Target Entity
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName targetentityname
MaxLength 160
RequiredLevel None
Type String

TimeZoneRuleVersionNumber

Propriété Valeur
Description For internal use only.
DisplayName
Format None
IsValidForForm False
IsValidForRead True
LogicalName timezoneruleversionnumber
MaxValue 2147483647
MinValue -1
RequiredLevel None
Type Integer

UpsertModeCode

Propriété Valeur
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

Choix/Options UpsertModeCode

Valeur Étiquette Description
0 Create
1 Update
2 Ignore

UseSystemMap

Propriété Valeur
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

Choix/Options UseSystemMap

Valeur Étiquette Description
1 Yes
0 No

Valeur par défaut : 0

UTCConversionTimeZoneCode

Propriété Valeur
Description Time zone code that was in use when the record was created.
DisplayName
Format None
IsValidForForm False
IsValidForRead True
LogicalName utcconversiontimezonecode
MaxValue 2147483647
MinValue -1
RequiredLevel None
Type Integer

Colonnes/Attributs en lecture seule

Ces colonnes/attributs renvoient la valeur false pour IsValidForCreate ou IsValidForUpdate. Répertorié par SchemaName.

AdditionalHeaderRow

Propriété Valeur
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
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName additionalheaderrow
MaxLength 100000
RequiredLevel None
Type String

CompletedOn

Propriété Valeur
DateTimeBehavior UserLocal
Description Shows the date and time when the import associated with the import file was completed.
DisplayName Completed On
Format DateOnly
IsValidForForm False
IsValidForRead True
LogicalName completedon
RequiredLevel None
Type DateTime

CreatedBy

Propriété Valeur
Description Shows who created the record.
DisplayName Created By
IsValidForForm False
IsValidForRead True
LogicalName createdby
RequiredLevel None
Targets systemuser
Type Lookup

CreatedByName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyname
MaxLength 100
RequiredLevel None
Type String

CreatedByYomiName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyyominame
MaxLength 100
RequiredLevel None
Type String

CreatedOn

Propriété Valeur
DateTimeBehavior UserLocal
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
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName createdon
RequiredLevel None
Type DateTime

CreatedOnBehalfBy

Propriété Valeur
Description Shows who created the record on behalf of another user.
DisplayName Created By (Delegate)
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfby
RequiredLevel None
Targets systemuser
Type Lookup

CreatedOnBehalfByName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

CreatedOnBehalfByYomiName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

FailureCount

Propriété Valeur
Description Shows the number of records in the import file that cannot be imported.
DisplayName Errors
Format None
IsValidForForm True
IsValidForRead True
LogicalName failurecount
MaxValue 1000000000
MinValue 0
RequiredLevel None
Type Integer

HeaderRow

Propriété Valeur
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
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName headerrow
MaxLength 1073741823
RequiredLevel None
Type String

ImportIdName

Propriété Valeur
Description Name of the import.
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName importidname
MaxLength 100
RequiredLevel SystemRequired
Type String

ImportMapIdName

Propriété Valeur
Description Name of the import map.
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName importmapidname
MaxLength 100
RequiredLevel SystemRequired
Type String

ModifiedBy

Propriété Valeur
Description Shows who last updated the record.
DisplayName Modified By
IsValidForForm False
IsValidForRead True
LogicalName modifiedby
RequiredLevel None
Targets systemuser
Type Lookup

ModifiedByName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedByYomiName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyyominame
MaxLength 100
RequiredLevel None
Type String

ModifiedOn

Propriété Valeur
DateTimeBehavior UserLocal
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
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel SystemRequired
Type DateTime

ModifiedOnBehalfBy

Propriété Valeur
Description Shows who created the record on behalf of another user.
DisplayName Modified By (Delegate)
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfby
RequiredLevel None
Targets systemuser
Type Lookup

ModifiedOnBehalfByName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedOnBehalfByYomiName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

OwnerIdName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName owneridname
MaxLength 100
RequiredLevel SystemRequired
Type String

OwnerIdYomiName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName owneridyominame
MaxLength 100
RequiredLevel SystemRequired
Type String

OwningBusinessUnit

Propriété Valeur
Description Shows the business unit that the record owner belongs to.
DisplayName
IsValidForForm True
IsValidForRead True
LogicalName owningbusinessunit
RequiredLevel None
Targets businessunit
Type Lookup

OwningBusinessUnitName

Propriété Valeur
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName owningbusinessunitname
MaxLength 160
RequiredLevel None
Type String

OwningTeam

Propriété Valeur
Description Unique identifier of the team who owns the import file.
DisplayName Owning Team
IsValidForForm False
IsValidForRead True
LogicalName owningteam
RequiredLevel None
Targets team
Type Lookup

OwningUser

Propriété Valeur
Description Unique identifier of the user who owns the import file.
DisplayName Owning User
IsValidForForm False
IsValidForRead True
LogicalName owninguser
RequiredLevel None
Targets systemuser
Type Lookup

ParsedTableColumnPrefix

Propriété Valeur
Description Shows the prefix applied to each column after the import file is parsed.
DisplayName Parse Table Column Prefix
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName parsedtablecolumnprefix
MaxLength 160
RequiredLevel None
Type String

ParsedTableColumnsNumber

Propriété Valeur
Description Shows the number of columns included in the parsed import file.
DisplayName Parse Table Column Number
Format None
IsValidForForm False
IsValidForRead True
LogicalName parsedtablecolumnsnumber
MaxValue 2147483647
MinValue -2147483648
RequiredLevel None
Type Integer

ParsedTableName

Propriété Valeur
Description Shows the name of the table that contains the parsed data from the import file.
DisplayName Parse Table
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName parsedtablename
MaxLength 160
RequiredLevel None
Type String

PartialFailureCount

Propriété Valeur
Description Shows the number of records in this file that had failures during the import.
DisplayName Partial Failures
Format None
IsValidForForm True
IsValidForRead True
LogicalName partialfailurecount
MaxValue 1000000000
MinValue 0
RequiredLevel None
Type Integer

ProcessingStatus

Propriété Valeur
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

Choix/Options ProcessingStatus

Valeur Étiquette Description
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

Propriété Valeur
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
Format None
IsValidForForm False
IsValidForRead True
LogicalName progresscounter
MaxValue 2147483647
MinValue 0
RequiredLevel None
Type Integer

RecordsOwnerIdName

Propriété Valeur
Description Name of the record owner.
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName recordsowneridname
MaxLength 160
RequiredLevel None
Type String

SuccessCount

Propriété Valeur
Description Shows the number of records in the import file that are imported successfully.
DisplayName Successes
Format None
IsValidForForm True
IsValidForRead True
LogicalName successcount
MaxValue 1000000000
MinValue 0
RequiredLevel None
Type Integer

TotalCount

Propriété Valeur
Description Shows the total number of records in the import file.
DisplayName Total Processed
Format None
IsValidForForm True
IsValidForRead True
LogicalName totalcount
MaxValue 1000000000
MinValue 0
RequiredLevel None
Type Integer

Relations un-à-plusieurs

Répertorié par SchemaName.

ImportFile_BulkDeleteFailures

Identique à la relation plusieurs à un ImportFile_BulkDeleteFailures pour la table/entité bulkdeletefailure.

Propriété Valeur
ReferencingEntity bulkdeletefailure
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName ImportFile_BulkDeleteFailures
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

ImportLog_ImportFile

Identique à la relation plusieurs à un ImportLog_ImportFile pour la table/entité importlog.

Propriété Valeur
ReferencingEntity importlog
ReferencingAttribute importfileid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName ImportLog_ImportFile
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

ImportFile_AsyncOperations

Identique à la relation plusieurs à un ImportFile_AsyncOperations pour la table/entité asyncoperation.

Propriété Valeur
ReferencingEntity asyncoperation
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName ImportFile_AsyncOperations
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Relations plusieurs-à-un

Chaque relation plusieurs-à-un est définie par une relation un-à-plusieurs correspondante avec la table associée. Répertorié par SchemaName.

lk_importfilebase_createdby

Voir la relation un à plusieurs lk_importfilebase_createdby pour la table/entité systemuser.

lk_importfilebase_createdonbehalfby

Voir la relation un à plusieurs lk_importfilebase_createdonbehalfby pour la table/entité systemuser.

team_ImportFiles

Voir la relation un à plusieurs team_ImportFiles pour la table/entité team.

ImportFile_Team

Voir la relation un à plusieurs ImportFile_Team pour la table/entité team.

ImportFile_SystemUser

Voir la relation un à plusieurs ImportFile_SystemUser pour la table/entité systemuser.

SystemUser_ImportFiles

Voir la relation un à plusieurs SystemUser_ImportFiles pour la table/entité systemuser.

lk_importfilebase_modifiedonbehalfby

Voir la relation un à plusieurs lk_importfilebase_modifiedonbehalfby pour la table/entité systemuser.

Import_ImportFile

Voir la relation un à plusieurs Import_ImportFile pour la table/entité import.

ImportMap_ImportFile

Voir la relation un à plusieurs ImportMap_ImportFile pour la table/entité importmap.

lk_importfilebase_modifiedby

Voir la relation un à plusieurs lk_importfilebase_modifiedby pour la table/entité systemuser.

BusinessUnit_ImportFiles

Voir la relation un à plusieurs BusinessUnit_ImportFiles pour la table/entité businessunit.

Voir aussi

Référence d’entité/de table Dataverse Référence d’API web importfile EntityType