Hi DataPrep Team,
I'm facing an issue with Contact module lookup mapping to a custom module during the DataPrep-to-CRM migration.
As per the documentation, the mapping format for lookup fields should be:
<Lookup_Field_API_Name>.<Lookup_Module_API_Name>
For example:
Account lookup: Account_Name.Account_Name
Custom module lookup: Item_Name.Name
However, this format does not seem to work when the lookup field is mapped to the Contact module.
When we use a Contact lookup field in a custom module, the display value is a combination of the Contact's First Name and Last Name (i.e., the Contact Name). However, the Contact module does not have a single Contact Name or Name field; instead, it has separate First_Name and Last_Name fields.
I have tried different combinations using these field/API names, but none of them seem to work.
Could you please check and confirm the correct way to map a Contact lookup field in a custom module during DataPrep migration? Specifically, which API name/value should be used for the Contact lookup?
It would also be helpful if you could confirm whether this is a limitation or expected behavior of the current system.