PowerBuilder

Rabobank OAuth2 Access Token

See more OAuth2 Examples

Demonstrates how to get an OAuth 2.0 access token to access Rabobank API's

Important: This example is for desktop apps only. (It is not for web-based applications.)

Your app defined in the Rabobank portal should look something like this. (Our test app is named "chilkat". You should name your app something else.)

PowerBuilder

integer li_rc
integer li_Success
oleobject loo_Oauth2
string ls_Url
integer li_NumMsWaited
oleobject loo_Json
oleobject loo_Fac

li_Success = 0

// For more information about the OAuth2, see OAuth 2.0 Authorization Flow

loo_Oauth2 = create oleobject
li_rc = loo_Oauth2.ConnectToNewObject("Chilkat.OAuth2")
if li_rc < 0 then
    destroy loo_Oauth2
    MessageBox("Error","Connecting to COM object failed")
    return
end if

// This should be the port in the localhost callback URL for your app.  
// The callback URL would look like "http://localhost:3017/" if the port number is 3017.
loo_Oauth2.ListenPort = 3017

// IMPORTANT: Don't forget to subscribe your Rabobank application to the OAuth 2.0 services in the Rabobank Online Developer Portal.
// IMPORTANT: Don't forget to subscribe your Rabobank application to the OAuth 2.0 services in the Rabobank Online Developer Portal.
// IMPORTANT: Don't forget to subscribe your Rabobank application to the OAuth 2.0 services in the Rabobank Online Developer Portal.
// IMPORTANT: Don't forget to subscribe your Rabobank application to the OAuth 2.0 services in the Rabobank Online Developer Portal.

// See also https://developer.rabobank.nl/faq

loo_Oauth2.AuthorizationEndpoint = "https://api-sandbox.rabobank.nl/openapi/sandbox/oauth2/authorize"
loo_Oauth2.TokenEndpoint = "https://api-sandbox.rabobank.nl/openapi/sandbox/oauth2/token"

// Replace these with actual values.
loo_Oauth2.ClientId = "YOUR_APP_CLIENT_ID"
// This is your app password:
loo_Oauth2.ClientSecret = "YOUR_APP_CLIENT_SECRET"

loo_Oauth2.CodeChallenge = 0
// Provide a SPACE separated list of scopes, as defined in the Rabobank API documentation, 
// such as at https://developer-sandbox.rabobank.nl/reference/accounts-ais-sb/3-0-8

// Important: To get a refresh token in the final response, you have to ask for "offline_access" scope
loo_Oauth2.Scope = "ais.balances.read ais.transactions.read-90days ais.transactions.read-history"

// Begin the OAuth2 Authorization code flow.  This returns a URL that should be loaded in a browser.
ls_Url = loo_Oauth2.StartAuth()
if loo_Oauth2.LastMethodSuccess <> 1 then
    Write-Debug loo_Oauth2.LastErrorText
    destroy loo_Oauth2
    return
end if

Write-Debug "url = " + ls_Url

// Launch the default browser on the system and navigate to the url.
// The LaunchBrowser method was added in Chilkat v10.1.2.
li_Success = loo_Oauth2.LaunchBrowser(ls_Url)
if li_Success = 0 then
    Write-Debug loo_Oauth2.LastErrorText
    destroy loo_Oauth2
    return
end if

// Wait for the user to approve or deny authorization in the browser.
li_NumMsWaited = 0
do while (li_NumMsWaited < 90000) AND (loo_Oauth2.AuthFlowState < 3)
    loo_Oauth2.SleepMs(100)
    li_NumMsWaited = li_NumMsWaited + 100
loop

// If the browser does not respond within the specified time, AuthFlowState will be:
// 
// 1: Waiting for Redirect - The OAuth2 background thread is waiting for the browser's redirect request.
// 2: Waiting for Final Response - The thread is awaiting the final access token response.
// In either case, cancel the background task initiated by StartAuth.

if loo_Oauth2.AuthFlowState < 3 then
    loo_Oauth2.Cancel()
    Write-Debug "No response from the browser!"
    destroy loo_Oauth2
    return
end if

// Check AuthFlowState to determine if authorization was granted, denied, or failed:
// 
// 3: Success - OAuth2 flow completed, the background thread exited, and the successful response is in AccessTokenResponse.
// 4: Access Denied - OAuth2 flow completed, the background thread exited, and the error response is in AccessTokenResponse.
// 5: Failure - OAuth2 flow failed before completion, the background thread exited, and error details are in FailureInfo.

if loo_Oauth2.AuthFlowState = 5 then
    Write-Debug "OAuth2 failed to complete."
    Write-Debug loo_Oauth2.FailureInfo
    destroy loo_Oauth2
    return
end if

if loo_Oauth2.AuthFlowState = 4 then
    Write-Debug "OAuth2 authorization was denied."
    Write-Debug loo_Oauth2.AccessTokenResponse
    destroy loo_Oauth2
    return
end if

if loo_Oauth2.AuthFlowState <> 3 then
    Write-Debug "Unexpected AuthFlowState:" + string(loo_Oauth2.AuthFlowState)
    destroy loo_Oauth2
    return
end if

Write-Debug "OAuth2 authorization granted!"
Write-Debug "Access Token = " + loo_Oauth2.AccessToken

// Get the full JSON response:
loo_Json = create oleobject
li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject")

loo_Json.Load(loo_Oauth2.AccessTokenResponse)
loo_Json.EmitCompact = 0

// The JSON response looks like this:

// {
//   "token_type": "Bearer",
//   "access_token": "AAIkYTU0ZWM ... sxE0KL0HHWw",
//   "expires_in": 3600,
//   "consented_on": 1584641121,
//   "scope": "ais.balances.read ais.transactions.read-90days ais.transactions.read-history",
//   "refresh_token": "AAJXXSdN ... Uiblz9ILkxNBlytRGA",
//   "refresh_token_expires_in": 157784760,
//   "expires_on": "1584644722"
// }

Write-Debug loo_Json.Emit()

// Save the JSON to a file to be used in future requests.
loo_Fac = create oleobject
li_rc = loo_Fac.ConnectToNewObject("Chilkat.FileAccess")

loo_Fac.WriteEntireTextFile("qa_data/tokens/rabobank.json",loo_Json.Emit(),"utf-8",0)


destroy loo_Oauth2
destroy loo_Json
destroy loo_Fac