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)

Martin Dráb 236,471 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.

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No
Martin Dráb 236,471 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.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to create entity to show header and line data

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to create entity to show header and line data

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates