Share via

Exporting Query Results as XML in Azure Data Factory

Glasier 440 Reputation points
2023-11-23T19:58:05.3466667+00:00

I'm new to Azure, so I hope my question is clear. In Azure Data Factory, I'm attempting to execute a query and save the results as XML in my blob storage. However, neither the 'copy data' nor 'data flow' features seem to support this for XML, even though they work seamlessly for JSON. Does anyone know how to generate XML files from Azure Data Factory?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
Accepted answer
  1. Smaran Thoomu 24,110 Reputation points Microsoft External Staff Moderator
    2023-11-24T06:02:42.3633333+00:00

    Hi @Glasier

    Thanks for reaching out to the community forum.

    Unfortunately, XML format is only supported as Source but not at Sink side in Azure Data Factory. Refer to documentation - XML format in Azure Data Factory.
    User's image

    You can also try using the query in copy activity source which returns XML format and in sink change the file extension to .XML. Refer to this blog post.
    Hope this helps. Do let us know if you any further queries.

    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.