Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / DIXF: Populate the Par...
Finance | Project Operations, Human Resources, ...
Suggested answer

DIXF: Populate the Parent RecId and assign it to Child Table Field during staging?

(0) ShareShare
ReportReport
Posted on by Community member

Hi

I'm working on a data management import project (XML) in d365FO. I have composite Entity that has 2 tables in it.

T1 and T2. T1 as the parent and T2 as the child.

T2 has 3 fields.

TableId - TableId of T1 (index)

RefRecId - RecID of T1 (index) this is a foreign key

Field1 - The value of this field is from the XML file being imported.

Now during staging I need to populate values in t2.tableid and t2.refrecid which are the parent table's tableId and RecID.

How do I populate the recID and TableId of the parent and assign it to child table fields during staging?

Any help would be appreciated

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    DIXF: Populate the Parent RecId and assign it to Child Table Field during staging?
    Hi Hanna,
     
    Using record IDs for linking data using data entities is not the correct approach. When you import data from a source file into T1 and T2, the records will get new record IDs so you can't make the correct link using record ID references in data entities. The idea from data entities is replacing record IDs with a natural key. In this example, you would need to use the natural key field value from T1 as value in T2 to be able to make the reference.
  • Suggested answer
    Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,605 Super User 2024 Season 1 on at
    D365FO DIXF: Populate the Parent RecId and assign it to Child Table Field during staging?
    Do you mean staging means while importing? If yes, you can use mapentitytodatasource method which is OOB functionality for this part.

Under review

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans