VBScript Google Drive: List Files on a Team Drive

Back to Index

Retrieves a list of files for a particular team drive.

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


Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
Set outFile = fso.CreateTextFile("output.txt", True)

set rest = CreateObject("Chilkat_9_5_0.Rest")

'   Provide a previously obtained OAuth2 access token.
set oauth2 = CreateObject("Chilkat_9_5_0.OAuth2")
oauth2.AccessToken = "OAUTH2_ACCESS_TOKEN"
success = rest.SetAuthOAuth2(oauth2)

success = rest.Connect("www.googleapis.com",443,1,1)
If (success <> 1) Then
    outFile.WriteLine(rest.LastErrorText)
    WScript.Quit
End If

success = rest.AddQueryParam("teamDriveId","0AEd3EhGff2SaUk9PVA")
success = rest.AddQueryParam("includeTeamDriveItems","true")
success = rest.AddQueryParam("corpora","teamDrive")
success = rest.AddQueryParam("supportsTeamDrives","true")

set sbJson = CreateObject("Chilkat_9_5_0.StringBuilder")
success = rest.FullRequestNoBodySb("GET","/drive/v3/files",sbJson)
If (success <> 1) Then
    outFile.WriteLine(rest.LastErrorText)
    WScript.Quit
End If

If (rest.ResponseStatusCode <> 200) Then
    outFile.WriteLine("Received error response code: " & rest.ResponseStatusCode)
    outFile.WriteLine("Response body:")
    outFile.WriteLine(sbJson.GetAsString())
    WScript.Quit
End If

set json = CreateObject("Chilkat_9_5_0.JsonObject")
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")
incompleteSearch = json.BoolOf("incompleteSearch")
i = 0
count_i = json.SizeOfArray("files")
Do While i < count_i
    json.I = i
    kind = json.StringOf("files[i].kind")
    id = json.StringOf("files[i].id")
    name = json.StringOf("files[i].name")
    mimeType = json.StringOf("files[i].mimeType")
    teamDriveId = json.StringOf("files[i].teamDriveId")
    i = i + 1
Loop

outFile.WriteLine("Example Completed.")

outFile.Close

Sample JSON Response Body

{
  "kind": "drive#fileList",
  "incompleteSearch": false,
  "files": [
    {
      "kind": "drive#file",
      "id": "18UpPSa-c_OPNi2CXY05gkpjIzNAJyd4q",
      "name": "hedgehogs.jpg",
      "mimeType": "image/jpeg",
      "teamDriveId": "0AEd3EhGff2SaUk9PVA"
    },
    {
      "kind": "drive#file",
      "id": "1R_70heIyzIAu1_u0prXbYcaIiJRVkgBl",
      "name": "penguins.jpg",
      "mimeType": "image/jpeg",
      "teamDriveId": "0AEd3EhGff2SaUk9PVA"
    },
    {
      "kind": "drive#file",
      "id": "16MsxSRSz6ISRx1D_PXyA5Sj6aNFSEd4e",
      "name": "seahorse.jpg",
      "mimeType": "image/jpeg",
      "teamDriveId": "0AEd3EhGff2SaUk9PVA"
    },
    {
      "kind": "drive#file",
      "id": "1lT4TbeSSMtxgB2MmwE7-5i7vQaxhr6Ze",
      "name": "starfish2.jpg",
      "mimeType": "image/jpeg",
      "teamDriveId": "0AEd3EhGff2SaUk9PVA"
    },
    {
      "kind": "drive#file",
      "id": "1PVtx4SJB0n2GDcaJAbi_mSlQwXltYsx3",
      "name": "test",
      "mimeType": "application/vnd.google-apps.folder",
      "teamDriveId": "0AEd3EhGff2SaUk9PVA"
    }
  ]
}