(Excel) Google Drive - Upload File

This example demonstrates how to upload a file to Google Drive. The assumption is that the file can be loaded into memory and uploaded. It is also possible to stream large files to Google Drive, but the code required is a little more complex.

Download Excel Class Modules Chilkat Excel Class Modules

success = True

' This example 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. 
' See Get Google Drive OAuth2 Access Token

Dim gAuth As Chilkat.AuthGoogle
Set gAuth = Chilkat.NewAuthGoogle
gAuth.AccessToken = "GOOGLE_DRIVE_ACCESS_TOKEN"

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

' Connect using TLS.

bAutoReconnect = True
success = rest.Connect("www.googleapis.com",443,True,bAutoReconnect)

' Provide the authentication credentials (i.e. the access token)
Dim success As Boolean
success = rest.SetAuthGoogle(gAuth)

' -------------------------------------------------------------------------
' A multipart upload to Google Drive needs a multipart/related Content-Type
success = rest.AddHeader("Content-Type","multipart/related")

' Specify each part of the request.

' The 1st part is JSON with information about the file.
rest.PartSelector = "1"
success = rest.AddHeader("Content-Type","application/json; charset=UTF-8")

' Construct the JSON that will contain the metadata about the file data to be uploaded...
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.AppendString("name","starfish.jpg")
success = json.AppendString("description","A picture of a starfish.")
success = json.AppendString("mimeType","image/jpeg")

' To place the file in a folder, we must add a parents[] array to the JSON
' and add the folder ID.  
' In a previous example (see Lookup Google Drive Folder ID
' we showed how to find the folder ID for a folder in Google Drive.

' Use the folder ID we already looked up..

folderId = "1Fksv-TfA1ILii1YjXsNa1-rDu8Cdrg72"

Set parents = json.AppendArray("parents")
success = parents.AddStringAt(-1,folderId)

success = rest.SetMultipartBodyString(json.Emit())

' The 2nd part is the file content, which will contain the binary image data.
rest.PartSelector = "2"
success = rest.AddHeader("Content-Type","image/jpeg")

Dim jpgBytes As Chilkat.BinData
Set jpgBytes = Chilkat.NewBinData
success = jpgBytes.LoadFile("qa_data/jpg/starfish.jpg")

' Add the data to our upload
success = rest.SetMultipartBodyBd(jpgBytes)


jsonResponse = rest.FullRequestMultipart("POST","/upload/drive/v3/files?uploadType=multipart")
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' A successful response will have a status code equal to 200.
If (rest.ResponseStatusCode <> 200) Then
    Debug.Print "response status code = "; rest.ResponseStatusCode
    Debug.Print "response status text = "; rest.ResponseStatusText
    Debug.Print "response header: "; rest.ResponseHeader
    Debug.Print "response JSON: "; jsonResponse
    Exit Sub
End If

success = json.Load(jsonResponse)

' Show the full JSON response.
json.EmitCompact = False
Debug.Print json.Emit()

' A successful response looks like this:
' {
'   "kind": "drive#file",
'   "id": "0B53Q6OSTWYoldmJ0Z3ZqT2x5MFk",
'   "name": "starfish.jpg",
'   "mimeType": "image/jpeg"
' }

' Get the fileId:
Debug.Print "fileId: "; json.StringOf("id")