VBScript Google Drive: Create a New Comment on a File

Back to Index

Creates a new comment on a file. The file is specified by file ID. This example creates a comment on the file having id = "0B5drHSd5ZHwgc3RhcnRlcl9maWxlX2Rhc2hlclYw".

Documentation: https://developers.google.com/drive/v3/reference/comments/create

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
Set outFile = fso.CreateTextFile("output.txt", True)

set rest = CreateObject("Chilkat_9_5_0.Rest")

'   Provide a previously obtained OAuth2 access token.
set oauth2 = CreateObject("Chilkat_9_5_0.OAuth2")
oauth2.AccessToken = "OAUTH2_ACCESS_TOKEN"
success = rest.SetAuthOAuth2(oauth2)

success = rest.Connect("www.googleapis.com",443,1,1)
If (success <> 1) Then
    outFile.WriteLine(rest.LastErrorText)
    WScript.Quit
End If

success = rest.AddQueryParam("fields","author,content")

'  The following code creates the JSON request body.
'  The JSON created by this code is shown below.
set jsonReq = CreateObject("Chilkat_9_5_0.JsonObject")
success = jsonReq.UpdateString("content","This is a test comment about this file...")

set sbReq = CreateObject("Chilkat_9_5_0.StringBuilder")
success = jsonReq.EmitSb(sbReq)

success = rest.AddHeader("Content-Type","application/json")

set sbJson = CreateObject("Chilkat_9_5_0.StringBuilder")
success = rest.FullRequestSb("POST","/drive/v3/files/0B5drHSd5ZHwgc3RhcnRlcl9maWxlX2Rhc2hlclYw/comments",sbReq,sbJson)
If (success <> 1) Then
    outFile.WriteLine(rest.LastErrorText)
    WScript.Quit
End If

If (rest.ResponseStatusCode <> 200) Then
    outFile.WriteLine("Received error response code: " & rest.ResponseStatusCode)
    outFile.WriteLine("Response body:")
    outFile.WriteLine(sbJson.GetAsString())
    WScript.Quit
End If

set json = CreateObject("Chilkat_9_5_0.JsonObject")
success = json.LoadSb(sbJson)

'  The following code parses the JSON response.
'  A sample JSON response is shown below the sample code.

authorKind = json.StringOf("author.kind")
authorDisplayName = json.StringOf("author.displayName")
authorPhotoLink = json.StringOf("author.photoLink")
authorMe = json.BoolOf("author.me")
content = json.StringOf("content")

outFile.WriteLine("Example Completed.")

outFile.Close

Sample JSON Request Body

{
  "content": "This is a test comment about this file..."
}

Sample JSON Response Body

{
  "author": {
    "kind": "drive#user",
    "displayName": "Matt Fausey",
    "photoLink": "//ssl.gstatic.com/s2/profiles/images/silhouette96.png",
    "me": true
  },
  "content": "This is a test comment about this file..."
}