(Excel) Google Drive Multipart Upload String

Demonstrates a file upload to Google Drive where the contents of the file are contained in a string variable.

Download Excel Class Modules Chilkat Excel Class Modules

' This example will upload a file to Google Drive.

success = True

' It requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim gAuth As Chilkat.AuthGoogle
Set gAuth = Chilkat.NewAuthGoogle
gAuth.Scope = "https://www.googleapis.com/auth/drive"
gAuth.SubEmailAddress = "some.user@example.com"
gAuth.ExpireNumSeconds = 3600

' Obtain an access token as shown in one of the following examples:
' See Get Access Token using a Service Account JSON Key
' See Get Access Token using a P12 File

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 key)
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")

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.AddStringAt(-1,"title","helloWorld.txt")
success = json.AddStringAt(-1,"description","A simple text file that says Hello World.")
success = json.AddStringAt(-1,"mimeType","text/plain")
success = rest.SetMultipartBodyString(json.Emit())

' The 2nd part is the file content.
' In this case, we'll upload a simple text file containing "Hello World!"
rest.PartSelector = "2"
success = rest.AddHeader("Content-Type","text/plain")
success = rest.SetMultipartBodyString("Hello World!")

' POST https://www.googleapis.com/upload/drive/v2/files

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

' Show the JSON response.
Debug.Print "Response Status Code: "; rest.ResponseStatusCode
Debug.Print "Json Response: "; jsonResponse