pull csv file data from http

arkiboys 8,371 Reputation points

I would like to have a ADF pipeline to go to http site and pull data from the csv file which is inside the site and put the data into the database.
Probably I can use copy activity but not sure how to read data inside the csv when it is in http.
How can I do this

Thank you

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,159 questions
{count} votes

Accepted answer
  1. SatishBoddu-MSFT 15,206 Reputation points

    Hello @arkiboys

    I tried the HTTP url to pull some CSV data and sink the SQL DB table, i hope this helps with your initial query!

    Source: Shows the HTTP endpoint dataset inside the Copy Activity.

    User's image


    User's image


    User's image

    HTTP connection inside the Copy Activity:
    User's image

    User's image

    Example: the HTTP endpoint looks something like below, from which we pull the CSV data.


    Please let us know if you need further help in this matter and we would be glad to help you further!

    If the response is helpful, please click "Accept Answer" and upvote it. So that we can close this thread.

    0 comments No comments

0 additional answers

Sort by: Most helpful