Load Import Records Service - Inputs

The table provides mandatory inputs for this web service.

Input Description
User name The login ID of the user
Password The password for the specified user name
Enterprise The name of the enterprise
execmode

(Mandatory)

Specify the execution mode. The valid values are ASYNCHR or SYNCHR.
Repository

(Mandatory)

The name of the repository. Specify any existing repository name.
InputMapName

(Mandatory)

The name of an input map for importing data.

Any existing input map within the specified repository.

FileName The name of the data source file. You can attach the file using SOAP UI. The filename must contain the .csv or .txt extension.

Optional for SQL data sources, otherwise mandatory.

BinaryData When you create a new request using SOAP UI, the value for the <BinaryData> parameter is automatically created. This is a unique value for every request, and if the request contains an attachment, specifying the binary data parameter is mandatory.
Along with these inputs, you can specify the ValidateOnly and ConfirmImmediately context variables. The following example denotes the use of ValidateOnly context variable to validate records that are being imported. For example, 
<ns:LoadImportActionRequest>
         <ns:UserInfo>
            <ns:UserName>a</ns:UserName>
            <ns:Password>a</ns:Password>
             <ns:Enterprise>mjk</ns:Enterprise>
         </ns:UserInfo>
          <ns:Context>
            <ns:Parameter name="ValidateOnly">true</ns:Parameter>
         </ns:Context>
         <ns:Import execmode="ASYNCHR">
            <ns:Repository>TEST_IMPORT</ns:Repository>
            <ns:InputMapName>IM1_DIRECTLOAD</ns:InputMapName>
            <ns:DatasourceFile>
               <ns:FileName>ds1.txt</ns:FileName>
               <ns:BinaryData>cid:797439351432</ns:BinaryData>
            </ns:DatasourceFile>
         </ns:Import>

The following example denotes the use of Export zip for Data Transfer 

<ns:LoadImportActionRequest>
         <ns:UserInfo>
            <ns:UserName>admin</ns:UserName>
            <ns:Password>admin</ns:Password>
            <ns:Enterprise>target</ns:Enterprise>
         </ns:UserInfo>
         <ns:Context>
         </ns:Context>
         <ns:ImportArchive>
            <ns:ExportArchive>
               <ns:FileName>Export_2016-03-16-18-51-45.zip</ns:FileName>
               <ns:BinaryData>cid:110218116024</ns:BinaryData>
            </ns:ExportArchive>
         </ns:ImportArchive>
      </ns:LoadImportActionRequest>
For more information on the ValidateOnly and ConfirmImmediately parameters, refer to TIBCO MDM User's Guide.