ODATA fields do not show all table fields

(0) Share

Report

Posted on by OkayGoogle

CONTEXT

I am using Power BI to get data from Dynamics 365 Finance and Operations ([My organization's root URL]/data) using the following guide from Microsoft:

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/odata

There is a table I can look up in the SysTableBrowser in Dynamics

( organization.operations.dynamics.com/ ) with many fields in it.

ISSUE

Unfortunately, the ODATA does not display all the fields in the table. It displays around 80% of the fields. How do I get the missing fields to show up in ODATA?

There was already a question on this forum similar to this, but it was never answered!

https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/371843/odata-field-from-inventdim-does-not-show-up

In that question the OP specifically states, "The Entity PurchPurchaseOrderLineEntity has many fields in D365FO, but in the OData, it only has few."

Any help would be much appreciated!

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

OkayGoogle 5 on at

Like (0)

Report

The ODATA does not display the Table. It actually displays the Entity. The Entity was missing fields from the table. Once the Entity is updated, the ODATA will then show the updated fields.

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

First of all, the OData shows fields from an entity, not from a table. The entity can have one or more tables as data source.

Second, some of the entity fields might be internal, not available externally. This is often the case with RefRecId fields. They are system fields and should not have significance outside of the system.

You can develop an extension to the entity (and it's staging table) to add more fields from the data source table.

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi,

I noticed that PurchPurchaseOrderLineEntity has been marked as obsolete (since you mentioned it by name). Please try using PurchPurchaseOrderLineV2Entity instead.

Additionally few of the fields are are marked with a Access Modifier value "Private". These are true for RefRecId fields as Nikolaos mentioned. An example of such a field would be "DeliveryPostalAddressRecId" in the aforementioned entity.

Please provide us with a few examples of the fields you are unable to view. That would help us figure out anything else we might be missing now.

Was this reply helpful? Yes No
OkayGoogle 5 on at

Like (0)

Report

Thank you for the additional insight! The entity that was missing fields was a third party entity which I don't have access to modify, but I reached out to them and asked them to update it.

Was this reply helpful? Yes No

Join the conversation

Community site session details

ODATA fields do not show all table fields

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates

Community site session details

ODATA fields do not show all table fields

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates