(Excel) Dynamics CRM Oauth2 Client Credentials

Get an OAuth2 access token for Dynamics CRM using client credentials.

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

' Pass the client ID/secret using Basic HTTP authentication.
http.Login = "CLIENT_ID"
http.Password = "CLIENT_SECRET"
http.BasicAuth = True

Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest
req.AddParam "client_secret","CLIENT_SECRET"
req.AddParam "client_id","CLIENT_ID"
req.AddParam "scope","https://yourdynamicsdomain.crm3.dynamics.com/.default"
req.AddParam "grant_type","client_credentials"

' Use your own tenant ID, for example 4d8fdd66-66d1-43b0-ae5c-e31b4b7de5cd

url = "https://login.microsoftonline.com/TENANT_ID/oauth2/v2.0/token"

Set resp = http.PostUrlEncoded(url,req)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If


statusCode = resp.StatusCode
Debug.Print "Response status code = "; statusCode

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
Dim success As Boolean
success = json.Load(resp.BodyStr)

json.EmitCompact = False
Debug.Print json.Emit()

If (statusCode = 200) Then
    success = json.WriteFile("qa_data/tokens/dynamicsCrmClientCredentialsToken.json")
    Debug.Print "Success."
Else
    Debug.Print "Failed."
End If