How do I get the base url for my sharepoint spreadsheet while I do a copy activity to adls

Question

Pravash 21

I'm copying a file from sharepoint to ADLS. When I have the source as HTTP->Excel, how can I find proper base url?

I've tried couple of combinations however, I have been getting this error,

1 answer

Answer 1

ShaikMaheer-MSFT 38,546 Microsoft Employee Moderator

Thank you for posting query in Microsoft Q&A Platform.

As per the below document which you are following, you should actually create linked service which is "Sharepoint Online List" connector.
https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory#copy-file-from-sharepoint-online

Sharepoint Online List connector will ask to provide Site URL details. Not base URL. Kindly check below screenshots for better idea.

The SharePoint Online site url, e.g. https://contoso.sharepoint.com/sites/siteName

Hope this will help. Please let us know if any further queries.

-------------------

Please consider hitting Accept Answer. Accepted answers helps community as well.

ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2022-02-01T16:32:41.437+00:00

Hi @Pravash ,

Just checking in to see if the below answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2022-02-07T16:55:40.193+00:00

Just checking in to see if the below answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.