Excel Google Drive: List Team Drives

Back to Index

Lists the user's Team Drives.

Documentation: https://developers.google.com/drive/v3/reference/teamdrives/list

Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest

'   Provide a previously obtained OAuth2 access token.
Dim oauth2 As Chilkat.OAuth2
Set oauth2 = Chilkat.NewOAuth2
oauth2.AccessToken = "OAUTH2_ACCESS_TOKEN"
success = rest.SetAuthOAuth2(oauth2)

success = rest.Connect("www.googleapis.com",443,True,True)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

Dim sbJson As Chilkat.StringBuilder
Set sbJson = Chilkat.NewStringBuilder
success = rest.FullRequestNoBodySb("GET","/drive/v3/teamdrives",sbJson)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

If (rest.ResponseStatusCode <> 200) Then
    Debug.Print "Received error response code: "; rest.ResponseStatusCode
    Debug.Print "Response body:"
    Debug.Print sbJson.GetAsString()
    Exit Sub
End If

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.LoadSb(sbJson)

'  The following code parses the JSON response.
'  A sample JSON response is shown below the sample code.

kind = json.StringOf("kind")
i = 0
count_i = json.SizeOfArray("teamDrives")
Do While i < count_i
    json.I = i
    kind = json.StringOf("teamDrives[i].kind")
    id = json.StringOf("teamDrives[i].id")
    name = json.StringOf("teamDrives[i].name")
    i = i + 1
Loop

Debug.Print "Example Completed."

Sample JSON Response Body

{
  "kind": "drive#teamDriveList",
  "teamDrives": [
    {
      "kind": "drive#teamDrive",
      "id": "0AEd3EhGff2SaUk9PVA",
      "name": "Project Pegasus"
    },
    {
      "kind": "drive#teamDrive",
      "id": "0AGO-j6qTGkqgUk9PVA",
      "name": "Project Unicorn"
    }
  ]
}