web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
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

I have the same question (0)

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
TAHER Mehdi Profile Picture

TAHER Mehdi 3

#2
Nakul Profile Picture

Nakul 2

#2
Mea_ Profile Picture

Mea_ 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans