topic Re: how to setup rest connection to afas in QlikView

how to setup rest connection to afas

lmonincx — Fri, 16 Feb 2018 14:29:26 GMT

Hi,

I am trying to make with the restconnector in Qlikview a connection with AFAS but i can't get it to work.

I know the URL , the login but i have no clue how to put the app connector info or get connector names in so that i am able to browse through the tabel behind the connector.

Does someone has an example on how to build up the connection?

kind regards,

Linda

Re: how to setup rest connection to afas

oknotsen — Wed, 17 Oct 2018 11:04:30 GMT

Did you find your question?

I am looking for the same information.

Re: how to setup rest connection to afas

Anonymous — Mon, 10 Aug 2020 09:27:14 GMT

I've got it working now with Profit Online since we migrated in august 2019.

The trick is first to use https://connect.afas.nl to test your GetConnector. Then proceed in Qlikview.

You'll need the URL for accessing the data and Token for authentication. the Token is generated within AFAS profit via het AppConnector.

1. - First step is to convert the <Token> to Base64 format. To convert the token go to
https://www.base64encode.org/

Then paste your token code (Example: <token><version>1</version><data>C4B71E2663886125167AFD4DA9638C9AD1CFF03B3610390FB6A2B5BEA8759939</data></token>) into the first field.

Then press encode and get an Base64 encoded string. (Example: PHRva2VuPjx2ZXJzaW9uPjE8L3ZlcnNpb24+PGRhdGE+QzRCNzFFMjY2Mzg4NjEyNTE2N0FGRDREQTk2MzhDOUFEMUNGRjAzQjM2MTAzOTBGQjZBMkI1QkVBODc1OTkzOTwvZGF0YT48L3Rva2VuPg==)

2. Start the REST connector Wizard

- Fill in your URL

- In the Header Section you put in the next fields.

1st field: Authorization

2nd field: AfasToken PHRva2VuPjx2ZXJzaW9uPjE8L3ZlcnNpb24+PGRhdGE+QzRCNzFFMjY2Mzg4NjEyNTE2N0FGRDREQTk2MzhDOUFEMUNGRjAzQjM2MTAzOTBGQjZBMkI1QkVBODc1OTkzOTwvZGF0YT48L3Rva2VuPg==

Between AfasToken and the authorization string there is 1 space.

Now you should have a connection.

And then the fun begins creating the proper load script, using Skip and Take and filtering for larger data sets.
Also read the help from AFAS https://help.afas.nl/help/NL/SE/App_Cnr_Rest_GET.htm
It took me over 2 weeks to set it up.

Greetings Roland

Re: how to setup rest connection to afas

curiousfellow — Fri, 19 Nov 2021 15:04:44 GMT

Is this method still valid. Response is Connection failed: HTTP protocol error 401 (Unautohorize); Requested resource requires authentication.

When testing in AFAS connect I had to add the username to the customer id.

What did you use for Authentication Schema

Re: how to setup rest connection to afas

Anonymous — Fri, 19 Nov 2021 15:23:56 GMT

First startup AFAS profit https://afasonline.nl and go to the correct environment.

You have to setup the AppConnector https://help.afas.nl/help/EN/SE/App_Cnr_App.htm

Eventually you generate a token within the Appconnector wich contains the authorization.

(Example: <token><version>1</version><data>C4B71E2663886125167AFD4DA9638C9AD1CFF03B3610390FB6A2B5BEA8759939</data></token>)

In AFAS connect https://connect.afas.nl You Just enter 3 parameters

- Deelnemers nummer : 5 digits

- Wich kind of environment : production, accept or test

- Authorization token: and value as in the example above (No Base64 encoding needed here)

Then you should be able to do some tests.

Re: how to setup rest connection to afas

Sophie85 — Mon, 22 Nov 2021 08:53:56 GMT

In the config file you can add different connections to the AFAS profitServices. One connection is added by default. If you will be using only.

alaskasworld

Re: how to setup rest connection to afas

curiousfellow — Mon, 22 Nov 2021 09:35:14 GMT

Thank you. Connection succeeded 🙂

Re: how to setup rest connection to afas

curiousfellow — Mon, 22 Nov 2021 09:36:50 GMT

What config file do you mean ? config of Qlik ?