Blog Post

Azure Data Factory Blog
1 MIN READ

Azure Data Factory adds support for XML format

Linda_Wang's avatar
Linda_Wang
Icon for Microsoft rankMicrosoft
Jul 17, 2020
We are glad to announce that now in Azure Data Factory, you can extract data from XML files by using copy activity and mapping data flow. With such capability, you can either directly load XML data t...
Updated Jul 17, 2020
Version 1.0
Azure Data Integration
Copy Activity
Mapping Data Flows
jbalta470's avatar
jbalta470
Copper Contributor
Nov 06, 2020

Hi Linda_Wang 

 

I have a copy activity in a pipeline where the source is XML file and the sink is SQL table.  I have some issues with mapping the XML file due its hierarchical structure. I wonder if is possible to use XPath in the mapping to pick the xml nodes   

Did anyone use the XPath in this circumstance?

 

Thanks 
John Balta