Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In batch mode multiple rows can be loaded into the database by one EagleML message. In this mode the element element warehouseTransaction can contain several can contain several warehouseCloseLot complex elements. The data from each element will be loaded into a separate database row.

Expand
titleClick to expand a batch mode example
Include Page
Warehouse Close Lot - Batch Mode Example
Warehouse Close Lot - Batch Mode Example

Batch Key Element

The group of complex elements (so-called 'batch') is given a specific set of values - a batch key (warehouseTransaction/batchKeyelement).

For WarehouseCloseLot it is Entity Id, Effective Date and Source Name formatted as entityId^effectiveDate^sourceName

  • entityId – the

    element 

    element warehouseTransaction/warehouseCloseLot/entityId. Should be specified if it mapped from the EagleML message directly (in

    the 

    the warehouseTransaction/warehouseCloseLot/entityId). If the value of entityId is defined by

    the 

    the warehouseTransaction/warehouseCloseLot/xrefAccountId

     and 

     and warehouseTransaction/warehouseCloseLot/xrefAccountIdType

     elements

     elements, the first part

    of 

    of warehouseTransaction/batchKey

     could

     could be any. The batch key will be updated with the entityId calculated from xref Ids.

  • effectiveDate – the

    element 

    element warehouseTransaction/warehouseCloseLot/effectiveDate. Should be specified in DATE format: YYYYMMDD.

  • sourceName – the

    element 

    element warehouseTransaction/warehouseCloseLot/sourceName.

Examples of correct WarehouseCloseLot batch key:

...