REST connector error (sense) v1.7

[lidiavonkrond]

Hello all,

I'm using the rest connector  qlik sense to a AFAS database and get a response type failure.

create connection to the lib is oke.

But i can't retrieve any data

Below the the string from the QMC connector edit

CUSTOM CONNECT TO

"provider=QvRestConnector.exe;

url=https://xxxxxx.afasonlineconnector.nl/profitservices/appconnectorget.asmx;

timeout=300;

method=GET;

autoDetectResponseType=true;

keyGenerationStrategy=0;

authSchema=anonymous;

skipServerCertificateValidation=false; 

useCertificate=No;

certificateStoreLocation=LocalMachine;

certificateStoreName=My;

queryParameters=Skip%20%0Take%2100;

addMissingQueryParametersToFinalRequest=false;

queryHeaders=Authorization%20%<token><version>1</version><data>xxxxxx</data></token>;  // %2

PaginationType=None;

allowResponseHeaders=false;

allowHttpsOnly=false;"

for privacy-  i don't show the token and the url here

As you see the string comes with the wrong return i changed this to  queryParameters=Skip%20%0Take%20%100;  (as in the queryheader)

But still get the message below

Does any one know how to solve this

or does any one know where i can see the XML that is read by the REST connector

thanks in advance

Lidia Vonk

[mikaelsc]

have you tried increasing the preload symbol count?

and do you need xml ? (have you tried json format)

[lidiavonkrond]

Hi Mikael,

Thanks for answering.

I don't know how. i use the autodetect, The template of the connector doesn't ask for json or xml

If you can tell how to change the string i can do in there.

wkr

Lidia

[mikaelsc]

Tried changing those settings manually?

Top left drop down items on your screenshot

[lidiavonkrond]

Hi mikael,

yes we tried,

But we found the sollution

the url needed to be extend with xml request ?WSDL 

url=https://xxxxxx.afasonlineconnector.nl/profitservices/appconnectorget.asmx?WSDL

eventualy this is the working connector

CUSTOM CONNECT TO "provider=QvRestConnector.exe;url=https://XXXXXX.afasonlineconnector.nl/profitservices/appconnectorget.asmx?WSDL;timeout=6000;method=G...<token><version>1</version><data>XXXXXXXX</data></token>%%1;PaginationType=None;allowResponseHeaders=false;allowHttpsOnly=false;"

wkr

Lidia Vonk

[osama_anwar]

Hi Lidia,

I am trying to connect too AFAS using Rest connector both on Desktop and cloud, but not able to establish a connection.

Can you please hep me out.

with snapshot while creating connection.

I have AFAS Online account as well.

Thanks,

Osama Anwar

[lidiavonkrond]

Hi osama,

just read you're message,is it working?

you need to create a body in the script when you have the connection

Lidia