Visual FoxPro

List all Pages of Files in Google Drive

See more Google Drive Examples

Demonstrates how iterate over pages 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 loJson
LOCAL i
LOCAL lnNumFiles
LOCAL lcJsonResponse
LOCAL lnPageNumber
LOCAL lcPageToken
LOCAL lnBContinueLoop
LOCAL lnBHasMorePages

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 5 results per page for testing.  (The default page size is 100, with a max of 1000.
loRest.AddQueryParam("pageSize","5")

loJson = CreateObject('Chilkat.JsonObject')

* Send the request for the 1st page.
lcJsonResponse = loRest.FullRequestNoBody("GET","/drive/v3/files")

lnPageNumber = 1

lnBContinueLoop = loRest.LastMethodSuccess AND (loRest.ResponseStatusCode = 200)

DO WHILE lnBContinueLoop = 1

    ? "---- Page " + STR(lnPageNumber) + " ----"

    * Iterate over each file in the response and show the name, id, and mimeType.
    loJson.Load(lcJsonResponse)

    * See the sample JSON response at the bottom of this example.
    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

    * 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.
    lcPageToken = loJson.StringOf("nextPageToken")
    lnBContinueLoop = 0
    lnBHasMorePages = loJson.LastMethodSuccess
    IF (lnBHasMorePages = 1) THEN
        loRest.ClearAllQueryParams()
        loRest.AddQueryParam("pageSize","5")
        loRest.AddQueryParam("pageToken",lcPageToken)
        lcJsonResponse = loRest.FullRequestNoBody("GET","/drive/v3/files")
        lnBContinueLoop = loRest.LastMethodSuccess AND (loRest.ResponseStatusCode = 200)
        lnPageNumber = lnPageNumber + 1
    ENDIF

ENDDO

IF (loRest.LastMethodSuccess <> 1) THEN
    ? loRest.LastErrorText
    RELEASE loGAuth
    RELEASE loRest
    RELEASE loJson
    CANCEL
ENDIF

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

* A successful JSON 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"
*    }
*  ]
* }

RELEASE loGAuth
RELEASE loRest
RELEASE loJson