CODEWITHSUNDEEP
azureazure-data-factory
ZZZSharePoint
ZZZSharePoint

Reputation: 1341

How to get a specific data from dataflow to be used in other activity in Azure Data Factory

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.

enter image description here

How can I do this?

enter image description here

Upvotes: 0

Views: 560

Answers (1)

NiharikaMoola
NiharikaMoola

Reputation: 5074

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:

enter image description here

sink settings:

enter image description here

pipeline:

enter image description here

Output of lookup activity:

enter image description here

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

@activity('Lookup1').output.value

enter image description here

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

Ex:

enter image description here

Upvotes: 1

Related Questions