(Excel) OneDrive -- Streaming File Upload

See more OneDrive Examples

Uploads a local file by path to the signed-in user's OneDrive. This uses OneDrive's simple upload API to upload in a single API call. Uploading in this way only supports files up to 4MB in size. The 4MB limitation is a OneDrive limitation, not a Chilkat limitation. (See the other example(s) for uploading larger files.)

Note: This example requires Chilkat v9.5.0.68 or greater.

For more information, see https://docs.microsoft.com/en-us/onedrive/developer/rest-api/api/driveitem_put_content?view=odsp-graph-online

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' Use your previously obtained access token here:
' See the following examples for getting an access token:
'    Get Microsoft Graph OAuth2 Access Token (Azure AD v2.0 Endpoint).
'    Get Microsoft Graph OAuth2 Access Token (Azure AD Endpoint).
'    Refresh Access Token (Azure AD v2.0 Endpoint).
'    Refresh Access Token (Azure AD Endpoint).

' (Make sure your token was obtained with the Files.ReadWrite scope.)
http.AuthToken = "MICROSOFT_GRAPH_ACCESS_TOKEN"

' To upload in a single HTTP request, send a PUT request such as the following:

' 	PUT /v1.0/me/drive/root:/{item-path}:/content
' 	Content-type: text/plain
' 	Content-Length: <the actual content length>
' 
' 	The contents of the file goes here.

' Note: This example can upload any type of file.
' Chilkat automatically adds the Content-Length header.

Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest
req.HttpVerb = "PUT"
' If not using "me", then the path should be /v1.0/users/{id | userPrincipalName}/...
req.Path = "/v1.0/me/drive/root:/someFolder/penguins.jpg:/content"
' Indicate the local file to be streamed in the upload.
Dim success As Boolean
success = req.StreamBodyFromFile("qa_data/jpg/penguins.jpg")
' If you're uploading a file and don't know what the Content-Type should be,
' just use "application/octet-stream".  See below for an example..
req.ContentType = "image/jpeg"


Set resp = http.SynchronousRequest("graph.microsoft.com",443,True,req)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' If successful, a 201 status code is returned, with the driveItem object in the response body for the newly created file.
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
json.EmitCompact = False
success = json.Load(resp.BodyStr)

If (resp.StatusCode <> 201) Then

    ' Here is an example of an error:

    ' 		{
    ' 		  "error": {
    ' 		    "code": "nameAlreadyExists",
    ' 		    "message": "An item with the same name already exists under the parent",
    ' 		    "innerError": {
    ' 		      "request-id": "22302ba5-b885-4b67-9e20-8f6801aec372",
    ' 		      "date": "2017-06-03T14:22:27"
    ' 		    }
    ' 		  }
    ' 		}
    ' 
    ' 		Response status = 409

    Debug.Print json.Emit()
    Debug.Print "Response status = "; resp.StatusCode

    Exit Sub
End If

' Success.  Examine the driveItem JSON object:
Debug.Print json.Emit()
Debug.Print "-- Success --"

' Here is a sample successful response:

' 	{
' 	  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('me')/drive/root/$entity",
' 	  "@microsoft.graph.downloadUrl": "https://s5ucmg.dm2301.livefilestore.com/y4p0MT4NGBshn3EMBjrq8NuU3c_3Bt4DBz0BjZiQPNhiCDj3DjXEHrMr71M6wAGRrvT6WJmPIqNo_lxBP4Uen5MXFVtO3Dz_tdZ531hC_J9fb-eU6CoEmvjonwapmTorJb6hbi6g8VNxBQLItDyVgWM-InmxoNRo0N6xpcAuIbKZccN5vuctIs-Wqxefaza19thlu__bOl8kfG_SkgsrbBzKdTjOS0phBhIi8kYo9wG25k",
' 	  "createdBy": {
' 	    "application": {
' 	      "displayName": "Chilkat",
' 	      "id": "441c9990"
' 	    },
' 	    "user": {
' 	      "displayName": "Matt Smith",
' 	      "id": "3a33fceb9b74cc15"
' 	    }
' 	  },
' 	  "createdDateTime": "2017-06-03T14:23:52.153Z",
' 	  "cTag": "aYzozQTMzRkNFQjlCNzRDQzE1ITQ4NjMuMjU3",
' 	  "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSE0ODYzLjA",
' 	  "id": "3A33FCEB9B74CC15!4863",
' 	  "lastModifiedBy": {
' 	    "application": {
' 	      "displayName": "Chilkat",
' 	      "id": "441c9990"
' 	    },
' 	    "user": {
' 	      "displayName": "Matt Smith",
' 	      "id": "3a33fceb9b74cc15"
' 	    }
' 	  },
' 	  "lastModifiedDateTime": "2017-06-03T14:23:52.153Z",
' 	  "name": "penguins.jpg",
' 	  "parentReference": {
' 	    "driveId": "3a33fceb9b74cc15",
' 	    "id": "3A33FCEB9B74CC15!4862",
' 	    "name": "someFolder",
' 	    "path": "/drive/root:/someFolder"
' 	  },
' 	  "size": 777835,
' 	  "webUrl": "https://1drv.ms/i/s!ABXMdJvr_DM6pX8",
' 	  "file": {
' 	    "hashes": {
' 	      "sha1Hash": "DF7BE9DC4F467187783ACA68C7CE98E4DF2172D0"
' 	    },
' 	    "mimeType": "image/jpeg",
' 	    "processingMetadata": true
' 	  },
' 	  "fileSystemInfo": {
' 	    "createdDateTime": "2017-06-03T14:23:52.153Z",
' 	    "lastModifiedDateTime": "2017-06-03T14:23:52.153Z"
' 	  }
' 	}

