(VBScript) 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.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

success = 1

' 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.

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.AuthGoogle")
set gAuth = CreateObject("Chilkat.AuthGoogle")
gAuth.AccessToken = "GOOGLE-DRIVE-ACCESS-TOKEN"

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Rest")
set rest = CreateObject("Chilkat.Rest")

' Connect using TLS.
bAutoReconnect = 1
success = rest.Connect("www.googleapis.com",443,1,bAutoReconnect)

' Provide the authentication credentials (i.e. the access token)
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")

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = CreateObject("Chilkat.JsonObject")

' Send the request for the 1st page.
jsonResponse = rest.FullRequestNoBody("GET","/drive/v3/files")

pageNumber = 1

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

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringArray")
set saFileIds = CreateObject("Chilkat.StringArray")

Do While bContinueLoop = 1

    outFile.WriteLine("---- 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")
        outFile.WriteLine("name: " & json.StringOf("files[i].name"))
        outFile.WriteLine("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 = 0
    bHasMorePages = json.LastMethodSuccess
    If (bHasMorePages = 1) 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 <> 1) Then
    outFile.WriteLine(rest.LastErrorText)
    WScript.Quit
End If

' A successful response will have a status code equal to 200.
If (rest.ResponseStatusCode <> 200) Then
    outFile.WriteLine("response status code = " & rest.ResponseStatusCode)
    outFile.WriteLine("response status text = " & rest.ResponseStatusText)
    outFile.WriteLine("response header: " & rest.ResponseHeader)
    outFile.WriteLine("response JSON: " & jsonResponse)
    WScript.Quit
End If

' OK, we have the full list of files.  Delete each..
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder")
set sbPath = CreateObject("Chilkat.StringBuilder")
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 <> 1) Then
        outFile.WriteLine(rest.LastErrorText)
        WScript.Quit
    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
        outFile.WriteLine("response status code = " & rest.ResponseStatusCode)
        outFile.WriteLine("response status text = " & rest.ResponseStatusText)
        outFile.WriteLine("response header: " & rest.ResponseHeader)
        outFile.WriteLine("response JSON: " & jsonResponse)
        WScript.Quit
    End If

    i = i + 1
    outFile.WriteLine(i & ": Deleted " & fileId)
Loop

outFile.WriteLine("All Files Deleted.")

outFile.Close