topic Re: REST connector error (sense) v1.7 in Integration, Extension & APIs

REST connector error (sense) v1.7

lidiavonkrond — Wed, 04 Jul 2018 15:41:22 GMT

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

Re: REST connector error (sense) v1.7

mikaelsc — Wed, 04 Jul 2018 20:31:34 GMT

have you tried increasing the preload symbol count?

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

Re: REST connector error (sense) v1.7

lidiavonkrond — Fri, 06 Jul 2018 08:26:35 GMT

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

Re: REST connector error (sense) v1.7

mikaelsc — Tue, 10 Jul 2018 18:49:46 GMT

Tried changing those settings manually?

Top left drop down items on your screenshot

Re: REST connector error (sense) v1.7

lidiavonkrond — Tue, 10 Jul 2018 20:55:49 GMT

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=GET;autoDetectResponseType=true;keyGenerationStrategy=0;authSchema=ntlm;skipServerCertificateValidation=true;useCertificate=No;certificateStoreLocation=LocalMachine;certificateStoreName=My;addMissingQueryParametersToFinalRequest=false;queryHeaders=Authorization%2<token><version>1</version><data>XXXXXXXX</data></token>%%1;PaginationType=None;allowResponseHeaders=false;allowHttpsOnly=false;"

wkr

Lidia Vonk

Re: REST connector error (sense) v1.7

osama_anwar — Fri, 26 Oct 2018 13:50:12 GMT

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

Re: REST connector error (sense) v1.7

lidiavonkrond — Thu, 08 Nov 2018 15:19:52 GMT

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