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

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Excel add-in to import...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Excel add-in to import data for e.g. VendVendorV2Entity

(0) ShareShare
ReportReport
Posted on by HBrook 40
We have an unusual requirement for one of our custom entity to mark the data as whether it was inserted/updated from external source (excel or integration) or whether it was inserted/updated using D365UI.
 
My question is is there any API that we can extend to mark a record as coming externally?
 
Thanks in advance.
I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 302,492 Super User 2025 Season 2 on at
    Hi HarryFromBrook,
     
    There is no out of the box feature for this. In case the external source is running with a different user account, the created by column can be used as distinction. You can also consider creating a specific custom field and have this filled with a specific value when performing an insert/update.
  • GirishS Profile Picture
    GirishS 27,829 Moderator on at
    Hi HarryFromBrook,
     
    I agree with Andre, there is no out of box feature available. You can create one custom field called "source" which will identify the records during insertion or updation.
     
    Thanks,
    Girish S.
  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,565 Moderator on at
    Hi, You can create a Boolean field isUserCreated or isCreatedFromUI and set it to True in form datasource write method. By default value will be false, so don't expose the field in data entity so record created from Data Entity or Third Party will always have value false.
  • Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Hi,
    Depending on the problem you described, it seems that you want to have a way to flag foreign data. Maybe you can add a custom field:Add an identifier field to your custom entity to indicate the source of the data. You can create a boolean field (e.g., “IsExternal”) and set the appropriate value when the record is inserted/updated.
    Best regards,
    Kevin
  • HBrook Profile Picture
    HBrook 40 on at
    Thanks all.
     
    OK, I will come clean :) We nave found out that a lot of users in our environment have write access to data entities. Fixing this one by one is very tedious and prone to mistake. Plus every upgrade microsoft adds data entities and every upgrade we have to fix this. (Our auditors expect a detailed security access comparison before and after upgrade) At the same time our management is on our back to reduce the time it takes to upgrade. 
     
    I don't want mess up with DMFWriter since that would be very intrusive. Plus it will stop all scenarios where code is legitimately writing to data entities.
     
    Hence, I was looking for a excel-integration method to hook on to. I can create a simple form as to which roles have write access to which data entity. my hook will check if the user has the write access in the underlying table. This is autdit-compatible as well.
     
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 302,492 Super User 2025 Season 2 on at
    Hi HarryFromBrook,
     
    When I read your latest reply, it looks like you have a completely different question. Is the question now how to ensure users can't import data using data entities or marking if records were imported?
     
    Note that access to data entities is also managed via security privileges. 
     
    In your implementation, have you some security configurations via the user interface or only changes done via development in Visual Studio? The answer on this question would be helpful to recommend you a next step for comparing security access before and after updates.
     
     

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

News and Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 612 Super User 2025 Season 2

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 437 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 305 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans