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?

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Martin Dráb 239,097 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Ashraf_ahk 75 on at

Like (0)

Report
Copy link

Link copied!

OData services that give above output in JSON.

Was this reply helpful? Yes No
Martin Dráb 239,097 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No