Invalid Parameter Message=The value of the property '' is invalid.

Question

I am trying to upsert data to Salesforce from a CSV file using a copy activity, but I keep getting the error message "The value of the property '' is invalid: 'ExternalIdFieldName: DLUID is required in the source data for upsert mode'." I have ensured that I have the required field "DLUID" in my CSV file, cleared the dataset schema, and even remapped the fields, but the error persists. What could be causing this issue?

Answer 1

Hi @Adrian Searles

Thanks for the question and using MS Q&A platform.

I understand you're facing an error message "The value of the property '' is invalid: 'ExternalIdFieldName: DLUID is required in the source data for upsert mode'" when trying to upsert data from a CSV file to Salesforce using a copy activity.

It indicates that the ExternalIdFieldName "DLUID" is missing in the source data for upsert mode. Please ensure that the "DLUID" field is present in your CSV file and that it is mapped correctly in the dataset schema. Let’s troubleshoot this:

• External ID Field Requirement: To perform an upsert operation in Salesforce, you must specify an external ID field. This field uniquely identifies records and helps determine whether to insert new records or update existing ones. Please ensure that your CSV file contains a column named “DLUID” that serves as the external ID field. Verify that this column has valid values for each record.
• Mapping in Copy Activity: Double-check your copy activity configuration in ADF. Confirm that you’ve correctly mapped the “DLUID” column from your CSV file to the corresponding field in Salesforce during the copy operation. If you’ve remapped the fields, ensure that the mapping is accurate.
• Dataset Schema and Clearing Cache: You mentioned that you’ve cleared the dataset schema. Make sure that the schema reflects the correct structure of your CSV file, including the “DLUID” column. Sometimes cached metadata can cause issues. Try clearing the cache again and retesting the pipeline.
• Salesforce External ID Configuration: In Salesforce, verify that the “DLUID” field is indeed marked as an external ID. You can do this by checking the field properties in Salesforce. Ensure that the external ID field is unique across records.

If you've gone through these steps and the error persists, feel free to share the following information for further assistance:

• A sample of your CSV data (excluding sensitive information).
• Screenshots of your Copy Activity configuration, including the sink settings and field mapping.

Hope this helps. Do let us know if you any further queries.