Forum Discussion
Use iteration object in data copy mapping
Hi PanuO ,
Can you please add column type to int (or respective type) and try to rerun the pipeline, let me know if you are still facing the same issue.
Add on - Please refer these videos that might help you with your issue.
32. Copy data from REST API which sends response in Pages using Azure data factory - YouTube
21. Dynamic Column mapping in Copy Activity in Azure Data Factory - YouTube
Thank you
Hi PanuO - Thanks for using Fabric Community,
As I understand you are trying to fetch data using API in Fabric Data Factory with the help of pipelines.
Can you please confirm if your pipeline design is similar to below screen shot?
Can you please share some details along with screenshots regarding your approach and issue.
I would be able to help you better if you can provide these details.
That is quite close. I now have datalake as input, because it is faster to test that way (I have stored data in there so I don't want to fetch it all the time when I test this).
The foreach has following Items setting:
Hi PanuO - Thanks for your response.
Can you please share a complete screenshot of for loop settings and copy data activity settings.
Eg:
For Loop -
Copy Data -Loop:
Copy Data:
(The API has result objects inside array called results, so thats why I need to use the collection reference in mapping)
Hi PanuO ,
Can you please add column type to int (or respective type) and try to rerun the pipeline, let me know if you are still facing the same issue.
Add on - Please refer these videos that might help you with your issue.
32. Copy data from REST API which sends response in Pages using Azure data factory - YouTube
21. Dynamic Column mapping in Copy Activity in Azure Data Factory - YouTube
Thank you