Load data from a website using ADL Data pipelines

Question

bk 466

Oct 19, 2020, 3:09 PM

Hi All
I want to load data from an excel link on a webiste. Is there a good document to show how to do it? I want to load data using ADF.
Thanks

MartinJaffer-MSFT 26,236 Reputation points

Oct 22, 2020, 6:06 PM

@bk Did my response help you? If so please mark as accepted answer, otherwise let me know how I may better assist. Without more information, I cannot give you a more detailed solution.
MartinJaffer-MSFT 26,236 Reputation points

Oct 23, 2020, 5:56 PM

@bk if you found your own solution, could you please share it here with the community?

1 answer

MartinJaffer-MSFT 26,236 Reputation points

Oct 22, 2020, 6:06 PM

@bk Did my response help you? If so please mark as accepted answer, otherwise let me know how I may better assist. Without more information, I cannot give you a more detailed solution.
MartinJaffer-MSFT 26,236 Reputation points

Oct 23, 2020, 5:56 PM

@bk if you found your own solution, could you please share it here with the community?

Answer 1

MartinJaffer-MSFT 26,236

Oct 19, 2020, 11:38 PM

Hello @bk and thank you for your question.

If the link on the website is for a download, you probably want to do 2 copy activities.

First, copy from the website to your storage. (HTTP binary dataset) , probably also decompress at the same time.

Second you can use the excel connector to load from the excel file now in storage to wherever you want it to go.