Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Parsing Source Data

banner art

[Applies to: Microsoft Dynamics CRM 4.0]

Find the latest SDK documentation: CRM 2015 SDK

Parsing of the source data includes parsing of all import files associated with a particular import (data import).

Parsed data is stored in the temporary parse tables that are created for every import file. The name of the parse table is stored in the importfile.parsedtablename property. The source file column headings are specified in the importfile.headerrow property. If the source file does not include a first row that contains the column headings, this property specifies the system-generated default column headings.

Save parsed data in the parse table by using the ParseImport message. Retrieve data from the parse table by using the GetDistinctValuesImportFile message and the RetrieveParsedDataImportFile message.

To parse the import files and retrieve the parsed data from the parse tables, use the messages listed in the following table.

MessageDescription
ParseImportUse this message to submit an asynchronous job that parses all import files associated with the specified import (data import).

Pass a unique identifier of the associated import (data import) in the ImportId property of this request.

A unique identifier of the asynchronous job that runs in the background and performs parsing of data is returned in the AsyncOperationId property of the message response.

GetDistinctValuesImportFileUse this message to return distinct values for a column in the source file that contains list values.

Pass a unique identifier of associated import file in the ImportFileId property of this request.

The distinct values are returned in an array of strings, in the Values property of the message response.

Use this message only after you have created a parse table by using the ParseImport message.

Do not use this message after you use the ImportRecordsImport message. You cannot access the parse table after the import job submitted by the ImportRecordsMessage message has finished running.

RetrieveParsedDataImportFileUse this message to retrieve the data from the parse table.

Pass a unique identifier of the associated import file in the ImportFileId property of this request.

The parsed data is returned in a two-dimensional array of strings in the Values property of the message response. The data is returned with the same column order as the column order in the source file.

Use this message only after you have created a parse table by using the ParseImport message.

Do not use this message after you use the ImportRecordsImport message. You cannot access the parse table after the import job submitted by the ImportRecordsMessage message has finished running.


See Also

Other Resources


© 2010 Microsoft Corporation. All rights reserved.


Show:
© 2015 Microsoft