I am trying to insert Junction object data based on External Id of the Contact. I have created an external id field as follows on Contact object:

  • Name: External Id
  • API: External_Id__c
  • DataType: Text(20)
  • External Id checkbox is selected.

Junction object has Lookup relationship to Contact with API Name Contact__c

In the data loader, it is unable to find the Contact relationship based on External Id.

Any suggestions are welcome.


External Id field does not have FLS for System Administrator profile, That's why it was unable to see this field.

Background of the issue: Through the change set this field has been migrated to other sandbox. Normally Profiles have not been added in the change set.

So, field have migrated properly but, FLS was not available since we have not added respective profiles.

After migration, manually FLS supposed to be given (even if to the System Admin profile), which has been missed.

  • Happens, faced same once :) – Pranay Jaiswal Sep 26 '17 at 17:09
  • because of migration it has been missed – Santanu Boral Sep 26 '17 at 17:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.