Visual FoxPro

List Files in Google Drive

See more Google Drive Examples

Demonstrates how to list files in Google Drive.

See Google Drive Files list for more optional HTTP parameters.

Visual FoxPro

LOCAL lnSuccess
LOCAL loGAuth
LOCAL loRest
LOCAL lnBAutoReconnect
LOCAL lcJsonResponse
LOCAL loJson
LOCAL lnNumFiles
LOCAL i

lnSuccess = 0

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

loGAuth = CreateObject('Chilkat.AuthGoogle')
loGAuth.AccessToken = "GOOGLE-DRIVE-ACCESS-TOKEN"

loRest = CreateObject('Chilkat.Rest')

* Connect using TLS.
lnBAutoReconnect = 1
lnSuccess = loRest.Connect("www.googleapis.com",443,1,lnBAutoReconnect)

* Provide the authentication credentials (i.e. the access token)
loRest.SetAuthGoogle(loGAuth)

* Get 4 results per page.  (The default page size is 100, with a max of 1000.
loRest.AddQueryParam("pageSize","4")

* This uses the Google Drive V3 API... (not V2)
lcJsonResponse = loRest.FullRequestNoBody("GET","/drive/v3/files")
IF (loRest.LastMethodSuccess <> 1) THEN
    ? loRest.LastErrorText
    RELEASE loGAuth
    RELEASE loRest
    CANCEL
ENDIF

* A successful response will have a status code equal to 200.
IF (loRest.ResponseStatusCode <> 200) THEN
    ? "request header = " + loRest.LastRequestHeader
    ? "response status code = " + STR(loRest.ResponseStatusCode)
    ? "response status text = " + loRest.ResponseStatusText
    ? "response header: " + loRest.ResponseHeader
    ? "response JSON: " + lcJsonResponse
    RELEASE loGAuth
    RELEASE loRest
    CANCEL
ENDIF

* 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.
loJson = CreateObject('Chilkat.JsonObject')
loJson.Load(lcJsonResponse)

* Show the full JSON response.
loJson.EmitCompact = 0
? loJson.Emit()

lnNumFiles = loJson.SizeOfArray("files")
i = 0
DO WHILE i < lnNumFiles
    loJson.I = i
    ? "name: " + loJson.StringOf("files[i].name")
    ? "id: " + loJson.StringOf("files[i].id")
    ? "mimeType: " + loJson.StringOf("files[i].mimeType")
    ? "-"
    i = i + 1
ENDDO

RELEASE loGAuth
RELEASE loRest
RELEASE loJson