(Excel) OneDrive -- Delete a File or Folder

See more OneDrive Examples

Demonstrates how to delete a file, folder, or any DriveItem.

Note: This example requires Chilkat v9.5.0.68 or greater.

Download Excel Class Modules Chilkat Excel Class Modules

' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' Use your previously obtained access token here:
' See the following examples for getting an access token:
'    Get Microsoft Graph OAuth2 Access Token (Azure AD v2.0 Endpoint).
'    Get Microsoft Graph OAuth2 Access Token (Azure AD Endpoint).
'    Refresh Access Token (Azure AD v2.0 Endpoint).
'    Refresh Access Token (Azure AD Endpoint).

' (Make sure your token was obtained with the Files.ReadWrite scope.)
http.AuthToken = "MICROSOFT_GRAPH_ACCESS_TOKEN"

' To delete a file or folder, send a DELETE request like this:
' If not using "me", then the URL path should be /v1.0/users/{id | userPrincipalName}/...
' DELETE /v1.0/me/drive/root:/{item-path}

Dim success As Boolean
success = http.SetUrlVar("item_path","someFolder/sample.pdf")

resp = http.QuickDeleteStr("https://graph.microsoft.com/v1.0/me/drive/root:/{$item_path}")
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' A 204 response (with no response body) indicates success.
If (http.LastStatus = 204) Then
    Debug.Print "DriveItem deleted."
Else
    Debug.Print "DriveItem not deleted."
    Debug.Print resp
End If