' ------------------------------------------------------------------------------------
' Now let's upload some file where we don't know what the Content-Type should be.
' 
' In this case, we're uploading the same JPG file but instead of providing "image/jpeg" for the
' Content-Type, we provide "application/octet-stream".  ("application/octet-stream" is the general
' HTTP content-type used for anything unkown.  "octet" is a synonym for "byte".  It's just a way of
' saying: Here's a stream of bytes that comprise the file.)

' Also, you'll notice in the successful JSON response (below), that Microsoft automatically
' detected the Content-Type as "image/jpeg", because the mimeType is set as such.
' It is likely Microsoft set the MIME type (i.e. Content-Type) based on the file extension, or even better
' it may have determined the MIME type by examining the initial bytes of the file to find the standard 
' identifying markers that signify common file types such as PDF, JPG, ZIP, and many more.

' In a nutshell:  Don't worry about setting the ContentType precisely. If you know it, great.  If not, just
' use "application/octet-stream".

req.HttpVerb = "PUT"
req.Path = "/v1.0/me/drive/root:/someFolder/penguins2.jpg:/content"
success = req.StreamBodyFromFile("qa_data/jpg/penguins.jpg")
req.ContentType = "application/octet-stream"

Set resp = http.SynchronousRequest("graph.microsoft.com",443,True,req)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

success = json.Load(resp.BodyStr)
If (resp.StatusCode <> 201) Then
    Debug.Print json.Emit()
    Debug.Print "Response status = "; resp.StatusCode

    Exit Sub
End If

' Success.  Examine the driveItem JSON object:
Debug.Print json.Emit()
Debug.Print "-- Success --"

' 	{
' 	  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('me')/drive/root/$entity",
' 	  "@microsoft.graph.downloadUrl": "https://s5ucmg.dm2301.livefilestore.com/y4pKX-VIcxZfOUa1iYzGo7K4dX8an2xkcL7i-bb1YLE2ralUEPAixycWzekSn6-lUl5ojvZLQzpce45pgX2SIZfHe9l9scGcYu1viPHxKQ67Xh5b6iMhQNwbjbPQdr3ez6DET55DL25f7kS-fnksazALBtHiTLYayEqMc3WokdQYPsCj7AtzyNPzgKh6ye9R0FxM6ZRS5y6ARY23dIWuGkAKE9lKLgC4PPjvgNBBvl7zi8",
' 	  "createdBy": {
' 	    "application": {
' 	      "displayName": "Chilkat",
' 	      "id": "441c9990"
' 	    },
' 	    "user": {
' 	      "displayName": "Matt Smith",
' 	      "id": "3a33fceb9b74cc15"
' 	    }
' 	  },
' 	  "createdDateTime": "2017-06-03T14:30:22.017Z",
' 	  "cTag": "aYzozQTMzRkNFQjlCNzRDQzE1ITQ4NjUuMjU3",
' 	  "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSE0ODY1LjA",
' 	  "id": "3A33FCEB9B74CC15!4865",
' 	  "lastModifiedBy": {
' 	    "application": {
' 	      "displayName": "Chilkat",
' 	      "id": "441c9990"
' 	    },
' 	    "user": {
' 	      "displayName": "Matt Smith",
' 	      "id": "3a33fceb9b74cc15"
' 	    }
' 	  },
' 	  "lastModifiedDateTime": "2017-06-03T14:30:22.017Z",
' 	  "name": "penguins2.jpg",
' 	  "parentReference": {
' 	    "driveId": "3a33fceb9b74cc15",
' 	    "id": "3A33FCEB9B74CC15!4862",
' 	    "name": "someFolder",
' 	    "path": "/drive/root:/someFolder"
' 	  },
' 	  "size": 777835,
' 	  "webUrl": "https://1drv.ms/i/s!ABXMdJvr_DM6pgE",
' 	  "file": {
' 	    "hashes": {
' 	      "sha1Hash": "DF7BE9DC4F467187783ACA68C7CE98E4DF2172D0"
' 	    },
' 	    "mimeType": "image/jpeg",
' 	    "processingMetadata": true
' 	  },
' 	  "fileSystemInfo": {
' 	    "createdDateTime": "2017-06-03T14:30:22.016Z",
' 	    "lastModifiedDateTime": "2017-06-03T14:30:22.016Z"
' 	  }
' 	}