How to convert a csv file to a nested XML using Azure Data Factory?

Question

How to convert a csv file to a nested XML using Azure Data Factory?

Answer 1

Hello @Swapnil Sarkar ,

Thanks for the question and using MS Q&A platform.

Unfortunately, ADF doesn't support XML as sink.

You may try exploring Transform XML in Azure Logic apps and see if that helps to meet your requirement. Below are few related articles by community volunteers.

• http://blogs.recneps.net/post/Using-Azure-Logic-Apps-to-Import-CSV-to-SQL-Server
• https://stackoverflow.com/questions/61417713/how-to-convert-a-csv-to-xml-in-logic-apps
• https://social.msdn.microsoft.com/Forums/en-US/dfce78db-ebd6-41d9-ac7b-423a1f83f186/convert-csvexcell-to-xml-in-logic-app

But I would highly recommend to upvote and/or comment on below existing feature request suggestions by other users in ADF user voice forum, which would help increase the priority of the feature implementation.

• XML at sink side
• Support for XML file for ADLS as sink

Hope this info helps.

----------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.