XML to CSV on OneDrive

[DarinSpence]

I'm wondering if Data Factory would be the right tool for this scenario:

Every month I receive a 1.5 GB XML file with sales transactions, which I convert to CSV.  Could I use Data Factory to injest an XML file from SFTP, convert it to CSV, and finally save the csv file in a OneDrive folder?

[#2]

HI, Onedrive cannot be used as a Sink. But you can use Mapping DataFlow to parse your XML file and then save it to a Blob Storage. Create a logic app or something similar to copy the data from the blob to OneDrive. Will this help you