Warehouse Position - 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/Batch Key element is not present or null in the incoming EagleML message. The message contains a logical unique Object key for each Warehouse Position object instead of the warehouseTransaction/Batch Key element. 

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

Procedure Mode Element

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

Leave the element Procedure Mode (warehouseTransaction/warehousePosition/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:

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:

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