MicrosoftIn my case, First I created a copy activity that uses a binary dataset source type to call the Marketing Cloud SOAP Api and puts the results(XML envelope) in Data lake as Binary Dataset Sink in Data lake. My binary source dataset uses an http linked service, under the Base URL you would use your API url from your MC. but again the result will get dumped to data lake as binary sink. You are correct that there is no SINK XML so you will need to use a binary dataset for sink that points to a location/folder in ADL.
Then, I created a new XML source dataset that points to the binary sink from step above. I then use this source in a new copy activity as source dataset, for my sink in my case I use Azure DB table that has the columns that I want to map. Then under mappings you can import schemas and you will see XML structure. Here is where it can get complex, if its a simple collection reference then you should be able to map it. Here is how my mapping looks.
