Hi All,
I have 2 x Alternative keys setup in the Account Table (2 x separate systems that create their own keys), the one alternative key works as intended with the dataflows and does upserts, however, something has happened and the second one seems to be not working correctly.
When refreshing the dataflow I get the below message. (It looks like it is trying to insert but my intention is an upsert)
{"error":{"code":"0x80060892","message":"A record that has the attribute values [Column Name] already exists. The entity key [Column Name] requires that this set of attributes contains unique values. Select unique values and try again."}}
I have tried removing the key and using different naming convention but still end up with the same error.
Any ideas would be appreciated.