question

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 asked KranthiPakala-MSFT edited

Copy file from Azure SQL to sharepoint

Hello,
We have a requirement wherein we need to copy a file into Sharepoint library from Azure SQL.
Is it possible via ADF?
We were able to implement copying files from Sharepoint to blob but vice versa is not possible as we do not have http connector as Sink.

azure-data-factory
· 1
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.

Please check if this can be done in Logic Apps..

0 Votes 0 ·
KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @Nandanhegde-7720,

Thanks for the ask. As mentioned in the Supported data stores and formats document currently ADF doesn't support Sharepoint/HTTP as sink. As @VaibhavChaudhari suggested you can give a try with Logic Apps or you can write your own code and use it in Custom Activity of ADF.

Here are few related existing feedback threads, please feel free to upvote and share your thoughts.

  1. https://feedback.azure.com/forums/270578-data-factory/suggestions/42971007-support-sharepoint-folder-as-a-sink

  2. https://feedback.azure.com/forums/270578-data-factory/suggestions/40236256-copy-a-file-from-a-blob-to-sharepoint

  3. https://feedback.azure.com/forums/270578-data-factory/suggestions/31943653-sharepoint-list-destination

I have also shared this feedback internally to the product team, will keep this thread updated if I hear back anything on the same.

Thank you



Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.







· 1
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 @Nandanhegde-7720,

Checking to see if the above info was helpful. Do let us know if you have further query.

Thanks

0 Votes 0 ·
JianleiShen-MSFT avatar image
0 Votes"
JianleiShen-MSFT answered JianleiShen-MSFT edited

@NandanHegde-7720 We currently doesn't have plan to support SharePoint as sink. Our plan is to support SharePoint as source first in 2H. we keep watching this demand but not yet n our plan as for now.

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.