Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
higgy7
Frequent Visitor

Copy Data via API - Looping through an input

Hi,

 

I am quite new to pipelines and i am trying to copy data via an api using the lat and long from a table.

 

I can successfully copy data for one site using the parameters and url. However ideally i want it to run 25 times for 25 sets of lats and longs.

 

I had looked at using the lookup and a for each loop but I do not know how to put it all together. Any help would be greatly appreciated. 

 

higgy7_0-1718888715542.png

higgy7_1-1718888897914.png

 

 

1 ACCEPTED SOLUTION
v-gchenna-msft
Community Support
Community Support

Hi @higgy7 ,

Thanks for using Fabric Community.
Can you please refer below links to get some idea on how to use it -
08 Microsoft Fabric Data Pipeline: How to Use Lookup and Foreach Activity in Data Pipeline (youtube....
1.08-Building Iterative Logic in Microsoft Fabric Data Pipelines using ForEach Activity (youtube.com...

My suggestion:
1. Use Lookup activity to get the latitudes and longitudes by using a query.
2. After fetching the data, use For Loop to interate over the data
3. Use Copy Activity and create the logic that required.

Hope this is helpful. Please do let me know incase of further queries.


View solution in original post

3 REPLIES 3
v-gchenna-msft
Community Support
Community Support

Hi @higgy7 ,

Thanks for using Fabric Community.
Can you please refer below links to get some idea on how to use it -
08 Microsoft Fabric Data Pipeline: How to Use Lookup and Foreach Activity in Data Pipeline (youtube....
1.08-Building Iterative Logic in Microsoft Fabric Data Pipelines using ForEach Activity (youtube.com...

My suggestion:
1. Use Lookup activity to get the latitudes and longitudes by using a query.
2. After fetching the data, use For Loop to interate over the data
3. Use Copy Activity and create the logic that required.

Hope this is helpful. Please do let me know incase of further queries.


Thanks for this. The only piece i was missing was the syntax to bring in individual items from the lookup into items to use in the url. These videos showed this part in use.

Hi @higgy7 ,

I hope your query was answered. Please continue using Fabric Community on your further queries.

Helpful resources

Announcements
FabricCarousel_June2024

Fabric Monthly Update - June 2024

Check out the June 2024 Fabric update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Users online (1,257)