(Excel) Moody's REST API - Get OAuth2 Token

See more Moody's Examples

Demonstrates how to get an OAuth2 access token for the Moody's REST API.

Download Excel Class Modules Chilkat Excel Class Modules

' This example assumes 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.AddParam "grant_type","password"
req.AddParam "scope","api/ratings api/addin rest"
req.AddParam "username","my_username"
req.AddParam "password","my_password"
' I have no idea of where to get the client_id or client_secret.
' When you create a Moody's App, it only provides an "API Key".
req.AddParam "client_id","my_client_id"
req.AddParam "client_secret","my_client_secret"


Set resp = http.PostUrlEncoded("https://api.moodys.com/OAuth/Token",req)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

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

responseBody = resp.BodyStr
Debug.Print responseBody

' Save the JSON to a file for future requests.
If (resp.StatusCode = 200) Then
    Dim fac As Chilkat.FileAccess
    Set fac = Chilkat.NewFileAccess
    Dim success As Boolean
    success = fac.WriteEntireTextFile("qa_data/tokens/moodys.json",resp.BodyStr,"utf-8",False)
End If