ADF For each with until activity

Vikas Tiwari 766 Reputation points

I have 6 different API details as rows in sql watermark table and using foreach to iterates over these 6 rows and copy data from source to destination using ADF pipeline.

Now, I need to split data into different files and each file will have 2000 records, for this I have tried until activity and its working fine standalone but unable to find way where I can use until activity inside foreach loop.

Basically I am looking to find a way, foreach -> 1st iteration (call 1st API)-> get the data and split using until activity -> 2nd iteration (call 2nd API)->get the data and split using until activity .... upto 6 iteration.

Is it possible to use until activity under foreach loop?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,455 questions
{count} votes

Accepted answer
  1. Nandan Hegde 29,886 Reputation points MVP

    You can call excute pipeline activity within for each activity.
    So you can add the untill logic in another pipeline and call that pipeline within foreach

0 additional answers

Sort by: Most helpful