Warehouse Close Lot - UPSERT Mode of Data Loading

The UPSERT mode is used if the element Batch Key (warehouseTransaction/batchKey element) is not present or null in the incoming EagleML message. For the single row mode the warehouseTransaction node can contains only one warehouseCloseLot complex element.

The set of values – key of record:

Security Alias + Source Name + Entity Id + Master Ticket Number + Close Open Event Id

Available examples:

• Warehouse Close Lot - UPSERT Mode, Insert Data Example
• Warehouse Close Lot - UPSERT Mode, Update Data Example
• Warehouse Close Lot - UPSERT Mode, Delete Data Example

Insert Data

For loading the new record automatically into the database leave the Update Switch empty in incoming message. The set of specified above values should not be exist.

Also you can set the the Update Switch to ‘I’:

<updateSwitch>I</updateSwitch>

For updating the existing record automatically in the database leave the Update Switch empty in incoming message. The set of specified above values should exist.

Also you can set the the Update Switch to ‘U’:

<updateSwitch>U</updateSwitch>

For deletion the existing record from the database set the Update Switch to ‘D’:

<updateSwitch>D</updateSwitch>