(Visual Basic 6.0) List Files in Google Drive

Demonstrates how to list files in Google Drive.

See Google Drive Files list for more optional HTTP parameters.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

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

' This uses the Google Drive V3 API... (not V2)
Dim jsonResponse As String
jsonResponse = rest.FullRequestNoBody("GET","/drive/v3/files")
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 "request header = " & rest.LastRequestHeader
    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

' A successful response looks like this:
' {
'  "kind": "drive#fileList",
'  "files": [
'    {
'      "kind": "drive#file",
'      "id": "0B53Q6OSTWYolenpjTEU4ekJlQUU",
'      "name": "test",
'      "mimeType": "application/vnd.google-apps.folder"
'    },
'    {
'      "kind": "drive#file",
'      "id": "0B53Q6OSTWYolRm4ycjZtdXhRaEE",
'      "name": "starfish4.jpg",
'      "mimeType": "image/jpeg"
'    },
'    {
'      "kind": "drive#file",
'      "id": "0B53Q6OSTWYolMWt2VzN0Qlo1UjA",
'      "name": "hamlet2.xml",
'      "mimeType": "text/xml"
'    },
' ...
'    {
'      "kind": "drive#file",
'      "id": "0B53Q6OSTWYolc3RhcnRlcl9maWxlX2Rhc2hlclYw",
'      "name": "Getting started",
'      "mimeType": "application/pdf"
'    }
'  ]
' }

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

' Show the full JSON response.
json.EmitCompact = 0
Debug.Print json.Emit()

Dim numFiles As Long
numFiles = json.SizeOfArray("files")
Dim i As Long
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