title: Preserve filename on sink when doing binary file copy with Azure Data Factory v2
body: <p>This might be really simple but I can't figure out how to do it. I'm using Azure Data Factory v2 to copy one Excel file from SharePoint Online to Azure Blob Storage using HTTP connector and binary file format. I am following this tutorial <a href="https://docs.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list#copy-file-from-sharepoint-online" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list#copy-file-from-sharepoint-online</a> to get the bearer token and pull the file to be copied from SharePoint Online. I'm using two activities:</p>
  <ol>
  <li>GetBearerToken - gets bearer token for SharePoint Online</li>
  <li>CopyFromSPOToAzureStorage - using the bearer token from 1) copy an Excel file in binary format from a SharePoint Online folder into Azure Storage in binary format</li>
  </ol>
  <p><a href="https://i.stack.imgur.com/gBLNY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gBLNY.png" alt="Data Factory activities" /></a></p>
  <p>I'm able to read and copy a file Dummy.xlsx but I'm having a gripe with that - the file ends up stripped of its original name and extension onto Azure Storage:</p>
  <p><a href="https://i.stack.imgur.com/4oFgI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4oFgI.png" alt="Copied file on sink" /></a></p>
  <p>I am able to open the file in Excel, see the columns and rows and it looks fine in general. However, I would like to preserve the filename and extension and copy it as-is on the sink.</p>