Forum Discussion
DarinSpence
Sep 14, 2021Copper Contributor
XML to CSV on OneDrive
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?
- 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