Warehouse Open Lot - Single Row UPSERT Mode of Data Loading

The Single row Upsert mode is used for loading a single row into the database if the warehouseTransaction/batchKey element is not present or null in the incoming EagleML message. The message contains a logical unique Object key for each Warehouse Open Lot object instead of the warehouseTransaction/batchKey element. 

For the Upsert mode, the warehouseTransaction node can contain only one warehouseOpenLot complex element.

Upsert mode available examples:

Procedure Mode Element

The mode: INSERT or UPDATE can be defined automatically or by the element Procedure Mode.

Leave the element Procedure Mode (warehouseTransaction/warehouseOpenLot/procedureMode) empty for automatically definition insert or update mode. In this case the data will be updated into the DB tables if the row exists or inserted if not.

The valid values for element Procedure Mode: ‘INSERT’, ‘UPDATE’.

Insert Data

For loading the new row into the database the value of element Procedure Mode should be null or equal ‘INSERT’ if the row does not exist in the database tables:

See the example of incoming EagleML message for inserting new record in the Upsert Mode.

Update Data

For updating the existing row in the database the value of element Procedure Mode should be null or equal ‘UPDATE’ if the row exists in the database table:

See the example of incoming EagleML message for updating record in the Upsert Mode.

After inserting or updating the record, Roll up will always run.