Question

You are building a nightly integration that pushes product records from an external ERP into Dataverse. The ERP does not store Dataverse GUIDs, but each product has a unique ERP SKU code. You have created an alternate key named 'erp_sku' on the product table. You need to write code that inserts new products and updates existing ones in a single operation per record, without first querying to check whether the record exists. Which approach should you use?

Accepted Answer

Build an Entity using an EntityReference keyed on the 'erp_sku' alternate key and submit it with an UpsertRequest.

Answer

Retrieve the record by SKU with a RetrieveMultipleRequest, then issue either a CreateRequest or UpdateRequest based on the result.

Answer

Submit a CreateRequest for every record and catch the duplicate-key exception to fall back to an UpdateRequest.

Answer

Enable change tracking on the product table and submit each record with an UpdateRequest using the RowVersion.