Retrieves a list of all existing Touchstone®
Mapping Sets for a given
Business Unit and
SQL Server Instance.
You create Mapping sets in the Touchstone application, and these Mapping Sets are required for importing comma separated values (CSV) data files into Touchstone using AIR ImportExpress™.
Public Function GetMappingSets( _
ByVal As GetMappingSetsRequest _
) As GetMappingSetsResponse
Dim instance As MappingSetManagementServiceClient
Dim request As GetMappingSetsRequest
Dim value As GetMappingSetsResponse
value = instance.GetMappingSets(request)
public GetMappingSetsResponse GetMappingSets(
GetMappingSetsRequest
)
Parameters
- request
- Contains a GetMappingSetsRequest that identifies the Touchstone-generated Business Unit Sequential Identifier (SID) and SQL Instance SID associated with the list of Mapping Sets that you want to retrieve.
Return Value
A GetMappingSetsResponse containing a list of Mapping Sets in the specified SQL Server Instance in the specified Business Unit.
The following example shows how to retrieve a list of all Touchstone Mapping Sets for a given Business Unit and SQL Server Instance using the
GetMappingSets() method:
using System;
using AIR.Services.Common.Data;
using AIR.Services.DataImport.MappingSetManagement.Api;
using AIR.Services.DataImport.MappingSetManagement.Data;
class SnippetGetMappingSetsRequest
{
private static void GetMappingSets(int businessUnitSid, int sqlInstanceSid)
{
MappingSetManagementServiceClient mappingClient = new MappingSetManagementServiceClient();
GetMappingSetsRequest request = new GetMappingSetsRequest();
request.BusinessUnitSid = businessUnitSid;
request.SqlInstanceSid = sqlInstanceSid;
GetMappingSetsResponse response = mappingClient.GetMappingSets(request);
if (response.Status.Code == StatusCode.Success)
{
foreach (MappingSetSummary mappingSet in response.MappingSetSummaries)
{
Console.WriteLine("SID: " + mappingSet.MappingSetSid);
Console.WriteLine("Name: " + mappingSet.Name);
}
}
}
}
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
