Forum Discussion
Copy Data via API - Looping through an input
- Anonymous2 years ago
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.com)
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.
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.com)
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.
- higgy72 years agoAdvocate II
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.
- Anonymous2 years agoNot applicable
Hi higgy7 ,
I hope your query was answered. Please continue using Fabric Community on your further queries.