Hi,
i have to read an Excel-file from a Sharepoint-Site. The Authentication Method is Kerbeos.
Any suggestions ?
Barbara
Userlevel 4
- 8170 replies
-
23 June 2020
Currently, the easiest is probably to map the Sharepoint site as a network drive, then read the Excel file from there. Example: https://www.clouddirect.net/knowledge-base/KB0011543/mapping-a-sharepoint-site-as-a-network-drive
Safe is currently working on a SharepointConnector transformer that will allow you to read and write files directly to Sharepoint, but it's still in development.
@barbara @david_r
The new transformer we are working on is the SharepointOnlineConnector which will allow the listing, download, upload, and deletion of files in Sharepoint Online via Microsoft Graph API.
I am adding this to just clarify that the upcoming transformer is targeting Sharepoint Online only for now which might not necessarily fit this particular use case (e.g. no support for Kerberos).
If at all possible we might be looking into leveraging Microsoft Graph endpoints for Sharepoint on-premise solutions to expand the capabilities in the future. But currently, this is not planned.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.