Hello Team - I am loading data into the Incident table of a Dynamics 365 environment from an Azure SQL DB using the Azure Data Factory.
the Incident table has lookups to the Account table on AccountId and Contacts via the ContactId. I have populated these two tables and obtained their GUIDs using a Data Flow so the mapping is straightforward up to this point.
There is a field called CustomerId that is a polymorhpic field. It is linked as shown below in the image.
I can't work out the mapping for this. I would think both AccountId and ContactId need to be mapped to this CustomerId field.
but can't seem to work out the correct mapping of say source ContactId -> target CustomerId@EntityReference does not work.
I think I need to create some sort of derived field in the dataflow or copy activitry where it has contact(+/ContactId/+) or something but am not sure.
This link to some MS documentation gave me the answer. The source customerid will map to the incident customerid and I created an additional derived field - I named it Target - that will contain the entity where the customerid should be referenced eg either account or contact.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
9
Share
Report
All responses (
Answers (
