Is it possible to export documents or other content from SharePoint online using a workflow (or other method) to an external location?
The recipient will likely be an ftp location, and won't be an email address - the idea is to have a daily export.
-
You would need to use a remote event receiver most likely to do this, msdn.microsoft.com/en-us/library/office/dn456315.aspx – Eric Alexander Aug 4 '15 at 15:38
-
See this RER documentation for SPOline. If its only a daily export you might want to take the PowerShell approach to extract documents and dump them someplace else. It keeps the logic out of SharePoint and is easier to understand/maintain for admins. – Danny '365CSI' Engelman Aug 4 '15 at 15:48
-
You can create a console application and schedule it daily by converting it to a windows service. – Akhoy Aug 4 '15 at 18:11
I would suggest to use power shell with CSOM for SharePoint online which is the best and efficient way to handle these kind of automation's.
overall solution will be:
writing a windows powershell script leveraging CSOM for accessing sharepoint resources and then connect to FTP/SFTP to trasfer the documents.
powershell based CSOM references
finally, schedule this script as a task with in the task scheduler of windows server.
You can create a Microsoft Flow that run each time a file is created or modified to copy it in a FTP folder.
