locked
Lookup activity output to Azure Blob? RRS feed

  • Question

  • Hi Techie!

    I wanted to push Lookup activity output to Azure blob, how we can achieve this?

    e.g., @activity('Lookup1').output.value => Blob

    Thanks

    Wednesday, October 30, 2019 5:10 PM

All replies

  • Hello SanthoskKumar09 and thank you for your question.  

    There are a few ways to do this.  If your lookup is using a database such as SQL, then a copy activity can be used.  In the copy activity you can specify to use a query instead of the whole table.  The query from the lookup can be placed there.

    If your lookup is not on a database, there are several ways to do this.

    • Use a web activity to call a Logic app.  The Logic app can write to blob.
    • Use an Azure Function app to write to blob.
    • Use web activity to get OAuth token and then use web activity to write via blob REST API.

    In my opinion, the Logic app option is easiet to implement.

    Wednesday, October 30, 2019 10:38 PM