Search code examples
odataaxaptadynamics-365dynamics-365-operations

Dynamics 365 Finance Operations Entity Relationships


I'm working in Dynamics 365 Finance and Operations with OData calls. There is a lot of pre-imported information in Customers and ContactPersons. I was wondering if there is any way to relate the two fields. They are connected via party number, but neither defined entity has a navigation property to party number.

My question is it expected that if we want to be able to query Customer entities and be able to expand on their party number, then expand on the contact, are we expected to modify these pre-defined entities by adding navigation properties? Is this even possible?


Solution

  • It should be doable (am CRM guy, not AX guy)

    Able to browse some links to understand AX DB schema & for sure X++ odata calls are way different. Even the relationships are available & can set the navigation property between Odata entities.

    dirPartyTable.RecId == custTable.Party
    

    enter image description here