(Excel) List all Folders

Demonstrates how to retrieve a list of all folders.

Note: Let's say we have a directory tree with the following folders in Google Drive:

/AAWorkArea
/AAWorkArea/FolderA
/AAWorkArea/FolderB
/Folder2
/Folder2/FolderA

This would be our result. Notice that the "name" of each folder is NOT the full path, but just the final folder name. To distinguish between the two FolderA's, we would need to get the parent information for each.

---- Page 1 ----
name: FolderB
id: 1ep8p9wsCV8S_xTI7G1-qEuf8RNO_9250
mimeType: application/vnd.google-apps.folder
-
name: FolderA
id: 1h_BWJGEn7L7aFV5SN8iOKv91uxddTbY8
mimeType: application/vnd.google-apps.folder
-
name: Folder2
id: 1cvDIF78KSDuUyrU_VCKRSRbmENWkHNqV
mimeType: application/vnd.google-apps.folder
-
name: AAWorkArea
id: 0BzXkF-yZEO0-ank3VndfZTZsdlk
mimeType: application/vnd.google-apps.folder
-
name: FolderA
id: 1Fksv-TfA1ILii1YjXsNa1-rDu8Cdrg72
mimeType: application/vnd.google-apps.folder
-

Download Excel Class Modules Chilkat Excel Class Modules

success = True

' This example 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 50 results per page for testing.  (The default page size is 100, with a max of 1000.
success = rest.AddQueryParam("pageSize","50")

' Get all entries that are folders.
success = rest.AddQueryParam("q","mimeType = 'application/vnd.google-apps.folder'")

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

' Send the request for the 1st page.

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


pageNumber = 1


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

Do While bContinueLoop = True

    Debug.Print "---- Page "; pageNumber; " ----"

    ' Iterate over each file in the response and show the name, id, and mimeType.
    success = json.Load(jsonResponse)

    numFiles = json.SizeOfArray("files")
    i = 0
    Do While i < numFiles
        json.I = i
        Debug.Print "name: "; json.StringOf("files[i].name")
        Debug.Print "id: "; json.StringOf("files[i].id")
        Debug.Print "mimeType: "; json.StringOf("files[i].mimeType")
        Debug.Print "-"
        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","50")
        success = rest.AddQueryParam("pageToken",pageToken)
        success = rest.AddQueryParam("q","mimeType = 'application/vnd.google-apps.folder'")

        jsonResponse = rest.FullRequestNoBody("GET","/drive/v3/files")
        bContinueLoop = rest.LastMethodSuccess And (rest.ResponseStatusCode = 200)
        pageNumber = pageNumber + 1
    End If

Loop

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