(VBScript) Quickbooks OAuth1 Authorization (3-legged)

Demonstrates 3-legged OAuth1 authorization for Quickbooks.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

consumerKey = "QUICKBOOKS_CONSUMER_KEY"
consumerSecret = "QUICKBOOKS_CONSUMER_SECRET"

requestTokenUrl = "https://oauth.intuit.com/oauth/v1/get_request_token"
authorizeUrl = "https://appcenter.intuit.com/Connect/Begin"
accessTokenUrl = "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..
callbackUrl = "http://localhost:3017/"
callbackLocalPort = 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
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Http")
set http = CreateObject("Chilkat.Http")

http.OAuth1 = 1
http.OAuthConsumerKey = consumerKey
http.OAuthConsumerSecret = consumerSecret
http.OAuthCallback = callbackUrl

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.HttpRequest")
set req = CreateObject("Chilkat.HttpRequest")
' resp is a Chilkat.HttpResponse
Set resp = http.PostUrlEncoded(requestTokenUrl,req)
If (http.LastMethodSuccess <> 1) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

If (resp.StatusCode >= 400) Then
    outFile.WriteLine("Error response status code = " & resp.StatusCode)
    outFile.WriteLine(resp.BodyStr)
    WScript.Quit
End If

' If successful, the resp.BodyStr contains this:  
' oauth_token=-Wa_KwAAAAAAxfEPAAABV8Qar4Q&oauth_token_secret=OfHY4tZBX2HK4f7yIw76WYdvnl99MVGB&oauth_callback_confirmed=true
outFile.WriteLine(resp.BodyStr)

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Hashtable")
set hashTab1 = CreateObject("Chilkat.Hashtable")
success = hashTab1.AddQueryParams(resp.BodyStr)

requestToken = hashTab1.LookupStr("oauth_token")
requestTokenSecret = hashTab1.LookupStr("oauth_token_secret")
http.OAuthTokenSecret = requestTokenSecret

outFile.WriteLine("oauth_token = " & requestToken)
outFile.WriteLine("oauth_token_secret = " & requestTokenSecret)

' ---------------------------------------------------------------------------
' 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.
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder")
set sbUrlForBrowser = CreateObject("Chilkat.StringBuilder")
success = sbUrlForBrowser.Append(authorizeUrl)
success = sbUrlForBrowser.Append("?oauth_token=")
success = sbUrlForBrowser.Append(requestToken)
urlForBrowser = sbUrlForBrowser.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.
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Socket")
set listenSock = CreateObject("Chilkat.Socket")

backLog = 5
success = listenSock.BindAndListen(callbackLocalPort,backLog)
If (success <> 1) Then
    outFile.WriteLine(listenSock.LastErrorText)
    WScript.Quit
End If

' 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.
maxWaitMs = 60000
' task is a Chilkat.Task
Set task = listenSock.AcceptNextConnectionAsync(maxWaitMs)
success = task.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.
success = task.Wait(maxWaitMs)
If (Not success Or (task.StatusInt <> 7) Or (task.TaskSuccess <> 1)) Then
    If (Not success) Then
        ' The task.LastErrorText applies to the Wait method call.
        outFile.WriteLine(task.LastErrorText)
    Else
        ' The ResultErrorText applies to the underlying task method call (i.e. the AcceptNextConnection)
        outFile.WriteLine(task.Status)
        outFile.WriteLine(task.ResultErrorText)
    End If

    WScript.Quit
End If

' 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.
success = listenSock.Close(10)

' The first thing to do is to get the connected socket.
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Socket")
set sock = CreateObject("Chilkat.Socket")
success = sock.LoadTaskResult(task)

' Read the start line of the request..
startLine = sock.ReceiveUntilMatch(vbCrLf)
If (sock.LastMethodSuccess <> 1) Then
    outFile.WriteLine(sock.LastErrorText)
    WScript.Quit
End If

