(Excel) AzureWebsites OAuth2 Password Flow

Demonstrates how to do OAuth 2.0 password flow for azurewebsites.net.

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

Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest
req.HttpVerb = "POST"
req.Path = "/token"
req.ContentType = "application/x-www-form-urlencoded"
req.AddParam "grant_type","password"
req.AddParam "username","your_username"
req.AddParam "password","your_password"


tokenEndpoint = "https://your_api.azurewebsites.net/token"

Set resp = http.PostUrlEncoded(tokenEndpoint,req)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
Dim success As Boolean
success = resp.GetBodySb(sbResponseBody)
Dim jResp As Chilkat.JsonObject
Set jResp = Chilkat.NewJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False

Debug.Print "Response Body:"
Debug.Print jResp.Emit()

' Sample JSON response:

' {
'   "access_token": "NQGHn ... xTS",
'   "token_type": "bearer",
'   "expires_in": 1209599,
'   "userName": "your_username",
'   ".issued": "Mon, 27 Apr 2020 23:49:35 GMT",
'   ".expires": "Mon, 11 May 2020 23:49:35 GMT"
' }


respStatusCode = resp.StatusCode
Debug.Print "Response Status Code = "; respStatusCode
If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print resp.Header
    Debug.Print "Failed."

    Exit Sub
End If

' ----------------------------------
' Use the OAuth2 token in a request.
' For example...

Dim sbXml As Chilkat.StringBuilder
Set sbXml = Chilkat.NewStringBuilder
success = sbXml.LoadFile("c:/someDir/someXmlFile.xml","utf-8")
If (success = False) Then
    Debug.Print "Failed to load the XML file."
    Exit Sub
End If

' Get the OAuth2 token and use it for authentication
http.AuthToken = jResp.StringOf("token")


destUrl = "https://your_api.azurewebsites.net/destinationUrl"
Set resp = http.PostXml(destUrl,sbXml.GetAsString(),"utf-8")
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

respStatusCode = resp.StatusCode
Debug.Print "Response Status Code = "; respStatusCode
If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print resp.Header
    Debug.Print "Failed."

    Exit Sub
End If

' Examine the response body
Debug.Print resp.BodyStr