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)

For this feature to work proper relation should be declared on the child data entity to 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)

 

Search

About

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

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

Blog Tags