Share via

XML to Jason

Johardas J 1 Reputation point Microsoft External Staff
2022-07-26T06:09:45.303+00:00

Hi All,

Is there any tool we have inside Microsoft for conversion between XML to JASON.

Microsoft Security Microsoft Graph
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 26,586 Reputation points
    2022-07-26T13:24:29.317+00:00

    Hi @Johardas J ,

    You can do it in MS SQL Server starting from SQL Server 2016 onwards:

    1. Shred XML into relational format by using XQuery methods nodes() and value(): value-method-xml-data-type
    2. Compose JSON with SELECT ... FOR JSON statement: format-query-results-as-json-with-for-json-sql-server.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.