(Visual FoxPro) Search for Files in Google Drive

This example follows the same methodology for listing all files in Google Drive in pages, but applies a search filter. It shows how to apply a query parameter for filtering the file results. See the Google Drive Files list for more optional HTTP parameters.

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

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

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.AuthGoogle')
loGAuth = CreateObject('Chilkat.AuthGoogle')
loGAuth.AccessToken = "GOOGLE-DRIVE-ACCESS-TOKEN"

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Rest')
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")

* Our search filter is to list all files containing ".jpg" (i.e. all JPG image files)
loRest.AddQueryParam("q","name contains '.jpg'")

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
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)

    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)
        loRest.AddQueryParam("q","name contains '.jpg'")

        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

RELEASE loGAuth
RELEASE loRest
RELEASE loJson