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