title: How to copy files from sharepoint into blob storage azure data factory v2 using Odata linked service
body: <p>Can any one help in understanding procedure of copying excel  file from  share point  to azure Blob storage through  Azure Data Factory pipelines. I am struggling while creating Odata linked service. What is service url in odata linked service? 
  I am using rest apis provided in link <a href="https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-folders-and-files-with-rest" rel="nofollow noreferrer">here</a> as a service url :<a href="https://xxxxx.sharepoint.com/sites/xxx/_api/web/" rel="nofollow noreferrer">https://xxxxx.sharepoint.com/sites/xxx/_api/web/</a></p>
  
  <p>authentication type: basic </p>
  
  <p>when I test connection I outputs a weird error: <a href="https://i.stack.imgur.com/DFYuS.png" rel="nofollow noreferrer">here</a></p>
  
  <p>I have tried the following articles so far.
  <a href="https://docs.microsoft.com/en-us/azure/data-factory/connector-odata" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/azure/data-factory/connector-odata</a></p>
  
  <p><a href="https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-folders-and-files-with-rest" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-folders-and-files-with-rest</a></p>
  
  <p>Note: when I try these rest api urls from browser they work fine I can download files and so on.
  is there any other way of achieving this goal??</p>