(DataFlex) 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

Use ChilkatAx-win32.pkg

Procedure Test
    Boolean iSuccess
    Variant vGAuth
    Handle hoGAuth
    Handle hoRest
    Boolean iBAutoReconnect
    Handle hoJson
    Integer i
    Integer iNumFiles
    String sJsonResponse
    Integer iPageNumber
    String sPageToken
    Boolean iBContinueLoop
    String sFileId
    Handle hoSaFileIds
    Boolean iBHasMorePages
    Handle hoSbPath
    String sTemp1
    Integer iTemp1
    Boolean bTemp1

    Move True To iSuccess

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

    Get Create (RefClass(cComChilkatAuthGoogle)) To hoGAuth
    If (Not(IsComObjectCreated(hoGAuth))) Begin
        Send CreateComObject of hoGAuth
    End
    Set ComAccessToken Of hoGAuth To "GOOGLE-DRIVE-ACCESS-TOKEN"

    Get Create (RefClass(cComChilkatRest)) To hoRest
    If (Not(IsComObjectCreated(hoRest))) Begin
        Send CreateComObject of hoRest
    End

    // Connect using TLS.
    Move True To iBAutoReconnect
    Get ComConnect Of hoRest "www.googleapis.com" 443 True iBAutoReconnect To iSuccess

    // Provide the authentication credentials (i.e. the access token)
    Get pvComObject of hoGAuth to vGAuth
    Get ComSetAuthGoogle Of hoRest vGAuth To iSuccess

    // Get 10 results per page for testing.  (The default page size is 100, with a max of 1000.
    Get ComAddQueryParam Of hoRest "pageSize" "10" To iSuccess

    Get Create (RefClass(cComChilkatJsonObject)) To hoJson
    If (Not(IsComObjectCreated(hoJson))) Begin
        Send CreateComObject of hoJson
    End

    // Send the request for the 1st page.
    Get ComFullRequestNoBody Of hoRest "GET" "/drive/v3/files" To sJsonResponse

    Move 1 To iPageNumber

    Get ComLastMethodSuccess Of hoRest To bTemp1
    Get ComResponseStatusCode Of hoRest To iTemp1
    Move (bTemp1 And (iTemp1 = 200)) To iBContinueLoop

    Get Create (RefClass(cComCkStringArray)) To hoSaFileIds
    If (Not(IsComObjectCreated(hoSaFileIds))) Begin
        Send CreateComObject of hoSaFileIds
    End

    While (iBContinueLoop = True)

        Showln "---- Page " iPageNumber " ----"
        Get ComLoad Of hoJson sJsonResponse To iSuccess

        Get ComSizeOfArray Of hoJson "files" To iNumFiles
        Move 0 To i
        While (i < iNumFiles)
            Set ComI Of hoJson To i
            Get ComStringOf Of hoJson "files[i].id" To sFileId
            Get ComStringOf Of hoJson "files[i].name" To sTemp1
            Showln "name: " sTemp1
            Showln "id: " sFileId
            Get ComAppend Of hoSaFileIds sFileId To iSuccess
            Move (i + 1) To i
        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.
        Get ComStringOf Of hoJson "nextPageToken" To sPageToken
        Move False To iBContinueLoop
        Get ComLastMethodSuccess Of hoJson To iBHasMorePages
        If (iBHasMorePages = True) Begin
            Get ComClearAllQueryParams Of hoRest To iSuccess
            Get ComAddQueryParam Of hoRest "pageSize" "10" To iSuccess
            Get ComAddQueryParam Of hoRest "pageToken" sPageToken To iSuccess
            Get ComFullRequestNoBody Of hoRest "GET" "/drive/v3/files" To sJsonResponse
            Get ComLastMethodSuccess Of hoRest To bTemp1
            Get ComResponseStatusCode Of hoRest To iTemp1
            Move (bTemp1 And (iTemp1 = 200)) To iBContinueLoop
            Move (iPageNumber + 1) To iPageNumber
        End

    Loop

    // Before actually deleting, check for errors...
    Get ComLastMethodSuccess Of hoRest To bTemp1
    If (bTemp1 <> True) Begin
        Get ComLastErrorText Of hoRest To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    // A successful response will have a status code equal to 200.
    Get ComResponseStatusCode Of hoRest To iTemp1
    If (iTemp1 <> 200) Begin
        Get ComResponseStatusCode Of hoRest To iTemp1
        Showln "response status code = " iTemp1
        Get ComResponseStatusText Of hoRest To sTemp1
        Showln "response status text = " sTemp1
        Get ComResponseHeader Of hoRest To sTemp1
        Showln "response header: " sTemp1
        Showln "response JSON: " sJsonResponse
        Procedure_Return
    End

    // OK, we have the full list of files.  Delete each..
    Get Create (RefClass(cComChilkatStringBuilder)) To hoSbPath
    If (Not(IsComObjectCreated(hoSbPath))) Begin
        Send CreateComObject of hoSbPath
    End
    Get ComCount Of hoSaFileIds To iNumFiles
    Move 0 To i
    While (i < iNumFiles)
        Get ComGetString Of hoSaFileIds i To sFileId

        Get ComClearAllQueryParams Of hoRest To iSuccess

        Send ComClear To hoSbPath
        Get ComAppend Of hoSbPath "/drive/v3/files/" To iSuccess
        Get ComAppend Of hoSbPath sFileId To iSuccess

        Get ComGetAsString Of hoSbPath To sTemp1
        Get ComFullRequestNoBody Of hoRest "DELETE" sTemp1 To sJsonResponse
        Get ComLastMethodSuccess Of hoRest To bTemp1
        If (bTemp1 <> True) Begin
            Get ComLastErrorText Of hoRest To sTemp1
            Showln sTemp1
            Procedure_Return
        End

        // 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..)
        Get ComResponseStatusCode Of hoRest To iTemp1
        If (iTemp1 <> 204) Begin
            Get ComResponseStatusCode Of hoRest To iTemp1
            Showln "response status code = " iTemp1
            Get ComResponseStatusText Of hoRest To sTemp1
            Showln "response status text = " sTemp1
            Get ComResponseHeader Of hoRest To sTemp1
            Showln "response header: " sTemp1
            Showln "response JSON: " sJsonResponse
            Procedure_Return
        End

        Move (i + 1) To i
        Showln i ": Deleted " sFileId
    Loop

    Showln "All Files Deleted."


End_Procedure