How to Write Web Activity Output OR Azure Function Json Output to Azure Blob Storage - ADF Tutorial

[@viktorjanssen2197]

Its just fucking sad that in 2022 you have to do all that to save a web activity output to a json file with the Azure Data Factory. Microsoft should be ashamed. Great Video.

[@rdeheld]

Yes it would be great if you could just have the same experience in ADF as in Power BI to get data. The escape characters is a real nightmare, Powerbi just eats it

[@deepakshiv4427]

Nice detailed explanation. Thank you so much. Please keep uploading such rare and tough scenarios.

[@alifakhraee]

Very helpful! Thanks a lot!

[@gabrielc6636]

Great video! Thanks

[@dennis771]

Wow you helped alot.....it save me weeks on my projects. I wish you expanded the video to include POST - Get method.

[@liamdoughty8069]

Thank you so much for this video. This really saved me in one of my projects!!!

[@TechBrothersIT]

you are welcome

[@GrabowskiMaciej]

thanks. i managed to read this "csv" files as json files and then convert it to table shape using PBI data flows! in my case data source is data lake gen 2

[@mayuranpara4734]

Great video; Glad I found this video.

[@ashishsharan6503]

Please keep on Creating Videos on Azure Data Factory Tutorials and Interview Questions on Azure Data Factory

[@ajwork3698]

Thanks for making these fantastic series

[@TechBrothersIT]

Glad you like them!

[@SureshBabu-tk8lg]

Hi Thank you for the awesome video. I have a question here? Instead of using web activity, why can't we provide the same URL to copy activity source?

[@azurelearner4055]

Thanks Aamir Sir

[@SuperJamu]

Excellent!

[@rswilley]

Great video. Thank you!

[@TechBrothersIT]

Glad you liked it!

[@resumodoslivrosemaudio]

Thank you!

[@kathyr4132]

Very helpful. Thank you!

[@HarshitaVishwakarma-b6c]

How can i use this output json from blob storage as a source in my data flow activity. I tried using it but its not giving proper columns while previewing the data.

[@otabolayo5742]

Can you make a video for function json output to azure blob storage ?

[@sahilgupta006]

What's the need for variables? can't we do the same without variable just take the web activity and copy activity?

[@TechBrothersIT]

Hi Sahil, We might not need the variable here but often we come to point where we need to save the value temporarily and use it later. Thanks for the message.

[@sahilgupta006]

@@TechBrothersIT got it I got the answers after watching more videos uploaded by you.

[@Kudohsz]

I am trying to move data from output file (in text file format) into SQL table. How do I go about doing it?

[@ITworld1987]

copy data activity

[@mearigureisu9679]

Have you tried to pass Json file from Azure Blob Storage to Azure Function?

[@TechBrothersIT]

sorry have not tried

[@mearigureisu9679]

@@TechBrothersIT Thank you! Hope in the future you can share how to do it. :)

[@NaaneVinu]

I have a data of 5000+ lines in a table and when queried the copy activity is splitting this json object randomly into multiple rows after say 200 lines. hell of this adf. not a right tool for flexible data import. I am feeling college students developed tool not for industry's actual use cases.

[@mearigureisu9679]

@(activity('Web1').output) doesnt work in my end. :( How can i pass the values then to my variable?

[@bpChannelTest]

I might be experiencing the same issue and found the solution --> Adding the { } braces kzbin.info/www/bejne/ooSvn5mcr5iSZ68. "ErrorCode=UserErrorInvalidValueInPayload,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to convert the value in 'value' property to 'System.String' type. Please make sure the payload structure and value are correct.,Source=Microsoft.DataTransfer.DataContracts,''Type=System.InvalidCastException,Message=Object must implement IConvertible.,Source=mscorlib,'"

[@mearigureisu9679]

@@bpChannelTest Thanks Brian!