How to create entity to show header and line data

(0) Share

Report

Posted on by Ashraf_ahk

I want create an entity to show header and lines data separately in a following pattern:

{
"context": "",
"value": [
{
"invoice": ",
"truckId": "",
"deliveryDate": "",
"dataAreaId": "",
"company": "",
"invoiceDetails": [
{
"invoice": "",
"truckId": "",
"deliveryDate": "",
"dataAreaId": "",
"companyName": "",
"company": "",
"invoiceAmountMST": "",
"salesUnit": "",
"invoiceDate": "",
"invoiceAmount": "",
"address": "",
"odataetag": "",
"name": "",
"grossWeight": "",
"currencyCode": "",
"customerName": "",
"itemId": "",
"qty": ""
}

]

}

Any solution?

All responses (3)

Answers (0)

Martin Dráb 232,917 Most Valuable Professional on at

Like (0)

Report

RE: How to create entity to show header and line data

OData protocol has $expand query option for this purpose. When your read the page about OData in F&O (the second link in my reply above), you may have noticed that $expand is supported, but just for one level.
Ashraf_ahk 75 on at

Like (0)

Report

RE: How to create entity to show header and line data

OData services that give above output in JSON.
Martin Dráb 232,917 Most Valuable Professional on at

Like (0)

Report

RE: How to create entity to show header and line data

It's a pity that you gave us so little information about your requirement. People will either ignore your question because it's not clear enough, or will have to ask extra questions, or will try to guess what you actually want, or need to spend extra effort covering multiple possible scenario. Let me do the last, but just briefly. We can discuss the actual scenario in detail when you tell us what it is.

F&O supports composite data entities, so you'll get a structure like this, but it's supported in data management only and it doesn't support JSON. You'd have to use XML.

The fact that you shared JSON suggests that you may actually be interested in OData services, and compisite entities aren't supported there. On the other hand OData has some support for related entities.