Skip to main content

Notifications

Announcements

Share Your Journey with Power Pages and Help Shape Its Future!
News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / Custom Data Entity is ...
Finance forum
Suggested answer

Custom Data Entity is empty

(1) ShareShare
ReportReport
Posted on by D365FO Junior-Dev 22
 Hello,
I created a custom data entity in Visual Studio using purchTable as the data source. The entity was successfully created, and I can see it listed under System administration > Workspaces > Data management > Data Entities. However, it doesn't contain any data, even though purchTable in SQL Server has plenty of data.
All steps I followed:
  1. Created a new Dynamics 365 FO project and set Synchronize database to true.
  2. Added a new Data Entity using the wizard.
  3. Set purchTable as the data source.
  4. Set Is Public to true.
  5. Built both the project and solution successfully with no errors.

    the result in postman will be like this  
    {
    "@odata.context": "https://exampleurl.axcloud.dynamics.com/data/$metadata#MyCustDataEntity",
    "value": []
}
     
What could I be missing?


 
Categories:
Integrations
  • Komi Siabi Profile Picture
    Komi Siabi 12,585 Most Valuable Professional on at
    Custom Data Entity is empty
    Hi,

    Why are you using a standard table purchTable for your data entity, when the it already has one? 
    As Layan said, ensure you are in the right entity and your user has access to a valid entity.
  • Suggested answer
    Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,562 Moderator on at
    Custom Data Entity is empty
    Did you specify cross company filter in odata query? It can be the scenario that may be in the user related dataareaid, data is not available.
     
    Please make sure that you have specified the url like this.
    http://[baseURI\]/data/FleetCustomers?cross-company=true
     
    For more details check this.
     
    https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/odata
  • Suggested answer
    Layan Jwei Profile Picture
    Layan Jwei 7,053 Super User 2024 Season 2 on at
    Custom Data Entity is empty
    Hi,

    It could be because of the legal entity, by default if you don't specify the dataAreaId, then it will take the user legal entity. So make sure you use "cross-company" and specify the dataAreaId where you want to get the data from.

    Example:
    url/data/CustomersV3?cross-company=true&$filter=dataAreaId eq 'USMF' and CustomerAccount eq 'US-01'

    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

News and Announcements

Share Your Journey with Power Pages and Help Shape Its Future!

Quick Links

Dynamics 365 Community Update – Sep 16th

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

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,500 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,426 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans