Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
have you tried increasing the preload symbol count?
and do you need xml ? (have you tried json format)
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
Tried changing those settings manually?
Top left drop down items on your screenshot
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
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
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