How to remove escaped character when parsing xml to json with copy data activity in Azure Data Factory?
I have an ADF pipeline exporting from xml dataset (ADLS) to json dataset (ADLS) with a copy Data activity. Due to the complex xml structure, I need to parse the nested xml to nested json then use T-SQL to parse the nested json into Synapse table.
However, the output nested has double backslash (It seems like escape characters) at nodes which have comma in it. You can check a sample of xml input and json output below:
xml input
<Address2>Centro, COLONIA CENTRO DE LA CIUDAD DE</Address2>
json output
"Address2":"Centro\, COLONIA CENTRO DE LA CIUDAD DE"
How can I remove the double backslash in the output json with copy data activity in Azure Data Factory ?
Read more here: Source link