Finance | Project Operations, Human Resources, ...

Use of JSON format to export composite entity in D365 FO

(1) Share

Report

Posted on by aayushii

131

Hello,

I would like to know if I can use JSON format to export composite entity in D365 FO. If yes, how we can expose it?

Any blog document or reference is helpful.

Also, I am trying to integrate sales order invoices with 3rd party which will have header and lines and so I wanted to know shall I use the sales order invoice header V2 and sales order invoice line V2 both entities separately.

Also, can we have a single one or a composite one for this? what should be the best practice for the above scenario?

Also, for bulk record shall I use OData or custom web service?

Thankyou.

Ayu.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Ayu,

Generally, when you use OData, the data comes in JSON format.

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report

Hi,
First, composite data entities cannot be used for OData integration. So if you are using OData, forget composite data entities. https://www.gangsta.se/blog/entry/composite-data-entities-in-d365fo
Using separate entities provides greater control over each data set, simplifies data manipulation and validation, and aligns with standard practices in D365 FO. OData supports JSON format as the data transmission format.Open Data Protocol (OData) - Finance & Operations | Dynamics 365 | Microsoft Learn
Best Regards,
Hana

Was this reply helpful? Yes No
Layan Jwei 8,112 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Json is not supported for export in general. You can export it as xml then convert it to json.

Also there is an article regarding downloading an extension to convert it to json

https://community.dynamics.com/blogs/post/?postid=9fcc5864-a5e2-4086-af92-23af3eee2fbc

For large volumes, odata has poor performance

Thanks,

Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No

Join the conversation

Community site session details

Use of JSON format to export composite entity in D365 FO

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Use of JSON format to export composite entity in D365 FO

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates