I have my Data Flow designed with Dataflow activity in it. The Dataflow gives my sink data as something like this

{"BaseObject":"ABCD","OHY":"AAS"}
{"BaseObject":"DEFG","OHY":"LOI"}
{"BaseObject":"POIU","OHY":"JJI"}

Now I need each value of BaseObject and have to pass it as a parameter to a web activity one by one so it will be like for each loop where one value of BaseObject is taken at a time and then passed to the web activity as a parameter, which is in turns gives me my final JSON.

How can I do this?

CodePudding user response：

Once the dataflow activty is executed, data will be loaded to the sink dataset. To get the sink results of dataflow activity, use another activity (lookup) and connect it to the sink dataset.

1. In the pipeline, connect the lookup activity after the dataflow activity and read the sink dataset to get the data loaded.

Dataflow:

Sink dataset:

sink settings:

pipeline:

Output of lookup activity:

2. Connect the lookup output to the Foreach activity, to loop the value BaseObject.

@activity('Lookup1').output.value

3. You can use this current item (@item().BaseObject) of activities inside the Foreach activity.

Ex: