(Lianja) Quickbooks OAuth1 Authorization (3-legged)

Demonstrates 3-legged OAuth1 authorization for Quickbooks.

Chilkat Lianja Extension Download Chilkat Lianja Extension

lcConsumerKey = "QUICKBOOKS_CONSUMER_KEY"
lcConsumerSecret = "QUICKBOOKS_CONSUMER_SECRET"

lcRequestTokenUrl = "https://oauth.intuit.com/oauth/v1/get_request_token"
lcAuthorizeUrl = "https://appcenter.intuit.com/Connect/Begin"
lcAccessTokenUrl = "https://oauth.intuit.com/oauth/v1/get_access_token"

// The port number is picked at random. It's some unused port that won't likely conflict with anything else..
lcCallbackUrl = "http://localhost:3017/"
lnCallbackLocalPort = 3017

// The 1st step in 3-legged OAuth1.0a is to send a POST to the request token URL to obtain an OAuth Request Token
loHttp = createobject("CkHttp")

loHttp.OAuth1 = .T.
loHttp.OAuthConsumerKey = lcConsumerKey
loHttp.OAuthConsumerSecret = lcConsumerSecret
loHttp.OAuthCallback = lcCallbackUrl

loReq = createobject("CkHttpRequest")
loResp = loHttp.PostUrlEncoded(lcRequestTokenUrl,loReq)
if (loHttp.LastMethodSuccess <> .T.) then
    ? loHttp.LastErrorText
    release loHttp
    release loReq
    return
endif

if (loResp.StatusCode >= 400) then
    ? "Error response status code = " + str(loResp.StatusCode)
    ? loResp.BodyStr
    release loHttp
    release loReq
    return
endif

// If successful, the resp.BodyStr contains this:  
// oauth_token=-Wa_KwAAAAAAxfEPAAABV8Qar4Q&oauth_token_secret=OfHY4tZBX2HK4f7yIw76WYdvnl99MVGB&oauth_callback_confirmed=true
? loResp.BodyStr

loHashTab1 = createobject("CkHashtable")
loHashTab1.AddQueryParams(loResp.BodyStr)

lcRequestToken = loHashTab1.LookupStr("oauth_token")
lcRequestTokenSecret = loHashTab1.LookupStr("oauth_token_secret")
loHttp.OAuthTokenSecret = lcRequestTokenSecret

release loResp

? "oauth_token = " + lcRequestToken
? "oauth_token_secret = " + lcRequestTokenSecret

// ---------------------------------------------------------------------------
// The next step is to form a URL to send to the AuthorizeUrl
// This is an HTTP GET that we load into a popup browser.
loSbUrlForBrowser = createobject("CkStringBuilder")
loSbUrlForBrowser.Append(lcAuthorizeUrl)
loSbUrlForBrowser.Append("?oauth_token=")
loSbUrlForBrowser.Append(lcRequestToken)
lcUrlForBrowser = loSbUrlForBrowser.GetAsString()

// When the urlForBrowser is loaded into a browser, the response from Quickbooks will redirect back to localhost:3017
// We'll need to start a socket that is listening on port 3017 for the callback from the browser.
loListenSock = createobject("CkSocket")

lnBackLog = 5
llSuccess = loListenSock.BindAndListen(lnCallbackLocalPort,lnBackLog)
if (llSuccess <> .T.) then
    ? loListenSock.LastErrorText
    release loHttp
    release loReq
    release loHashTab1
    release loSbUrlForBrowser
    release loListenSock
    return
endif

// Wait for the browser's connection in a background thread.
// (We'll send load the URL into the browser following this..)
// Wait a max of 60 seconds before giving up.
lnMaxWaitMs = 60000
loTask = loListenSock.AcceptNextConnectionAsync(lnMaxWaitMs)
loTask.Run()

//  At this point, your application should load the URL in a browser.
//  For example,
//  in C#:  System.Diagnostics.Process.Start(urlForBrowser);
//  in Java: Desktop.getDesktop().browse(new URI(urlForBrowser));
//  in VBScript: Set wsh=WScript.CreateObject("WScript.Shell")
//               wsh.Run urlForBrowser
// in Xojo: ShowURL(url)  (see http://docs.xojo.com/index.php/ShowURL)
// in Dataflex: Runprogram Background "c:\Program Files\Internet Explorer\iexplore.exe" sUrl        
//  The Quickbooks account owner would interactively accept or deny the authorization request.

//  Add the code to load the url in a web browser here...
//  Add the code to load the url in a web browser here...
//  Add the code to load the url in a web browser here...
// System.Diagnostics.Process.Start(urlForBrowser);

// Wait for the listenSock's task to complete.
llSuccess = loTask.Wait(lnMaxWaitMs)
if (not llSuccess or (loTask.StatusInt <> 7) or (loTask.TaskSuccess <> .T.)) then
    if (not llSuccess) then
        // The task.LastErrorText applies to the Wait method call.
        ? loTask.LastErrorText
    else
        // The ResultErrorText applies to the underlying task method call (i.e. the AcceptNextConnection)
        ? loTask.Status
        ? loTask.ResultErrorText
    endif

    release loTask
    release loHttp
    release loReq
    release loHashTab1
    release loSbUrlForBrowser
    release loListenSock
    return
endif

// If we get to this point, the connection from the browser arrived and was accepted.

// We no longer need the listen socket...
// Close it so that it's no longer listening on port 3017.
loListenSock.Close(10)

// The first thing to do is to get the connected socket.
loSock = createobject("CkSocket")
loSock.LoadTaskResult(loTask)
release loTask

