Xml_To_Json

Converts an XML to a JSON string

Free Function
SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017

Syntax:

SELECT SQLHTTP.net.Xml_To_Json ( @Xml )

Arguments:

Name	Type	Description
@Xml	xml	An XML value to be converted to a JSON string



Return Type:

nvarchar(MAX)



Sample Usage:


DECLARE @Json nvarchar(MAX)
DECLARE @X xml

SET @X = '<?xml version="1.0" encoding="UTF-8"?>
 <DocumentElement param="value">
     <FirstElement>
         &#xb6; Some Text
     </FirstElement>
     <?some_pi some_attr="some_value"?>
     <SecondElement param2="something">
         Pre-Text <Inline>Inlined text</Inline> Post-text.
     </SecondElement>
</DocumentElement>'

SET @Json = SQLHTTP.net.Xml_To_Json(@X)

SELECT SQLHTTP.net.FormatJson(@Json)

DECLARE @Json nvarchar(MAX)

DECLARE @X xml

SET @X = '<?xml version="1.0" encoding="UTF-8"?>

¶ Some Text

</FirstElement>

<?some_pi some_attr="some_value"?>

Pre-Text <Inline>Inlined text</Inline> Post-text.

</SecondElement>

</DocumentElement>'

SET @Json = SQLHTTP.net.Xml_To_Json(@X)

SELECT SQLHTTP.net.FormatJson(@Json)

------------------------------------------------

{

"DocumentElement": {

"FirstElement": "¶ Some Text",

"SecondElement": {

"Inline": "Inlined text",

"param2": "something",

"value": [

"Pre-Text",

"Post-text."

]

"param": "value"

}



Xml_To_Json

Featured API Wrapper Code / SQL Server