(Excel) Delete All Files

Permanently deletes all files owned by the user without moving it to the trash.

This example works by first getting a list of all fileIds, and then iterating over the list to delete each file.

See Google Drive Files delete for more information.

Download Excel Class Modules Chilkat Excel Class Modules

success = True

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

' This example uses a previously obtained access token having permission for the 
' Google Drive scope.

Dim gAuth As Chilkat.AuthGoogle
Set gAuth = Chilkat.NewAuthGoogle
gAuth.AccessToken = "GOOGLE-DRIVE-ACCESS-TOKEN"

Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest

' Connect using TLS.

bAutoReconnect = True
success = rest.Connect("www.googleapis.com",443,True,bAutoReconnect)

' Provide the authentication credentials (i.e. the access token)
Dim success As Boolean
success = rest.SetAuthGoogle(gAuth)

' Get 10 results per page for testing.  (The default page size is 100, with a max of 1000.
success = rest.AddQueryParam("pageSize","10")

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject

' Send the request for the 1st page.

jsonResponse = rest.FullRequestNoBody("GET","/drive/v3/files")


pageNumber = 1


bContinueLoop = rest.LastMethodSuccess And (rest.ResponseStatusCode = 200)

Dim saFileIds As Chilkat.StringArray
Set saFileIds = Chilkat.NewStringArray

Do While bContinueLoop = True

    Debug.Print "---- Page "; pageNumber; " ----"
    success = json.Load(jsonResponse)

    numFiles = json.SizeOfArray("files")
    i = 0
    Do While i < numFiles
        json.I = i
        fileId = json.StringOf("files[i].id")
        Debug.Print "name: "; json.StringOf("files[i].name")
        Debug.Print "id: "; fileId
        success = saFileIds.Append(fileId)
        i = i + 1
    Loop

    ' Get the next page of files.
    ' If the "nextPageToken" is present in the JSON response, then use it in the "pageToken" parameter
    ' for the next request.   If no "nextPageToken" was present, then this was the last page of files.
    pageToken = json.StringOf("nextPageToken")
    bContinueLoop = False

    bHasMorePages = json.LastMethodSuccess
    If (bHasMorePages = True) Then
        success = rest.ClearAllQueryParams()
        success = rest.AddQueryParam("pageSize","10")
        success = rest.AddQueryParam("pageToken",pageToken)
        jsonResponse = rest.FullRequestNoBody("GET","/drive/v3/files")
        bContinueLoop = rest.LastMethodSuccess And (rest.ResponseStatusCode = 200)
        pageNumber = pageNumber + 1
    End If

Loop

' Before actually deleting, check for errors...
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' A successful response will have a status code equal to 200.
If (rest.ResponseStatusCode <> 200) Then
    Debug.Print "response status code = "; rest.ResponseStatusCode
    Debug.Print "response status text = "; rest.ResponseStatusText
    Debug.Print "response header: "; rest.ResponseHeader
    Debug.Print "response JSON: "; jsonResponse
    Exit Sub
End If

' OK, we have the full list of files.  Delete each..
Dim sbPath As Chilkat.StringBuilder
Set sbPath = Chilkat.NewStringBuilder
numFiles = saFileIds.Count
i = 0
Do While i < numFiles
    fileId = saFileIds.GetString(i)

    success = rest.ClearAllQueryParams()

    sbPath.Clear 
    success = sbPath.Append("/drive/v3/files/")
    success = sbPath.Append(fileId)

    jsonResponse = rest.FullRequestNoBody("DELETE",sbPath.GetAsString())
    If (rest.LastMethodSuccess <> True) Then
        Debug.Print rest.LastErrorText
        Exit Sub
    End If

    ' A successful response will have a status code equal to 204 and the response body is empty.
    ' (If not successful, then there should be a JSON response body with information..)
    If (rest.ResponseStatusCode <> 204) Then
        Debug.Print "response status code = "; rest.ResponseStatusCode
        Debug.Print "response status text = "; rest.ResponseStatusText
        Debug.Print "response header: "; rest.ResponseHeader
        Debug.Print "response JSON: "; jsonResponse
        Exit Sub
    End If

    i = i + 1
    Debug.Print i; ": Deleted "; fileId
Loop

Debug.Print "All Files Deleted."