(Visual FoxPro) 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

LOCAL lnSuccess
LOCAL loGAuth
LOCAL loRest
LOCAL lnBAutoReconnect
LOCAL loJson
LOCAL i
LOCAL lnNumFiles
LOCAL lcJsonResponse
LOCAL lnPageNumber
LOCAL lcPageToken
LOCAL lnBContinueLoop
LOCAL lcFileId
LOCAL loSaFileIds
LOCAL lnBHasMorePages
LOCAL loSbPath

lnSuccess = 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')
loGAuth = CreateObject('Chilkat.AuthGoogle')
loGAuth.AccessToken = "GOOGLE-DRIVE-ACCESS-TOKEN"

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Rest')
loRest = CreateObject('Chilkat.Rest')

* Connect using TLS.
lnBAutoReconnect = 1
lnSuccess = loRest.Connect("www.googleapis.com",443,1,lnBAutoReconnect)

* Provide the authentication credentials (i.e. the access token)
loRest.SetAuthGoogle(loGAuth)

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

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJson = CreateObject('Chilkat.JsonObject')

* Send the request for the 1st page.
lcJsonResponse = loRest.FullRequestNoBody("GET","/drive/v3/files")

lnPageNumber = 1

lnBContinueLoop = loRest.LastMethodSuccess AND (loRest.ResponseStatusCode = 200)

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.StringArray')
loSaFileIds = CreateObject('Chilkat.StringArray')

DO WHILE lnBContinueLoop = 1

    ? "---- Page " + STR(lnPageNumber) + " ----"
    loJson.Load(lcJsonResponse)

    lnNumFiles = loJson.SizeOfArray("files")
    i = 0
    DO WHILE i < lnNumFiles
        loJson.I = i
        lcFileId = loJson.StringOf("files[i].id")
        ? "name: " + loJson.StringOf("files[i].name")
        ? "id: " + lcFileId
        loSaFileIds.Append(lcFileId)
        i = i + 1
    ENDDO

    * 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.
    lcPageToken = loJson.StringOf("nextPageToken")
    lnBContinueLoop = 0
    lnBHasMorePages = loJson.LastMethodSuccess
    IF (lnBHasMorePages = 1) THEN
        loRest.ClearAllQueryParams()
        loRest.AddQueryParam("pageSize","10")
        loRest.AddQueryParam("pageToken",lcPageToken)
        lcJsonResponse = loRest.FullRequestNoBody("GET","/drive/v3/files")
        lnBContinueLoop = loRest.LastMethodSuccess AND (loRest.ResponseStatusCode = 200)
        lnPageNumber = lnPageNumber + 1
    ENDIF

ENDDO

* Before actually deleting, check for errors...
IF (loRest.LastMethodSuccess <> 1) THEN
    ? loRest.LastErrorText
    RELEASE loGAuth
    RELEASE loRest
    RELEASE loJson
    RELEASE loSaFileIds
    CANCEL
ENDIF

* A successful response will have a status code equal to 200.
IF (loRest.ResponseStatusCode <> 200) THEN
    ? "response status code = " + STR(loRest.ResponseStatusCode)
    ? "response status text = " + loRest.ResponseStatusText
    ? "response header: " + loRest.ResponseHeader
    ? "response JSON: " + lcJsonResponse
    RELEASE loGAuth
    RELEASE loRest
    RELEASE loJson
    RELEASE loSaFileIds
    CANCEL
ENDIF

* OK, we have the full list of files.  Delete each..
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.StringBuilder')
loSbPath = CreateObject('Chilkat.StringBuilder')
lnNumFiles = loSaFileIds.Count
i = 0
DO WHILE i < lnNumFiles
    lcFileId = loSaFileIds.GetString(i)

    loRest.ClearAllQueryParams()

    loSbPath.Clear()
    loSbPath.Append("/drive/v3/files/")
    loSbPath.Append(lcFileId)

    lcJsonResponse = loRest.FullRequestNoBody("DELETE",loSbPath.GetAsString())
    IF (loRest.LastMethodSuccess <> 1) THEN
        ? loRest.LastErrorText
        RELEASE loGAuth
        RELEASE loRest
        RELEASE loJson
        RELEASE loSaFileIds
        RELEASE loSbPath
        CANCEL
    ENDIF

    * 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 (loRest.ResponseStatusCode <> 204) THEN
        ? "response status code = " + STR(loRest.ResponseStatusCode)
        ? "response status text = " + loRest.ResponseStatusText
        ? "response header: " + loRest.ResponseHeader
        ? "response JSON: " + lcJsonResponse
        RELEASE loGAuth
        RELEASE loRest
        RELEASE loJson
        RELEASE loSaFileIds
        RELEASE loSbPath
        CANCEL
    ENDIF

    i = i + 1
    ? STR(i) + ": Deleted " + lcFileId
ENDDO

? "All Files Deleted."

RELEASE loGAuth
RELEASE loRest
RELEASE loJson
RELEASE loSaFileIds
RELEASE loSbPath