How to copy data from Sharepoint to azure adls Gen2?

Question

How to copy data from Sharepoint to azure adls Gen2?

Narayanan Sankara 1

How to copy data from Sharepoint to azure adls Gen2? I have tried to do it via the ADF using the below link.

https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory

But it doesn't seem to work as the Sharepoint access is granted by someone other than me and in ADF the base URL still says the link isn't trusted yet, maybe because it is not me that has granted the access.

Is there any other way to copy files from Sharepoint to Azure ADLS Gen2.? Please do let me know.

1 answer

Your answer

Answer 1

KranthiPakala-MSFT 46,642 Microsoft Employee Moderator

Hello @Narayanan Sankara ,

Thanks for the question and using MS Q&A platform.

In order to use ADF to copy file from Sharepoint Online to ADLS Gen2, then you will have to Register an application entity in Azure Active Directory. Then your Sharepoint site Admin (Site Admin Role) will have to Grant SharePoint Online site permission to your registered application by following the steps below:

Below are other Microsoft products which supports Sharepoint connectors and can be used to access data in Sharepoint.

For more info, please refer to below resources:

Hope this info helps.

Narayanan Sankara 1 Reputation point

2022-10-13T07:23:42.85+00:00

Hello @KranthiPakala-MSFT

The Sharepoint Admin has given the permissions and trusted the app. but when I try to give the basic URL:

https://[site-url]/_api/web/GetFileByServerRelativeUrl('[relative-path-to-file]')/$value

I get the following error.
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2022-10-17T19:50:57.42+00:00

Hello @Narayanan Sankara ,

Thanks for getting back. The error message clearly says not authorized which means either not relevant permissions are granted to your service principal or there is a chance that the access token being passed along with your request is incorrect.

How did you test the request? Is it through ADF or Postman or something else? In case if you haven't tried with Postman, I would recommend testing with it first and once a successful connection is established, it would be better implementing the same using ADF.

Please keep us posted how it goes with Postman testing.

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2022-10-19T06:08:21.773+00:00

Hello @Narayanan Sankara ,

Following up to check if you have got a chance to test the connection from POSTMAN? If so, could you please share your findings?

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2022-10-20T06:29:30.027+00:00

Hello @Narayanan Sankara ,

We still have not heard back from you. Just wanted to check if you have any update on the above additional test. Please let us know how it goes or if you need further assistance on this.

Thank you

Share via

How to copy data from Sharepoint to azure adls Gen2?

1 answer

Your answer