// Read the start line of the request..
lcStartLine = loSock.ReceiveUntilMatch(Chr(13) + Chr(10))
if (loSock.LastMethodSuccess <> .T.) then
    ? loSock.LastErrorText
    release loHttp
    release loReq
    release loHashTab1
    release loSbUrlForBrowser
    release loListenSock
    release loSock
    return
endif

// Read the request header.
lcRequestHeader = loSock.ReceiveUntilMatch(Chr(13) + Chr(10) + Chr(13) + Chr(10))
if (loSock.LastMethodSuccess <> .T.) then
    ? loSock.LastErrorText
    release loHttp
    release loReq
    release loHashTab1
    release loSbUrlForBrowser
    release loListenSock
    release loSock
    return
endif

// The browser SHOULD be sending us a GET request, and therefore there is no body to the request.
// Once the request header is received, we have all of it.
// We can now send our HTTP response.
loSbResponseHtml = createobject("CkStringBuilder")
loSbResponseHtml.Append("<html><body><p>Chilkat thanks you!</b></body</html>")

loSbResponse = createobject("CkStringBuilder")
loSbResponse.Append("HTTP/1.1 200 OK" + Chr(13) + Chr(10))
loSbResponse.Append("Content-Length: ")
loSbResponse.AppendInt(loSbResponseHtml.Length)
loSbResponse.Append(Chr(13) + Chr(10))
loSbResponse.Append("Content-Type: text/html" + Chr(13) + Chr(10))
loSbResponse.Append(Chr(13) + Chr(10))
loSbResponse.AppendSb(loSbResponseHtml)

loSock.SendString(loSbResponse.GetAsString())
loSock.Close(50)

// The information we need is in the startLine.
// For example, the startLine will look like this:
//  GET /?oauth_token=abcdRQAAZZAAxfBBAAABVabcd_k&oauth_verifier=9rdOq5abcdCe6cn8M3jabcdj3Eabcd HTTP/1.1
loSbStartLine = createobject("CkStringBuilder")
loSbStartLine.Append(lcStartLine)
lnNumReplacements = loSbStartLine.Replace("GET /?","")
lnNumReplacements = loSbStartLine.Replace(" HTTP/1.1","")
loSbStartLine.Trim()

// oauth_token=qyprdP04IrTDIXtP1HRZz0geQdjXHVlGDxXPexlXZsjZNRcY&oauth_verifier=arx5pj5&realmId=193514465596199&dataSource=QBO
? "startline: " + loSbStartLine.GetAsString()

loHashTab1.Clear()
loHashTab1.AddQueryParams(loSbStartLine.GetAsString())

lcRequestToken = loHashTab1.LookupStr("oauth_token")
lcAuthVerifier = loHashTab1.LookupStr("oauth_verifier")

// ------------------------------------------------------------------------------
// Finally , we must exchange the OAuth Request Token for an OAuth Access Token.

loHttp.OAuthToken = lcRequestToken
loHttp.OAuthVerifier = lcAuthVerifier
loResp = loHttp.PostUrlEncoded(lcAccessTokenUrl,loReq)
if (loHttp.LastMethodSuccess <> .T.) then
    ? loHttp.LastErrorText
    release loHttp
    release loReq
    release loHashTab1
    release loSbUrlForBrowser
    release loListenSock
    release loSock
    release loSbResponseHtml
    release loSbResponse
    release loSbStartLine
    return
endif

// Make sure a successful response was received.
if (loResp.StatusCode <> 200) then
    ? loResp.StatusLine
    ? loResp.Header
    ? loResp.BodyStr
    release loHttp
    release loReq
    release loHashTab1
    release loSbUrlForBrowser
    release loListenSock
    release loSock
    release loSbResponseHtml
    release loSbResponse
    release loSbStartLine
    return
endif

// If successful, the resp.BodyStr contains something like this:
// oauth_token=12347455-ffffrrlaBdCjbdGfyjZabcdb5APNtuTPNabcdEpp&oauth_token_secret=RxxxxJ8mTzUhwES4xxxxuJyFWDN8ZfHmrabcddh88LmWE
? loResp.BodyStr

loHashTab2 = createobject("CkHashtable")
loHashTab2.AddQueryParams(loResp.BodyStr)

lcAccessToken = loHashTab2.LookupStr("oauth_token")
lcAccessTokenSecret = loHashTab2.LookupStr("oauth_token_secret")

release loResp

// The access token + secret is what should be saved and used for
// subsequent REST API calls.
? "Access Token = " + lcAccessToken
? "Access Token Secret = " + lcAccessTokenSecret

// Save this access token for future calls.
loJson = createobject("CkJsonObject")
loJson.AppendString("oauth_token",lcAccessToken)
loJson.AppendString("oauth_token_secret",lcAccessTokenSecret)

// Also save the realmId and dataSource from hashTab1.
lcRealmId = loHashTab1.LookupStr("realmId")
? "realmId = " + lcRealmId
lcDataSource = loHashTab1.LookupStr("dataSource")
? "dataSource = " + lcDataSource

loJson.AppendString("realmId",lcRealmId)
loJson.AppendString("dataSource",lcDataSource)

loFac = createobject("CkFileAccess")
loFac.WriteEntireTextFile("qa_data/tokens/quickbooks.json",loJson.Emit(),"utf-8",.F.)

? "Success."


release loHttp
release loReq
release loHashTab1
release loSbUrlForBrowser
release loListenSock
release loSock
release loSbResponseHtml
release loSbResponse
release loSbStartLine
release loHashTab2
release loJson
release loFac