Upload file to SharePoint drive using Microsoft Graph

In order to get all the files of a drive using v1.0, you would first need to get an access token, then get the ‘drive-id’ and use the following URL (note: it is ‘drives’ not ‘drive’): https://graph.microsoft.com/v1.0/drives/{drive-id}/root/children To get the drive id, make the following GET request using postman, this will list all the drives … Read more

Upload a file to SharePoint through the built-in web services

Example of using the WSS “Copy” Web service to upload a document to a library… public static void UploadFile2007(string destinationUrl, byte[] fileData) { // List of desination Urls, Just one in this example. string[] destinationUrls = { Uri.EscapeUriString(destinationUrl) }; // Empty Field Information. This can be populated but not for this example. SharePoint2007CopyService.FieldInformation information = … Read more

Get the content of a sharepoint folder with Excel VBA

The only way I’ve found to work with files on SharePoint while having to server rights is to map the WebDAV folder to a drive letter. Here’s an example for the implementation. Add references to the following ActiveX libraries in VBA: Windows Script Host Object Model (wshom.ocx) – for WshNetwork Microsoft Scripting Runtime (scrrun.dll) – … Read more

tech