(Excel) Create a File in a Folder

Creates (uploads) a file to be located in a particular folder.

See Google Drive Files: create for more details.

Also See Google Drive Multipart Upload for more details.

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.

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

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.AppendString("name","testHello.txt")
success = json.AppendString("description","A simple file that says Hello World.")
success = json.AppendString("mimeType","text/plain")

' To place the file in a folder, we must add a parents[] array to the JSON
' and list the folder id's.  It's possible for a file to be in multiple folders at once
' if it has more than one parent.  If no parents are specified, then the file is created
' in the My Drive folder.  
' Note: We'll assume we already have the id if the folder.  It is the id's that are specified here,
' not the folder names.

Set parents = json.AppendArray("parents")

folderId = "0B53Q6OSTWYolY2tPU1BnYW02T2c"
success = parents.AddStringAt(-1,folderId)

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

' The 2nd part is the file content, which will contain "Hello World!"
rest.PartSelector = "2"
success = rest.AddHeader("Content-Type","text/plain")


fileContents = "Hello World!"
success = rest.SetMultipartBodyString(fileContents)


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

' Show the JSON response.
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": "Untitled",
'   "mimeType": "text/plain"
' }

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