Skip to main content
Microsoft Idea

Data Factory

Needs Votes

Write Data Factory Web activity output to Lakehouse File or Table

Vote (1) Share
Daryl Lynch's profile image

Daryl Lynch on 10 Oct 2023 15:11:44

Please provide the simple ability to write data from the Data Factory "Web" activity output to Lakehouse File or Table.

We used the new "Cloud Connection" Service Principal feature to run an Web V2 API call. The Output from the API call contained a JSON file. However, there did not appear to be a simple way to write this JSON to a Lakehouse file for Archive purposes. I had intended to replace the previous Json file, and save an Gzip archive.

We were looking something similar to the "Copy Data" Destination, which allowed the selection of Lakehouse file in Json and Gzip compression.

Unfortunately, there was no simple way to include the API json data into the "Copy Data" source. The source was limited to Workspace and External without the ability to select a previous step.

We managed to find a work arounds by adding complex Notebooks. The Notebook was allowed to received the API Json as a parameter input.