Warehouse Trade - UPSERT Mode of Data Loading

Owned by Natalie Gesin (Deactivated)
Last updated: Oct 23, 2024 by Kinga Huszno
1 min read

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 warehouseTrade complex element.

The set of values – key of record:

Security Alias + Source Name + Entity Id + Master Ticket Number + Event ID (star_tag25)

To insert new data the database set of specified above values should not exist. To update a data record with your message, you should make it up with the full database set of values determined.

Examples of use: