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> |