Question

You are building a nightly integration that copies only the records that changed in the Dataverse 'account' table since the previous run into an external reporting database. You want the Dataverse Web API to return both created/updated records and information about deleted records without you having to manually compare snapshots. What must you do first to enable this approach?

Accepted Answer

Enable change tracking on the account table, then persist the delta link (deltatoken) returned by the query and pass it on the next run.

Answer

Create an alternate key on the account table and use it to filter records modified after the last run.

Answer

Register a webhook via the Plug-in Registration Tool so Dataverse pushes every account change to your integration in real time.

Answer

Query the audit history table on each run and reconcile the changes manually against your reporting database.