'How do I save an XML file in ADLS using the Synapse Copy Activity?

I'm calling an api with xml as response and I need to write this to Azure Data Lake? But I do not see a sink dataset for XML in Synapse Copy Activity. Source dataset is http (binary). Sink is ADLS Gen 2 but I cannot see XML on the data format.

Thanks.



Solution 1:[1]

Currently XML format is not supported in sink. You can raise a feature request from the synapse studio.

enter image description here

Also, when using a binary dataset as a source in copy activity, you can only copy to a binary dataset in the sink.

Source:

enter image description here

Sink: Connect your sink dataset to binary format and copy the file.

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 NiharikaMoola-MT