Share via

Save Azure Data Factory web Activity's output to a file

Rohith Babu Ginjupalli 1 Reputation point
2021-02-04T04:16:08.74+00:00

I am trying to use web activity in Azure Data Factory for calling API. For that, I drag web activity from the activities list to the Azure Data Factory pipeline.

And I can able to call my API request and I got output from the Azure from the Web activity. And everything works fine till now.

The problem is that I need to save my web activity output (which is in JSON format) to a file (CSV, text).
Please help me how can I save my web activity output to a file?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,071 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Pedro Fiadeiro 216 Reputation points
    2021-02-04T06:35:40.583+00:00

    Hi @Rohith Babu Ginjupalli

    Can't you use a copy activity with a REST API as your source and some file store as your sink as shown here

    1 person found this answer helpful.
  2. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee
    2021-02-04T23:40:08.75+00:00

    Hello @Rohith Babu Ginjupalli ,

    Thanks for the ask and using the Microsoft Q&A platform .
    Just double clicking on what @Pedro Fiadeiro said . You can use the COPY activity and as SOURCE take the API
    and SINK use the container . The below animation should help .

    64204-qna-issue.gif

    Thanks
    Himanshu
    Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members