Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Azure data Factory save CSV from URL

I need to download a CSV file from a URL using Azure Data Factory v2.

The URL is: https://api.worldtradingdata.com/api/v1/history?symbol=SNAP&output=csv&sort=newest&api_token=demo

Do you know how to do this. I was thinking about downloading it to Blob storage but am unsure what connection to use?

Thanks, Bob

like image 568
VendettaBob Avatar asked Sep 14 '25 05:09

VendettaBob


1 Answers

This is easy thanks to the HTTP connector, here is a tutorial: https://learn.microsoft.com/en-us/azure/data-factory/connector-http

The tutorial guides you in creating a linked service, a dataset for that linked service and finally do a copy activity using that dataset!!

Should be fairly easy to follow, but if you have any questions be sure to reply me and ask away!

Hope this helped!

like image 108
Martin Esteban Zurita Avatar answered Sep 20 '25 14:09

Martin Esteban Zurita