CODEWITHSUNDEEP
azureazure-data-factory
dascalos
dascalos

Reputation: 509

Azure Data Factory - Calling a REST call per row of imported data

I would like to use Azure Data Factory to do the following...

Read in a CSV file, do a Google Maps Geocode lookup based on addresses in that file, and dump the results in Azure SQL. I've been able to read from CSV and dump into Azure SQL, it's calling the rest service that I'm not sure how to do.

Can anyone give me guidance on the best way to do this? Thank you!

Upvotes: 1

Views: 1646

Answers (1)

Jay Gong
Jay Gong

Reputation: 23782

1.Use LookUp Activity to read the content of csv file.

@{activity('MyLookupActivity').output

2.Use ForEach Activity to loop the output of LookUp Activity.

enter image description here

3.Inside ForEach Activity,use copy activity. The source dataset please set REST Dataset to call geocode rest api. Configure the per row as body content.

@item()

enter image description here

4.Configure the azure sql database as sink dataset.

Upvotes: 2

Related Questions