Question

You are building a nightly integration that imports supplier records from an external ERP system into a custom Dataverse table. Each supplier has a unique ERP identifier stored in an alternate key column named 'erp_supplierid'. To avoid creating duplicates when a supplier already exists, you send an UpsertRequest referencing the alternate key. During testing, you need to confirm how the operation behaves and how your code can determine what actually happened. Which statement correctly describes the behavior of UpsertRequest in this scenario?

Accepted Answer

UpsertRequest updates the record if a match on the alternate key exists, otherwise creates it, and the UpsertResponse.RecordCreated property indicates which action occurred.

Answer

UpsertRequest always creates a new record; you must precede it with a RetrieveRequest to decide whether to update instead.

Answer

UpsertRequest requires the primary GUID to be supplied; alternate keys cannot be used to locate the target record.

Answer

UpsertRequest throws an exception if no matching record is found, so you must catch it and issue a CreateRequest manually.