web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Use of JSON format to ...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Use of JSON format to export composite entity in D365 FO

(1) ShareShare
ReportReport
Posted on by aayushii 135
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)
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 26,801 Super User 2026 Season 1 on at
    Hi @Ayu,
     
    Generally, when you use OData, the data comes in JSON format.
     
    Best regards,
    Mohamed Amine MAHMOUDI
  • Suggested answer
    Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    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
  • Layan Jwei Profile Picture
    Layan Jwei 8,165 Super User 2026 Season 1 on at
    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
     
     
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 689

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 258 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans