Qlikview --> Rest API Connection including a parameterized URL

twanqlik — Thu, 06 Jan 2022 14:06:30 GMT

I'm running a Qlikview API rest connection where i have used several parameters in the used URL. Now I would like to re-create this in Qlik Sense.

In Qlik Sense you can create an API connection with a new data connection, however that data connection doesn't offer any flexiblity in it. I'm trying to use an API data connection together with a URL, where I use the URL to use parameters.

Any idea how i can get this working?:

Qlikview:
CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=https://secure.p01.eloqua.com/api/REST/2.0/assets/campaigns;timeout=30;method=GET;autoDetectResponseType=true;keyGenerationStrategy=3;useWindowsAuthentication=false;forceAuthenticationType=1;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;PaginationType=None;XUserId=123;XPassword=123;";

RestConnectorMasterTable:
SQL SELECT
"total"
FROM JSON (wrap on) "root";

Qlik Sense
Tried to convert it to Qlik Sense, but it gives a 'HTTP protocol error 400 (bad request)' error:

LIB CONNECT TO 'Eloqua (API_Test)';

RestConnectorMasterTable:
SQL SELECT
"total"
FROM JSON (wrap on) "root"
WITH CONNECTION
(url "https://secure.p01.eloqua.com/api/REST/2.0/assets/campaigns;timeout=30;method=GET;autoDetectResponseType=true;keyGenerationStrategy=3;useWindowsAuthentication=false;forceAuthenticationType=1;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;PaginationType=None;XUserId=123;XPassword=123"; );

topic Qlikview --> Rest API Connection including a parameterized URL in App Development

Qlikview --> Rest API Connection including a parameterized URL