Skip to main content



No record found.

Dynamics 365 Community / Forums / Finance forum / Use of JSON format to ...
Finance forum
Suggested answer

Use of JSON format to export composite entity in D365 FO

Posted on by 129
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?
  • Layan Jwei Profile Picture
    Layan Jwei 4,742 Super User on at
    Use of JSON format to export composite entity in D365 FO
    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
    For large volumes, odata has poor performance
    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
  • Suggested answer
    Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    Use of JSON format to export composite entity in D365 FO
    First, composite data entities cannot be used for OData integration. So if you are using OData, forget composite data entities.
    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,
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 7,245 User Group Leader on at
    Use of JSON format to export composite entity in D365 FO
    Hi @Ayu,
    Generally, when you use OData, the data comes in JSON format.
    Best regards,
    Mohamed Amine MAHMOUDI

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,835 Super User

Martin Dráb Profile Picture

Martin Dráb 225,526 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans