Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to duplicate Data ...
Finance | Project Operations, Human Resources, ...
Answered

How to duplicate Data Entity VendVendorV2 correctly ?

(1) ShareShare
ReportReport
Posted on by Teevo 312
Hi all,
 
I intended to duplicate data entity VendVendorV2 Entity. The reason is I want to use this Data Entity for my third party system which will call this as OData. However I need to add range first. Understand that I can filter in the OData query, but I do not want to expose it to my third party. So the range should be added in that data entity. But I also don't want to change the existing by creating extension for example.
 
May I know how is the best to duplicate this data entity ? As I knew this is pretty big or complex data entity. I also want to remove some of its field because it is too many.
 
May I get some guidance.
 
Thanks.
  • Suggested answer
    Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 1,452 Super User 2025 Season 1 on at
    How to duplicate Data Entity VendVendorV2 correctly ?
    HI Teevo,
     
    Agree with Martin's suggestion. The issue with duplication of entities is maintaining them as we move along to different versions.
     
    A few more suggestions:
    1. If you happen to duplicate the data entity then ensure that the underlying data source is the same as the standard data entity.
    2. The best option is to extend the data entity and modify them. 
     
    Considering that you are considering removing a few fields, the best option in this case from an implementation stand-point is to create a duplicate data entity and use the standard data entity as the data source of the duplicate data entity. An example snapshot where we created a duplicate entity and added the base data entity as the data source. 

     
    Happy to answer questions, if any.
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 231,801 Most Valuable Professional on at
    How to duplicate Data Entity VendVendorV2 correctly ?
    Duplication should be the last resort, because it's the solution that is the most expensive by far (in maintainance costs). You need to keep updating your copy when Microsoft changes the entity and if you forget, your outdated entity make cause problems including data curruption. Also, extensions for the standard entity (e.g. in ISV solution) won't be applied to your entity and you'll need to customize your entity again when you identify the problem.
     
    A much better solution is using the standard entity as a data source of a custom entity.
  • Suggested answer
    Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,622 Moderator on at
    How to duplicate Data Entity VendVendorV2 correctly ?
    For the 2nd requirement you can select only few fields in odata based on condition.
     
    Let's say if you have the public collection name as Customers then you can do below. But as you do not want to expose this to customer directly, in that case you need 2 custom entities duplicated from above standard entity.
     
    [Your organization's root URL]/data/Customers?$select=FirstName,LastName
     
    This url only gives you all customers with selected field list.
  • Teevo Profile Picture
    Teevo 312 on at
    How to duplicate Data Entity VendVendorV2 correctly ?
    Hi Layan,
     
    Yes, the intention is to to give my third party the intended vendor list only without them guessing what I'm excluding or what field I'm using to filter. I want to filter based 2 things:
    1. Vendor Group
    2. If the Party type is Person, I need to limit the information to only Vendor code, Vendor name and their email address.
     
    I know for filter Vendor Group I can add Range in my "copied" data entity, but not too sure how to accomplished the 2nd requirement.
     
    Thanks.
  • Suggested answer
    Layan Jwei Profile Picture
    Layan Jwei 7,722 Super User 2025 Season 1 on at
    How to duplicate Data Entity VendVendorV2 correctly ?
    Hi Teevo,
     
    Why you don't want to expose the filter to ur third party?
     
    But in general, duplicating it is very easy. Just right click on the entity and click duplicate in project then rename it.
    Also duplicate the staging table then click rename.
     
    In the entity, there is a property for staging table, make sure you put the new name.
     
    Also make sure that the label of the entity, public collection name and public entity name are unique.
     
    Also change label for staging table.
     
    Make sure the relations in the copied staging table point to the copied entity.
     
    Delete any data sources in the entity that you think you won't need in addition to deleting the fields you don't need. Also delete the un-needed fields from the staging table
     
    Or u can create the entity from scratch with the required datasources and fields.
     
    Thanks,
    Layan Jweihan
    Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,933 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,801 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans