Now we will go to the “Functionality” screen to give an implementation for the OAuth login connector procedure. Here, it is important to setup the output parameters to fill in the process variables that we have created earlier.Īfter creating the process flow it should look like the one in the picture below. This is responsible for showing the login screen and will give us the token information. The next step is the “OAuth login connector”. This is the trigger for starting the flow. The flow starts with the “Start table task” process action (with the task “task_exact_online_oauth_login”) we just created. I added 3 process variables that I will use in this flow. I called mine “exact_online_oauth_login”. Add the task to the “oauth_token_info” table by using the “Table tasks” tab. To do that we create a task (I called mine “task_exact_online_oauth_login”), with task logic type set to “None” and we don’t add parameters. Let’s start by creating the trigger for our process flow. The first thing we want to do is obtaining the OAuth access and OAuth refresh tokens. Now that we have most of the setup done, we can start creating some process flows. Here we will add the extended property “oauthredirecturi” with the value of your Redirect URI. Go to the “Runtime configurations” tab and then the “Extended properties” tab. Remember when I mentioned the issue with the “Redirect URI”? We will also resolve this right now. Registering the OAuth server in the Software Factory Here we will add the information from the Exact Online App registration. Open the screen “Project overview” and select the right project and project version. The Thinkwise platform assumes the redirect URI is “ but Exact Online forces https and doesn’t allow localhost.Īfter registering the app, you get a “Client ID” and a “Client secret”, we will copy this information to the Thinkwise Software Factory. In my case I used the name “tw_auth_demo” and the redirect URI “ ”. Here you can register an app by giving it a name and a redirect URI. To do that you can go to the Exact Online App Centre and then go to “ Manage my apps”, please note that an account is required to register an application.

To call the API first we need to register an application in Exact Online. The project table contains the information we will extract from the Exact Online API. The data model contains two tables, the oauth_token_info table to save the OAuth access and refresh tokens. As a developer you can extract a lot more data from the API. I made a very simple model for demo purposes. In this blog I will use Exact Online as the external application to synchronize the projects from Exact to a database. With the support of system flows we can even automate this to automatically collect the latest data. We can use the Thinkwise Platform to synchronize this data. In that case they often want to import the data to the Thinkwise database, as the external system is their single source of truth.

Customers often use external applications, for example a payment system. The Thinkwise Platform has powerful functionality to connect to external applications using OAuth.

Insomnia cookies menu uri