(Excel) Azure REST API Access Token

Demonstrates how to request an Azure REST API OAUTH2 access token.

Note: In order to access resources a Service Principal needs to be created in your Tenant. It is really convenient to do it via AZ CLI:

az ad sp create-for-rbac --name [APP_NAME] --password [CLIENT_SECRET]

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 rest As Chilkat.Rest
Set rest = Chilkat.NewRest

' URL: https://login.microsoftonline.com/TENANT_ID/oauth2/token

bTls = True

port = 443

bAutoReconnect = True

success = rest.Connect("login.microsoftonline.com",port,bTls,bAutoReconnect)
If (success <> True) Then
    Debug.Print "ConnectFailReason: "; rest.ConnectFailReason
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' Add query params to the request.
success = rest.AddQueryParam("grant_type","client_credentials")
success = rest.AddQueryParam("client_id","APP_ID")
success = rest.AddQueryParam("client_secret","CLIENT_SECRET")
success = rest.AddQueryParam("resource","https://management.azure.com/")


strResponseBody = rest.FullRequestFormUrlEncoded("POST","/TENANT_ID/oauth2/token")
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If


respStatusCode = rest.ResponseStatusCode
If (respStatusCode >= 400) Then
    Debug.Print "Response Status Code = "; respStatusCode
    Debug.Print "Response Header:"
    Debug.Print rest.ResponseHeader
    Debug.Print "Response Body:"
    Debug.Print strResponseBody
    Exit Sub
End If

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.Load(strResponseBody)
json.EmitCompact = False
Debug.Print json.Emit()

' The result is an access token such as the following:

' {
'   "token_type": "Bearer",
'   "expires_in": "3600",
'   "ext_expires_in": "3600",
'   "expires_on": "1557864616",
'   "not_before": "1557860716",
'   "resource": "https://management.azure.com/",
'   "access_token": "eyJ0eXAiOiJKV1QiL ... 20UFDDOHEyUg"
' }

' We'll save this JSON to a file for other examples to use..
success = json.WriteFile("qa_data/tokens/azureToken.json")