' Read the request header.
requestHeader = sock.ReceiveUntilMatch(vbCrLf & vbCrLf)
If (sock.LastMethodSuccess <> 1) Then
    outFile.WriteLine(sock.LastErrorText)
    WScript.Quit
End If

' 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.
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder")
set sbResponseHtml = CreateObject("Chilkat.StringBuilder")
success = sbResponseHtml.Append("<html><body><p>Chilkat thanks you!</b></body</html>")

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder")
set sbResponse = CreateObject("Chilkat.StringBuilder")
success = sbResponse.Append("HTTP/1.1 200 OK" & vbCrLf)
success = sbResponse.Append("Content-Length: ")
success = sbResponse.AppendInt(sbResponseHtml.Length)
success = sbResponse.Append(vbCrLf)
success = sbResponse.Append("Content-Type: text/html" & vbCrLf)
success = sbResponse.Append(vbCrLf)
success = sbResponse.AppendSb(sbResponseHtml)

success = sock.SendString(sbResponse.GetAsString())
success = sock.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
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder")
set sbStartLine = CreateObject("Chilkat.StringBuilder")
success = sbStartLine.Append(startLine)
numReplacements = sbStartLine.Replace("GET /?","")
numReplacements = sbStartLine.Replace(" HTTP/1.1","")
success = sbStartLine.Trim()

' oauth_token=qyprdP04IrTDIXtP1HRZz0geQdjXHVlGDxXPexlXZsjZNRcY&oauth_verifier=arx5pj5&realmId=193514465596199&dataSource=QBO
outFile.WriteLine("startline: " & sbStartLine.GetAsString())

hashTab1.Clear 
success = hashTab1.AddQueryParams(sbStartLine.GetAsString())

requestToken = hashTab1.LookupStr("oauth_token")
authVerifier = hashTab1.LookupStr("oauth_verifier")

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

http.OAuthToken = requestToken
http.OAuthVerifier = authVerifier
' resp is a Chilkat.HttpResponse
Set resp = http.PostUrlEncoded(accessTokenUrl,req)
If (http.LastMethodSuccess <> 1) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

' Make sure a successful response was received.
If (resp.StatusCode <> 200) Then
    outFile.WriteLine(resp.StatusLine)
    outFile.WriteLine(resp.Header)
    outFile.WriteLine(resp.BodyStr)
    WScript.Quit
End If

' If successful, the resp.BodyStr contains something like this:
' oauth_token=12347455-ffffrrlaBdCjbdGfyjZabcdb5APNtuTPNabcdEpp&oauth_token_secret=RxxxxJ8mTzUhwES4xxxxuJyFWDN8ZfHmrabcddh88LmWE
outFile.WriteLine(resp.BodyStr)

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Hashtable")
set hashTab2 = CreateObject("Chilkat.Hashtable")
success = hashTab2.AddQueryParams(resp.BodyStr)

accessToken = hashTab2.LookupStr("oauth_token")
accessTokenSecret = hashTab2.LookupStr("oauth_token_secret")

' The access token + secret is what should be saved and used for
' subsequent REST API calls.
outFile.WriteLine("Access Token = " & accessToken)
outFile.WriteLine("Access Token Secret = " & accessTokenSecret)

' Save this access token for future calls.
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = CreateObject("Chilkat.JsonObject")
success = json.AppendString("oauth_token",accessToken)
success = json.AppendString("oauth_token_secret",accessTokenSecret)

' Also save the realmId and dataSource from hashTab1.
realmId = hashTab1.LookupStr("realmId")
outFile.WriteLine("realmId = " & realmId)
dataSource = hashTab1.LookupStr("dataSource")
outFile.WriteLine("dataSource = " & dataSource)

success = json.AppendString("realmId",realmId)
success = json.AppendString("dataSource",dataSource)

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.FileAccess")
set fac = CreateObject("Chilkat.FileAccess")
success = fac.WriteEntireTextFile("qa_data/tokens/quickbooks.json",json.Emit(),"utf-8",0)

outFile.WriteLine("Success.")

outFile.Close