SubmitCsvExposureExport Method

Submits a request to export Touchstone® exposure data to comma-separated values (CSV) format.

Syntax

Visual Basic (Declaration)
Visual Basic (Usage)
C#

Public Function SubmitCsvExposureExport( _
   ByVal request As SubmitCsvExposureExportRequest _
) As SubmitCsvExposureExportResponse

Dim instance As DataExportServiceClient
Dim request As SubmitCsvExposureExportRequest
Dim value As SubmitCsvExposureExportResponse
 
value = instance.SubmitCsvExposureExport(request)

public SubmitCsvExposureExportResponse SubmitCsvExposureExport( 
   SubmitCsvExposureExportRequest request
)

Parameters

request: Contains a SubmitCsvExposureExportRequest that identifies the CSV Export Options that specify which exposure data you want to export and the folder and file to which you want to export this data, along with the associated Business Unit SID and SQL Instance SID.

Return Value

A SubmitCsvExposureExportResponse containing the Activity SID that uniquely identifies the asynchronous web service call that you made to submit the specified exposure data export request.

Remarks

To find the Business Unit SID to pass into this method, call the GetBusinessUnits() method.

To find the SQL Instance SID to pass into this method, call the GetSqlInstances() method.

Example

The following example shows how to submit a request to export Touchstone exposure data to CSV format using the SubmitCsvExposureExport() method:

using System;
using AIR.Services.Common.Data;
using AIR.Services.ExposureManagement.Api;
using AIR.Services.DataExport.Api;
            
class SnippetSubmitCsvExposureExportRequest
{
    private static void SubmitCsvExposureExport(int businessUnitSid, int sqlInstanceSid, int exposureViewSid, 
                                                string destinationPath, string destinationFileBaseName)
    {
        DataExportServiceClient client = new DataExportServiceClient();
            
        SubmitCsvExposureExportRequest request = new SubmitCsvExposureExportRequest();
        request.BusinessUnitSid = businessUnitSid;
        request.SqlInstanceSid = sqlInstanceSid;
        request.ExposureExportOptionsCsv = new AIR.Services.DataExport.Data.ExportOptionsCsv
        {
            TargetSid = exposureViewSid,
            ExportContractData = true,
            ExportLocationData = true,
            ExportReinsuranceData = true,
            DestinationFolder = destinationPath,
            DestinationFileNameBase = destinationFileBaseName,
        };
            
        SubmitCsvExposureExportResponse response = client.SubmitCsvExposureExport(request);
            
        if (response.Status.Code == StatusCode.Success)
        {
            Console.WriteLine("Request successfully Submitted with Activity SID: " + response.ActivitySid);
        }
    }
}

Requirements

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

Reference

DataExportServiceClient Class
DataExportServiceClient Members