(Excel) ETrade Renew Access Token

Renews an ETrade OAuth access token.

For more information, see https://apisb.etrade.com/docs/api/authorization/renew_access_token.html

Download Excel Class Modules Chilkat Excel Class Modules

' This 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

http.OAuth1 = True
http.OAuthVerifier = ""
http.OAuthConsumerKey = "ETRADE_CONSUMER_KEY"
http.OAuthConsumerSecret = "ETRADE_CONSUMER_SECRET"

' Load the access token previously obtained via the OAuth1 Authorization
Dim jsonToken As Chilkat.JsonObject
Set jsonToken = Chilkat.NewJsonObject

success = jsonToken.LoadFile("qa_data/tokens/etrade.json")
If (success <> True) Then
    Debug.Print "Failed to load OAuth1 token"
    Exit Sub
End If

http.OAuthToken = jsonToken.StringOf("oauth_token")
http.OAuthTokenSecret = jsonToken.StringOf("oauth_token_secret")


Set resp = http.QuickGetObj("https://api.etrade.com/oauth/renew_access_token")
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' Make sure a successful response was received.
If (resp.StatusCode <> 200) Then
    Debug.Print resp.StatusLine
    Debug.Print resp.Header
    Debug.Print resp.BodyStr
    Exit Sub
End If

' If successful, the resp.BodyStr contains something like this:
' oauth_token=%3TiQRgQCRGPo7Xdk6G8QDSEzX0Jsy6sKNcULcDavAGgU%3D&oauth_token_secret=%7RrC9scEpzcwSEMy4vE7nodSzPLqfRINnTNY4voczyFM%3D
Debug.Print resp.BodyStr

Dim sbRespBody As Chilkat.StringBuilder
Set sbRespBody = Chilkat.NewStringBuilder
success = resp.GetBodySb(sbRespBody)
If (sbRespBody.ContentsEqual("Access Token has been renewed",False)) Then
    ' The documentation at https://apisb.etrade.com/docs/api/authorization/renew_access_token.html
    ' indicates that the response should be as described above.  However, the response received when
    ' trying to refresh a non-expired token was "Access Token has been renewed"
    Debug.Print "Keeping the same access token, but it's renewed..."
    Exit Sub
End If

Dim hashTab As Chilkat.Hashtable
Set hashTab = Chilkat.NewHashtable
success = hashTab.AddQueryParams(resp.BodyStr)


accessToken = hashTab.LookupStr("oauth_token")

accessTokenSecret = hashTab.LookupStr("oauth_token_secret")

' The access token + secret is what should be saved and used for
' subsequent REST API calls.
Debug.Print "Access Token = "; accessToken
Debug.Print "Access Token Secret = "; accessTokenSecret

' Save this access token for future calls.
' Just in case we need user_id and screen_name, save those also..
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.AppendString("oauth_token",accessToken)
success = json.AppendString("oauth_token_secret",accessTokenSecret)

Dim fac As Chilkat.FileAccess
Set fac = Chilkat.NewFileAccess
success = fac.WriteEntireTextFile("qa_data/tokens/etrade.json",json.Emit(),"utf-8",False)

Debug.Print "Success."