Import Source File (ImportFile) テーブル/エンティティの参照

  • [アーティクル]

注意

テーブルとエンティティの違いについて不明な点がありますか? 開発者: Microsoft Dataverse の用語を理解するを参照してください。

File name of file used for import.

メッセージ

メッセージ Web API 操作 SDK クラスまたはメソッド
Assign PATCH [org URI]/api/data/v9.0/importfiles(importfileid)
owneridのプロパティを更新する。		 AssignRequest
Create POST [org URI]/api/data/v9.0/importfiles
作成を参照		 CreateRequest または
Create
Delete DELETE [org URI]/api/data/v9.0/importfiles(importfileid)
削除を参照		 DeleteRequest または
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)
取得を参照		 RetrieveRequest または
Retrieve
RetrieveMultiple GET [org URI]/api/data/v9.0/importfiles
データのクエリを参照		 RetrieveMultipleRequest または
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)
更新を参照		 UpdateRequest または
Update

プロパティ

プロパティ 値
CollectionSchemaName ImportFiles
DisplayCollectionName Imports
DisplayName Import Source File
EntitySetName importfiles
IsBPFEntity False
LogicalCollectionName importfiles
LogicalName importfile
OwnershipType UserOwned
PrimaryIdAttribute importfileid
PrimaryNameAttribute name
SchemaName ImportFile

書き込み可能な列/属性

これらの列/属性は IsValidForCreate または IsValidForUpdate のいずれかについて true を返します (通常は両方)。 SchemaName が一覧表示。

Content

プロパティ 値
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

プロパティ 値
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

DataDelimiterCode の選択肢/オプション

値 ラベル 内容
1 DoubleQuote
2 None
3 SingleQuote

EnableDuplicateDetection

プロパティ 値
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

EnableDuplicateDetection の選択肢/オプション

値 ラベル 内容
1 Yes
0 No

既定値 : 0

EntityKeyId

プロパティ 値
Description Unique identifier of the Alternate key Id
DisplayName Entity Key ID
IsValidForForm False
IsValidForRead True
LogicalName entitykeyid
RequiredLevel None
Type Uniqueidentifier

FieldDelimiterCode

プロパティ 値
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

FieldDelimiterCode の選択肢/オプション

値 ラベル 内容
1 Colon
2 Comma
3 Tab
4 Semicolon

FileTypeCode

プロパティ 値
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

FileTypeCode の選択肢/オプション

値 ラベル 内容
0 CSV
1 XML Spreadsheet 2003
2 Attachment
3 XLSX

ImportFileId

プロパティ 値
Description Unique identifier of the import file.
DisplayName Import
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName importfileid
RequiredLevel SystemRequired
Type Uniqueidentifier

ImportId

プロパティ 値
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

プロパティ 値
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

プロパティ 値
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

IsFirstRowHeader の選択肢/オプション

値 ラベル 内容
1 Yes
0 No

既定値 : 0

Name

プロパティ 値
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

プロパティ 値
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

プロパティ 値
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName owneridtype
RequiredLevel SystemRequired
Type EntityName

ProcessCode

プロパティ 値
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

ProcessCode の選択肢/オプション

値 ラベル 内容
1 Process
2 Ignore
3 Internal

RecordsOwnerId

プロパティ 値
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

プロパティ 値
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName recordsowneridtype
RequiredLevel SystemRequired
Type EntityName

RelatedEntityColumns

プロパティ 値
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

プロパティ 値
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

プロパティ 値
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

プロパティ 値
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

プロパティ 値
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

StateCode の選択肢/オプション

値 ラベル 既定の状態 不変名
0 Active 0 Active

StatusCode

プロパティ 値
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

StatusCode の選択肢/オプション

値 ラベル 状態
0 Submitted 0
1 Parsing 0
2 Transforming 0
3 Importing 0
4 Completed 0
5 Failed 0

TargetEntityName

プロパティ 値
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

プロパティ 値
Description For internal use only.
DisplayName
Format None
IsValidForForm False
IsValidForRead True
LogicalName timezoneruleversionnumber
MaxValue 2147483647
MinValue -1
RequiredLevel None
Type Integer

UpsertModeCode

プロパティ 値
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

UpsertModeCode の選択肢/オプション

値 ラベル 内容
0 Create
1 Update
2 Ignore

UseSystemMap

プロパティ 値
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

UseSystemMap の選択肢/オプション

値 ラベル 内容
1 Yes
0 No

既定値 : 0

UTCConversionTimeZoneCode

プロパティ 値
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

読み取り専用列/属性

これらの列/属性は IsValidForCreate または IsValidForUpdate の両方について false を返します。 SchemaName が一覧表示。

AdditionalHeaderRow

プロパティ 値
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

プロパティ 値
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

プロパティ 値
Description Shows who created the record.
DisplayName Created By
IsValidForForm False
IsValidForRead True
LogicalName createdby
RequiredLevel None
Targets systemuser
Type Lookup

CreatedByName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyname
MaxLength 100
RequiredLevel None
Type String

CreatedByYomiName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyyominame
MaxLength 100
RequiredLevel None
Type String

CreatedOn

プロパティ 値
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

プロパティ 値
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

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

CreatedOnBehalfByYomiName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

FailureCount

プロパティ 値
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

プロパティ 値
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

プロパティ 値
Description Name of the import.
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName importidname
MaxLength 100
RequiredLevel SystemRequired
Type String

ImportMapIdName

プロパティ 値
Description Name of the import map.
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName importmapidname
MaxLength 100
RequiredLevel SystemRequired
Type String

ModifiedBy

プロパティ 値
Description Shows who last updated the record.
DisplayName Modified By
IsValidForForm False
IsValidForRead True
LogicalName modifiedby
RequiredLevel None
Targets systemuser
Type Lookup

ModifiedByName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedByYomiName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyyominame
MaxLength 100
RequiredLevel None
Type String

ModifiedOn

プロパティ 値
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

プロパティ 値
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

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedOnBehalfByYomiName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

OwnerIdName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName owneridname
MaxLength 100
RequiredLevel SystemRequired
Type String

OwnerIdYomiName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName owneridyominame
MaxLength 100
RequiredLevel SystemRequired
Type String

OwningBusinessUnit

プロパティ 値
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

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName owningbusinessunitname
MaxLength 160
RequiredLevel None
Type String

OwningTeam

プロパティ 値
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

プロパティ 値
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

プロパティ 値
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

プロパティ 値
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

プロパティ 値
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

プロパティ 値
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

プロパティ 値
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

ProcessingStatus の選択肢/オプション

値 ラベル 内容
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

プロパティ 値
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

プロパティ 値
Description Name of the record owner.
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName recordsowneridname
MaxLength 160
RequiredLevel None
Type String

SuccessCount

プロパティ 値
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

プロパティ 値
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

一対多関連付け

SchemaName が一覧表示。

ImportFile_BulkDeleteFailures

bulkdeletefailure テーブル/エンティティの多対一のリレーションシップ ImportFile_BulkDeleteFailures と同じです。

プロパティ 値
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

importlog テーブル/エンティティの多対一のリレーションシップ ImportLog_ImportFile と同じです。

プロパティ 値
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

asyncoperation テーブル/エンティティの多対一のリレーションシップ ImportFile_AsyncOperations と同じです。

プロパティ 値
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

多対一関連付け

各多対一の関係付けは、関連するテーブルとの対応する一対多の関係付けによって定義されます。 SchemaName が一覧表示。

lk_importfilebase_createdby

systemuser テーブル/エンティティの一対多のリレーションシップ lk_importfilebase_createdby を参照してください。

lk_importfilebase_createdonbehalfby

systemuser テーブル/エンティティの一対多のリレーションシップ lk_importfilebase_createdonbehalfby を参照してください。

team_ImportFiles

team テーブル/エンティティの一対多のリレーションシップ team_ImportFiles を参照してください。

ImportFile_Team

team テーブル/エンティティの一対多のリレーションシップ ImportFile_Team を参照してください。

ImportFile_SystemUser

systemuser テーブル/エンティティの一対多のリレーションシップ ImportFile_SystemUser を参照してください。

SystemUser_ImportFiles

systemuser テーブル/エンティティの一対多のリレーションシップ SystemUser_ImportFiles を参照してください。

lk_importfilebase_modifiedonbehalfby

systemuser テーブル/エンティティの一対多のリレーションシップ lk_importfilebase_modifiedonbehalfby を参照してください。

Import_ImportFile

import テーブル/エンティティの一対多のリレーションシップ Import_ImportFile を参照してください。

ImportMap_ImportFile

importmap テーブル/エンティティの一対多のリレーションシップ ImportMap_ImportFile を参照してください。

lk_importfilebase_modifiedby

systemuser テーブル/エンティティの一対多のリレーションシップ lk_importfilebase_modifiedby を参照してください。

BusinessUnit_ImportFiles

businessunit テーブル/エンティティの一対多のリレーションシップ BusinessUnit_ImportFiles を参照してください。

関連項目

Dataverse テーブル/エンティティ参照 Web API リファレンス importfile EntityType