(Excel) Calendar: Refresh Expired OAuth2 Access Token

Refreshes an expired OAuth2 access token.

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 json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject

success = json.LoadFile("qa_data/tokens/msGraphCalendar.json")
If (success <> True) Then
    Exit Sub
End If

Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest
req.AddParam "grant_type","refresh_token"
req.AddParam "redirect_uri","http://localhost:3017/"
req.AddParam "client_id","MICROSOFT-GRAPH-CLIENT-ID"
req.AddParam "client_secret","MICROSOFT-GRAPH-CLIENT-SECRET"
req.AddParam "refresh_token",json.StringOf("refresh_token")
req.AddParam "scope","openid profile offline_access user.readwrite calendars.readwrite files.readwrite"

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


Set resp = http.PostUrlEncoded("https://login.microsoftonline.com/common/oauth2/v2.0/token",req)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' Load the JSON response.
success = json.Load(resp.BodyStr)
json.EmitCompact = False

' Show the JSON response.
Debug.Print json.Emit()

Debug.Print "Response status code: "; resp.StatusCode

' If the response status code is not 200, then it's an error.
If (resp.StatusCode <> 200) Then
    Exit Sub
End If

' Save the refreshed access token JSON to a file for future requests.
Dim fac As Chilkat.FileAccess
Set fac = Chilkat.NewFileAccess
success = fac.WriteEntireTextFile("qa_data/tokens/msGraphCalendar.json",json.Emit(),"utf-8",False)

Debug.Print "Success."