Describe the bug
The upsert operation is behaving like an insert. Instead of updating existing records based on the external ID, it is creating new records. This happens even though I am using a unique field as the external ID, and there is no record in either the source or target org with the same external ID.
To Reproduce
Use SFDMU to perform an upsert on a custom object.
Specify a unique external ID field in the export.json.
Ensure that the record with that external ID does not exist in the target or source org.
Run the data import using SFDMU.
Expected behavior
The upsert should behave as follows:
If a record with the given external ID exists in the target org, it should update it.
If no record with the external ID exists, it should insert a new record.
However, SFDMU is inserting records even though this record should have been matched and updated (suggesting it's not detecting the match correctly).
Describe the bug
The upsert operation is behaving like an insert. Instead of updating existing records based on the external ID, it is creating new records. This happens even though I am using a unique field as the external ID, and there is no record in either the source or target org with the same external ID.
To Reproduce
Use SFDMU to perform an upsert on a custom object.
Specify a unique external ID field in the export.json.
Ensure that the record with that external ID does not exist in the target or source org.
Run the data import using SFDMU.
Expected behavior
The upsert should behave as follows:
If a record with the given external ID exists in the target org, it should update it.
If no record with the external ID exists, it should insert a new record.
However, SFDMU is inserting records even though this record should have been matched and updated (suggesting it's not detecting the match correctly).