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
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: