Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Display data using Related data entities

(0) ShareShare
ReportReport
Posted on by 20

Hi everyone,

I am trying to display sales order and its lines in single JSON response(using data entities) as below but facing an challenge in that

{
   "@odata.context":https://******devaos.cloudax.dynamics.com/data/$metadata#SalesOrders,
  "value": [
    {     

"@odata.etag": "W/\"08D3AB06B6F467DC\"",
      "SalesId":"000005",


      "Salesline": [


        {
         "ItemId":"0008",

          "Qty": 2
          },

{
   "ItemId":"0009",

          "Qty": 1
          }


       }
      ],
  
    }

We have a concept of composite data entities in AX, but that cannot be made public but can be used for DIXF and can only output data in XML format.

https://ax.help.dynamics.com/en/wiki/developing-composite-data-entities/

So Alternately, I am building 2 separate data entities for SALESORDERHEADER and SALESORDERLINES and trying to use relationship concept of Odata($ref)

https://*******devaos.cloudax.dynamics.com/data/SalesOrders?$ref=SalesLines

I have tried many things but cannot identify how we can apply that concept here?

Thanks!

*This post is locked for comments

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans