web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Using Mapping Type and...
Finance forum

Using Mapping Type and Functions for Data Import of Entity

(1) ShareShare
ReportReport
Posted on by 4,969 Moderator

Dear all,

for data Import i tried to use "mapping type" and "Function" inside of a Entity. is there any ducumentaion using this features, i can't find anything.

Many Thanks for your time.

BR Anra

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    303,395 Super User 2026 Season 1 on at

    Hi Andreas,

    Please elaborate. What is the exact requirement? And where do you get stuck in detail? What are your attempts until now?

  • AR-01121610-0 Profile Picture
    4,969 Moderator on at

    Hy,

    thank you for your reply. The editable mapping is avaialable in "Map staging to target" when cretaing a new line.

    I came to the situation to import Entity contact V2 which requires AssosiactedPartyNumber from the customer the person associates. My idea was to call a method to fetch the PartyID from the customer (CustAccount is supplied in datasource) while data are loaded into staging area using a function. So i tried to change the "mapping type" which is initial "=" to something else. "0" is available and opens the "function" field for editing a method name. Which methods are available at this point, or does it require customization?

    Thank you again.

    best regards, Andreas

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    303,395 Super User 2026 Season 1 on at

    Hi Andreas,

    The best way would be using computed columns or virtual fields which do require additional development. Have a look at the documentation: docs.microsoft.com/.../data-entity-computed-columns-virtual-fields

  • Suggested answer
    AhmedHafez Profile Picture
    Microsoft Employee on at

    Hi Andreas,

    I think the easiest way to uploading contacts to save your time

    Export customers with party id , v-lookup with contact sheet , upload :)

  • Community Member Profile Picture
    on at

    Hi Andreas,

    Did you get any clarity on how the mapping type/function could work?

    BR,

    Abel

  • poglad Profile Picture
    12 on at

    That's the trouble with these answers from people who don't actually know the answer. Simple question from the OP - is there any documentation? People come here with the same question. All they find is answers from people who don't know, trying to suggest alternative approaches. So the question remains unanswered.

    If anyone does know whether there is any documentation on using these features, please let us know. :-)

  • Suggested answer
    Eugen Glasow Profile Picture
    6,359 on at

    Don't be rude, dude. No, there is no documentation, but you may check my ancient blog blogs.msdn.microsoft.com/.../ and figure out that Andre was actually right: this is an obsolete technique and should not be used anymore in favour of the entity computed columns.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans