Tableau Connector for Microsoft Dynamics CRM

Build 24.0.9060

ImportFile

This is a table representing the ImportFile entities in Dynamics CRM.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the import file.

AdditionalHeaderRow String True

System generated heading row used for processing transformations.

CompletedOn Datetime True

Date and time when the import was completed for this import file.

Content String False

Content of the import file.

CreatedBy_Id String True

Unique identifier of the user who created the import file record.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the import file was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the import file.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

DataDelimiterCode String False

Single character data delimiter used in the import file.

EnableDuplicateDetection Boolean False

Information about whether duplicate detection is enabled.

FailureCount Integer True

Number of records in this file that could not be imported.

FieldDelimiterCode String False

Single character field delimiter used in the import file.

FileTypeCode String False

File type of the uploaded source file

HeaderRow String True

Header row of the import file.

ImportFileId String False

Unique identifier of the import file.

ImportId_Id String False

Unique identifier of the import job for this import file.

ImportId_LogicalName String False

ImportId_Name String False

ImportMapId_Id String False

Unique identifier of the associated data map.

ImportMapId_LogicalName String False

ImportMapId_Name String False

IsFirstRowHeader Boolean False

Information about whether the first row contains column headings.

ModifiedBy_Id String True

Unique identifier of the user who last modified the import file.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the import file was last modified.

ModifiedOnBehalfBy_Id String True

Unique identifier of the delegate user who last modified the importfile.

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

Name String False

Name of the import file.

OwnerId_Id String False

Unique identifier of the user or team who owns the import file.

OwnerId_LogicalName String False

OwnerId_Name String False

OwningBusinessUnit_Id String True

Business unit that owns the import file.

OwningBusinessUnit_LogicalName String True

OwningBusinessUnit_Name String True

OwningTeam_Id String True

Unique identifier of the team who owns the import file.

OwningTeam_LogicalName String True

OwningTeam_Name String True

OwningUser_Id String True

Unique identifier of the user who owns the import file.

OwningUser_LogicalName String True

OwningUser_Name String True

ParsedTableColumnPrefix String True

Prefix of the column in the parsed table.

ParsedTableColumnsNumber Integer True

Total number of columns present in the parsed table.

ParsedTableName String True

Name of the table that contains the parsed data of the import file.

PartialFailureCount Integer True

Number of records in this file that had failures in updating.

ProcessCode String False

Information about whether the import file needs to be processed.

ProcessingStatus String True

Detailed status showing how much the import file has been processed.

ProgressCounter Integer True

Indicates how much of a particular operation has been completed. Used when resuming a paused import job.

RecordsOwnerId_Id String False

Unique identifier of the owner to whom records imported from this file are assigned.

RecordsOwnerId_LogicalName String False

RecordsOwnerId_Name String False

RelatedEntityColumns String False

Related Entity Columns

Size String False

Size of the import file.

Source String False

Source of the import file.

SourceEntityName String False

Name of the source entity.

StateCode String True

Status of the import file.

StatusCode String False

Reason for the status of the import file.

SuccessCount Integer True

Number of records in this file that were imported successfully.

TargetEntityName String False

Name of the Microsoft Dynamics CRM entity.

TimeZoneRuleVersionNumber Integer False

For internal use only.

TotalCount Integer True

Number of records processed in this file.

UseSystemMap Boolean False

Information about whether to use the system map.

UTCConversionTimeZoneCode Integer False

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060