how to capture output of append variable in adf and write to json or csv file in adls

Raviyaramati-1837 1 Reputation point

i have a set up like below , i need to capture data from for each activity to json or csv


Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,060 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 43,602 Reputation points Microsoft Employee

    Hi @Raviyaramati-1837 ,

    Welcome to Microsoft Q&A forum and thanks for posting your query.

    One way to achieve this requirement is by utilizing "Add additional columns during copy" feature as explained in this stackoverflow thread - [Transfer the output of 'Set Variable' activity into a json file Azure Data Factory

    After your append variable activity, have a subsequent Copy activity and define a column and pass the value of append variable as described in stackoverflow thread.

    Hope this info helps. Do let us know if you have further query.


    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.