Visual FoxPro

Delete All Files

See more Google Drive Examples

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.

Visual FoxPro

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 = 0

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.

loGAuth = CreateObject('Chilkat.AuthGoogle')
loGAuth.AccessToken = "GOOGLE-DRIVE-ACCESS-TOKEN"

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")

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)

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