(Excel) ETrade OAuth1 Authorization (3-legged) Step 2

Demonstrates the final step in 3-legged OAuth1 authorization for the ETrade REST API. Example uses the OAuth1 verifier code that was copy-and-pasted from the browser in the 1st step. The end result of this final OAuth1 step is an access token that can be used to make ETrade REST API calls.

See https://apisb.etrade.com/docs/api/authorization/get_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.


consumerKey = "ETRADE_CONSUMER_KEY"

consumerSecret = "ETRADE_CONSUMER_SECRET"


requestTokenUrl = "https://apisb.etrade.com/oauth/request_token"

authorizeUrl = "https://us.etrade.com/e/t/etws/authorize"

accessTokenUrl = "https://apisb.etrade.com/oauth/access_token"

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

success = True

http.OAuth1 = True
http.OAuthConsumerKey = consumerKey
http.OAuthConsumerSecret = consumerSecret
http.OAuthCallback = "oob"

Dim jsonRequestToken As Chilkat.JsonObject
Set jsonRequestToken = Chilkat.NewJsonObject
success = jsonRequestToken.LoadFile("qa_data/tokens/etrade_request_token.json")

requestToken = jsonRequestToken.StringOf("oauth_token")

requestTokenSecret = jsonRequestToken.StringOf("oauth_token_secret")

' ------------------------------------------------------------------------------
' Exchange the OAuth Request Token for an OAuth Access Token.

http.OAuthToken = requestToken
http.OAuthTokenSecret = requestTokenSecret

' This is the verifier that was interactively copy-and-pasted from the browser back to our app.
http.OAuthVerifier = "NJ07S"


Set resp = http.QuickGetObj(accessTokenUrl)
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=85123455-fF41296Bi3daM8eCo9Y5vZabcdxXpRv864plYPOjr&oauth_token_secret=afiYJOgabcdSfGae7BDvJVVTwys8fUGpra5guZxbmFBZo
Debug.Print resp.BodyStr

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."