...
Roll Up in Single Row mode is only available in environments 13.x or higher. Roll Up in Batch mode is fully supported. |
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.
...
| Expand |
|---|
| title | Click to see an example of incoming EagleML message for inserting new record in Upsert Mode |
|---|
|
| Include Page |
|---|
| Warehouse Position - UPSERT Mode, Insert Data Example |
|---|
| Warehouse Position - UPSERT Mode, Insert Data Example |
|---|
|
|
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:
| Code Block |
|---|
|
<procedureMode>UPDATE</procedureMode> |
| Expand |
|---|
| title | Click to expand an example of incoming EagleML message for updating record in the Upsert Mode |
|---|
|
| Include Page |
|---|
| Warehouse Position - UPSERT Mode, Update Data Example |
|---|
| Warehouse Position - UPSERT Mode, Update Data Example |
|---|
|
|
After inserting or updating the record, Roll up is always run.
