question

MarceloMotaManhes-4519 avatar image
0 Votes"
MarceloMotaManhes-4519 asked MarceloMotaManhes-4519 answered

Copy from Share Point online is not working

Hi Team

I configured as requested in the site:

https://docs.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list

Section : Copy file from SharePoint Online

1) Enabled application in Azure
2) Configured Share Point to authorize application
3) Checked IRM ( It is disable on Share Point online site I´m trying)
4) Checked all options described in previous discussions

https://docs.microsoft.com/en-us/answers/questions/109275/copy-file-from-sharepoint-not-working.html

and

https://docs.microsoft.com/en-us/answers/questions/331742/azure-data-factory-copy-a-file-from-sharepoint-to.html

My Error is:

Failure type
User configuration issue
Details
Failure happened on 'Sink' side. ErrorCode=HttpFileFailedToRead,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to read data from http server. Check the error from http server:The remote server returned an error: (400) Bad Request.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=The remote server returned an error: (400) Bad Request.,Source=System,'


Is there some point i´m missing. Help me please !

Thanks
Marcelo

azure-data-factory
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @marcelomotamanhes-4519,

Thanks for using Microsoft Q&A !!
Error says issues at Sink side. What is your sink ? If it is Blob storage ? How are you authenticating (Account Key, SAS Token etc.) to your sink ? Also, have you tested the connection in your linked services ?

Also, are you able to preview the SharePoint list from Dataset ?
122048-image.png

Thanks
Saurabh

0 Votes 0 ·
image.png (53.8 KiB)

Hi @marcelomotamanhes-4519,

We haven't heard back from you. Just wanted to check if you are you still facing the issue? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks
Saurabh

0 Votes 0 ·

1 Answer

MarceloMotaManhes-4519 avatar image
0 Votes"
MarceloMotaManhes-4519 answered

Hi Team the issue was solved using correctly the address in the sharepoint call

For example if you put

https://{site url}/_api/web/GetFileByServerRelativeUrl('/My Folder Name/My File Name.csv)/$value

you need to use site URL as same used https://[your_site_url]/_layouts/15/appinv.aspx

However the My Folder name needs to be with the all the content after tenantname.sharepoint.com address

for example:

https://tenantname.sharepoint.com/teams/teamname/_api/web/GetFileByServerRelativeUrl('/teams/teamname/...')/$value

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.