Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

lidiavonkrond
New Contributor III

REST connector error (sense) v1.7

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

error message REST Response Type.PNG

thanks in advance

Lidia Vonk

6 Replies
mikaelsc
Contributor III

Re: REST connector error (sense) v1.7

have you tried increasing the preload symbol count?

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

lidiavonkrond
New Contributor III

Re: REST connector error (sense) v1.7

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
Contributor III

Re: REST connector error (sense) v1.7

Tried changing those settings manually?

Top left drop down items on your screenshot

lidiavonkrond
New Contributor III

Re: REST connector error (sense) v1.7

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
New Contributor

Re: REST connector error (sense) v1.7

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
New Contributor III

Re: REST connector error (sense) v1.7

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

Community Browser