Visual Basic 6.0

Search for Files in Google Drive

See more Google Drive Examples

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. Visual Basic 6.0

Dim success As Long
success = 0

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

Dim gAuth As New ChilkatAuthGoogle
gAuth.AccessToken = "GOOGLE-DRIVE-ACCESS-TOKEN"

Dim rest As New ChilkatRest

' Connect using TLS.
Dim bAutoReconnect As Long
bAutoReconnect = 1
success = rest.Connect("www.googleapis.com",443,1,bAutoReconnect)

' Provide the authentication credentials (i.e. the access token)
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 New ChilkatJsonObject
Dim i As Long
Dim numFiles As Long

' Send the request for the 1st page.
Dim jsonResponse As String
jsonResponse = rest.FullRequestNoBody("GET","/drive/v3/files")

Dim pageNumber As Long
pageNumber = 1
Dim pageToken As String
Dim bContinueLoop As Long
bContinueLoop = rest.LastMethodSuccess And (rest.ResponseStatusCode = 200)

Do While bContinueLoop = 1

    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 = 0
    Dim bHasMorePages As Long
    bHasMorePages = json.LastMethodSuccess
    If (bHasMorePages = 1) 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 <> 1) 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