none
copy a file from one blog to another

    Question

  • Hi

    I want to copy a file from a source blob (source/MyFile.txt) to a destination blob (Destination/newMyFile.txt)

    i have to use a "Web" Activity from ADF (Azure Data Factory) to call the "Logic App" i will have to pass 2 variables

    source/MyFile.txt

    and 

    Destination/newMyFile.txt

    I am trying something like ....    

    https://kromerbigdata.com/2018/03/15/azure-data-factory-delete-from-azure-blob-storage-and-table-storage/

    but i want to copy the file

    Thanks for the help

    Nik


    Sincerely Nik -- Please kindly mark the post(s) that answered your question and/or vote for the post(s). http://sqldataside.blogspot.ca/ (SQL Tabular + PowerShell)

    Wednesday, September 12, 2018 2:38 AM

Answers

  • I found t he answer

    some cases when creating the BLOB connection in Logic App you need to delete and recreate the connection to the blob 

    to test it use Postman and the jason script

    for copy you can use something like 

    @concat('{"SourceblobPath":"','/FileName.txt','","DestinationblobPath":"','/FileName.csv'"}')


    , after that you can test with ADF


    Sincerely Nik -- Please kindly mark the post(s) that answered your question and/or vote for the post(s). http://sqldataside.blogspot.ca/ (SQL Tabular + PowerShell)

    Thursday, September 27, 2018 8:58 PM

All replies

  • Hi Nik,

    Azure data factory supports Copy activity. You can try Copy Data tool to achieve your goal.

    Hope it helps.

    Wednesday, September 12, 2018 3:26 AM
  • Hi Bo

    Thanks for the reply, but that was not my question,

    the "Copy Data" activity , does NOT copy files it open files and moves the DATA within the file to another destination blob and then saves the file at the destination

    i am looking for COPYing the file from a blob folder, ADF can not MOVE/DELETE/COPY files

    Sincerely

      Nik


    Sincerely Nik -- Please kindly mark the post(s) that answered your question and/or vote for the post(s). http://sqldataside.blogspot.ca/ (SQL Tabular + PowerShell)

    Wednesday, September 12, 2018 12:12 PM
  • To be clear, the Copy Activity in ADF can do binary copies of files and that's how you should be doing it rather than a Logic App.

    In ADF, when creating the Connection for the Source and Sink, just check the Binary Copy box.  Or edit you existing Connections such.

    Wednesday, September 12, 2018 2:15 PM
  • Thank you very much for the reply, can you please show me how you can delete a text file within a blob from ADF only.

    Sincerely Nik -- Please kindly mark the post(s) that answered your question and/or vote for the post(s). http://sqldataside.blogspot.ca/ (SQL Tabular + PowerShell)

    Thursday, September 13, 2018 12:14 AM
  • I found t he answer

    some cases when creating the BLOB connection in Logic App you need to delete and recreate the connection to the blob 

    to test it use Postman and the jason script

    for copy you can use something like 

    @concat('{"SourceblobPath":"','/FileName.txt','","DestinationblobPath":"','/FileName.csv'"}')


    , after that you can test with ADF


    Sincerely Nik -- Please kindly mark the post(s) that answered your question and/or vote for the post(s). http://sqldataside.blogspot.ca/ (SQL Tabular + PowerShell)

    Thursday, September 27, 2018 8:58 PM
  • The question was about Azue Logic App I don't know why it was moved to ADF


    Sincerely Nik -- Please kindly mark the post(s) that answered your question and/or vote for the post(s). http://sqldataside.blogspot.ca/ (SQL Tabular + PowerShell)

    Thursday, September 27, 2018 8:59 PM