Dynamics 365 Business Central 2024 Wave 2 release: Query.SaveAsJson… and why not more?

Dynamics 365 Business Central

Dynamics 365 Business Central and AL language extension have robust support for handling JSON objects.
In the upcoming Dynamics 365 Business Central 2024 Wave 2 release, query objects will include native Json serialization with the new Query.SaveAsJson method.
The Json serialization in version 25 will save data sets of a query as JSON without special formatting to reduce object size.
DateTime values in the serialized object will be formatted according to the UTC format.
This addition will be beneficial for scenarios requiring passing query results to an external system via a REST API without manual Json object creation in AL code.
The article suggests extending the Json serialization feature to Table objects, especially temporary tables, to simplify data operations for passing data to external systems.
The author proposes a custom generic function for JSON serialization of record objects in AL, highlighting the need for a native platform solution.
The article concludes with a pseudo-code example demonstrating the author's desire for a simplified JSON serialization process within Dynamics 365 Business Central.

Registered users can view the full text for FREE!