Touchstone 11.0 API Reference
SubmitImportCsvWithAutomapRequest XML
Reference > Requests as XML > Requests > Data Import > SubmitImportCsvWithAutomapRequest XML
SubmitImportCsvWithAutomapRequest
Copy Code
<SubmitImportCsvWithAutomapRequest xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="AIR.Services.DataImport.Api">
    <BusinessUnitSid xmlns="AIR.Services.Common.Api">1</BusinessUnitSid>
    <LicenseUid xmlns="AIR.Services.Common.Api">00000000-0000-0000-0000-000000000000</LicenseUid>
    <Product xmlns="AIR.Services.Common.Api"/>
    <RequestUid xmlns="AIR.Services.Common.Api">00000000-0000-0000-0000-000000000000</RequestUid>
    <SqlInstanceSid xmlns="AIR.Services.Common.Api">1</SqlInstanceSid>
    <ImportOptions xmlns:d2p1="AIR.Services.DataImport.Data">
        <d2p1:AutoExposureViewOptions i:nil="true" />
        <d2p1:Currency>USD</d2p1:Currency>
        <d2p1:CurrencyExchangeRateSid>3</d2p1:CurrencyExchangeRateSid>
        <d2p1:DestinationDatabase>MSA_DB</d2p1:DestinationDatabase>
        <d2p1:DestinationExposureSetName>MSA_ES_637104527462439329</d2p1:DestinationExposureSetName>
        <d2p1:DestinationServer>Server_name</d2p1:DestinationServer>
        <d2p1:Geocoder>AIRGeocoder</d2p1:Geocoder>
        <d2p1:ImportFileCleanup i:nil="true" />
        <d2p1:JobPriority>Normal</d2p1:JobPriority>
        <d2p1:JobScheduledTime i:nil="true" />
        <d2p1:MaximumCores>4</d2p1:MaximumCores>
        <d2p1:MinimumCores>1</d2p1:MinimumCores>
        <d2p1:PreserveGeocode>true</d2p1:PreserveGeocode>
        <d2p1:ProjectCurrency>USD</d2p1:ProjectCurrency>
        <d2p1:ProjectCurrencyExchangeRateSid>3</d2p1:ProjectCurrencyExchangeRateSid>
        <d2p1:ShowDecommissionPlatform>false</d2p1:ShowDecommissionPlatform>
        <d2p1:DataSourceSid>58</d2p1:DataSourceSid>
        <d2p1:DateTimeFormat></d2p1:DateTimeFormat>
        <d2p1:DuplicateContractBehaviour>SkipAndRaiseError</d2p1:DuplicateContractBehaviour>
        <d2p1:ExposureSetSid>63</d2p1:ExposureSetSid>
        <d2p1:FailureThreshold>None</d2p1:FailureThreshold>
        <d2p1:SkipBadContracts>false</d2p1:SkipBadContracts>
        <d2p1:SkipBadLocations>true</d2p1:SkipBadLocations>
        <d2p1:VerifyJobName i:nil="true" />
        <d2p1:VerifyOnly>false</d2p1:VerifyOnly>
        <d2p1:Delimiter>44</d2p1:Delimiter>
        <d2p1:TextQualifier>DoubleQuote</d2p1:TextQualifier>
        <d2p1:ContractId i:nil="true" />
        <d2p1:ContractSID>0</d2p1:ContractSID>
        <d2p1:ContractsFilePath>\\[host-name]\[share-name]\Contract_ProvideName_target.csv</d2p1:ContractsFilePath>
        <d2p1:DefaultValuesSid>0</d2p1:DefaultValuesSid>
        <d2p1:HasHeaders>true</d2p1:HasHeaders>
        <d2p1:LineOfBusiness i:nil="true" />
        <d2p1:LocationsFilePath>\\[host-name]\[share-name]\Location_ProvideName_target.csv</d2p1:LocationsFilePath>
        <d2p1:LocationsWCFilePath i:nil="true" />
        <d2p1:MappingSetSid>0</d2p1:MappingSetSid>
        <d2p1:MappingSetXML></d2p1:MappingSetXML>
        <d2p1:ReinsuranceFilePath i:nil="true" />
        <d2p1:Sorted>false</d2p1:Sorted>
        <d2p1:SourceContractsFilePath>\\[host-name]\[share-name]\Contract_ProvideName_target.csv</d2p1:SourceContractsFilePath>
        <d2p1:SourceLocationsFilePath>\\[host-name]\[share-name]\Location_ProvideName_target.csv</d2p1:SourceLocationsFilePath>
        <d2p1:SourceLocationsWCFilePath i:nil="true" />
        <d2p1:SourceReinsurancesFilePath i:nil="true" />
        <d2p1:SourceStepFunctionsFilePath i:nil="true" />
        <d2p1:StepFunctionFilePath i:nil="true" />
    </ImportOptions>
    <MappingOptions xmlns:d2p1="AIR.Services.DataImport.MappingSetManagement.Data">
        <d2p1:ContractExcludedColumnNames xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
            <d3p1:string>UserDefined Field 1 (UDF 1)</d3p1:string>
            <d3p1:string>UserDefined Field 2 (UDF 2)</d3p1:string>
            <d3p1:string>UserDefined Field 3 (UDF 3)</d3p1:string>
            <d3p1:string>UserDefined Field 4 (UDF 4)</d3p1:string>
            <d3p1:string>UserDefined Field 5 (UDF 5)</d3p1:string>
        </d2p1:ContractExcludedColumnNames>
        <d2p1:ContractType>PrimaryProperty</d2p1:ContractType>
        <d2p1:DefaultsXML i:nil="true" />
        <d2p1:Delimiter>44</d2p1:Delimiter>
        <d2p1:FailedOnUnmappedColumns>false</d2p1:FailedOnUnmappedColumns>
        <d2p1:LocationExcludedColumnNames xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
            <d3p1:string>ConstructionCodeType</d3p1:string>
            <d3p1:string>OccupancyCodeType</d3p1:string>
        </d2p1:LocationExcludedColumnNames>
        <d2p1:MappingSetName>MSA_162316</d2p1:MappingSetName>
        <d2p1:ReinsuranceExcludedColumnNames xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
            <d3p1:string>ReinsuranceType</d3p1:string>
            <d3p1:string>CedePercentage</d3p1:string>
        </d2p1:ReinsuranceExcludedColumnNames>
        <d2p1:StepFuctionExcludedColumnNames xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
            <d3p1:string>Name</d3p1:string>
            <d3p1:string>Perils</d3p1:string>
        </d2p1:StepFuctionExcludedColumnNames>
        <d2p1:TextQualifier>DoubleQuote</d2p1:TextQualifier>
    </MappingOptions>
</SubmitImportCsvWithAutomapRequest>