(Excel) Search for Files in Google Drive

This example follows the same methodology for listing all files in Google Drive in pages, but applies a search filter. It shows how to apply a query parameter for filtering the file results. See the Google Drive Files list for more optional HTTP parameters.

Download Excel Class Modules Chilkat Excel Class Modules

success = True

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

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

' Our search filter is to list all files containing ".jpg" (i.e. all JPG image files)
success = rest.AddQueryParam("q","name contains '.jpg'")

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

' 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","5")
        success = rest.AddQueryParam("pageToken",pageToken)
        success = rest.AddQueryParam("q","name contains '.jpg'")

        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