CODEWITHSUNDEEP
azure-data-factorykqlazure-data-explorer
Swasti
Swasti

Reputation: 287

How to write WebActivity Ouput to a Kusto table in ADF

The output of my web activity is a json file. I want to dump the entire json into single column kusto table. (likely do a .set-or-replace) in azure data factory pipeline.

So, my pipeline has a web activity, next I need to dump the output to kusto table

Upvotes: 0

Views: 85

Answers (1)

Aswin
Aswin

Reputation: 7156

  • Take a web activity and give the required API in the URL.

  • Connect the web activity with the copy activity.

  • In source settings of copy activity, add a dummy source dataset with one row data.

  • Add an additional column in source setting and give the value for that column as dynamic content @string(activity('Web1').output)

  • Add the azure data explorer dataset in sink dataset.

  • In mapping settings of copy activity, add only the required mapping.

This way you can copy the output of web activity to a column in Kusto table.

Upvotes: 0

Related Questions