Export (0) Print
Expand All

GetDistinctValuesImportFileRequest Class

Dynamics CRM 2013

Applies To: Microsoft Dynamics CRM 2013, Microsoft Dynamics CRM Online

Contains the data that is needed to retrieve distinct values from the parse table for a column in the source file that contains list values.

Namespace: Microsoft.Crm.Sdk.Messages
Assembly: Microsoft.Crm.Sdk.Proxy (in Microsoft.Crm.Sdk.Proxy.dll)

<DataContractAttribute(Namespace:="http://schemas.microsoft.com/crm/2011/Contracts")> _
Public NotInheritable Class GetDistinctValuesImportFileRequest
	Inherits OrganizationRequest

The following example shows how to use this message. For this sample to work correctly, you must be connected to the server to get an IOrganizationService interface. For the complete sample, see the link later in this topic.

' Retrieve the first two distinct values for column 1 from the parse table.
' NOTE: You must create the parse table first using the ParseImport message.
' The parse table is not accessible after ImportRecordsImportResponse is called.
Dim distinctValuesRequest As New GetDistinctValuesImportFileRequest() With
        .columnNumber = 1,
        .ImportFileId = importFileId,
        .pageNumber = 1,
        .recordsPerPage = 2
Dim distinctValuesResponse As GetDistinctValuesImportFileResponse =

' Output the distinct values.  In this case: (column 1, row 1) and (column 1, row 2).
Dim cellNum As Integer = 1
For Each cellValue As String In distinctValuesResponse.Values
    Console.WriteLine("(1, " & cellNum.ToString() & "): " & cellValue)
    cellNum += 1
Next cellValue

Message Availability

This message works regardless whether the caller is connected to the server or offline.


Pass an instance of this class to the Execute method, which returns an instance of GetDistinctValuesImportFileResponse.

Privileges and Access Rights

To perform this action, the caller must have privileges on the ImportFile entity and access rights on the record specified in the ImportFileId property. For a complete list of the required privileges, see GetDistinctValuesImportFile Privileges.

Notes for Callers

Use this message only after you have created a parse table by using the ParseImportRequest message. Do not use this message after you use the ImportRecordsImportRequest message. You cannot access the parse table after the import job submitted by the ImportRecordsRequest message has finished running.


Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows Server 2008, Windows Server 2012, Windows 7 (All Versions), Windows 8 (All Versions)

Target Platforms

Windows Server 2008, ,Windows Server 2012, ,Windows 7 (All Versions),

Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.

Community Additions

© 2014 Microsoft