how to setup rest connection to afas

[lmonincx]

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

[oknotsen]

Did you find your question?

I am looking for the same information.

[rolandraijmaker]

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

[curiousfellow]

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

[rolandraijmaker]

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. 

[Sophie85]

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

[curiousfellow]

Thank you. Connection succeeded 🙂 

[curiousfellow]

What config file do you mean ? config of Qlik ?