Dear,
My ERP system periodically exports JSON formatted files, which I want to load in my Dataverse table.
The files have a unique key on each row which I identified as unique.
However, when I load the JSON files periodically, the keys aren't recognized and the table creates many duplicates.
I hoped that existing records are recognized and updated instead of created again.
Any idea how to avoid the issue?
Thanks a lot,