oData expand feature

Data entities can be expand with additional child entities with expand keyword. For example:

https://{d365BaseURL}/data/ReleasedProductsV2?cross-company=true&$filter=dataAreaId eq 'VK' &$expand=VendorProductDescriptionsV2($select=ItemNumber),ProductAttributeValuesV3($select=ProductNumber)

Use the D365 Data Entity List and the Public Entity Query Builder tools to search standard data entities and compose oData queries.

The $filter query option within $expand is not supported as of version 10.0.46. You will get the following error: 
Nested query options in $expand are not supported.

For this feature to work, a proper relation must be defined from the child data entity to the parent data entity:

RELATION PROPERTY

VALUE

Name

EcoResReleasedProductV2Entity

Related Data Entity

EcoResReleasedProductV2Entity

Cardinality

ZeroMore

Related Data Entity Cardinality  

ExactlyOne

Relationship Type

Association

Relation

EcoResReleasedProductV2Entity.ItemNumber = PurchVendorProductDescriptionV2Entity.ItemNumber

Validate

No

RelatedDataEntityRole

ReleasedProductV2
(parent PublicEntityName property)

Role

VendorProductDescriptionV2
(child PublicEntityName property)

Support The Author

 If you found value in what I share, I've set up a Buy Me a Coffee page as a way to show your support.

Buy Me a Coffee

Post a Comment

   renew the code

All Comments

No comments. Be the first one to comment on this post.

Search

About

DaxOnline.org is free platform that allows you to quickly store and reuse snippets, notes, articles related to Dynamics 365 FO.

Authors are allowed to set their own "buy me a coffee" link.
Join us.

Blog Tags