Share via

Read XML content as a parametar

AYUB SHAIK 46 Reputation points
2022-01-12T16:42:12.837+00:00

HI All , I have one XML file .... I need to read the file and wants to pass the total data into one variable as a single column .....is it possible to do that in ADF ? Thanks in Advance

Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 38,631 Reputation points Microsoft Employee Moderator
    2022-01-13T15:57:59.983+00:00

    Hi @AYUB SHAIK ,

    Thank you for posting query in Microsoft Q&A Platform.

    Yes you can achieve your requirement by following below steps.

    Step1: Lookup activity, use dataset which is pointing to your xml file. Lookup activity will read your file data and give it in output json.
    Step2: Create a variable in pipeline.
    Step3: Use Set variable activity, write your xml data from output of lookup activity using dynamic expression.

    Below video helps you to understand how to pass output data from activity to another activity.
    https://www.youtube.com/watch?v=2XfUKWwDi3g

    Hope this will be helpful. Please let us know if any further queries.

    --------------------

    Please consider hitting Accept Answer. Accepted answers helps community as well.

    Was this answer helpful?

Your answer

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